View In:   ArcGIS Online Map Viewer

Name: Parcels_with_address_Erase

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 9ae2fbb952834927bb426b1bdf65f898

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

Extent:

XMin: -9651419.8245326
YMin: 4248140.764550321
XMax: -9589167.408701142
YMax: 4314317.995844834
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [255, 255, 255, 255]
Width: 1
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• join_count ( modelName: join_count, nullable: true, editable: true, defaultValue: null, alias: Join_Count, type: esriFieldTypeInteger )
• target_fid ( modelName: target_fid, nullable: true, editable: true, defaultValue: null, alias: TARGET_FID, type: esriFieldTypeInteger )
• countyid ( modelName: COUNTYID, nullable: true, editable: true, defaultValue: 75, alias: COUNTYID, type: esriFieldTypeSmallInteger )
• parcel_type ( modelName: PARCEL_TYPE, nullable: true, editable: true, defaultValue: 1, alias: PARCEL_TYPE, type: esriFieldTypeInteger )
• gislink ( modelName: GISLINK, nullable: true, editable: true, defaultValue: null, length: 15, alias: GIS Link, type: esriFieldTypeString )
• mapnumber ( modelName: MAPNUMBER, nullable: true, editable: true, defaultValue: null, length: 30, alias: Map Number, type: esriFieldTypeString )
• camaacct ( modelName: CAMAACCT, nullable: true, editable: true, defaultValue: null, length: 30, alias: CAMA Account, type: esriFieldTypeString )
• parent ( modelName: PARENT, nullable: true, editable: true, defaultValue: null, length: 30, alias: Parent, type: esriFieldTypeString )
• county ( modelName: COUNTY, nullable: true, editable: true, defaultValue: 075, length: 30, alias: County, type: esriFieldTypeString )
• map ( modelName: MAP, nullable: true, editable: true, defaultValue: null, length: 5, alias: Map, type: esriFieldTypeString )
• cntlmap ( modelName: CNTLMAP, nullable: true, editable: true, defaultValue: null, length: 3, alias: Control Map, type: esriFieldTypeString )
• mapltr ( modelName: MAPLTR, nullable: true, editable: true, defaultValue: null, length: 2, alias: Map Letter, type: esriFieldTypeString )
• grp ( modelName: GRP, nullable: true, editable: true, defaultValue: null, length: 2, alias: Group, type: esriFieldTypeString )
• parcel ( modelName: PARCEL, nullable: true, editable: true, defaultValue: null, length: 5, alias: Parcel, type: esriFieldTypeString )
• citycode ( modelName: CITYCODE, nullable: true, editable: true, defaultValue: null, length: 30, alias: City Code, type: esriFieldTypeString )
• streetno ( modelName: STREETNO, nullable: true, editable: true, defaultValue: null, length: 15, alias: Street Number, type: esriFieldTypeString )
• streetalp ( modelName: STREETALP, nullable: true, editable: true, defaultValue: null, length: 6, alias: Street Alpha, type: esriFieldTypeString )
• streetdir ( modelName: STREETDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: Street Direction, type: esriFieldTypeString )
• streetname ( modelName: STREETNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: Street Name, type: esriFieldTypeString )
• streetsuf ( modelName: STREETSUF, nullable: true, editable: true, defaultValue: null, length: 4, alias: Street Suffix, type: esriFieldTypeString )
• streetaddress ( modelName: STREETADDRESS, nullable: true, editable: true, defaultValue: null, length: 75, alias: Street Address, type: esriFieldTypeString )
• city ( modelName: CITY, nullable: true, editable: true, defaultValue: null, length: 25, alias: City, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 10, alias: ZIP, type: esriFieldTypeString )
• deedacres ( modelName: DEEDACRES, nullable: true, editable: true, defaultValue: null, alias: Deed Acres, type: esriFieldTypeDouble )
• calcacres ( modelName: CALCACRES, nullable: true, editable: true, defaultValue: null, alias: Calculated Acres, type: esriFieldTypeDouble )
• subdivision ( modelName: SUBDIVISION, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision, type: esriFieldTypeString )
• subsect ( modelName: SUBSECT, nullable: true, editable: true, defaultValue: null, length: 25, alias: Section, type: esriFieldTypeString )
• subphase ( modelName: SUBPHASE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Phase, type: esriFieldTypeString )
• subid ( modelName: SUBID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision ID, type: esriFieldTypeString )
• lot ( modelName: LOT, nullable: true, editable: true, defaultValue: null, length: 12, alias: Lot, type: esriFieldTypeString )
• unit ( modelName: UNIT, nullable: true, editable: true, defaultValue: null, length: 8, alias: Unit, type: esriFieldTypeString )
• tract ( modelName: TRACT, nullable: true, editable: true, defaultValue: null, length: 8, alias: Tract, type: esriFieldTypeString )
• platbook ( modelName: PLATBOOK, nullable: true, editable: true, defaultValue: null, length: 8, alias: Plat Book, type: esriFieldTypeString )
• platpage ( modelName: PLATPAGE, nullable: true, editable: true, defaultValue: null, length: 8, alias: Plat Page, type: esriFieldTypeString )
• zoning ( modelName: ZONING, nullable: true, editable: true, defaultValue: null, length: 6, alias: Zoning, type: esriFieldTypeString )
• dimfront ( modelName: DIMFRONT, nullable: true, editable: true, defaultValue: null, alias: Dimension Front, type: esriFieldTypeDouble )
• dimside ( modelName: DIMSIDE, nullable: true, editable: true, defaultValue: null, alias: Dimension Side, type: esriFieldTypeDouble )
• dimirr ( modelName: DIMIRR, nullable: true, editable: true, defaultValue: N, length: 1, alias: Dimension Irregular, type: esriFieldTypeString )
• specint ( modelName: SPECINT, nullable: true, editable: true, defaultValue: N, length: 1, alias: Special Interest, type: esriFieldTypeString )
• greenbelt ( modelName: GREENBELT, nullable: true, editable: true, defaultValue: N, length: 1, alias: Greenbelt, type: esriFieldTypeString )
• cama ( modelName: CAMA, nullable: true, editable: true, defaultValue: null, length: 1, alias: CAMA, type: esriFieldTypeString )
• um ( modelName: UM, nullable: true, editable: true, defaultValue: null, length: 1, alias: UM, type: esriFieldTypeString )
• umvalue ( modelName: umvalue, nullable: true, editable: true, defaultValue: null, length: 10, alias: UMVALUE, type: esriFieldTypeString )
• review ( modelName: REVIEW, nullable: true, editable: true, defaultValue: Y, length: 3, alias: Review, type: esriFieldTypeString )
• taxyear ( modelName: TAXYEAR, nullable: true, editable: true, defaultValue: null, length: 4, alias: Tax Year, type: esriFieldTypeString )
• valueareaid ( modelName: VALUEAREAID, nullable: true, editable: true, defaultValue: null, length: 10, alias: Value Area ID, type: esriFieldTypeString )
• lea ( modelName: lea, nullable: true, editable: true, defaultValue: null, length: 10, alias: LEA, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 250, alias: Comments, type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Create Date, type: esriFieldTypeDate )
• createeditor ( modelName: CREATEEDITOR, nullable: true, editable: true, defaultValue: null, length: 10, alias: Create Editor, type: esriFieldTypeString )
• modifydate ( modelName: MODIFYDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Modify Date, type: esriFieldTypeDate )
• modifyeditor ( modelName: MODIFYEDITOR, nullable: true, editable: true, defaultValue: null, length: 10, alias: Modify Editor, type: esriFieldTypeString )
• siteaddid ( modelName: SITEADDID, nullable: true, editable: true, defaultValue: null, length: 20, alias: OIR ID, type: esriFieldTypeString )
• addptkey ( modelName: ADDPTKEY, nullable: true, editable: true, defaultValue: null, length: 20, alias: Address Point ID, type: esriFieldTypeString )
• preaddrnum ( modelName: PREADDRNUM, nullable: true, editable: true, defaultValue: null, length: 5, alias: Address Number Prefix, type: esriFieldTypeString )
• addrnumsuf ( modelName: ADDRNUMSUF, nullable: true, editable: true, defaultValue: null, length: 5, alias: Address Number Suffix, type: esriFieldTypeString )
• addrnum ( modelName: ADDRNUM, nullable: true, editable: true, defaultValue: null, length: 10, alias: Full Address Number, type: esriFieldTypeString )
• addrrange ( modelName: ADDRRANGE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Address Range, type: esriFieldTypeString )
• unittype ( modelName: UNITTYPE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Address Unit Type, type: esriFieldTypeString )
• unitid ( modelName: UNITID, nullable: true, editable: true, defaultValue: null, length: 10, alias: Address Unit Number, type: esriFieldTypeString )
• altunittype ( modelName: ALTUNITTYPE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Alt Address Unit Type, type: esriFieldTypeString )
• altunitid ( modelName: ALTUNITID, nullable: true, editable: true, defaultValue: null, length: 10, alias: Alternate Address Unit Number, type: esriFieldTypeString )
• addrlabel ( modelName: ADDRLABEL, nullable: true, editable: true, defaultValue: null, length: 15, alias: Address Label, type: esriFieldTypeString )
• roadpremod ( modelName: ROADPREMOD, nullable: true, editable: true, defaultValue: null, length: 50, alias: Road Pre Modifier Road Pre Modifier Road PreModifier, type: esriFieldTypeString )
• roadpredir ( modelName: ROADPREDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: Pre Direction, type: esriFieldTypeString )
• roadpretype ( modelName: ROADPRETYPE, nullable: true, editable: true, defaultValue: null, length: 4, alias: Road Pretype, type: esriFieldTypeString )
• roadname ( modelName: ROADNAME, nullable: true, editable: true, defaultValue: null, length: 75, alias: Road Name, type: esriFieldTypeString )
• roadtype ( modelName: ROADTYPE, nullable: true, editable: true, defaultValue: null, length: 4, alias: Road Type, type: esriFieldTypeString )
• roadpostdir ( modelName: ROADPOSTDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: Post Direction, type: esriFieldTypeString )
• roadpostmod ( modelName: ROADPOSTMOD, nullable: true, editable: true, defaultValue: null, length: 50, alias: Road Post Modifier, type: esriFieldTypeString )
• fullname ( modelName: FULLNAME, nullable: true, editable: true, defaultValue: null, length: 125, alias: Full Road Name, type: esriFieldTypeString )
• fulladdr ( modelName: FULLADDR, nullable: true, editable: true, defaultValue: null, length: 250, alias: Full Address, type: esriFieldTypeString )
• fulladdresn ( modelName: FULLADDRESN, nullable: true, editable: true, defaultValue: null, length: 100, alias: AddressESN, type: esriFieldTypeString )
• placename ( modelName: PLACENAME, nullable: true, editable: true, defaultValue: null, length: 250, alias: Place Name, type: esriFieldTypeString )
• building ( modelName: BUILDING, nullable: true, editable: true, defaultValue: null, length: 35, alias: Building Name/Num, type: esriFieldTypeString )
• floor ( modelName: FLOOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Floor, type: esriFieldTypeString )
• municipality ( modelName: MUNICIPALITY, nullable: true, editable: true, defaultValue: null, length: 100, alias: Municipality Name, type: esriFieldTypeString )
• county_1 ( modelName: COUNTY, nullable: true, editable: true, defaultValue: RUTHERFORD, length: 30, alias: County, type: esriFieldTypeString )
• state ( modelName: STATE, nullable: true, editable: true, defaultValue: TN, length: 2, alias: State, type: esriFieldTypeString )
• zip_1 ( modelName: ZIP, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIP Code, type: esriFieldTypeString )
• zip4 ( modelName: ZIP4, nullable: true, editable: true, defaultValue: null, length: 4, alias: ZIP + 4, type: esriFieldTypeString )
• esn ( modelName: ESN, nullable: true, editable: true, defaultValue: null, length: 5, alias: Emergency Service Number, type: esriFieldTypeString )
• psap ( modelName: PSAP, nullable: true, editable: true, defaultValue: null, length: 4, alias: Public Safety Answering Point, type: esriFieldTypeString )
• msag ( modelName: MSAG, nullable: true, editable: true, defaultValue: null, length: 35, alias: MSAG Community, type: esriFieldTypeString )
• usngcoord ( modelName: USNGCOORD, nullable: true, editable: true, defaultValue: null, length: 50, alias: USNG Coordinate, type: esriFieldTypeString )
• addrclass ( modelName: ADDRCLASS, nullable: true, editable: true, defaultValue: null, alias: Classification, type: esriFieldTypeInteger )
• pointtype ( modelName: POINTTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Location, type: esriFieldTypeString )
• structdesc ( modelName: STRUCTDESC, nullable: true, editable: true, defaultValue: null, length: 30, alias: Description, type: esriFieldTypeString )
• captureloc ( modelName: CAPTURELOC, nullable: true, editable: true, defaultValue: null, length: 4, alias: Capture Location, type: esriFieldTypeString )
• capturemeth ( modelName: CAPTUREMETH, nullable: true, editable: true, defaultValue: null, length: 30, alias: Capture Method, type: esriFieldTypeString )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: null, alias: TIPS Status, type: esriFieldTypeInteger )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• addrauth ( modelName: ADDRAUTH, nullable: true, editable: true, defaultValue: null, length: 50, alias: Addressing Authority, type: esriFieldTypeString )
• legacyid ( modelName: LEGACYID, nullable: true, editable: true, defaultValue: null, alias: Legacy ID, type: esriFieldTypeInteger )
• review_1 ( modelName: REVIEW, nullable: true, editable: true, defaultValue: null, length: 3, alias: Review, type: esriFieldTypeString )
• verified ( modelName: VERIFIED, nullable: true, editable: true, defaultValue: null, length: 3, alias: Verified, type: esriFieldTypeString )
• comments_1 ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Comments, type: esriFieldTypeString )
• lon ( modelName: LON, nullable: true, editable: true, defaultValue: null, length: 15, alias: Longitude, type: esriFieldTypeString )
• lat ( modelName: LAT, nullable: true, editable: true, defaultValue: null, length: 15, alias: Latitude, type: esriFieldTypeString )
• x_sp ( modelName: X_SP, nullable: true, editable: true, defaultValue: null, alias: State Plane X, type: esriFieldTypeDouble )
• y_sp ( modelName: Y_SP, nullable: true, editable: true, defaultValue: null, alias: State Plane Y, type: esriFieldTypeDouble )
• z_val ( modelName: Z_VAL, nullable: true, editable: true, defaultValue: null, alias: Elevation, type: esriFieldTypeInteger )
• gislink_1 ( modelName: GISLINK, nullable: true, editable: true, defaultValue: null, length: 15, alias: GISLINK, type: esriFieldTypeString )
• subname ( modelName: SUBNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision, type: esriFieldTypeString )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 400, alias: LOCATION, type: esriFieldTypeString )
• addrnumtt ( modelName: ADDRNUMTT, nullable: true, editable: true, defaultValue: null, alias: Tri Tech INT Address, type: esriFieldTypeInteger )
• citycode_1 ( modelName: citycode_1, nullable: true, editable: true, defaultValue: null, length: 30, alias: Sunguard City Code, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Parcels_with_address_Erase
  Description:
  Prototype:
  roadpostmod: null
  parent: null
  streetname: null
  citycode_1: null
  county: 075
  lea: null
  createdate: null
  cntlmap: null
  streetsuf: null
  zip4: null
  roadtype: null
  building: null
  zoning: null
  review: Y
  state: TN
  roadpredir: null
  specint: N
  gislink: null
  zip: null
  platbook: null
  addrrange: null
  unittype: null
  altunittype: null
  addrclass: null
  mapnumber: null
  subsect: null
  createeditor: null
  countyid: 75
  z_val: null
  umvalue: null
  comments_1: null
  status: null
  addrauth: null
  city: null
  psap: null
  lon: null
  addrnumsuf: null
  camaacct: null
  lot: null
  modifydate: null
  target_fid: null
  calcacres: null
  streetaddress: null
  fulladdr: null
  cama: null
  map: null
  addrnum: null
  review_1: null
  subname: null
  captureloc: null
  unitid: null
  zip_1: null
  dimirr: N
  msag: null
  esn: null
  modifyeditor: null
  mapltr: null
  pointtype: null
  municipality: null
  roadpostdir: null
  dimside: null
  capturemeth: null
  citycode: null
  addrnumtt: null
  dimfront: null
  um: null
  join_count: null
  addptkey: null
  lat: null
  parcel: null
  fulladdresn: null
  roadpretype: null
  streetalp: null
  roadpremod: null
  gislink_1: null
  altunitid: null
  county_1: RUTHERFORD
  parcel_type: 1
  unit: null
  x_sp: null
  greenbelt: N
  legacyid: null
  usngcoord: null
  lastupdate: null
  streetdir: null
  tract: null
  taxyear: null
  streetno: null
  placename: null
  subphase: null
  valueareaid: null
  deedacres: null
  subid: null
  subdivision: null
  addrlabel: null
  y_sp: null
  floor: null
  siteaddid: null
  comments: null
  grp: null
  structdesc: null
  verified: null
  lasteditor: null
  location: null
  preaddrnum: null
  fullname: null
  platpage: null
  roadname: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata