View In:   ArcGIS Online Map Viewer

Name: addr.DBO.Norton_Parc_Addr_Join

Display Field: cnvyname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 12fe454c9ec9427faf39feb34df4d5e6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -81.68978192321947
YMin: 40.90633258908544
XMax: -81.38717701625093
YMax: 41.35191686382915
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [242, 214, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Join_Count ( type: esriFieldTypeInteger, alias: Join_Count, editable: true, nullable: true, defaultValue: null, modelName: Join_Count )
• TARGET_FID ( type: esriFieldTypeInteger, alias: TARGET_FID, editable: true, nullable: true, defaultValue: null, modelName: TARGET_FID )
• lowparcelid ( type: esriFieldTypeString, alias: lowparcelid, editable: true, nullable: true, length: 30, defaultValue: null, modelName: lowparcelid )
• parcelid ( type: esriFieldTypeString, alias: parcelid, editable: true, nullable: true, length: 30, defaultValue: null, modelName: parcelid )
• building ( type: esriFieldTypeString, alias: building, editable: true, nullable: true, length: 1, defaultValue: null, modelName: building )
• unit ( type: esriFieldTypeString, alias: unit, editable: true, nullable: true, length: 20, defaultValue: null, modelName: unit )
• statedarea ( type: esriFieldTypeString, alias: statedarea, editable: true, nullable: true, length: 50, defaultValue: null, modelName: statedarea )
• lglstartdt ( type: esriFieldTypeDate, alias: lglstartdt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lglstartdt )
• cvttxcd ( type: esriFieldTypeString, alias: cvttxcd, editable: true, nullable: true, length: 5, defaultValue: null, modelName: cvttxcd )
• cvttxdscrp ( type: esriFieldTypeString, alias: cvttxdscrp, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cvttxdscrp )
• schltxcd ( type: esriFieldTypeString, alias: schltxcd, editable: true, nullable: true, length: 5, defaultValue: null, modelName: schltxcd )
• schldscrp ( type: esriFieldTypeString, alias: schldscrp, editable: true, nullable: true, length: 1, defaultValue: null, modelName: schldscrp )
• usecd ( type: esriFieldTypeString, alias: usecd, editable: true, nullable: true, length: 4, defaultValue: null, modelName: usecd )
• usedscrp ( type: esriFieldTypeString, alias: usedscrp, editable: true, nullable: true, length: 1, defaultValue: null, modelName: usedscrp )
• NGHBRHDCD ( type: esriFieldTypeString, alias: NGHBRHDCD, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NGHBRHDCD )
• classcd ( type: esriFieldTypeString, alias: classcd, editable: true, nullable: true, length: 4, defaultValue: null, modelName: classcd )
• classdscrp ( type: esriFieldTypeString, alias: classdscrp, editable: true, nullable: true, length: 1, defaultValue: null, modelName: classdscrp )
• siteaddress ( type: esriFieldTypeString, alias: siteaddress, editable: true, nullable: true, length: 127, defaultValue: null, modelName: siteaddress )
• prprtydscrp ( type: esriFieldTypeString, alias: prprtydscrp, editable: true, nullable: true, length: 120, defaultValue: null, modelName: prprtydscrp )
• cnvyname ( type: esriFieldTypeString, alias: cnvyname, editable: true, nullable: true, length: 1, defaultValue: null, modelName: cnvyname )
• ownernme1 ( type: esriFieldTypeString, alias: ownernme1, editable: true, nullable: true, length: 205, defaultValue: null, modelName: ownernme1 )
• ownernme2 ( type: esriFieldTypeString, alias: ownernme2, editable: true, nullable: true, length: 205, defaultValue: null, modelName: ownernme2 )
• pstladdress ( type: esriFieldTypeString, alias: pstladdress, editable: true, nullable: true, length: 242, defaultValue: null, modelName: pstladdress )
• pstlcity ( type: esriFieldTypeString, alias: pstlcity, editable: true, nullable: true, length: 40, defaultValue: null, modelName: pstlcity )
• pstlstate ( type: esriFieldTypeString, alias: pstlstate, editable: true, nullable: true, length: 2, defaultValue: null, modelName: pstlstate )
• pstlzip5 ( type: esriFieldTypeString, alias: pstlzip5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: pstlzip5 )
• pstlzip4 ( type: esriFieldTypeString, alias: pstlzip4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: pstlzip4 )
• floorcount ( type: esriFieldTypeSingle, alias: floorcount, editable: true, nullable: true, defaultValue: null, modelName: floorcount )
• bldgarea ( type: esriFieldTypeInteger, alias: bldgarea, editable: true, nullable: true, defaultValue: null, modelName: bldgarea )
• resflrarea ( type: esriFieldTypeInteger, alias: resflrarea, editable: true, nullable: true, defaultValue: null, modelName: resflrarea )
• resyrblt ( type: esriFieldTypeSmallInteger, alias: resyrblt, editable: true, nullable: true, defaultValue: null, modelName: resyrblt )
• resstrtyp ( type: esriFieldTypeString, alias: resstrtyp, editable: true, nullable: true, length: 3, defaultValue: null, modelName: resstrtyp )
• resstrtypval ( type: esriFieldTypeString, alias: resstrtypval, editable: true, nullable: true, length: 40, defaultValue: null, modelName: resstrtypval )
• strclass ( type: esriFieldTypeString, alias: strclass, editable: true, nullable: true, length: 1, defaultValue: null, modelName: strclass )
• classmod ( type: esriFieldTypeString, alias: classmod, editable: true, nullable: true, length: 1, defaultValue: null, modelName: classmod )
• lndvalue ( type: esriFieldTypeDouble, alias: lndvalue, editable: true, nullable: true, defaultValue: null, modelName: lndvalue )
• bldgvalue ( type: esriFieldTypeDouble, alias: bldgvalue, editable: true, nullable: true, defaultValue: null, modelName: bldgvalue )
• cntmarval ( type: esriFieldTypeDouble, alias: cntmarval, editable: true, nullable: true, defaultValue: null, modelName: cntmarval )
• prvassdval ( type: esriFieldTypeInteger, alias: prvassdval, editable: true, nullable: true, defaultValue: null, modelName: prvassdval )
• cntassdval ( type: esriFieldTypeDouble, alias: cntassdval, editable: true, nullable: true, defaultValue: null, modelName: cntassdval )
• assdvalyrcg ( type: esriFieldTypeInteger, alias: assdvalyrcg, editable: true, nullable: true, defaultValue: null, modelName: assdvalyrcg )
• assdpcntcg ( type: esriFieldTypeInteger, alias: assdpcntcg, editable: true, nullable: true, defaultValue: null, modelName: assdpcntcg )
• prvtxblval ( type: esriFieldTypeInteger, alias: prvtxblval, editable: true, nullable: true, defaultValue: null, modelName: prvtxblval )
• cnttxblval ( type: esriFieldTypeDouble, alias: cnttxblval, editable: true, nullable: true, defaultValue: null, modelName: cnttxblval )
• txblvalyrchg ( type: esriFieldTypeInteger, alias: txblvalyrchg, editable: true, nullable: true, defaultValue: null, modelName: txblvalyrchg )
• txblpcntchg ( type: esriFieldTypeInteger, alias: txblpcntchg, editable: true, nullable: true, defaultValue: null, modelName: txblpcntchg )
• prvwnttxod ( type: esriFieldTypeInteger, alias: prvwnttxod, editable: true, nullable: true, defaultValue: null, modelName: prvwnttxod )
• prvsmrtxod ( type: esriFieldTypeInteger, alias: prvsmrtxod, editable: true, nullable: true, defaultValue: null, modelName: prvsmrtxod )
• totprvttxtod ( type: esriFieldTypeInteger, alias: totprvttxtod, editable: true, nullable: true, defaultValue: null, modelName: totprvttxtod )
• cntwnttxod ( type: esriFieldTypeInteger, alias: cntwnttxod, editable: true, nullable: true, defaultValue: null, modelName: cntwnttxod )
• cntsmrtxod ( type: esriFieldTypeInteger, alias: cntsmrtxod, editable: true, nullable: true, defaultValue: null, modelName: cntsmrtxod )
• totcnttxod ( type: esriFieldTypeInteger, alias: totcnttxod, editable: true, nullable: true, defaultValue: null, modelName: totcnttxod )
• txodyrchg ( type: esriFieldTypeInteger, alias: txodyrchg, editable: true, nullable: true, defaultValue: null, modelName: txodyrchg )
• txodpcntchg ( type: esriFieldTypeInteger, alias: txodpcntchg, editable: true, nullable: true, defaultValue: null, modelName: txodpcntchg )
• waterserv ( type: esriFieldTypeString, alias: waterserv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: waterserv )
• sewerserv ( type: esriFieldTypeString, alias: sewerserv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: sewerserv )
• altid ( type: esriFieldTypeString, alias: altid, editable: true, nullable: true, length: 30, defaultValue: null, modelName: altid )
• oldtaxmap ( type: esriFieldTypeString, alias: oldtaxmap, editable: true, nullable: true, length: 8, defaultValue: null, modelName: oldtaxmap )
• ADDR_ID ( type: esriFieldTypeInteger, alias: ADDR_ID, editable: true, nullable: true, defaultValue: null, modelName: ADDR_ID )
• SEG_ID ( type: esriFieldTypeInteger, alias: SEG_ID, editable: true, nullable: true, defaultValue: null, modelName: SEG_ID )
• TSSEGID ( type: esriFieldTypeInteger, alias: TSSEGID, editable: true, nullable: true, defaultValue: null, modelName: TSSEGID )
• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID )
• ADDR_NUM ( type: esriFieldTypeString, alias: ADDR_NUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ADDR_NUM )
• ADDR_ANOMALY ( type: esriFieldTypeString, alias: ADDR_ANOMALY, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ADDR_ANOMALY )
• PRE_DIR ( type: esriFieldTypeString, alias: PRE_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRE_DIR )
• PRE_TYPE ( type: esriFieldTypeString, alias: PRE_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PRE_TYPE )
• STR_NAME ( type: esriFieldTypeString, alias: STR_NAME, editable: true, nullable: true, length: 75, defaultValue: null, modelName: STR_NAME )
• STR_TYPE ( type: esriFieldTypeString, alias: STR_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STR_TYPE )
• SUF_DIR ( type: esriFieldTypeString, alias: SUF_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUF_DIR )
• BUILDING_1 ( type: esriFieldTypeString, alias: BUILDING, editable: true, nullable: true, length: 16, defaultValue: null, modelName: BUILDING_OLD )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLOOR_OLD )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: UNIT_TYPE )
• UNIT_NUM ( type: esriFieldTypeString, alias: UNIT_NUM, editable: true, nullable: true, length: 12, defaultValue: null, modelName: UNITNUM )
• STRUC_TYPE ( type: esriFieldTypeSmallInteger, alias: STRUC_TYPE, editable: true, nullable: true, defaultValue: null, modelName: STRUC_TYPE )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENT )
• ALTPREFIX ( type: esriFieldTypeString, alias: ALTPREFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTPREFIX )
• ALTNAME ( type: esriFieldTypeString, alias: ALTNAME, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ALTNAME )
• ALTTYPE ( type: esriFieldTypeString, alias: ALTTYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ALTTYPE )
• ALTSUFFIX ( type: esriFieldTypeString, alias: ALTSUFFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTSUFFIX )
• SUBDIV ( type: esriFieldTypeString, alias: SUBDIV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBDIV )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CITY )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 3, defaultValue: SUM, modelName: COUNTY )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: OH, modelName: STATE )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP )
• LSN ( type: esriFieldTypeString, alias: LSN, editable: true, nullable: true, length: 125, defaultValue: null, modelName: LSN )
• ALSN ( type: esriFieldTypeString, alias: ALSN, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ALSN )
• ABSSIDE ( type: esriFieldTypeString, alias: ABSSIDE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ABSSIDE )
• ESRISIDE ( type: esriFieldTypeString, alias: ESRISIDE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ESRISIDE )
• CERT ( type: esriFieldTypeString, alias: CERT, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CERT )
• FIPS_CODE ( type: esriFieldTypeString, alias: FIPS_CODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FIPS_CODE )
• USPS_CITY ( type: esriFieldTypeString, alias: USPS_CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USPS_CITY )
• PT_LEN ( type: esriFieldTypeDouble, alias: PT_LEN, editable: true, nullable: true, defaultValue: null, modelName: PT_LEN )
• MP_VAL ( type: esriFieldTypeDouble, alias: MP_VAL, editable: true, nullable: true, defaultValue: null, modelName: MP_VAL )
• COMM ( type: esriFieldTypeString, alias: COMM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMM )
• LANDMARK ( type: esriFieldTypeString, alias: LANDMARK, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LANDMARK )
• LANDMARK_NAME ( type: esriFieldTypeString, alias: LANDMARK_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LANDMARK_NAME )
• LANDMARK_NOTE ( type: esriFieldTypeString, alias: LANDMARK_NOTE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LANDMARK_NOTE )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SOURCE )
• COLL_DATE ( type: esriFieldTypeDate, alias: COLL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COLL_DATE )
• CAPTURE_METHOD ( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FIELDNOTE )
• ADDPTKEY ( type: esriFieldTypeString, alias: ADDPTKEY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDPTKEY )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_MODIFIED_USER ( type: esriFieldTypeString, alias: LAST_MODIFIED_USER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_MODIFIED_USER )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• ADDR_SUG ( type: esriFieldTypeString, alias: ADDR_SUG, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ADDR_SUG )
• JOIN_ID ( type: esriFieldTypeInteger, alias: JOIN_ID, editable: true, nullable: true, defaultValue: null, modelName: JOIN_ID )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STArea() )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: addr.DBO.Norton_Parc_Addr_Join
  Description:
  Prototype:
  JOIN_ID: null
  ADDR_SUG: null
  Join_Count: null
  TARGET_FID: null
  lowparcelid: null
  parcelid: null
  building: null
  unit: null
  statedarea: null
  lglstartdt: null
  cvttxcd: null
  cvttxdscrp: null
  schltxcd: null
  schldscrp: null
  usecd: null
  usedscrp: null
  NGHBRHDCD: null
  classcd: null
  classdscrp: null
  siteaddress: null
  prprtydscrp: null
  cnvyname: null
  ownernme1: null
  ownernme2: null
  pstladdress: null
  pstlcity: null
  pstlstate: null
  pstlzip5: null
  pstlzip4: null
  floorcount: null
  bldgarea: null
  resflrarea: null
  resyrblt: null
  resstrtyp: null
  resstrtypval: null
  strclass: null
  classmod: null
  lndvalue: null
  bldgvalue: null
  cntmarval: null
  prvassdval: null
  cntassdval: null
  assdvalyrcg: null
  assdpcntcg: null
  prvtxblval: null
  cnttxblval: null
  txblvalyrchg: null
  txblpcntchg: null
  prvwnttxod: null
  prvsmrtxod: null
  totprvttxtod: null
  cntwnttxod: null
  cntsmrtxod: null
  totcnttxod: null
  txodyrchg: null
  txodpcntchg: null
  waterserv: null
  sewerserv: null
  altid: null
  oldtaxmap: null
  ADDR_ID: null
  SEG_ID: null
  TSSEGID: null
  NLFID: null
  ADDR_NUM: null
  ADDR_ANOMALY: null
  PRE_DIR: null
  PRE_TYPE: null
  STR_NAME: null
  STR_TYPE: null
  SUF_DIR: null
  BUILDING_1: null
  FLOOR: null
  UNIT_TYPE: null
  UNIT_NUM: null
  STRUC_TYPE: null
  COMMENT: null
  ALTPREFIX: null
  ALTNAME: null
  ALTTYPE: null
  ALTSUFFIX: null
  SUBDIV: null
  CITY: null
  COUNTY: SUM
  STATE: OH
  ZIP: null
  LSN: null
  ALSN: null
  ABSSIDE: null
  ESRISIDE: null
  CERT: null
  FIPS_CODE: null
  USPS_CITY: null
  PT_LEN: null
  MP_VAL: null
  COMM: null
  LANDMARK: null
  LANDMARK_NAME: null
  LANDMARK_NOTE: null
  SOURCE: null
  COLL_DATE: null
  CAPTURE_METHOD: null
  ADDPTKEY: null
  X_COORD: null
  Y_COORD: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_MODIFIED_USER: null
  LAST_MODIFIED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata