units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, MNG_AGENCY = 351 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370 | 1370 | 1369 | {"type": "Polygon", "coordinates": [[[-122.2916, 38.01582], [-122.29115, 38.01599], [-122.29085, 38.01572], [-122.2913, 38.01544], [-122.2916, 38.01582]]]} | Open Access 1 | 12052 | Waterfront Park | 27303 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 0.507 | Waterfront Park | 0 | Local Park 2 | 4 | |
5449 | 5449 | 5448 | {"type": "Polygon", "coordinates": [[[-122.26061, 38.01443], [-122.26017, 38.01496], [-122.25964, 38.01488], [-122.25894, 38.01487], [-122.25863, 38.01494], [-122.2587, 38.01457], [-122.25859, 38.0141], [-122.26007, 38.01404], [-122.26061, 38.01443]]]} | Open Access 1 | 11993 | Foxboro Park | 19035 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 3.485 | Foxboro Park | 0 | Local Park 2 | 4 | |
8072 | 8072 | 8071 | {"type": "Polygon", "coordinates": [[[-122.25266, 38.0067], [-122.25224, 38.00769], [-122.25192, 38.00797], [-122.25101, 38.0076], [-122.25175, 38.00629], [-122.25266, 38.0067]]]} | Open Access 1 | 12005 | Woodfield Park | 27708 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 3.765 | Woodfield Park | 0 | Local Park 2 | 4 | |
8074 | 8074 | 8073 | {"type": "Polygon", "coordinates": [[[-122.23719, 37.99248], [-122.23716, 37.99257], [-122.23705, 37.99266], [-122.23698, 37.99276], [-122.23681, 37.99357], [-122.23679, 37.99358], [-122.23679, 37.99363], [-122.23558, 37.9934], [-122.23555, 37.99247], [-122.23524, 37.99208], [-122.23421, 37.99163], [-122.23472, 37.99052], [-122.23565, 37.99071], [-122.23562, 37.9909], [-122.23593, 37.99102], [-122.23584, 37.99126], [-122.23608, 37.99136], [-122.23609, 37.9915], [-122.23629, 37.99157], [-122.2364, 37.99182], [-122.23657, 37.99209], [-122.23675, 37.99223], [-122.23709, 37.99238], [-122.23719, 37.99248]]]} | Open Access 1 | 12017 | Hanna Ranch Park | 19641 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 10.261 | Hanna Ranch Park | 0 | Local Park 2 | 4 | |
8076 | 8076 | 8075 | {"type": "Polygon", "coordinates": [[[-122.26966, 38.00898], [-122.26961, 38.00903], [-122.26779, 38.00931], [-122.26785, 38.00878], [-122.26758, 38.00852], [-122.26758, 38.00846], [-122.2669, 38.00788], [-122.26664, 38.00778], [-122.26646, 38.00774], [-122.26682, 38.0071], [-122.26688, 38.00709], [-122.26698, 38.00713], [-122.26704, 38.00711], [-122.26742, 38.0066], [-122.26898, 38.00767], [-122.26924, 38.00793], [-122.26931, 38.00801], [-122.26946, 38.00827], [-122.2696, 38.00861], [-122.26966, 38.00896], [-122.26966, 38.00898]]]} | Open Access 1 | 12029 | Refugio Valley Park | 24268 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 10.669 | Refugio Valley Park | 0 | Local Park 2 | 4 | |
8079 | 8079 | 8078 | {"type": "Polygon", "coordinates": [[[-122.27455, 38.00682], [-122.27431, 38.00723], [-122.27387, 38.00728], [-122.27367, 38.00655], [-122.27338, 38.00617], [-122.27258, 38.00601], [-122.27246, 38.00546], [-122.27306, 38.00523], [-122.27353, 38.00508], [-122.27435, 38.00571], [-122.27451, 38.00622], [-122.27437, 38.00636], [-122.27455, 38.00682]]]} | Open Access 1 | 12041 | Ohlone Park | 23077 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | Contra Costa 12 | 5.665 | Ohlone Park | 0 | Local Park 2 | 4 | |
15008 | 15008 | 15007 | {"type": "Polygon", "coordinates": [[[-122.27695, 38.02829], [-122.27668, 38.02857], [-122.27649, 38.02878], [-122.27626, 38.02908], [-122.27607, 38.02939], [-122.27585, 38.02979], [-122.2756, 38.0303], [-122.27523, 38.03116], [-122.27496, 38.03196], [-122.2748, 38.03258], [-122.27467, 38.03333], [-122.27449, 38.03465], [-122.27349, 38.03366], [-122.2735, 38.03363], [-122.27311, 38.03323], [-122.2733, 38.03321], [-122.27336, 38.03329], [-122.27348, 38.03333], [-122.2736, 38.03329], [-122.27365, 38.0332], [-122.27405, 38.03314], [-122.27396, 38.03285], [-122.27372, 38.03242], [-122.27387, 38.03234], [-122.27397, 38.0324], [-122.2741, 38.03267], [-122.27442, 38.03272], [-122.27447, 38.03272], [-122.27468, 38.03191], [-122.27491, 38.03132], [-122.27489, 38.03115], [-122.27485, 38.03103], [-122.27408, 38.03033], [-122.27414, 38.03025], [-122.27418, 38.03014], [-122.27423, 38.0299], [-122.27427, 38.02985], [-122.27435, 38.02982], [-122.27466, 38.02984], [-122.2748, 38.02988], [-122.27483, 38.02998], [-122.27515, 38.03012], [-122.27527, 38.03009], [-122.27546, 38.02976], [-122.27557, 38.02929], [-122.27593, 38.02886], [-122.27624, 38.02837], [-122.27647, 38.02815], [-122.27645, 38.0281], [-122.27635, 38.02804], [-122.27655, 38.0279], [-122.27695, 38.02829]]]} | Open Access 1 | 45658 | Shoreline Park | 28474 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=178#Shoreline Park | Contra Costa 12 | 10.467 | Shoreline Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);