Name: Public Sidewalks

Display Field: Width

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The City of Columbia's digital data set of sidewalks is a record of the location, segment type, surface type, if obstructions are present, and width of sidewalks within city limits. The data is composed of line data. This data set has editor tracking enabled. The created date for many of these segments has been configured to be used as the unique ID. This causes some records to have a odd ball created date, so of which are in the future. This feature class in part of a relationship with a sidewalk_History table that contains records of segments that have been inspected.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1653751.2836760804
YMin: 1064483.978055492
XMax: 1720589.136220578
YMax: 1167819.5322107375
Spatial Reference: 102697  (102697)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 255, 115, 255]
Width: 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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Segment_Type_number

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• FID_sidewalks_sample ( type: esriFieldTypeInteger, alias: FID_sidewalks_sample )
• CLASS_ID ( type: esriFieldTypeSmallInteger, alias: CLASS_ID )
• Width ( type: esriFieldTypeString, alias: Width of sidewalk, length: 20 , Coded Values: [24: 24 inches] , [36: 36 inches] , [48: 48 inches] , ...5 more... )
• Surface_type ( type: esriFieldTypeString, alias: Sidewalk surface type, length: 20 , Coded Values: [C: Concrete] , [B: Brick] , [A: Asphalt] , ...2 more... )
• Methods ( type: esriFieldTypeString, alias: Methods used for data collection, length: 50 , Coded Values: [E: Feature extract] , [P: Orthophoto] , [F: Fieldwork] , ...5 more... )
• Imagery_year ( type: esriFieldTypeString, alias: Year of reference imagery, length: 4 , Coded Values: [2003: 2003] , [2004: 2004] , [2005: 2005] , ...15 more... )
• Edit_data ( type: esriFieldTypeDate, alias: Date of most recent edits, length: 8 )
• Scale ( type: esriFieldTypeString, alias: Scale at which edits made, length: 20 , Coded Values: [100: 1:100] , [200: 1:200] , [300: 1:300] , ...6 more... )
• QAQC ( type: esriFieldTypeString, alias: QAQC, length: 5 )
• Field_ver ( type: esriFieldTypeString, alias: Data field verified, length: 5 )
• Segment_Type_number ( type: esriFieldTypeSmallInteger, alias: Segment_Type_number , Coded Values: [0: Sidewalk] , [1: Driveway] , [2: Curb ramp] , ...2 more... )
• sidewalks_in_miles ( type: esriFieldTypeDouble, alias: sidewalks_in_miles )
• segment_id ( type: esriFieldTypeInteger, alias: segment_id )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• YEAR ( type: esriFieldTypeInteger, alias: Year Built )
• ENTRY_TYPE ( type: esriFieldTypeString, alias: ENTRY TYPE, length: 24 , Coded Values: [Accepted: Accepted] , [Constructed: Constructed] , [Annexation: Annexation] )
• STATUS ( type: esriFieldTypeString, alias: Construction Status, length: 24 , Coded Values: [COMPLETE: COMPLETE] , [PLANNED: PLANNED] , [UNDERCONSTR: UNDER CONSTRUCTION] , ...1 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Temp_Obstructions ( type: esriFieldTypeSmallInteger, alias: Temporary obstructions protruding or hanging into path ? , Coded Values: [1: 1-3] , [2: 4-6] , [3: 7>] , ...1 more... )
• Gaps ( type: esriFieldTypeSmallInteger, alias: Noticeable cracks and gaps (horizontal trip hazards) ? , Coded Values: [1: 1-3] , [2: 4-6] , [3: 7>] , ...1 more... )
• Curbramps ( type: esriFieldTypeString, alias: Curb ramps at ends of segment?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• Cross_slope ( type: esriFieldTypeString, alias: Noticeable cross slope?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SW_width_rating ( type: esriFieldTypeString, alias: Sidewalk travelpath < 4 feet wide?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Ramp_landing ( type: esriFieldTypeString, alias: 5x5 foot landing area?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Dectectable_warning_Ramp ( type: esriFieldTypeString, alias: Detectable warning (texture)?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Ramp_Color_Diff ( type: esriFieldTypeString, alias: Color difference of warning texture?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Ramp_Orientation ( type: esriFieldTypeString, alias: Ramp orientation directs pedestrian to directly to crossing?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Driveway ( type: esriFieldTypeString, alias: Notes, length: 200 )
• ConnectstoOther ( type: esriFieldTypeString, alias: ConnectstoOther, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• MaterialSW ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [Concrete: Concrete] , [Asphalt: Asphalt] , [Brick: Brick] , ...1 more... )
• RoadwayCrossSection ( type: esriFieldTypeString, alias: RoadwayCrossSection CurbGutter, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• RoadwayCrossSectionFlush ( type: esriFieldTypeString, alias: RoadwayCrossSectionFlush, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SidewalkSeperation ( type: esriFieldTypeString, alias: SidewalkSeperation, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SidewalkSeperationfromRoad ( type: esriFieldTypeInteger, alias: SidewalkSeperationfromRoad )
• Dropoffhazard ( type: esriFieldTypeInteger, alias: Dropoffhazard )
• Protectedbyrailing ( type: esriFieldTypeString, alias: Protectedbyrailing, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• OtherProtection ( type: esriFieldTypeString, alias: OtherProtection, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• CounterSlope ( type: esriFieldTypeDouble, alias: CounterSlope )
• FlareSlope ( type: esriFieldTypeDouble, alias: FlareSlope )
• TrucatedDome ( type: esriFieldTypeString, alias: TrucatedDome, length: 50 , Coded Values: [None: None] , [Rubber_Dome: Rubber Dome] , [Stamped_Dome: Stamped Dome] , ...1 more... )
• DetectableWariningColor ( type: esriFieldTypeString, alias: DetectableWariningColor, length: 50 , Coded Values: [Brick Red: Brick Red] , [Yellow: Yellow] , [Black: Black] , ...2 more... )
• DetectableWariningPlace ( type: esriFieldTypeInteger, alias: De )
• RampType ( type: esriFieldTypeString, alias: RampType, length: 50 , Coded Values: [Perpendicular: Perpendicular] , [Parallel: Parallel] , [Combination: Combination] , ...2 more... )
• RampLength ( type: esriFieldTypeInteger, alias: RampLength )
• RampTopLanding ( type: esriFieldTypeInteger, alias: RampTopLanding )
• RampBottomLanding ( type: esriFieldTypeInteger, alias: RampBottomLanding )
• DropoffHazardyesno ( type: esriFieldTypeString, alias: DropoffHazardyesno, length: 50 )
• RampTopLandingLen ( type: esriFieldTypeInteger, alias: RampTopLandingLen )
• RampBottomLandingLen ( type: esriFieldTypeInteger, alias: RampBottomLandingLen )
• SWCurbSeperation ( type: esriFieldTypeDouble, alias: SWCurbSeperation )
• SWSlopePercent ( type: esriFieldTypeDouble, alias: SWSlopePercent )
• SWCrossSlopePercent ( type: esriFieldTypeDouble, alias: SWCrossSlopePercent )
• Obstructions_in_Path ( type: esriFieldTypeInteger, alias: Number of obstructions in Travel path )
• Obstructions_Avg_length ( type: esriFieldTypeDouble, alias: Obstructions_Avg_length )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, length: 50 )
• orig_objectid ( type: esriFieldTypeString, alias: orig_objectid, length: 50 )
• Repaired_Status ( type: esriFieldTypeString, alias: Repaired_Status, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• Repaired_Date ( type: esriFieldTypeDate, alias: Repaired_Date, length: 8 )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )

Types:

ID: 0
Name: Sidewalk
Domains:
• Width:
  Inherited
• Surface_type:
  Inherited
• Methods:
  Inherited
• Imagery_year:
  Inherited
• Scale:
  Inherited
• QAQC:
  Coded Values: [YES: YES] , [NO: NO]
• Field_ver:
  Coded Values: [YES: YES] , [NO: NO]
• Segment_Type_number:
  Inherited
• ENTRY_TYPE:
  Inherited
• STATUS:
  Inherited
• Temp_Obstructions:
  Inherited
• Gaps:
  Inherited
• Curbramps:
  Inherited
• Cross_slope:
  Inherited
• SW_width_rating:
  Inherited
• Ramp_landing:
  Inherited
• Dectectable_warning_Ramp:
  Inherited
• Ramp_Color_Diff:
  Inherited
• Ramp_Orientation:
  Inherited
• ConnectstoOther:
  Inherited
• MaterialSW:
  Inherited
• RoadwayCrossSection:
  Inherited
• RoadwayCrossSectionFlush:
  Inherited
• SidewalkSeperation:
  Inherited
• Protectedbyrailing:
  Inherited
• OtherProtection:
  Inherited
• TrucatedDome:
  Inherited
• DetectableWariningColor:
  Inherited
• RampType:
  Inherited
• DropoffHazardyesno:
  Coded Values: [Yes: Yes] , [No: No]
• Repaired_Status:
  Inherited

---

ID: 1
Name: Driveway
Domains:
• Width:
  Inherited
• Surface_type:
  Inherited
• Methods:
  Inherited
• Imagery_year:
  Inherited
• Scale:
  Inherited
• QAQC:
  Coded Values: [YES: YES] , [NO: NO]
• Field_ver:
  Coded Values: [YES: YES] , [NO: NO]
• Segment_Type_number:
  Inherited
• ENTRY_TYPE:
  Inherited
• STATUS:
  Inherited
• Temp_Obstructions:
  Inherited
• Gaps:
  Inherited
• Curbramps:
  Inherited
• Cross_slope:
  Inherited
• SW_width_rating:
  Inherited
• Ramp_landing:
  Inherited
• Dectectable_warning_Ramp:
  Inherited
• Ramp_Color_Diff:
  Inherited
• Ramp_Orientation:
  Inherited
• ConnectstoOther:
  Inherited
• MaterialSW:
  Inherited
• RoadwayCrossSection:
  Inherited
• RoadwayCrossSectionFlush:
  Inherited
• SidewalkSeperation:
  Inherited
• Protectedbyrailing:
  Inherited
• OtherProtection:
  Inherited
• TrucatedDome:
  Inherited
• DetectableWariningColor:
  Inherited
• RampType:
  Inherited
• DropoffHazardyesno:
  Coded Values: [Yes: Yes] , [No: No]
• Repaired_Status:
  Inherited

---

ID: 2
Name: Curb ramp
Domains:
• Width:
  Inherited
• Surface_type:
  Inherited
• Methods:
  Inherited
• Imagery_year:
  Inherited
• Scale:
  Inherited
• QAQC:
  Coded Values: [YES: YES] , [NO: NO]
• Field_ver:
  Coded Values: [YES: YES] , [NO: NO]
• Segment_Type_number:
  Inherited
• ENTRY_TYPE:
  Inherited
• STATUS:
  Inherited
• Temp_Obstructions:
  Inherited
• Gaps:
  Inherited
• Curbramps:
  Coded Values: [Yes: Yes] , [No: No]
• Cross_slope:
  Inherited
• SW_width_rating:
  Inherited
• Ramp_landing:
  Inherited
• Dectectable_warning_Ramp:
  Inherited
• Ramp_Color_Diff:
  Inherited
• Ramp_Orientation:
  Inherited
• ConnectstoOther:
  Inherited
• MaterialSW:
  Inherited
• RoadwayCrossSection:
  Inherited
• RoadwayCrossSectionFlush:
  Inherited
• SidewalkSeperation:
  Inherited
• Protectedbyrailing:
  Inherited
• OtherProtection:
  Inherited
• TrucatedDome:
  Inherited
• DetectableWariningColor:
  Inherited
• RampType:
  Inherited
• Repaired_Status:
  Inherited

---

ID: 3
Name: Red curb ramp
Domains:
• Width:
  Inherited
• Surface_type:
  Inherited
• Methods:
  Inherited
• Imagery_year:
  Inherited
• Scale:
  Inherited
• QAQC:
  Coded Values: [YES: YES] , [NO: NO]
• Field_ver:
  Coded Values: [YES: YES] , [NO: NO]
• Segment_Type_number:
  Inherited
• ENTRY_TYPE:
  Inherited
• STATUS:
  Inherited
• Temp_Obstructions:
  Inherited
• Gaps:
  Inherited
• Curbramps:
  Coded Values: [Yes: Yes] , [No: No]
• Cross_slope:
  Inherited
• SW_width_rating:
  Inherited
• Ramp_landing:
  Inherited
• Dectectable_warning_Ramp:
  Inherited
• Ramp_Color_Diff:
  Inherited
• Ramp_Orientation:
  Inherited
• ConnectstoOther:
  Inherited
• MaterialSW:
  Inherited
• RoadwayCrossSection:
  Inherited
• RoadwayCrossSectionFlush:
  Inherited
• SidewalkSeperation:
  Inherited
• Protectedbyrailing:
  Inherited
• OtherProtection:
  Inherited
• TrucatedDome:
  Inherited
• DetectableWariningColor:
  Inherited
• RampType:
  Inherited
• Repaired_Status:
  Inherited

---

ID: 4
Name: Pedway
Domains:
• Width:
  Inherited
• Surface_type:
  Inherited
• Methods:
  Inherited
• Imagery_year:
  Inherited
• Scale:
  Inherited
• QAQC:
  Coded Values: [YES: YES] , [NO: NO]
• Field_ver:
  Coded Values: [YES: YES] , [NO: NO]
• Segment_Type_number:
  Inherited
• ENTRY_TYPE:
  Inherited
• STATUS:
  Inherited
• Temp_Obstructions:
  Inherited
• Gaps:
  Inherited
• Curbramps:
  Inherited
• Cross_slope:
  Inherited
• SW_width_rating:
  Inherited
• Ramp_landing:
  Inherited
• Dectectable_warning_Ramp:
  Inherited
• Ramp_Color_Diff:
  Inherited
• Ramp_Orientation:
  Inherited
• ConnectstoOther:
  Inherited
• MaterialSW:
  Inherited
• RoadwayCrossSection:
  Inherited
• RoadwayCrossSectionFlush:
  Inherited
• SidewalkSeperation:
  Inherited
• Protectedbyrailing:
  Inherited
• OtherProtection:
  Inherited
• TrucatedDome:
  Inherited
• DetectableWariningColor:
  Inherited
• RampType:
  Inherited
• DropoffHazardyesno:
  Coded Values: [Yes: Yes] , [No: No]
• Repaired_Status:
  Inherited

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata