View In:   ArcGIS Online Map Viewer

Name: Civic Address Points

Display Field: COMMUNITY_ADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Civic address points created from municipal sources. Created primarily from Oxford County's 9-1-1 six digit address locates and assessment records Exported weekly to Oxford_OpenData 17-08-2023

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: 489555.6629999997
YMin: 4742014.827
XMax: 545694.5750000002
YMax: 4799934.368000001
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 0, 125, 255]
Size: 4.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:

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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 9, defaultValue: null, modelName: PIN )
• XROLL ( type: esriFieldTypeString, alias: XROLL, editable: true, nullable: true, length: 15, defaultValue: null, modelName: XROLL )
• ADDRESSID ( type: esriFieldTypeInteger, alias: ADDRESSID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESSID )
• ADDRESS_NUMBER ( type: esriFieldTypeInteger, alias: ADDRESS_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_NUMBER )
• ADDRESS_NUMBER_HIGH ( type: esriFieldTypeInteger, alias: ADDRESS_NUMBER_HIGH, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_NUMBER_HIGH )
• ADDRESS_QUALIFIER ( type: esriFieldTypeString, alias: ADDRESS_QUALIFIER, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDRESS_QUALIFIER )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UNIT_TYPE )
• UNIT ( type: esriFieldTypeString, alias: UNIT, editable: true, nullable: true, length: 12, defaultValue: null, modelName: UNIT )
• ROADNAMEID ( type: esriFieldTypeInteger, alias: ROADNAMEID, editable: true, nullable: true, defaultValue: null, modelName: ROADNAMEID )
• ROADNAME ( type: esriFieldTypeString, alias: ROADNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROADNAME )
• ROAD_NUM ( type: esriFieldTypeSmallInteger, alias: ROAD_NUM, editable: true, nullable: true, defaultValue: null, modelName: ROAD_NUM )
• MU ( type: esriFieldTypeString, alias: MU, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MU )
• PARENT_ADDRESSID ( type: esriFieldTypeInteger, alias: PARENT_ADDRESSID, editable: true, nullable: true, defaultValue: null, modelName: PARENT_ADDRESSID )
• DATA_SOURCE ( type: esriFieldTypeString, alias: DATA_SOURCE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DATA_SOURCE )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• LAT ( type: esriFieldTypeDouble, alias: LAT, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• LONG_ ( type: esriFieldTypeDouble, alias: LONG_, editable: true, nullable: true, defaultValue: null, modelName: LONG_ )
• URBAN ( type: esriFieldTypeString, alias: URBAN, editable: true, nullable: true, length: 1, defaultValue: null, modelName: URBAN )
• IS_EXCEPTION ( type: esriFieldTypeString, alias: IS_EXCEPTION, editable: true, nullable: true, length: 1, defaultValue: null, modelName: IS_EXCEPTION )
• EXCEPTION_NOTE ( type: esriFieldTypeString, alias: EXCEPTION_NOTE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXCEPTION_NOTE )
• EDIT_USERNAME ( type: esriFieldTypeString, alias: EDIT_USERNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EDIT_USERNAME )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
• END_DATE ( type: esriFieldTypeDate, alias: END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_DATE )
• END_USERNAME ( type: esriFieldTypeString, alias: END_USERNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: END_USERNAME )
• END_REASON ( type: esriFieldTypeString, alias: END_REASON, editable: true, nullable: true, length: 1, defaultValue: null, modelName: END_REASON )
• START_DATE ( type: esriFieldTypeDate, alias: START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATE )
• START_USERNAME ( type: esriFieldTypeString, alias: START_USERNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: START_USERNAME )
• Community ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Community )
• COMMUNITY_ADDRESS ( type: esriFieldTypeString, alias: COMMUNITY_ADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMUNITY_ADDRESS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PINParent ( type: esriFieldTypeString, alias: PINParent, editable: true, nullable: true, length: 9, defaultValue: null, modelName: PINParent )
• County_DC ( type: esriFieldTypeString, alias: County_DC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: County_DC )
• WaterWW_DC ( type: esriFieldTypeString, alias: WaterWW_DC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WaterWW_DC )
• Muni_DC ( type: esriFieldTypeString, alias: Muni_DC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Muni_DC )
• DC_ServiceArea ( type: esriFieldTypeString, alias: DC_ServiceArea, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DC_ServiceArea )
• PropertyRSN ( type: esriFieldTypeInteger, alias: PropertyRSN, editable: true, nullable: true, defaultValue: null, modelName: PropertyRSN )
• ParentPropertyRSN ( type: esriFieldTypeInteger, alias: ParentPropertyRSN, editable: true, nullable: true, defaultValue: null, modelName: ParentPropertyRSN )

Templates:

• Name: OxfordSDE.OXDATA.Civic_Address_pt
  Description:
  Prototype:
  PropertyRSN: null
  PIN: null
  XROLL: null
  ADDRESSID: null
  ADDRESS_NUMBER: null
  ADDRESS_NUMBER_HIGH: null
  ADDRESS_QUALIFIER: null
  UNIT_TYPE: null
  UNIT: null
  ROADNAMEID: null
  ROADNAME: null
  ROAD_NUM: null
  MU: null
  PARENT_ADDRESSID: null
  DATA_SOURCE: null
  XCOORD: null
  YCOORD: null
  LAT: null
  LONG_: null
  URBAN: null
  IS_EXCEPTION: null
  EXCEPTION_NOTE: null
  EDIT_USERNAME: null
  EDIT_DATE: null
  END_DATE: null
  END_USERNAME: null
  END_REASON: null
  START_DATE: null
  START_USERNAME: null
  Community: null
  COMMUNITY_ADDRESS: null
  ParentPropertyRSN: null
  PINParent: null
  County_DC: null
  WaterWW_DC: null
  Muni_DC: null
  DC_ServiceArea: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

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