Layer: Address Points (ID:0)

View In: Map Viewer

Name: Address Points

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

for use in Accela APO. Created from overnight stored procs.

Copyright Text: HPITS

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,0],"size":1,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[100,100,100,255],"width":0.1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.NUMBER1","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GLOBALID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
NUMBER1 (type: esriFieldTypeInteger, alias: NUMBER1, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMBER_SUF (type: esriFieldTypeString, alias: NUMBER_SUF, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PRE_DIR (type: esriFieldTypeString, alias: PRE_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
STREET_TYPE (type: esriFieldTypeString, alias: STREET_TYPE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
SUF_DIR (type: esriFieldTypeString, alias: SUF_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ADD_TYPE (type: esriFieldTypeString, alias: ADD_TYPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Vacant: HP Vacant], [Residential: HP Residential], [Non-Residential: HP Non-Residential], ... 9 more ...)
CITY_911 (type: esriFieldTypeString, alias: CITY_911, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
START_DATE (type: esriFieldTypeDate, alias: START_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
END_DATE (type: esriFieldTypeDate, alias: END_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CITY_ZIP (type: esriFieldTypeString, alias: CITY_ZIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
I_O (type: esriFieldTypeSmallInteger, alias: I_O, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRIM_ADD (type: esriFieldTypeSmallInteger, alias: PRIMARY, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELU_CLASSIFICATION (type: esriFieldTypeSmallInteger, alias: ELU_CLASSIFICATION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Agricultural-Agriculture], [2: Residential-Common Elements Recreation], [3: Residential-Household Living], ... 29 more ...)
loc_id (type: esriFieldTypeInteger, alias: loc_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALLOW_PLAN (type: esriFieldTypeString, alias: ALLOW_PLAN, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_PERMITS (type: esriFieldTypeString, alias: ALLOW_PERMITS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_UTIL (type: esriFieldTypeString, alias: ALLOW_UTIL, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_911 (type: esriFieldTypeString, alias: ALLOW_911, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
is_active (type: esriFieldTypeSmallInteger, alias: is_active, SQL Type: sqlTypeOther, nullable: true, editable: true)
ts_update (type: esriFieldTypeDate, alias: ts_update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
addresscay (type: esriFieldTypeString, alias: addresscay, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
eff_begin (type: esriFieldTypeDate, alias: eff_begin, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
eff_end (type: esriFieldTypeDate, alias: eff_end, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ts_created (type: esriFieldTypeDate, alias: ts_created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
addr_guid (type: esriFieldTypeGUID, alias: addr_guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
parcel (type: esriFieldTypeString, alias: parcel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SITE_NGUID (type: esriFieldTypeString, alias: SITE_NGUID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
DiscrpAgID (type: esriFieldTypeString, alias: DiscrpAgID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
Inc_Muni (type: esriFieldTypeString, alias: Inc_Muni, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
MSAG_Comm (type: esriFieldTypeString, alias: MSAG_Comm, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
St_PreDir (type: esriFieldTypeString, alias: St_PreDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
St_PosDir (type: esriFieldTypeString, alias: St_PosDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
St_PosType (type: esriFieldTypeString, alias: St_PosType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GC_Exception (type: esriFieldTypeString, alias: GC_Exception, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
ID_1 (type: esriFieldTypeInteger, alias: ID_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDRESS_1 (type: esriFieldTypeString, alias: ADDRESS_1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ADD_CITY (type: esriFieldTypeString, alias: ADD_CITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
CITY_POSTAL (type: esriFieldTypeString, alias: CITY_POSTAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
ADD_STATE (type: esriFieldTypeString, alias: ADD_STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
ADD_ZIP (type: esriFieldTypeString, alias: ADD_ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
TAX_OWNER (type: esriFieldTypeString, alias: TAX_OWNER, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
TAX_OWNER_ADD (type: esriFieldTypeString, alias: TAX_OWNER_ADD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TAX_OWNER__ADD2 (type: esriFieldTypeString, alias: TAX_OWNER__ADD2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TAX_OWNER_CITY (type: esriFieldTypeString, alias: TAX_OWNER_CITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TAX_OWNER_STATE (type: esriFieldTypeString, alias: TAX_OWNER_STATE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
TAX_OWNER_ZIP (type: esriFieldTypeString, alias: TAX_OWNER_ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
ACREAGE (type: esriFieldTypeDouble, alias: ACREAGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SQFT (type: esriFieldTypeInteger, alias: SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
YEAR_BUILT (type: esriFieldTypeString, alias: YEAR_BUILT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PRIM_ADD_1 (type: esriFieldTypeInteger, alias: PRIM_ADD_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALLOW_PLAN_1 (type: esriFieldTypeString, alias: ALLOW_PLAN_1, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_PERMIT (type: esriFieldTypeString, alias: ALLOW_PERMIT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_UTIL_1 (type: esriFieldTypeString, alias: ALLOW_UTIL_1, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ALLOW_911_912 (type: esriFieldTypeString, alias: ALLOW_911_912, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
CHANGED_TO (type: esriFieldTypeString, alias: CHANGED_TO, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
JURISDICTION (type: esriFieldTypeString, alias: JURISDICTION, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
CITY_LIMITS (type: esriFieldTypeString, alias: CITY_LIMITS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
PARCEL_ID (type: esriFieldTypeString, alias: PARCEL_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
COUNTY_1 (type: esriFieldTypeString, alias: COUNTY_1, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
ZONING (type: esriFieldTypeString, alias: ZONING, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
GARBAGE (type: esriFieldTypeString, alias: GARBAGE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
FLOODZONE (type: esriFieldTypeString, alias: FLOODZONE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
LANDUSE (type: esriFieldTypeString, alias: LANDUSE, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
SPECIALUSE (type: esriFieldTypeString, alias: SPECIALUSE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
WARDS (type: esriFieldTypeString, alias: WARDS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
WATERSHED (type: esriFieldTypeString, alias: WATERSHED, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
AIRPORT (type: esriFieldTypeString, alias: AIRPORT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
BA (type: esriFieldTypeString, alias: BA, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
FLOODZONE_FZDEF (type: esriFieldTypeString, alias: FLOODZONE_FZDEF, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
HISTORIC (type: esriFieldTypeString, alias: HISTORIC, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
IMUD (type: esriFieldTypeString, alias: IMUD, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
SCENIC (type: esriFieldTypeString, alias: SCENIC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SUBBASIN (type: esriFieldTypeString, alias: SUBBASIN, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
ZONING_SUBAREA (type: esriFieldTypeString, alias: ZONING_SUBAREA, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
INSPECTION (type: esriFieldTypeString, alias: INSPECTION, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
STATIONS (type: esriFieldTypeString, alias: STATIONS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
STREAMS (type: esriFieldTypeString, alias: STREAMS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
FIRE_LIMITS (type: esriFieldTypeString, alias: FIRE_LIMITS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FIRM_PANEL (type: esriFieldTypeString, alias: FIRM_PANEL, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
SUBDIVISION (type: esriFieldTypeString, alias: SUBDIVISION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
TRACT (type: esriFieldTypeString, alias: TRACT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
BLOCKGROUP (type: esriFieldTypeString, alias: BLOCKGROUP, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
TIER (type: esriFieldTypeString, alias: TIER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
NATLDIST (type: esriFieldTypeString, alias: NATLDIST, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
DEVNO (type: esriFieldTypeString, alias: DEVNO, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ZONING2016 (type: esriFieldTypeString, alias: ZONING2016, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
RTA (type: esriFieldTypeString, alias: RTA, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
ANXTRK (type: esriFieldTypeString, alias: ANXTRK, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
NEIGHBORHOOD (type: esriFieldTypeString, alias: NEIGHBORHOOD, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ACCDIST (type: esriFieldTypeString, alias: ACCDIST, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
PLADIST (type: esriFieldTypeString, alias: PLADIST, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
CDHDIST (type: esriFieldTypeString, alias: CDHDIST, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
ELU_CLASSIFICATION_1 (type: esriFieldTypeInteger, alias: ELU_CLASSIFICATION_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELU_CATEGORY (type: esriFieldTypeString, alias: ELU_CATEGORY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ELU_TYPE (type: esriFieldTypeString, alias: ELU_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ELU_UNDERUTILIZED (type: esriFieldTypeString, alias: ELU_UNDERUTILIZED, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
POINTX (type: esriFieldTypeDouble, alias: POINTX, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINTY (type: esriFieldTypeDouble, alias: POINTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
ts_created_1 (type: esriFieldTypeDate, alias: ts_created_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CHPPRCLID (type: esriFieldTypeInteger, alias: CHPPRCLID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID_1 (type: esriFieldTypeGUID, alias: GlobalID_1, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
ELUCLASS (type: esriFieldTypeString, alias: ELUCLASS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
START_DATE_1 (type: esriFieldTypeDate, alias: START_DATE_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DATESTART (type: esriFieldTypeString, alias: DATESTART, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
CORECITY (type: esriFieldTypeString, alias: CORECITY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
GEOLAT (type: esriFieldTypeString, alias: GEOLAT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
GEOLNG (type: esriFieldTypeString, alias: GEOLNG, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

ELU_CLASSIFICATION: 29

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/13/2023 7:37:32 PM

Schema Last Edit Date: 6/13/2023 7:37:32 PM

Data Last Edit Date: 6/13/2023 7:37:32 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat