View In:   ArcGIS Online Map Viewer

Name: Address Points

Display Field: St_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9174ead10ef848788523b985ed755891

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

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: 1039196.3098958135
YMin: 668491.2480468601
XMax: 1298065.5026041567
YMax: 830248.3164062351
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSSquare
Color: [255, 0, 0, 255]
Size: 3.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• EFFECTIVE_STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 6, defaultValue: null, modelName: EFFECTIVE_STATUS , Coded Values: [ACTIVE: ACTIVE] , [PH: PH] , [PRELIM: PRELIM] , ...2 more... )
• STNUM ( type: esriFieldTypeInteger, alias: Street Number, editable: true, nullable: true, defaultValue: null, modelName: STNUM )
• PREDIR ( type: esriFieldTypeString, alias: Pre Direction, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PREDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• STREET_NAM ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_NAME )
• TYPE ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TYPE , Coded Values: [ALY: ALLEY] , [BLVD: BOULEVARD] , [CIR: CIRCLE] , ...48 more... )
• POSTDIR ( type: esriFieldTypeString, alias: Post Direction, editable: true, nullable: true, length: 3, defaultValue: null, modelName: POSTDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• UNITTYPE ( type: esriFieldTypeString, alias: Unit Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: UNITTYPE , Coded Values: [APT: APARTMENT] , [BSMT: BASEMENT] , [DEPT: DEPARTMENT] , ...21 more... )
• UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 5, defaultValue: null, modelName: UNIT )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CITY , Coded Values: [Bostic: Bostic] , [Casar: Casar] , [Collettsville: Collettsville] , ...13 more... )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 50, defaultValue: BURKE, modelName: COUNTY , Coded Values: [BURKE: Burke] , [AVERY: Avery] , [CALDWELL: Caldwell] , ...5 more... )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: NC, modelName: STATE , Coded Values: [NC: North Carolina] )
• ZIPCODE ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIPCODE , Coded Values: [28601: 28601] , [28602: 28602] , [28612: 28612] , ...15 more... )
• ZIPCODE_PLUS4 ( type: esriFieldTypeString, alias: Zip Plus 4, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIPCODE_PLUS4 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: COMMENT )
• XStPlane ( type: esriFieldTypeDouble, alias: State Plane X, editable: true, nullable: true, defaultValue: null, modelName: XStPlane )
• YStPlane ( type: esriFieldTypeDouble, alias: State Plane Y, editable: true, nullable: true, defaultValue: null, modelName: YStPlane )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PIN )
• CITYLIM ( type: esriFieldTypeString, alias: Jurisdiction City, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CITYLIM )
• ETJ ( type: esriFieldTypeString, alias: ETJ, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ETJ )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ESN )
• EDIT_DATE ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
• EDIT_USER ( type: esriFieldTypeString, alias: Edit User, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EDIT_USER )
• CAD_CITY ( type: esriFieldTypeString, alias: CAD City, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CAD_CITY , Coded Values: [BC: BC] , [CONN: CONN] , [DREX: DREX] , ...14 more... )
• STREET_NUMBER_PREFIX ( type: esriFieldTypeString, alias: Street Number Prefix, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_NUMBER_PREFIX )
• STREET_NUMBER_SUFFIX ( type: esriFieldTypeString, alias: Street Number Suffix, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_NUMBER_SUFFIX )
• PRE_MODIFIER ( type: esriFieldTypeString, alias: Pre Modifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRE_MODIFIER )
• PRE_TYPE ( type: esriFieldTypeString, alias: Pre Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRE_TYPE )
• POST_MODIFIER ( type: esriFieldTypeString, alias: Post Modifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POST_MODIFIER )
• AddressPointID ( type: esriFieldTypeInteger, alias: AddressPointID, editable: true, nullable: true, defaultValue: null, modelName: AddressPointID )
• FullAddress ( type: esriFieldTypeString, alias: FullName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FullAddress )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Pending, modelName: Status , Coded Values: [Active: Active] , [Pending: Pending] , [Reserved: Reserved] , ...1 more... )
• St_PreMod ( type: esriFieldTypeString, alias: Street name Pre Modifier, editable: true, nullable: true, length: 15, defaultValue: null, modelName: St_PreMod )
• St_PreDir ( type: esriFieldTypeString, alias: Street Name Pre Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PreDir , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...5 more... )
• St_PreTyp ( type: esriFieldTypeString, alias: Street Name Pre Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PreTyp , Coded Values: [ACCESS ROAD: ACCESS ROAD] , [ACRES: ACRES] , [ALCOVE: ALCOVE] , ...245 more... )
• St_PreSep ( type: esriFieldTypeString, alias: Street Name Pre Type Separator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: St_PreSep , Coded Values: [at: at] , [de las: de las] , [del: del] , ...7 more... )
• St_Name ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: StreetName )
• St_PosTyp ( type: esriFieldTypeString, alias: Street Name Post Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PosTyp , Coded Values: [ACCESS ROAD: ACCESS ROAD] , [ACRES: ACRES] , [ALCOVE: ALCOVE] , ...245 more... )
• St_PosDir ( type: esriFieldTypeString, alias: Street Name Post Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PosDir , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...5 more... )
• St_PosMod ( type: esriFieldTypeString, alias: Street Name Post Modifier, editable: true, nullable: true, length: 25, defaultValue: null, modelName: St_PosMod )
• MSAG_COMM ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MSAGComm )
• Post_Comm ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Post_Comm )
• Post_Code ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Post_Code )
• Post_Code4 ( type: esriFieldTypeString, alias: ZIP Plus 4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Post_Code4 )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Building )
• Long ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Long )
• Lat ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Lat )
• Elev ( type: esriFieldTypeSmallInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elev )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: false, length: 2, defaultValue: US, modelName: Country )
• DiscrpAgID ( type: esriFieldTypeString, alias: Discrepancy Agency ID, editable: true, nullable: true, length: 75, defaultValue: burknceo1.burke.nc.us, modelName: DiscrpAgID )
• Site_NGUID ( type: esriFieldTypeString, alias: Site NENA Globally Unique ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Site_NGUID )
• MasterStreetNameID ( type: esriFieldTypeInteger, alias: MasterStreetNameID, editable: true, nullable: true, defaultValue: null, modelName: MasterStreetNameID )
• CenterlineID ( type: esriFieldTypeInteger, alias: CenterlineID, editable: true, nullable: true, defaultValue: null, modelName: CenterlineID )
• FULLNAME ( type: esriFieldTypeString, alias: Legacy FullName, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LST_FullName )
• common_pla ( type: esriFieldTypeString, alias: common_pla, editable: true, nullable: true, length: 255, defaultValue: null, modelName: common_pla )
• CITY_CODE ( type: esriFieldTypeString, alias: CITY_CODE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CITY_CODE )
• ST_NUM ( type: esriFieldTypeInteger, alias: ST_NUM, editable: true, nullable: true, defaultValue: null, modelName: ST_NUM )
• NgFullName ( type: esriFieldTypeString, alias: NgFullName, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NgFullName )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CREATE_USER )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• GC_Exceptions ( type: esriFieldTypeString, alias: GC_Exceptions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GC_Exceptions )

Templates:

• Name: SiteStructureAddressPoints
  Description:
  Prototype:
  ST_NUM: null
  EFFECTIVE_STATUS: null
  STNUM: null
  PREDIR: null
  STREET_NAM: null
  TYPE: null
  POSTDIR: null
  UNITTYPE: null
  UNIT: null
  CITY: null
  COUNTY: BURKE
  STATE: NC
  ZIPCODE: null
  ZIPCODE_PLUS4: null
  ADDRESS: null
  COMMENT: null
  XStPlane: null
  YStPlane: null
  PIN: null
  CITYLIM: null
  ETJ: null
  ESN: null
  GC_Exceptions: null
  NgFullName: null
  CAD_CITY: null
  STREET_NUMBER_PREFIX: null
  STREET_NUMBER_SUFFIX: null
  PRE_MODIFIER: null
  PRE_TYPE: null
  POST_MODIFIER: null
  AddressPointID: null
  FullAddress: null
  Status: Pending
  St_PreMod: null
  St_PreDir: null
  St_PreTyp: null
  St_PreSep: null
  St_Name: null
  St_PosTyp: null
  St_PosDir: null
  St_PosMod: null
  MSAG_COMM: null
  Post_Comm: null
  Post_Code: null
  Post_Code4: null
  Building: null
  Long: null
  Lat: null
  Elev: null
  Country: US
  DiscrpAgID: burknceo1.burke.nc.us
  Site_NGUID: null
  MasterStreetNameID: null
  CenterlineID: null
  FULLNAME: null
  common_pla: null
  CITY_CODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATE_DATE
• Creator Field: CREATE_USER
• Edit Date Field: EDIT_DATE
• Editor Field: EDIT_USER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata