View In:   ArcGIS Online Map Viewer

Name: gisdb.GIS_SDE.OpenGov_AddressPoints_MAT

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: d9405649776d44a9bdf39c7da8bb8d6a

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: 496709.7932853848
YMin: 184226.08980572224
XMax: 529597.1399121433
YMax: 230015.09894931316
Spatial Reference: 0  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 197, 255, 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 )
• BLDG_NUM ( type: esriFieldTypeString, alias: BLDG_NUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_NUM )
• PREFIX_DIR ( type: esriFieldTypeString, alias: PREFIX_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREFIX_DIR )
• PREFIXTYPE ( type: esriFieldTypeString, alias: PREFIXTYPE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PREFIXTYPE )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STREETNAME )
• STREETTYPE ( type: esriFieldTypeString, alias: STREETTYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STREETTYPE )
• SUFFIX_DIR ( type: esriFieldTypeString, alias: SUFFIX_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFFIX_DIR )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CITY )
• UNIT_INFO ( type: esriFieldTypeString, alias: UNIT_INFO, editable: true, nullable: true, length: 12, defaultValue: null, modelName: UNIT_INFO )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE )
• COMMENTS_O ( type: esriFieldTypeString, alias: COMMENTS_O, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS_O )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 85, defaultValue: null, modelName: ADDRESS )
• DATE_ASSIG ( type: esriFieldTypeDate, alias: DATE_ASSIG, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_ASSIG )
• Pcity ( type: esriFieldTypeString, alias: Pcity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pcity )
• Zip ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Zip )
• UpdateBy ( type: esriFieldTypeString, alias: UpdateBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UpdateBy )
• ADD_ID_NAT ( type: esriFieldTypeString, alias: ADD_ID_NAT, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ADD_ID_NAT )
• ADD_ID_LOC ( type: esriFieldTypeString, alias: ADD_ID_LOC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADD_ID_LOC )
• ANUMBERPRE ( type: esriFieldTypeString, alias: ANUMBERPRE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ANUMBERPRE )
• ANUMBER ( type: esriFieldTypeDouble, alias: ANUMBER, editable: true, nullable: true, defaultValue: null, modelName: ANUMBER )
• ANUMBERSUF ( type: esriFieldTypeString, alias: ANUMBERSUF, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ANUMBERSUF )
• ANUMBERSEP ( type: esriFieldTypeString, alias: ANUMBERSEP, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ANUMBERSEP )
• ST_PRE_MOD ( type: esriFieldTypeString, alias: ST_PRE_MOD, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ST_PRE_MOD )
• ST_PRE_DIR ( type: esriFieldTypeString, alias: ST_PRE_DIR, editable: true, nullable: true, length: 9, defaultValue: null, modelName: ST_PRE_DIR )
• ST_PRE_TYP ( type: esriFieldTypeString, alias: ST_PRE_TYP, editable: true, nullable: true, length: 24, defaultValue: null, modelName: ST_PRE_TYP )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 42, defaultValue: null, modelName: ST_NAME )
• ST_POS_TYP ( type: esriFieldTypeString, alias: ST_POS_TYP, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ST_POS_TYP )
• ST_POS_DIR ( type: esriFieldTypeString, alias: ST_POS_DIR, editable: true, nullable: true, length: 9, defaultValue: null, modelName: ST_POS_DIR )
• ST_POS_MOD ( type: esriFieldTypeString, alias: ST_POS_MOD, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ST_POS_MOD )
• SUB_TYPE1 ( type: esriFieldTypeString, alias: SUB_TYPE1, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUB_TYPE1 )
• SUB_ID1 ( type: esriFieldTypeString, alias: SUB_ID1, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUB_ID1 )
• SUB_TYPE2 ( type: esriFieldTypeString, alias: SUB_TYPE2, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUB_TYPE2 )
• SUB_ID2 ( type: esriFieldTypeString, alias: SUB_ID2, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUB_ID2 )
• MUNI_NAME ( type: esriFieldTypeString, alias: MUNI_NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MUNI_NAME )
• MUNI_CODE ( type: esriFieldTypeString, alias: MUNI_CODE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MUNI_CODE )
• USPS_PLACE ( type: esriFieldTypeString, alias: USPS_PLACE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: USPS_PLACE )
• CO_CODE ( type: esriFieldTypeString, alias: CO_CODE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CO_CODE )
• CO_NAME ( type: esriFieldTypeString, alias: CO_NAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CO_NAME )
• STATE_CODE ( type: esriFieldTypeString, alias: STATE_CODE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE_CODE )
• ZIP5 ( type: esriFieldTypeString, alias: ZIP5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP5 )
• ZIP4 ( type: esriFieldTypeString, alias: ZIP4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZIP4 )
• LOC_DESC ( type: esriFieldTypeString, alias: LOC_DESC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LOC_DESC )
• LANDMARK ( type: esriFieldTypeString, alias: LANDMARK, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LANDMARK )
• RESIDENCE ( type: esriFieldTypeString, alias: RESIDENCE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RESIDENCE )
• MAILABLE ( type: esriFieldTypeString, alias: MAILABLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAILABLE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATUS )
• TAXPIN ( type: esriFieldTypeString, alias: TAXPIN, editable: true, nullable: true, length: 17, defaultValue: null, modelName: TAXPIN )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• POSI_ACCU ( type: esriFieldTypeSmallInteger, alias: POSI_ACCU, editable: true, nullable: true, defaultValue: null, modelName: POSI_ACCU )
• ADIRSOURCE ( type: esriFieldTypeString, alias: ADIRSOURCE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ADIRSOURCE )
• AAUTHORITY ( type: esriFieldTypeString, alias: AAUTHORITY, editable: true, nullable: true, length: 40, defaultValue: null, modelName: AAUTHORITY )
• EDIT_ORG ( type: esriFieldTypeString, alias: EDIT_ORG, editable: true, nullable: true, length: 40, defaultValue: null, modelName: EDIT_ORG )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATEDATE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENTS )
• AQUALITY ( type: esriFieldTypeSmallInteger, alias: AQUALITY, editable: true, nullable: true, defaultValue: null, modelName: AQUALITY )
• 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 )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GlobalID )

Templates:

• Name: gisdb.GIS_SDE.OpenGov_AddressPoints_MAT
  Description:
  Prototype:
  AQUALITY: null
  GlobalID: null
  BLDG_NUM: null
  PREFIX_DIR: null
  PREFIXTYPE: null
  STREETNAME: null
  STREETTYPE: null
  SUFFIX_DIR: null
  CITY: null
  UNIT_INFO: null
  SOURCE: null
  COMMENTS_O: null
  ADDRESS: null
  DATE_ASSIG: null
  Pcity: null
  Zip: null
  UpdateBy: null
  ADD_ID_NAT: null
  ADD_ID_LOC: null
  ANUMBERPRE: null
  ANUMBER: null
  ANUMBERSUF: null
  ANUMBERSEP: null
  ST_PRE_MOD: null
  ST_PRE_DIR: null
  ST_PRE_TYP: null
  ST_NAME: null
  ST_POS_TYP: null
  ST_POS_DIR: null
  ST_POS_MOD: null
  SUB_TYPE1: null
  SUB_ID1: null
  SUB_TYPE2: null
  SUB_ID2: null
  MUNI_NAME: null
  MUNI_CODE: null
  USPS_PLACE: null
  CO_CODE: null
  CO_NAME: null
  STATE_CODE: null
  ZIP5: null
  ZIP4: null
  LOC_DESC: null
  LANDMARK: null
  RESIDENCE: null
  MAILABLE: null
  STATUS: null
  TAXPIN: null
  LONGITUDE: null
  LATITUDE: null
  POSI_ACCU: null
  ADIRSOURCE: null
  AAUTHORITY: null
  EDIT_ORG: null
  UPDATEDATE: null
  COMMENTS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

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