View In:   ArcGIS Online Map Viewer

Name: DBO.PointAddresses

Display Field: LOCATION

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3326ef715b0a4adab70bf458fed75250

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: 2314010.7942401157
YMin: 1900027.7251554555
XMax: 2490094.1484019156
YMax: 1999765.3330936588
Spatial Reference: 102695  (2255)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [158, 86, 44, 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:
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: 10
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Feature Draw Order:

N/A

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: 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 ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• LOCATION ( modelName: LOCATION, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: LOCATION, type: esriFieldTypeString )
• SITE_TYPE ( modelName: SITE_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: SITE_TYPE, type: esriFieldTypeString )
• NUMBER ( modelName: NUMBER, nullable: true, editable: true, defaultValue: N/A, alias: NUMBER, type: esriFieldTypeInteger )
• PREFIX_DIR ( modelName: PREFIX_DIR, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: PREFIX_DIR, type: esriFieldTypeString )
• STREET_NAM ( modelName: STREET_NAM, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: STREET_NAM, type: esriFieldTypeString )
• STREET_TYP ( modelName: STREET_TYP, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: STREET_TYP, type: esriFieldTypeString )
• SUFFIX_DIR ( modelName: SUFFIX_DIR, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SUFFIX_DIR, type: esriFieldTypeString )
• ALIAS ( modelName: ALIAS, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: ALIAS, type: esriFieldTypeString )
• FULL_ADDR ( modelName: FULL_ADDR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: FULL_ADDR, type: esriFieldTypeString )
• BLDG_NO ( modelName: BLDG_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: BLDG_NO, type: esriFieldTypeString )
• BLDG_UNITS ( modelName: BLDG_UNITS, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: BLDG_UNITS, type: esriFieldTypeString )
• NO_UNITS ( modelName: NO_UNITS, nullable: true, editable: true, defaultValue: N/A, alias: NO_UNITS, type: esriFieldTypeSmallInteger )
• FLOOR ( modelName: FLOOR, nullable: true, editable: true, defaultValue: N/A, length: 75, alias: FLOOR, type: esriFieldTypeString )
• ADDRESS_ID ( modelName: ADDRESS_ID, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: ADDRESS_ID, type: esriFieldTypeString )
• CITY ( modelName: CITY, nullable: true, editable: true, defaultValue: N/A, length: 25, alias: CITY, type: esriFieldTypeString )
• STATE ( modelName: STATE, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: STATE, type: esriFieldTypeString )
• ZIP_CODE ( modelName: ZIP_CODE, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: ZIP_CODE, type: esriFieldTypeString )
• COMMUNITY ( modelName: COMMUNITY, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: COMMUNITY, type: esriFieldTypeString )
• ESN ( modelName: ESN, nullable: true, editable: true, defaultValue: N/A, alias: ESN, type: esriFieldTypeDouble )
• ADDR ( modelName: ADDR, nullable: true, editable: true, defaultValue: N/A, length: 75, alias: ADDR, type: esriFieldTypeString )
• ADDR_RANGE ( modelName: ADDR_RANGE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: ADDR_RANGE, type: esriFieldTypeString )
• PERMIT_DATE ( modelName: PERMIT_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: PERMIT_DATE, type: esriFieldTypeDate )
• HAZ_MAT ( modelName: HAZ_MAT, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: HAZ_MAT, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• COUNTY ( modelName: COUNTY, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: COUNTY, type: esriFieldTypeString )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• GUID ( modelName: GUID, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: GUID, type: esriFieldTypeString )
• X ( modelName: X, nullable: true, editable: true, defaultValue: N/A, alias: X, type: esriFieldTypeDouble )
• Y ( modelName: Y, nullable: true, editable: true, defaultValue: N/A, alias: Y, type: esriFieldTypeDouble )

Templates:

• Name: DBO.PointAddresses
  Description:
  Prototype:
  LOCATION: null
  STREET_NAM: null
  BLDG_UNITS: null
  ZIP_CODE: null
  ALIAS: null
  NO_UNITS: null
  STATE: null
  HAZ_MAT: null
  PERMIT_DATE: null
  STREET_TYP: null
  FLOOR: null
  COMMUNITY: null
  X: null
  BLDG_NO: null
  Y: null
  PREFIX_DIR: null
  SUFFIX_DIR: null
  COUNTY: null
  ESN: null
  NUMBER: null
  SITE_TYPE: null
  GUID: null
  ADDR: null
  ADDR_RANGE: null
  CITY: null
  FULL_ADDR: null
  ADDRESS_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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: false

Supports Coordinates Quantization: true

Child Resources:

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