View In:   ArcGIS Online Map Viewer

Name: Address Points

Display Field: roadname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 911 Addressing Data for Sullivan County, NY. Includes: Roads Address Points Master Street Name table This data is open data and can be downloaded from the Sullivan County Geoportal.

Service Item Id: 119c7be1e33b428b9ec82dcaac69bd83

Copyright Text: J.D. Stone, Sullivan County ITS: GIS Program

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.0

Max Scale: 100.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 318057.97954534367
YMin: 943209.3244340345
XMax: 528789.3402340114
YMax: 1158716.3166475296
Spatial Reference: 102715  (2260)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: false
Symbol:
Color: [255, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: center
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: 2500.0
Max. Scale: 100.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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• at_datetime ( modelName: AT_DATETIME, nullable: true, editable: true, defaultValue: null, length: 29, alias: AT_DATETIME, type: esriFieldTypeDate )
• at_username ( modelName: AT_USERNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: AT_USERNAME, type: esriFieldTypeString )
• cr_datetime ( modelName: CR_DATETIME, nullable: true, editable: true, defaultValue: null, length: 29, alias: CR_DATETIME, type: esriFieldTypeDate )
• cr_username ( modelName: CR_USERNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: CR_USERNAME, type: esriFieldTypeString )
• username ( modelName: USERNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: USERNAME, type: esriFieldTypeString )
• cldxf_postdirectional ( modelName: CLDXF_PostDirectional, nullable: true, editable: true, defaultValue: null, length: 25, alias: CLDXF_PostDirectional, type: esriFieldTypeString , Coded Values: [East: East] , [North: North] , [Northeast: Northeast] , ...5 more... )
• cldxf_posttype ( modelName: CLDXF_PostType, nullable: true, editable: true, defaultValue: null, length: 25, alias: CLDXF_PostType, type: esriFieldTypeString , Coded Values: [Acres: Acres] , [Alley: Alley] , [Annex: Annex] , ...247 more... )
• cldxf_predirectional ( modelName: CLDXF_PreDirectional, nullable: true, editable: true, defaultValue: null, length: 10, alias: CLDXF_PreDirectional, type: esriFieldTypeString , Coded Values: [East: East] , [North: North] , [Northeast: Northeast] , ...5 more... )
• sp_username ( modelName: SP_USERNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: SP_USERNAME, type: esriFieldTypeString )
• ap_flag ( modelName: AP_Flag, nullable: true, editable: true, defaultValue: null, length: 20, alias: AP_Flag, type: esriFieldTypeString )
• latitude ( modelName: Latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• sourceofdata ( modelName: SourceOfData, nullable: true, editable: true, defaultValue: 911 Addressing Authority, length: 30, alias: SourceOfData, type: esriFieldTypeString )
• addresssource ( modelName: AddressSource, nullable: false, editable: true, defaultValue: 911 AA, length: 30, alias: AddressSource, type: esriFieldTypeString , Coded Values: [911 AA: 911 Addressing Authority] , [County 911 AL: County 911 Address List] , [County AP: County Address Points] , ...7 more... )
• mapsource ( modelName: MapSource, nullable: true, editable: true, defaultValue: M, length: 1, alias: Source, type: esriFieldTypeString , Coded Values: [G: GPS] , [O: Orthophoto] , [M: Manual] )
• geonameid ( modelName: GeoNameID, nullable: true, editable: true, defaultValue: null, alias: GeoNameID, type: esriFieldTypeInteger )
• streetid ( modelName: StreetID, nullable: true, editable: true, defaultValue: 0, alias: StreetID, type: esriFieldTypeInteger )
• nysstreetid ( modelName: NYSStreetID, nullable: false, editable: true, defaultValue: null, alias: NYSStreetID, type: esriFieldTypeInteger )
• esiteid ( modelName: ESiteID, nullable: true, editable: true, defaultValue: null, length: 40, alias: CountyID, type: esriFieldTypeString )
• longitude ( modelName: Longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• nysaddresspointid ( modelName: NYSAddressPointID, nullable: false, editable: true, defaultValue: null, length: 10, alias: NYSAddressPointID, type: esriFieldTypeString )
• sp_datetime ( modelName: SP_DATETIME, nullable: true, editable: true, defaultValue: null, length: 29, alias: SP_DATETIME, type: esriFieldTypeDate )
• pictureid ( modelName: PictureID, nullable: true, editable: true, defaultValue: null, length: 150, alias: PictureID, type: esriFieldTypeString )
• rcinguid ( modelName: rcInguid, nullable: true, editable: true, defaultValue: null, length: 254, alias: NENA Global ID, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• vzst ( modelName: VZST, nullable: true, editable: true, defaultValue: null, length: 10, alias: VZST, type: esriFieldTypeString )
• vzpt ( modelName: VZPT, nullable: true, editable: true, defaultValue: null, length: 10, alias: VZPT, type: esriFieldTypeString )
• join_id ( modelName: JOIN_ID, nullable: true, editable: true, defaultValue: null, alias: JOIN_ID, type: esriFieldTypeDouble )
• tn ( modelName: TN, nullable: true, editable: true, defaultValue: null, length: 20, alias: Telephone Number, type: esriFieldTypeString )
• leftright ( modelName: LeftRight, nullable: true, editable: true, defaultValue: null, length: 5, alias: LR, type: esriFieldTypeString , Coded Values: [Left: Left] , [Right: Right] )
• dbpictureid ( modelName: DBPictureID, nullable: true, editable: true, defaultValue: null, alias: DBPictureID, type: esriFieldTypeInteger )
• municipality ( modelName: MUNICIPALITY, nullable: true, editable: true, defaultValue: null, length: 100, alias: MUNI, type: esriFieldTypeString , Coded Values: [BE: Bethel] , [CA: Callicoon] , [CO: Cochecton] , ...30 more... )
• description ( modelName: Description, nullable: true, editable: true, defaultValue: null, length: 255, alias: Description, type: esriFieldTypeString )
• psap ( modelName: PSAP, nullable: true, editable: true, defaultValue: Sullivan County E-911, length: 50, alias: PSAP, type: esriFieldTypeString )
• override ( modelName: Override, nullable: true, editable: true, defaultValue: null, alias: Override, type: esriFieldTypeBlob )
• ruleid ( modelName: RuleID, nullable: true, editable: true, defaultValue: null, alias: RuleID, type: esriFieldTypeInteger , Coded Values: [1: Current] , [2: Pending] , [3: Temporary] , ...3 more... )
• usegf ( modelName: UseGF, nullable: true, editable: true, defaultValue: 0, alias: UseGF, type: esriFieldTypeInteger , Coded Values: [1: Yes] , [0: No] , [2: Unknown] )
• centerlineid ( modelName: CENTERLINEID, nullable: true, editable: true, defaultValue: null, length: 20, alias: CenterlineID, type: esriFieldTypeString )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• calcaddrnum ( modelName: CalcAddrNum, nullable: true, editable: true, defaultValue: null, length: 20, alias: CalcAddrNum, type: esriFieldTypeString )
• capturemeth ( modelName: CAPTUREMETH, nullable: true, editable: true, defaultValue: null, length: 30, alias: Capture Method, type: esriFieldTypeString , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...4 more... )
• usngcoord ( modelName: USNGCOORD, nullable: true, editable: true, defaultValue: null, length: 50, alias: USNG Coordinate, type: esriFieldTypeString )
• country ( modelName: Country, nullable: true, editable: true, defaultValue: US, length: 2, alias: Country, type: esriFieldTypeString )
• building ( modelName: Building, nullable: true, editable: true, defaultValue: null, length: 40, alias: Building, type: esriFieldTypeString )
• altunitid ( modelName: ALTUNITID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Alternate Address Unit Number, type: esriFieldTypeString )
• altunittype ( modelName: ALTUNITTYPE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Alternate Address Unit Type, type: esriFieldTypeString , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...23 more... )
• unitid ( modelName: UNITID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Address Unit Number, type: esriFieldTypeString )
• unittype ( modelName: UNITTYPE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Address Unit Type, type: esriFieldTypeString , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...23 more... )
• addrrange ( modelName: ADDRRANGE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Address Range, type: esriFieldTypeString )
• addrnumsuf ( modelName: ADDRNUMSUF, nullable: true, editable: true, defaultValue: null, length: 10, alias: SuffixAddressNumber, type: esriFieldTypeString , Coded Values: [1: 1] , [1/2: 1/2] , [1/2-A: 1/2-A] , ...50 more... )
• addrnum ( modelName: ADDRNUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Full Address Number, type: esriFieldTypeString )
• floor ( modelName: Floor, nullable: true, editable: true, defaultValue: null, length: 40, alias: Floor, type: esriFieldTypeString )
• preaddrnum ( modelName: PREADDRNUM, nullable: true, editable: true, defaultValue: null, length: 5, alias: Address Number Prefix, type: esriFieldTypeString )
• gfaddressnum ( modelName: GFAddressNum, nullable: true, editable: true, defaultValue: null, length: 15, alias: GFAddressNum, type: esriFieldTypeString )
• parcelnum ( modelName: ParcelNum, nullable: true, editable: true, defaultValue: null, length: 30, alias: ParcelNum, type: esriFieldTypeString )
• primarypoint ( modelName: PrimaryPoint, nullable: true, editable: true, defaultValue: Y, length: 3, alias: PrimaryPoint, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• sitetype ( modelName: SiteType, nullable: true, editable: true, defaultValue: R1, length: 2, alias: SiteType, type: esriFieldTypeString , Coded Values: [R1: Single Family] , [R2: Multi Family] , [R3: Mobile Home] , ...43 more... )
• pointtype ( modelName: POINTTYPE, nullable: true, editable: true, defaultValue: 1, length: 30, alias: Location, type: esriFieldTypeString , Coded Values: [1: Rooftop] , [2: Primary Structure Entrance] , [3: Driveway Entrance] , ...8 more... )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: Active, length: 30, alias: Status, type: esriFieldTypeString , Coded Values: [Active: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• addptkey ( modelName: ADDPTKEY, nullable: true, editable: true, defaultValue: null, length: 20, alias: Address Point ID, type: esriFieldTypeString )
• siteaddid ( modelName: SITEADDID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Site Address ID, type: esriFieldTypeString )
• esn ( modelName: ESN, nullable: true, editable: true, defaultValue: null, alias: Emergency Service Number, type: esriFieldTypeInteger )
• unit ( modelName: Unit, nullable: true, editable: true, defaultValue: null, length: 40, alias: Unit, type: esriFieldTypeString )
• room ( modelName: Room, nullable: true, editable: true, defaultValue: null, length: 40, alias: Room, type: esriFieldTypeString )
• seat ( modelName: Seat, nullable: true, editable: true, defaultValue: null, length: 40, alias: Seat, type: esriFieldTypeString )
• state ( modelName: State, nullable: false, editable: true, defaultValue: NY, length: 2, alias: State, type: esriFieldTypeString )
• countyname ( modelName: CountyName, nullable: true, editable: true, defaultValue: Sullivan, length: 50, alias: CountyName, type: esriFieldTypeString )
• zipcode ( modelName: ZIPCode, nullable: false, editable: true, defaultValue: null, length: 5, alias: ZIP, type: esriFieldTypeString )
• pstlcity ( modelName: ZipName, nullable: false, editable: true, defaultValue: null, length: 30, alias: Postal City, type: esriFieldTypeString )
• fulladdr ( modelName: FULLADDR, nullable: true, editable: true, defaultValue: null, length: 250, alias: Full Address, type: esriFieldTypeString )
• fullname ( modelName: FULLNAME, nullable: true, editable: true, defaultValue: null, length: 125, alias: Full Road Name, type: esriFieldTypeString )
• addrclass ( modelName: ADDRCLASS, nullable: true, editable: true, defaultValue: 790, alias: Description, type: esriFieldTypeInteger , Coded Values: [701: Agriculture, Food, and Livestock] , [710: Industry] , [720: Commercial and Retail] , ...13 more... )
• placename ( modelName: PLACENAME, nullable: true, editable: true, defaultValue: null, length: 250, alias: Place Name, type: esriFieldTypeString )
• subaddress ( modelName: SubAddress, nullable: true, editable: true, defaultValue: null, length: 200, alias: SubAddress, type: esriFieldTypeString )
• postmodifier ( modelName: PostModifier, nullable: true, editable: true, defaultValue: null, length: 25, alias: PostModifier, type: esriFieldTypeString )
• roadpostdir ( modelName: SD, nullable: true, editable: true, defaultValue: null, length: 10, alias: SD, type: esriFieldTypeString , Coded Values: [E: East] , [N: North] , [S: South] , ...9 more... )
• roadtype ( modelName: ST, nullable: true, editable: true, defaultValue: null, length: 20, alias: ST, type: esriFieldTypeString , Coded Values: [Acrs: Acres] , [Aly: Alley] , [Anx: Annex] , ...246 more... )
• roadname ( modelName: SN, nullable: false, editable: true, defaultValue: null, length: 40, alias: SN, type: esriFieldTypeString )
• separatorelement ( modelName: SeparatorElement, nullable: true, editable: true, defaultValue: null, length: 10, alias: SeparatorElement, type: esriFieldTypeString , Coded Values: [And: And] , [At: At] , [At The: At The] , ...12 more... )
• roadpretype ( modelName: PT, nullable: true, editable: true, defaultValue: null, length: 25, alias: PT, type: esriFieldTypeString , Coded Values: [Farm: Farm] , [Loop: Loop] , [Oval: Oval] , ...39 more... )
• roadpredir ( modelName: PD, nullable: true, editable: true, defaultValue: null, length: 10, alias: PD, type: esriFieldTypeString , Coded Values: [E: East] , [N: North] , [S: South] , ...9 more... )
• premodifier ( modelName: PreModifier, nullable: true, editable: true, defaultValue: null, length: 25, alias: PreModifier, type: esriFieldTypeString )
• placetype ( modelName: PlaceType, nullable: true, editable: true, defaultValue: null, length: 75, alias: PlaceType, type: esriFieldTypeString , Coded Values: [Bench: Bench] , [Boat Site: Boat Site] , [Bridge: Bridge] , ...24 more... )
• location ( modelName: Location, nullable: true, editable: true, defaultValue: null, length: 40, alias: Location, type: esriFieldTypeString )
• discrpagid ( modelName: discrpagid, nullable: true, editable: true, defaultValue: null, length: 75, alias: Discrepancy Agency ID, type: esriFieldTypeString )
• msag ( modelName: msag, nullable: true, editable: true, defaultValue: null, length: 35, alias: MSAG Community, type: esriFieldTypeString , Coded Values: [BE: Bethel] , [CA: Callicoon] , [CO: Cochecton] , ...30 more... )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, 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, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )

Templates:

• Name: Site Address Points
  Description:
  Prototype:
  usegf: 0
  country: US
  esn: null
  pointtype: 1
  geonameid: null
  centerlineid: null
  discrpagid: null
  municipality: null
  roadpostdir: null
  roadtype: null
  building: null
  cr_username: null
  vzst: null
  capturemeth: null
  sp_username: null
  state: NY
  nysstreetid: 0
  addptkey: null
  roadpredir: null
  streetid: 0
  longitude: null
  at_username: null
  placetype: null
  addrrange: null
  unittype: null
  pstlcity:
  altunittype: null
  rcinguid: null
  roadpretype: null
  addrclass: 790
  parcelnum: null
  altunitid: null
  leftright: null
  zipcode:
  seat: null
  sp_datetime: null
  unit: null
  gfaddressnum: null
  addresssource: 911 AA
  ap_flag: null
  cldxf_postdirectional: null
  at_datetime: null
  subaddress: null
  usngcoord: null
  lastupdate: null
  dbpictureid: null
  ruleid: null
  status: Active
  cr_datetime: null
  psap: Sullivan County E-911
  postmodifier: null
  latitude: null
  mapsource: M
  description: null
  addrnumsuf: null
  sitetype: R1
  placename: null
  cldxf_predirectional: null
  primarypoint: Y
  nysaddresspointid:
  calcaddrnum: null
  separatorelement: null
  esiteid: null
  fulladdr: null
  override: null
  floor: null
  siteaddid: null
  addrnum: null
  premodifier: null
  join_id: null
  cldxf_posttype: null
  lasteditor: null
  countyname: Sullivan
  room: null
  pictureid: null
  unitid: null
  location: null
  tn: null
  preaddrnum: null
  fullname: null
  sourceofdata: 911 Addressing Authority
  roadname:
  username: null
  msag: null
  vzpt: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• RoadCenterline (0) -- Related To: Road Centerlines (1)

Capabilities: Query,Extract

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: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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