Proof of concept.This is an unofficial demo built by Datopian from the City of Paso Robles' public data. The official portal is paso-gis-public-hub-prcity.hub.arcgis.com. Questions or feedback: hello@datopian.com

A PortalJS proof of concept · data from the City of Paso Robles' ArcGIS Hub

Roads

This map is the starting point for creating maps and projects for the City of El Paso de Robles .

Records
2,782
Formats
5
Last updated
Jan 23, 2024

Download & API

Roads (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Roads (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Roads (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Roads (map tiles)pmtiles
Vector tiles — embed in a map
Download
Live ArcGIS layer (source)arcgis
Download

Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works

Schema

FieldTypeValues
SEG_IDnumber402,396 to 910,327
ROAD_IDnumber46 to 93,127
PREFIXstring3 values: S (36), N (24), W (13)
SUFFIXstring1 values: W (7)
AKAstring
MP_BEGnumber0.00 to 3.79
MP_ENDnumber0.00 to 5.07
LENGTHnumber7 to 16,091
SPEEDinteger10 to 65
CATEGORYstring10 values: ROAD (2,381), ALLEY (135), FREEWAY (50)…
HWY_NUMinteger0 to 101
SHIELDstring3 values: US HIGHWAY (50), STATE HIGHWAY (43), 46 East Parallel Route (37)
F_ZLEVinteger0 to 1
T_ZLEVinteger0 to 1
FCCstring9 values: 05 (2,160), 04 (61), 11 (60)…
R_F_ADDnumber0 to 6,450
R_T_ADDnumber0 to 7,010
L_F_ADDnumber0 to 6,451
L_T_ADDnumber0 to 7,011
ONE_WAYstring3 values: B (2,419), FT (163), TF (152)
L_ESNstring1 values: 1 (2,529)
R_ESNstring1 values: 1 (2,529)
ZIP_LTstring2 values: 93446 (2,722), 93465 (8)
ZIP_RTstring2 values: 93446 (2,728), 93465 (2)
JURIS_LTstring2 values: PASO ROBLES (2,587), UNINCORPORATED (195)
JURIS_RTstring2 values: PASO ROBLES (2,576), UNINCORPORATED (206)
RESTRCstring3 values: N (61), Y (24), YES (5)
SPD_PSTinteger10 to 65
PAVEDstring3 values: Y (2,658), N (83), YES (12)
MAINT_BYstring4 values: City of Paso Robles (2,112), Private (437), Caltrans (139)…
Update_Notstring
TRVL_TIMEnumber0.00 to 4.06
Heirarchyinteger1 to 7
Circ_Planstring11 values: Existing Collector (274), Divided Arterial - 2 Lane Existing (133), Undivided Arterial - 2 Lane Existing (108)…
YR_MAINTstring9 values: 2016 (90), 2007 (83), 2014 (46)…
ST_TYPE_FULLstring
ST_TYPEstring
SEG_FROMstring
SEG_TOstring
EVAL_AREAstring
ST_NAMEstring
ST_NAME_FULLstring
ST_NM_PREFstring3 values: S (35), N (13), W (13)
ST_NM_SUFFstring
ST_TYP_AFTstring
L_REFADDRstring
L_NREFADDRstring
R_REFADDRstring
R_NREFADDRstring
ST_NM_BASEstring
ST_TYPE_BEFstring1 values: HWY (78)
ST_SWEEPstring4 values: 2 (134), 3 (115), 1 (94)…
TRASH_PUstring8 values: M (329), F (322), Tu (302)…
PCInumber0 to 100
SubZonestring
NextMaintDatedatetime
TRUCK_RTEstring3 values: CITY (328), N (179), STAA (93)
NextMaintYrstring4 values: 2027 (116), 2029 (80), 2030 (26)…