View In:   ArcGIS Online Map Viewer

Name: Site Address Points

Display Field: FULLADDR

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Abstract undefined

Copyright Text: City of Cedar Rapids

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 5390426.894770548
YMin: 3415413.7544887215
XMax: 5459085.552072391
YMax: 3504366.301976979
Spatial Reference: 103045  (6463)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
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

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 )
• SITEADDID ( type: esriFieldTypeInteger, alias: Site Address ID, editable: true, nullable: true, defaultValue: null, modelName: SITEADDID )
• ENERGOVID ( type: esriFieldTypeString, alias: EnerGov ID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ENERGOVID )
• ADDPTKEY ( type: esriFieldTypeString, alias: Address Point ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDPTKEY )
• PLANID ( type: esriFieldTypeString, alias: Planimetrics ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLANID )
• PARCELID ( type: esriFieldTypeString, alias: Parcel Identification Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARCELID )
• LOWPARCELID ( type: esriFieldTypeString, alias: Lowest Parcel Identification Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOWPARCELID )
• CENTERLINEID ( type: esriFieldTypeInteger, alias: Centerline ID, editable: true, nullable: true, defaultValue: null, modelName: CENTERLINEID )
• ADDRTYPE ( type: esriFieldTypeString, alias: Address Point Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRTYPE )
• PREADDRNUM ( type: esriFieldTypeString, alias: Address Number Prefix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PREADDRNUM )
• NUM ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NUM )
• ADDRNUMSUF ( type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADDRNUMSUF )
• ADDRNUM ( type: esriFieldTypeString, alias: Full Address Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDRNUM )
• ADDRRANGE ( type: esriFieldTypeString, alias: Address Range, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRRANGE )
• UNITTYPE ( type: esriFieldTypeString, alias: Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITTYPE , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• UNITID ( type: esriFieldTypeString, alias: Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITID )
• UNITFULL ( type: esriFieldTypeString, alias: Full Address Unit Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNITFULL )
• ALTUNITTYPE ( type: esriFieldTypeString, alias: Alternate Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITTYPE , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• ALTUNITID ( type: esriFieldTypeString, alias: Alternate Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITID )
• ALTUNITFULL ( type: esriFieldTypeString, alias: Full Alternate Address Unit Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ALTUNITFULL )
• ROADNAME ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ROADNAME )
• ROADTYPE ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ROADTYPE , Coded Values: [ALY: Alley] , [ANX: Anex] , [ARC: Arcade] , ...207 more... )
• ROADPOSTDIR ( type: esriFieldTypeString, alias: Post Direction, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ROADPOSTDIR , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• FULLNAME ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULLNAME )
• FULLADDR ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULLADDR )
• PLACENAME ( type: esriFieldTypeString, alias: Place Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PLACENAME )
• PDCPN ( type: esriFieldTypeString, alias: PD Commonplace Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PDCPN )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MUNICIPALITY )
• ESN ( type: esriFieldTypeString, alias: Emergency Service Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• PSAP ( type: esriFieldTypeString, alias: Public Safety Answering Point, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSAP )
• MSAG ( type: esriFieldTypeString, alias: MSAG Community, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MSAG )
• USNGCOORD ( type: esriFieldTypeString, alias: USNG Coordinate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USNGCOORD )
• ADDRCLASS ( type: esriFieldTypeInteger, alias: Address Class, editable: true, nullable: true, defaultValue: null, modelName: ADDRCLASS , Coded Values: [701: Agriculture, Food, and Livestock] , [710: Industry] , [720: Commercial and Retail] , ...13 more... )
• ADDRSCLASS ( type: esriFieldTypeInteger, alias: Address Subclass, editable: true, nullable: true, defaultValue: null, modelName: ADDRSCLASS )
• POINTTYPE ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE , Coded Values: [Building: Building] , [Parcel: Parcel] , [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite] , ...3 more... )
• CAPTUREMETH ( type: esriFieldTypeString, alias: Capture Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CAPTUREMETH , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...2 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...3 more... )
• RETIRENOTES ( type: esriFieldTypeString, alias: Retired Address Reason, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RETIRENOTES )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• CDISTRICT ( type: esriFieldTypeString, alias: Council District, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CDISTRICT )
• NEIGHBORASSOC ( type: esriFieldTypeString, alias: Neighborhood Association, editable: true, nullable: true, length: 125, defaultValue: null, modelName: NEIGHBORASSOC )
• RETIREFLAG ( type: esriFieldTypeSmallInteger, alias: Retired Flag, editable: true, nullable: true, defaultValue: null, modelName: RETIREFLAG , Coded Values: [0: Current] , [1: Pending] , [2: Retired] , ...3 more... )
• MAPROLLFLAG ( type: esriFieldTypeString, alias: Map Roll Flag, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAPROLLFLAG )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONG )
• WATERSERV ( type: esriFieldTypeString, alias: Water Service Provider, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSERV )
• SEWERSERV ( type: esriFieldTypeString, alias: Sewer Service Provider, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SEWERSERV )
• POSTCOMM ( type: esriFieldTypeString, alias: Postal Service Community Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: POSTCOMM )
• ZIPCODE ( type: esriFieldTypeString, alias: 5 Digit Zip Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ZIPCODE )
• ZIPPLUS ( type: esriFieldTypeString, alias: Plus 4 ZIP Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZIPPLUS )
• GCEXCEPTION ( type: esriFieldTypeString, alias: GC Exception, editable: true, nullable: true, length: 75, defaultValue: null, modelName: GCEXCEPTION )
• GISINT1 ( type: esriFieldTypeInteger, alias: Temporary Integer Field, editable: true, nullable: true, defaultValue: null, modelName: GISINT1 )
• GISTEXT2 ( type: esriFieldTypeString, alias: Temporary Text Field, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISTEXT2 )
• GISTEXT3 ( type: esriFieldTypeString, alias: Temporary Secondary Text Field, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISTEXT3 )
• 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: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• XCOORD ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• AddressType ( type: esriFieldTypeString, alias: AddressType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddressType , Coded Values: [Address: Address] , [MileMarker: Mile Marker] , [TrailHead: Trail Head] , ...1 more... )

Templates:

• Name: Site Address Points
  Description:
  Prototype:
  YCOORD: null
  XCOORD: null
  SITEADDID: null
  ENERGOVID: null
  ADDPTKEY: null
  PLANID: null
  PARCELID: null
  LOWPARCELID: null
  CENTERLINEID: null
  ADDRTYPE: null
  PREADDRNUM: null
  NUM: null
  ADDRNUMSUF: null
  ADDRNUM: null
  ADDRRANGE: null
  UNITTYPE: null
  UNITID: null
  UNITFULL: null
  ALTUNITTYPE: null
  ALTUNITID: null
  ALTUNITFULL: null
  ROADNAME: null
  ROADTYPE: null
  ROADPOSTDIR: null
  FULLNAME: null
  FULLADDR: null
  PLACENAME: null
  PDCPN: null
  MUNICIPALITY: null
  ESN: null
  PSAP: null
  MSAG: null
  USNGCOORD: null
  ADDRCLASS: null
  ADDRSCLASS: null
  POINTTYPE: null
  CAPTUREMETH: null
  STATUS: null
  RETIRENOTES: null
  LASTUPDATE: null
  LASTEDITOR: null
  CDISTRICT: null
  NEIGHBORASSOC: null
  RETIREFLAG: null
  MAPROLLFLAG: null
  LATITUDE: null
  LONGITUDE: null
  WATERSERV: null
  SEWERSERV: null
  POSTCOMM: null
  ZIPCODE: null
  ZIPPLUS: null
  GCEXCEPTION: null
  GISINT1: null
  GISTEXT2: null
  GISTEXT3: null
  AddressType: 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: 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

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