View In:   ArcGIS Online Map Viewer

Name: AddressPoints

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 44920a29ceaf49f9a30dc131c70a001b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1600

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1711736.5210245848
YMin: 583752.4683103114
XMax: 1765042.1418422312
YMax: 624136.2319959253
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 1.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: [STNUM]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1600.0
Max. Scale: 0.0

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: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• oirid ( nullable: false, editable: true, defaultValue: null, length: 20, alias: OIRID, type: esriFieldTypeString )
• r_segid ( nullable: false, editable: true, defaultValue: null, length: 25, alias: R_SEGID, type: esriFieldTypeString )
• a_segid ( nullable: false, editable: true, defaultValue: null, length: 25, alias: A_SEGID, type: esriFieldTypeString )
• seg_side ( nullable: false, editable: true, defaultValue: null, length: 1, alias: SEG_SIDE, type: esriFieldTypeString )
• gislink ( nullable: false, editable: true, defaultValue: null, length: 15, alias: GISLINK, type: esriFieldTypeString )
• structype ( nullable: false, editable: true, defaultValue: 1, alias: STRUCTYPE, type: esriFieldTypeSmallInteger )
• strucdesc ( nullable: false, editable: true, defaultValue: null, length: 30, alias: STRUCDESC, type: esriFieldTypeString )
• building ( nullable: false, editable: true, defaultValue: null, length: 35, alias: BUILDING, type: esriFieldTypeString )
• floor ( nullable: false, editable: true, defaultValue: null, length: 10, alias: FLOOR, type: esriFieldTypeString )
• unit_type ( nullable: false, editable: true, defaultValue: null, length: 4, alias: UNIT_TYPE, type: esriFieldTypeString )
• unit_num ( nullable: false, editable: true, defaultValue: null, length: 10, alias: UNIT_NUM, type: esriFieldTypeString )
• secuntnum ( nullable: false, editable: true, defaultValue: null, length: 4, alias: SECUNTNUM, type: esriFieldTypeString )
• predir ( nullable: false, editable: true, defaultValue: null, length: 2, alias: PREDIR, type: esriFieldTypeString )
• pretype ( nullable: false, editable: true, defaultValue: null, length: 5, alias: PRETYPE, type: esriFieldTypeString )
• name ( nullable: false, editable: true, defaultValue: null, length: 40, alias: NAME, type: esriFieldTypeString )
• sufdir ( nullable: false, editable: true, defaultValue: null, length: 2, alias: SUFDIR, type: esriFieldTypeString )
• postmod ( nullable: false, editable: true, defaultValue: null, length: 20, alias: POSTMOD, type: esriFieldTypeString )
• address ( nullable: false, editable: true, defaultValue: null, length: 100, alias: ADDRESS, type: esriFieldTypeString )
• addr_esn ( nullable: false, editable: true, defaultValue: null, length: 100, alias: ADDR_ESN, type: esriFieldTypeString )
• label ( nullable: false, editable: true, defaultValue: null, length: 100, alias: LABEL, type: esriFieldTypeString )
• subname ( nullable: false, editable: true, defaultValue: null, length: 50, alias: SUBNAME, type: esriFieldTypeString )
• zip ( nullable: false, editable: true, defaultValue: null, length: 5, alias: ZIP, type: esriFieldTypeString )
• zip4 ( nullable: false, editable: true, defaultValue: null, length: 4, alias: ZIP4, type: esriFieldTypeString )
• esn ( nullable: false, editable: true, defaultValue: null, length: 3, alias: ESN, type: esriFieldTypeString )
• city ( nullable: false, editable: true, defaultValue: null, length: 30, alias: CITY, type: esriFieldTypeString )
• county ( nullable: false, editable: true, defaultValue: null, length: 30, alias: COUNTY, type: esriFieldTypeString )
• state ( nullable: false, editable: true, defaultValue: TN, length: 2, alias: STATE, type: esriFieldTypeString )
• source ( nullable: false, editable: true, defaultValue: null, alias: SOURCE, type: esriFieldTypeSmallInteger )
• lon ( nullable: false, editable: true, defaultValue: null, length: 15, alias: LON, type: esriFieldTypeString )
• lat ( nullable: false, editable: true, defaultValue: null, length: 15, alias: LAT, type: esriFieldTypeString )
• x_sp ( nullable: false, editable: true, defaultValue: null, alias: X_SP, type: esriFieldTypeDouble )
• y_sp ( nullable: false, editable: true, defaultValue: null, alias: Y_SP, type: esriFieldTypeDouble )
• z_val ( nullable: false, editable: true, defaultValue: null, alias: Z_VAL, type: esriFieldTypeInteger )
• gpsdate ( nullable: false, editable: true, defaultValue: null, length: 29, alias: GPSDATE, type: esriFieldTypeDate )
• addrauth ( nullable: false, editable: true, defaultValue: null, length: 50, alias: ADDRAUTH, type: esriFieldTypeString )
• editor ( nullable: false, editable: true, defaultValue: null, length: 10, alias: EDITOR, type: esriFieldTypeString )
• geomod ( nullable: false, editable: true, defaultValue: null, length: 75, alias: GEOMOD, type: esriFieldTypeString )
• geosrce ( nullable: false, editable: true, defaultValue: null, length: 45, alias: GEOSRCE, type: esriFieldTypeString )
• geodate ( nullable: false, editable: true, defaultValue: null, length: 29, alias: GEODATE, type: esriFieldTypeDate )
• attmod ( nullable: false, editable: true, defaultValue: null, length: 75, alias: ATTMOD, type: esriFieldTypeString )
• attsrce ( nullable: false, editable: true, defaultValue: null, length: 45, alias: ATTSRCE, type: esriFieldTypeString )
• attdate ( nullable: false, editable: true, defaultValue: null, length: 29, alias: ATTDATE, type: esriFieldTypeDate )
• status ( nullable: false, editable: true, defaultValue: 730, alias: STATUS, type: esriFieldTypeSmallInteger )
• delnotes ( nullable: false, editable: true, defaultValue: null, length: 75, alias: DELNOTES, type: esriFieldTypeString )
• owner ( nullable: false, editable: true, defaultValue: null, length: 32, alias: OWNER, type: esriFieldTypeString )
• pin ( nullable: false, editable: true, defaultValue: null, length: 254, alias: PIN, type: esriFieldTypeString )
• lot ( nullable: false, editable: true, defaultValue: null, length: 25, alias: LOT, type: esriFieldTypeString )
• phase ( nullable: false, editable: true, defaultValue: null, length: 25, alias: PHASE, type: esriFieldTypeString )
• comment ( nullable: false, editable: true, defaultValue: null, length: 35, alias: COMMENT, type: esriFieldTypeString )
• suite ( nullable: false, editable: true, defaultValue: null, length: 25, alias: SUITE, type: esriFieldTypeString )
• addr ( nullable: false, editable: true, defaultValue: null, length: 150, alias: ADDR, type: esriFieldTypeString )
• govern_pid ( nullable: false, editable: true, defaultValue: null, length: 10, alias: GOVERN_PID, type: esriFieldTypeString )
• lot_2 ( nullable: false, editable: true, defaultValue: null, length: 10, alias: LOT_2, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• stnum_h ( nullable: true, editable: true, defaultValue: null, length: 10, alias: STNUM_H, type: esriFieldTypeString )
• stnum_l ( nullable: true, editable: true, defaultValue: null, length: 10, alias: STNUM_L, type: esriFieldTypeString )
• stnum ( nullable: true, editable: true, defaultValue: null, length: 10, alias: STNUM, type: esriFieldTypeString )
• type ( nullable: true, editable: true, defaultValue: null, length: 5, alias: TYPE, type: esriFieldTypeString )
• vanity ( nullable: true, editable: true, defaultValue: null, length: 50, alias: VANITY, type: esriFieldTypeString )
• stnumsuf ( nullable: true, editable: true, defaultValue: null, length: 10, alias: STNUMSUF, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• streetname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: StreetName, type: esriFieldTypeString )
• routingstreetextkey ( nullable: true, editable: true, defaultValue: null, length: 36, alias: RoutingStreetExtKey, type: esriFieldTypeString )
• countycode ( nullable: true, editable: true, defaultValue: null, length: 5, alias: CountyCode, type: esriFieldTypeString )
• addrkey ( nullable: true, editable: true, defaultValue: null, alias: ADDRKEY, type: esriFieldTypeInteger )
• addressnum ( nullable: true, editable: true, defaultValue: null, alias: AddressNum, type: esriFieldTypeSmallInteger )
• fire_grid ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Fire_Grid, type: esriFieldTypeString )

Templates:

• Name: brentwoodgis.DBO.AddressPoints
  Description:
  Prototype:
  esn:
  countycode: null
  strucdesc:
  r_segid:
  streetname: null
  county:
  zip4:
  source: 0
  type: null
  stnum_h: null
  a_segid:
  building:
  attdate: -2209161600000
  stnum: null
  stnum_l: null
  sufdir:
  pin:
  geomod:
  state: TN
  gpsdate: -2209161600000
  gislink:
  predir:
  lat:
  geosrce:
  zip:
  phase:
  structype: 1
  seg_side:
  x_sp: 0
  secuntnum:
  z_val: 0
  name:
  geodate: -2209161600000
  oirid:
  status: 730
  govern_pid:
  addrauth:
  city:
  fire_grid: null
  lon:
  unit_type:
  postmod:
  stnumsuf: null
  vanity: null
  delnotes:
  lot:
  pretype:
  unit_num:
  addrkey: null
  y_sp: 0
  floor:
  addr:
  attmod:
  owner:
  editor:
  lot_2:
  address:
  attsrce:
  subname:
  addr_esn:
  label:
  routingstreetextkey: null
  suite:
  comment:
  addressnum: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata