View In:   ArcGIS Online Map Viewer

Name: CFWGIS.DBO.CAD_ADDRESS_POINTS

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: 2238577.982031256
YMin: 6859524.600781247
XMax: 2419239.57421875
YMax: 7074940.451562494
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [124, 0, 145, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

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 )
• ORIG_FID_MERGED ( type: esriFieldTypeInteger, alias: Original Feature OID - Merged, editable: true, nullable: true, defaultValue: null, modelName: ORIG_FID_MERGED )
• ADDRESS_SOURCE ( type: esriFieldTypeString, alias: Address Source Layer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDRESS_SOURCE )
• ADDRESS_NO ( type: esriFieldTypeInteger, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_NO )
• PREFIX ( type: esriFieldTypeString, alias: Prefix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREFIX )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREET_TYPE )
• SUFFIX ( type: esriFieldTypeString, alias: Suffix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFFIX )
• FULL_ADDRESS ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULL_ADDRESS )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: Full Street Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULL_STREET_NAME )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 3, defaultValue: null, modelName: STATE )
• ZIPCODE ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 16, defaultValue: null, modelName: COUNTY )
• COUNC_DIST ( type: esriFieldTypeString, alias: Council District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNC_DIST )
• FW_FRA ( type: esriFieldTypeString, alias: Fire Responsibility Area, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FW_FRA )
• FW_PRA ( type: esriFieldTypeString, alias: Police Responsibility Area, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FW_PRA )
• COUNTRY ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNTRY )
• TIMEZONE ( type: esriFieldTypeString, alias: Time Zone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TIMEZONE )
• LOT_NO ( type: esriFieldTypeString, alias: Lot Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LOT_NO )
• BLOCK_ID ( type: esriFieldTypeString, alias: Block Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BLOCK_ID )
• TRACT_NO ( type: esriFieldTypeString, alias: Tract Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TRACT_NO )
• SUBDIVISION ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBDIVISION )
• CFWLAND_ID ( type: esriFieldTypeInteger, alias: CFWLAND_ID, editable: true, nullable: true, defaultValue: null, modelName: CFWLAND_ID )
• PARCELS_ID ( type: esriFieldTypeInteger, alias: PARCELS OID, editable: true, nullable: true, defaultValue: null, modelName: PARCELS_ID )
• GIS_LINK ( type: esriFieldTypeString, alias: GIS_LINK, editable: true, nullable: true, length: 40, defaultValue: null, modelName: GIS_LINK )
• POSTAL_CITY ( type: esriFieldTypeString, alias: Postal City, editable: true, nullable: true, length: 40, defaultValue: null, modelName: POSTAL_CITY )
• ADDRESS_ID ( type: esriFieldTypeInteger, alias: Address Primary Key, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_ID )
• ADDEXTKEY ( type: esriFieldTypeString, alias: CAD System External Key, editable: true, nullable: true, length: 36, defaultValue: null, modelName: ADDEXTKEY )
• LOC_NAME ( type: esriFieldTypeString, alias: CAD System Location Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOC_NAME )
• BLDG_NO ( type: esriFieldTypeString, alias: CAD System Building Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_NO )
• APTMT_NO ( type: esriFieldTypeString, alias: CAD System Apartment Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: APTMT_NO )
• CITYCODE ( type: esriFieldTypeString, alias: CAD System City Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CITYCODE )
• SERVICEKEY ( type: esriFieldTypeString, alias: CAD Service Key, editable: true, nullable: true, length: 36, defaultValue: null, modelName: SERVICEKEY )
• COUNTYCODE ( type: esriFieldTypeString, alias: CAD System County Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COUNTYCODE )
• ROUTE_KEY ( type: esriFieldTypeString, alias: CAD System Route Key, editable: true, nullable: true, length: 36, defaultValue: null, modelName: ROUTE_KEY )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• CREATE_TIME ( type: esriFieldTypeDate, alias: CREATE_TIME, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATE_TIME )
• LAST_EDITOR ( type: esriFieldTypeString, alias: LAST_EDITOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITOR )
• LAST_EDIT_TIME ( type: esriFieldTypeDate, alias: LAST_EDIT_TIME, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_TIME )

Templates:

• Name: CFWGIS.DBO.CAD_ADDRESS_POINTS
  Description:
  Prototype:
  ROUTE_KEY: null
  COUNTYCODE: null
  ORIG_FID_MERGED: null
  ADDRESS_SOURCE: null
  ADDRESS_NO: null
  PREFIX: null
  STREET_NAME: null
  STREET_TYPE: null
  SUFFIX: null
  FULL_ADDRESS: null
  FULL_STREET_NAME: null
  CITY: null
  STATE: null
  ZIPCODE: null
  COUNTY: null
  COUNC_DIST: null
  FW_FRA: null
  FW_PRA: null
  COUNTRY: null
  TIMEZONE: null
  LOT_NO: null
  BLOCK_ID: null
  TRACT_NO: null
  SUBDIVISION: null
  CFWLAND_ID: null
  PARCELS_ID: null
  GIS_LINK: null
  POSTAL_CITY: null
  ADDRESS_ID: null
  ADDEXTKEY: null
  LOC_NAME: null
  BLDG_NO: null
  APTMT_NO: null
  CITYCODE: null
  SERVICEKEY: 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

Edit Fields Info:

• Creation Date Field: CREATE_TIME
• Creator Field: CREATOR
• Edit Date Field: LAST_EDIT_TIME
• Editor Field: LAST_EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata