View In:   ArcGIS Online Map Viewer

Name: OrangeGIS.DBO.SiteAddressPoint

Display Field: ROADNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Site Address Points are maintained and updated weekly by Building & Development Services and the GIS team.

Service Item Id: f65b634411744aa8a318e0412572f556

Copyright Text: Orange County GIS

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 1.152239829815355E7
YMin: 6727203.381376222
XMax: 1.1706248389114052E7
YMax: 6825160.693007141
Spatial Reference: 102746  (2283)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [74, 73, 155, 255]
Size: 4.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:

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: false
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 )
• SITEADDID ( type: esriFieldTypeString, alias: Site Address ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITEADDID )
• ADDRESSPTID ( type: esriFieldTypeString, alias: Address Point ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDPTKEY )
• PREADDRNUM ( type: esriFieldTypeString, alias: Address Number Prefix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PREADDRNUM )
• ADDRNUMSUF ( type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADDRNUMSUF )
• ADDRNUM ( type: esriFieldTypeString, alias: Full Address Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDRNUM )
• ADDRRANGE ( type: esriFieldTypeString, alias: Address Range, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRRANGE )
• UNITTYPE ( type: esriFieldTypeString, alias: Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITTYPE , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• UNITID ( type: esriFieldTypeString, alias: Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITID )
• ALTUNITTYPE ( type: esriFieldTypeString, alias: Alternate Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITTYPE , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• ALTUNITID ( type: esriFieldTypeString, alias: Alternate Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITID )
• ROADPREDIR ( type: esriFieldTypeString, alias: Road Prefix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADPREDIR , Coded Values: [N: North] , [S: South] , [E: East] , ...9 more... )
• ROADNAME ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ROADNAME )
• ROADTYPE ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROADTYPE , Coded Values: [Aly: Alley] , [Anx: Anex] , [Arc: Arcade] , ...207 more... )
• FULLNAME ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULLNAME )
• FULLADDR ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULLADDR )
• PSTLZIP5 ( type: esriFieldTypeString, alias: Postal Zip 5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PSTLZIP5 )
• PLACENAME ( type: esriFieldTypeString, alias: Place Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PLACENAME )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MUNICIPALITY , Coded Values: [Barboursville: Barboursville] , [Burr Hill: Burr Hill] , [Culpeper: Culpeper] , ...7 more... )
• COMMUNITY ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMMUNITY )
• ESN ( type: esriFieldTypeString, alias: Emergency Service Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• PSAP ( type: esriFieldTypeString, alias: Public Safety Answering Point, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSAP )
• USNGCOORD ( type: esriFieldTypeString, alias: USNG Coordinate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USNGCOORD )
• SAD ( type: esriFieldTypeString, alias: SAD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAD )
• MSAG ( type: esriFieldTypeString, alias: MSAG Community, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MSAG )
• MSAGSOURCE ( type: esriFieldTypeString, alias: MSAG Source, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MSAGCOUNTY )
• FeaCode ( type: esriFieldTypeString, alias: FeaCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeaCode )
• LAYER ( type: esriFieldTypeString, alias: LAYER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAYER )
• ADDRCLASS ( type: esriFieldTypeInteger, alias: Description, editable: true, nullable: true, defaultValue: null, modelName: ADDRCLASS , Coded Values: [701: Agriculture, Food, and Livestock] , [710: Industry] , [720: Commercial and Retail] , ...13 more... )
• POINTTYPE ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE , Coded Values: [Building: Building] , [Parcel: Parcel] , [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite] , ...3 more... )
• CAPTUREMETH ( type: esriFieldTypeString, alias: Capture Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CAPTUREMETH , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...2 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 30, defaultValue: Current, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• CREATEDDATE ( type: esriFieldTypeDate, alias: Create Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE )
• CREATEDBY ( type: esriFieldTypeString, alias: Create By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATEDBY )
• MODIFIEDDATE ( type: esriFieldTypeDate, alias: Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MODIFIEDDATE )
• MODIFIEDBY ( type: esriFieldTypeString, alias: Modified By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODIFIEDBY )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE , Coded Values: [VA: VA] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• PDFNAME ( type: esriFieldTypeString, alias: PDFNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PDFNAME )

Templates:

• Name: OrangeGIS.DBO.SiteAddressPoint
  Description:
  Prototype:
  STATE: null
  PDFNAME: null
  SITEADDID: null
  ADDRESSPTID: null
  PREADDRNUM: null
  ADDRNUMSUF: null
  ADDRNUM: null
  ADDRRANGE: null
  UNITTYPE: null
  UNITID: null
  ALTUNITTYPE: null
  ALTUNITID: null
  ROADPREDIR: null
  ROADNAME: null
  ROADTYPE: null
  FULLNAME: null
  FULLADDR: null
  PSTLZIP5: null
  PLACENAME: null
  MUNICIPALITY: null
  COMMUNITY: null
  ESN: null
  PSAP: null
  USNGCOORD: null
  SAD: null
  MSAG: null
  MSAGSOURCE: null
  FeaCode: null
  LAYER: null
  ADDRCLASS: null
  POINTTYPE: null
  CAPTUREMETH: null
  STATUS: Current
  CREATEDDATE: null
  CREATEDBY: null
  MODIFIEDDATE: null
  MODIFIEDBY: null
  LATITUDE: null
  LONGITUDE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata