Layer: Curb Stops (ID:94)

View In: Map Viewer

Name: Curb Stops

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Connections including stops, and curb stop boxes were GPS collected by RCAP Solutions. Based on the ESRI Local Government Information Model, and RCAP Solutions custom modifications as seen fit to meet the needs of our clients in order to store, manage, and display geographic data. Data is 1.) Collected using mapping-grade GPS receivers with SBAS Corrections and/or 2.) Digitized based on best available references.

Copyright Text: RCAP Solutions

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"c4a3210b3d9f4d7765f38443336eb67c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACdElEQVQ4jbWTXUhUQRTH/+feu7uWH2siu8pibUZUluVDIkpYKhRGmigIJRpK2UNUGxT0YaQQ4dJL9GBQEoK+VFKIPbSWrJuB9BAmbmAY2Afm7hK9ZH7sxz0xYwa5bhjUn7nDzJn//JhzZ46GfyTtv4PcAc4B4yDryGRCUAG8uobuklSaXBFo8AOvCRnRzjoqZYBkA4thGE63j697rLjSTKTHBD39yuZQEC8AZC3GAp8/QdMMSLGkiamJgaZCPzIB1MQEqfO4CVqAeHofYKDnPmyZGxEOBTH1cQKVR09hR/5usXy438cDJWl0JwrknmI7E2rlybq70NPRhnBwASAUiYTRfu0iGpucyM7bJdK9zMztRMS/gXQFpcSgcCiE4cF+3HjkwYWa/Xj1/JlcP1DbiDPOW3A66iUIQIY7gO0ARpamtk50E2OjyNqZD81gQMvdh3BUFMJiWwtHaxtIUZCcasHM9DesTkgUN2CPAinArDijHolAUVUZMxiNiE80Iyk55VdMVVTpkVkQZpb72ZK8fks2HnfeRumhBrSePIKRIY/8UtNtaDh/FV98k0gwJ0uOShiNApmCcM0Z4Dea4qz2zdvQVFeOce+wBAg9udeBd97XKKs7vvC8CK4iC/miQAUZNOv281lmdFYdOw0wIz7JjK25BRAXMPpyEHvKq5G/t0zYZ1jHuZjvqMhKXW4/b2BGc1WjA/Nzs3g/5oWiaqioPwFVk/bvYFQXp9ObmKCfsJZ+Pw8Ro8UUtypvU06uqBChIBi90HGp2EZvl+5btmhLrNQHoM/lY4vGsGsqQjowXmSh6eX8MUGL2pdGAVFuf/KsCPQ3+gG0L94lqsKXjAAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

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)
CURB_ID (type: esriFieldTypeString, alias: Curb Stop Valve ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ACTIVE (type: esriFieldTypeString, alias: Active or Inactive?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive])
CUSTOMER_TYPE (type: esriFieldTypeString, alias: Customer Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Residential: Residential], [Commercial: Commercial], [Industrial: Industrial], ... 1 more ...)
STREET_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREET_NO (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Center_Front Yard: Near Center of Front Yard], [Right_Front Yard: Right Side of Front Yard], [Left_Front Yard: Left Side of Front Yard], ... 7 more ...)
VISIBILITY (type: esriFieldTypeString, alias: Visibility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Buried: Buried], [Exposed: Exposed], [Unknown: Unknown])
LID_TYPE (type: esriFieldTypeString, alias: Lid Type for Curb Stop Box, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Plug-Cover: Plug Cover (Standard)], [Two_Hole: Two Hole Cover], [Meter_Lid: Standard Meter Lid / Box], ... 4 more ...)
DAMAGE (type: esriFieldTypeString, alias: Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cracked: Cracked], [Missing Cap: Missing Cap], [Broken Cap: Broken Cap], ... 13 more ...)
CONDITION (type: esriFieldTypeString, alias: Condition Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [3: Fair (some aging / wear & tear)], [1: Very Good (relatively new)], [2: Good (newer, with no problems)], ... 2 more ...)
CUSTOMER_NAME (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OWNER_NAME (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INSTALLYEAR (type: esriFieldTypeSmallInteger, alias: Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer of Curb Stop, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A.Y. MCDONALD: A.Y. McDonald], [CAMBRIDGE BRASS: Cambridge Bass], [FERGUSON: Ferguson], ... 4 more ...)
SIZE (type: esriFieldTypeString, alias: Size of Curb Stop Valve, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [.625: 5/8"], [.75: 3/4"], [1: 1"], ... 3 more ...)
FUNCTIONAL (type: esriFieldTypeString, alias: Functional / Operable?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CRITICAL_CUSTOMER (type: esriFieldTypeString, alias: Critical Customer?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DATE_INSPECTED (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NORMALLYOPEN (type: esriFieldTypeString, alias: Valve Normally in Open Position? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ROTATION (type: esriFieldTypeString, alias: Rotation Direction to Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Clockwise: Clockwise (RIGHT)], [Counterclockwise: Counterclockwise (LEFT)])
TURNSTOCLOSE (type: esriFieldTypeSmallInteger, alias: # of Turns to Close Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
CURRENTLYOPEN (type: esriFieldTypeString, alias: Currently Open Position? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
EXPECTED_LIFE (type: esriFieldTypeSmallInteger, alias: Expected Useful Life (Curb Stop), SQL Type: sqlTypeOther, nullable: true, editable: true)
REMAINING_LIFE (type: esriFieldTypeSmallInteger, alias: Remaining Useful Life (Curb Stop), SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACE_YEAR (type: esriFieldTypeSmallInteger, alias: Estimated Replacement Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNIT_COST (type: esriFieldTypeSingle, alias: Unit Cost of Curb Stop, SQL Type: sqlTypeOther, nullable: true, editable: true)
AGENCY (type: esriFieldTypeString, alias: Agency Collected GPS / GNSS Data, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONTACT (type: esriFieldTypeString, alias: Contact Person for Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATOR (type: esriFieldTypeString, alias: GPS Data Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CREATE_DATE (type: esriFieldTypeDate, alias: GPS Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
MODIFY_USER (type: esriFieldTypeString, alias: Last GIS Modify User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
MODIFY_DATE (type: esriFieldTypeDate, alias: Last Modify Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: Positional dilution of precision (3D), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: Horizontal Ground Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: Vertical (Elevation) Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Ground Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading of Phone / Tablet (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ATT_ISSUES (type: esriFieldTypeString, alias: Attribute Information Issues, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
XY_ISSUES (type: esriFieldTypeString, alias: GPS / Location Issues, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: Calculated Point X (Longitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: Calculated Point Y (Latitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Z (type: esriFieldTypeDouble, alias: Calculated Point Z (Elevation Height), SQL Type: sqlTypeOther, nullable: true, editable: true)
CALC_XYZ_SOURCE (type: esriFieldTypeString, alias: Calculated Coordinate Source Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to assist with Asset ID., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

ACTIVE: Active
CUSTOMER_TYPE: Residential
VISIBILITY: Exposed
LID_TYPE: Plug-Cover
DAMAGE: No Damage
CONDITION: 3
SIZE: .75
FUNCTIONAL: Yes
CRITICAL_CUSTOMER: No
NORMALLYOPEN: Yes
ROTATION: Counterclockwise
CURRENTLYOPEN: Yes
AGENCY: RCAP Solutions

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/28/2023 3:10:17 PM

Schema Last Edit Date: 8/22/2023 12:26:18 PM

Data Last Edit Date: 8/28/2023 3:10:17 PM

Child Resources: Field Groups Contingent Values

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat