View In:   ArcGIS Online Map Viewer

Name: arcserver.DBO.AddressPoint

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: arcserver.DBO.AddressPoint

Service Item Id: 47b4f1b05b9947cdb5b3cea41e37ad15

Copyright Text:

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: 2488542.0402266607
YMin: 1401291.850931406
XMax: 2577071.080031745
YMax: 1469787.9613142386
Spatial Reference: 102667  (2240)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [142, 132, 57, 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: 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 )
• AddressID ( type: esriFieldTypeDouble, alias: AddressID, editable: true, nullable: true, defaultValue: null, modelName: AddressID )
• ParcelID ( type: esriFieldTypeString, alias: ParcelID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ParcelID )
• FullAdd ( type: esriFieldTypeString, alias: FullAdd, editable: true, nullable: true, length: 70, defaultValue: null, modelName: FullAdd )
• HouseNum ( type: esriFieldTypeDouble, alias: HouseNum, editable: true, nullable: true, defaultValue: null, modelName: HouseNum )
• HouseNumEx ( type: esriFieldTypeString, alias: HouseNumEx, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HouseNumEx )
• FullHouseNum ( type: esriFieldTypeString, alias: FullHouseNum, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FullHouseNum )
• PreDir ( type: esriFieldTypeString, alias: PreDir, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PreDir )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName )
• StreetType ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StreetType )
• PostDir ( type: esriFieldTypeString, alias: PostDir, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PostDir )
• FullStreetName ( type: esriFieldTypeString, alias: FullStreetName, editable: true, nullable: true, length: 70, defaultValue: null, modelName: FullStreetName )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UnitType , Coded Values: [APT: APT] , [STE: STE] , [LOT: LOT] , ...1 more... )
• Unit ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Unit )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Building )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Floor )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 15, defaultValue: null, modelName: City )
• POSTALCITY ( type: esriFieldTypeString, alias: POSTALCITY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTALCITY )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 4, defaultValue: null, modelName: State )
• Zipcode ( type: esriFieldTypeDouble, alias: Zipcode, editable: true, nullable: true, defaultValue: null, modelName: Zipcode )
• AddClass ( type: esriFieldTypeString, alias: AddClass, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddClass , Coded Values: [UGA: UGA] , [CORNER LOT: Corner Lot] , [GOVERNMENT: Government] , ...6 more... )
• AddType ( type: esriFieldTypeString, alias: AddType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddType , Coded Values: [BUILDING: Building] , [PARCEL: Parcel] , [UNIT: Unit, Apartment, Condo, Lot or Suite] , ...3 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Status )
• Anomoly ( type: esriFieldTypeString, alias: Anomoly, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Anomoly , Coded Values: [ODDONEVEN: Odd on Even Side] , [EVENONODD: Even on Odd Side] , [OUTOFRANGE: Outside of Address Range] , ...1 more... )
• AddStart ( type: esriFieldTypeDate, alias: AddStart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AddStart )
• AddEnd ( type: esriFieldTypeDate, alias: AddEnd, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AddEnd )
• EditDate ( type: esriFieldTypeString, alias: EditDate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EditDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• JOINID ( type: esriFieldTypeString, alias: JOINID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JOINID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DegreeX ( type: esriFieldTypeDouble, alias: DegreeX, editable: true, nullable: true, defaultValue: null, modelName: DegreeX )
• DegreeY ( type: esriFieldTypeDouble, alias: DegreeY, editable: true, nullable: true, defaultValue: null, modelName: DegreeY )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: arcserver.DBO.AddressPoint
  Description:
  Prototype:
  DegreeX: null
  DegreeY: null
  AddressID: null
  ParcelID: null
  FullAdd: null
  HouseNum: null
  HouseNumEx: null
  FullHouseNum: null
  PreDir: null
  StreetName: null
  StreetType: null
  PostDir: null
  FullStreetName: null
  UnitType: null
  Unit: null
  Building: null
  Floor: null
  City: null
  POSTALCITY: null
  State: null
  Zipcode: null
  AddClass: null
  AddType: null
  Status: null
  Anomoly: null
  AddStart: null
  AddEnd: null
  EditDate: null
  Comments: null
  JOINID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Child Resources:   Field Groups   Contingent Values

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