superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 385 sorted by map descending
This data as json, copyable, CSV (advanced)
Link | rowid | id | map ▲ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5371 | 5371 | 5370 | {"type": "Polygon", "coordinates": [[[-122.05286, 37.99505], [-122.05278, 37.99508], [-122.05232, 37.99461], [-122.0525, 37.99451], [-122.05286, 37.99505]]]} | Open Access 1 | Iron Horse Park | 20234 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.22 | Iron Horse Park | ||
6101 | 6101 | 6100 | {"type": "Polygon", "coordinates": [[[-122.05177, 37.94056], [-122.05138, 37.94277], [-122.05069, 37.94269], [-122.05106, 37.94041], [-122.05165, 37.94042], [-122.05164, 37.94055], [-122.05177, 37.94056]]]} | Open Access 1 | Len Hester Community Park | 21161 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 3.966 | Len Hester Community Park | ||
2548 | 2548 | 2547 | {"type": "Polygon", "coordinates": [[[-122.04915, 37.95255], [-122.04632, 37.95453], [-122.04611, 37.95441], [-122.04588, 37.95449], [-122.04526, 37.95388], [-122.04525, 37.95361], [-122.04629, 37.95288], [-122.04641, 37.95301], [-122.04675, 37.95283], [-122.04771, 37.95221], [-122.04841, 37.95172], [-122.04915, 37.95255]]]} | Open Access 1 | Cambridge Park | 16752 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 10.873 | Cambridge Park | ||
5152 | 5152 | 5151 | {"type": "Polygon", "coordinates": [[[-122.04817, 37.99731], [-122.04801, 37.9984], [-122.04768, 37.99848], [-122.04746, 37.9985], [-122.04723, 37.99848], [-122.043, 37.99784], [-122.0428, 37.9978], [-122.04243, 37.99767], [-122.04226, 37.99757], [-122.04223, 37.99751], [-122.04249, 37.99665], [-122.04246, 37.99627], [-122.04422, 37.9966], [-122.04444, 37.99633], [-122.0447, 37.99554], [-122.0451, 37.99563], [-122.04584, 37.99596], [-122.04786, 37.99682], [-122.04521, 37.99613], [-122.04505, 37.99652], [-122.04783, 37.99725], [-122.04817, 37.99731]]]} | Open Access 1 | Hillcrest Community Park | 19965 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 22.97 | Hillcrest Community Park | ||
6863 | 6863 | 6862 | {"type": "Polygon", "coordinates": [[[-122.04156, 37.96284], [-122.04157, 37.96319], [-122.04143, 37.9635], [-122.03856, 37.96546], [-122.03816, 37.965], [-122.03816, 37.96496], [-122.03837, 37.96482], [-122.03852, 37.96467], [-122.03862, 37.9645], [-122.0387, 37.96422], [-122.03877, 37.96408], [-122.03887, 37.96394], [-122.039, 37.96383], [-122.03921, 37.96401], [-122.04137, 37.96256], [-122.04156, 37.96284]]]} | Open Access 1 | Meadow Homes Park | 22072 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 7.702 | Meadow Homes Park | ||
3961 | 3961 | 3960 | {"type": "Polygon", "coordinates": [[[-122.03877, 37.97179], [-122.03791, 37.97219], [-122.03832, 37.97276], [-122.03765, 37.97301], [-122.03649, 37.97161], [-122.03544, 37.97045], [-122.03573, 37.97031], [-122.03609, 37.9707], [-122.03617, 37.97065], [-122.03661, 37.97047], [-122.03693, 37.97087], [-122.0378, 37.97047], [-122.03877, 37.97179]]]} | Open Access 1 | Ellis Lake Park | 18592 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.405 | Ellis Lake Park | ||
10068 | 10068 | 10067 | {"type": "Polygon", "coordinates": [[[-122.03573, 38.00376], [-122.0353, 38.00455], [-122.03501, 38.00407], [-122.03474, 38.00393], [-122.03454, 38.00418], [-122.03377, 38.00383], [-122.03373, 38.00378], [-122.03394, 38.00348], [-122.03424, 38.00361], [-122.03447, 38.0033], [-122.03476, 38.00343], [-122.03573, 38.00376]]]} | Open Access 1 | Sun Terrace Park | 25978 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 2.6 | Sun Terrace Park | ||
10382 | 10382 | 10381 | {"type": "Polygon", "coordinates": [[[-122.03452, 37.97743], [-122.03363, 37.97784], [-122.0331, 37.97714], [-122.03399, 37.97672], [-122.03452, 37.97743]]]} | Open Access 1 | Todos Santos | 26388 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 2.043 | Todos Santos | ||
8686 | 8686 | 8685 | {"type": "Polygon", "coordinates": [[[-122.03362, 37.95355], [-122.03337, 37.95375], [-122.03326, 37.95323], [-122.03322, 37.9531], [-122.03317, 37.95297], [-122.03305, 37.95277], [-122.03291, 37.9526], [-122.03275, 37.95245], [-122.03249, 37.95228], [-122.03218, 37.95214], [-122.03236, 37.95203], [-122.03242, 37.9521], [-122.03262, 37.95225], [-122.03282, 37.95234], [-122.03284, 37.95242], [-122.03302, 37.95259], [-122.03321, 37.95285], [-122.03333, 37.95319], [-122.0334, 37.95331], [-122.03354, 37.95344], [-122.03362, 37.95355]]]} | Open Access 1 | Rick Sears Park | 24345 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.596 | Rick Sears Park | ||
1771 | 1771 | 1770 | {"type": "Polygon", "coordinates": [[[-122.0313, 37.96854], [-122.03098, 37.96932], [-122.03075, 37.96994], [-122.03022, 37.97123], [-122.03008, 37.97119], [-122.03003, 37.97114], [-122.03001, 37.97107], [-122.03109, 37.96873], [-122.03115, 37.96854], [-122.0312, 37.9685], [-122.0313, 37.96854]]]} | Open Access 1 | BART Park | 15839 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1.284 | BART Park | ||
3139 | 3139 | 3138 | {"type": "Polygon", "coordinates": [[[-122.03097, 37.96818], [-122.0305, 37.96804], [-122.0304, 37.96765], [-122.03042, 37.96763], [-122.03041, 37.96759], [-122.03061, 37.96755], [-122.03072, 37.96749], [-122.03085, 37.96758], [-122.0309, 37.96779], [-122.03088, 37.96778], [-122.03087, 37.9678], [-122.03097, 37.96818]]]} | Open Access 1 | Concord Skate Park | 17576 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.597 | Concord Skate Park | ||
11425 | 11425 | 11424 | {"type": "Polygon", "coordinates": [[[-122.03014, 37.94438], [-122.02767, 37.94589], [-122.02678, 37.94493], [-122.02722, 37.94455], [-122.02771, 37.94422], [-122.02807, 37.94401], [-122.02924, 37.94341], [-122.03014, 37.94438]]]} | Open Access 1 | Ygnacio Valley Park | 27771 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.461 | Ygnacio Valley Park | ||
5784 | 5784 | 5783 | {"type": "Polygon", "coordinates": [[[-122.02943, 37.96792], [-122.02914, 37.96856], [-122.02736, 37.96808], [-122.02717, 37.96843], [-122.02586, 37.96806], [-122.02578, 37.96822], [-122.02543, 37.96811], [-122.02545, 37.96798], [-122.02509, 37.96787], [-122.02557, 37.96682], [-122.02602, 37.96697], [-122.02634, 37.96703], [-122.02943, 37.96792]]]} | Open Access 1 | Krueger Play Fields | 20726 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.193 | Krueger Play Fields | ||
13731 | 13731 | 13730 | {"type": "Polygon", "coordinates": [[[-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.0237, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.0243, 38.01473], [-122.02585, 38.01792], [-122.02616, 38.01785], [-122.02649, 38.01854]]]} | Restricted Access 2 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 150.585 | Diablo Creek GC | ||
1797 | 1797 | 1796 | {"type": "Polygon", "coordinates": [[[-122.02596, 38.00835], [-122.02592, 38.00855], [-122.02562, 38.00858], [-122.0253, 38.0085], [-122.02441, 38.00795], [-122.02331, 38.00706], [-122.02336, 38.00691], [-122.02353, 38.00654], [-122.02402, 38.00703], [-122.02433, 38.00684], [-122.02477, 38.0073], [-122.02447, 38.0075], [-122.02483, 38.00787], [-122.02532, 38.00815], [-122.02596, 38.00835]]]} | Open Access 1 | Bayview Circle Park | 15900 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 3.326 | Bayview Circle Park | ||
3138 | 3138 | 3137 | {"type": "Polygon", "coordinates": [[[-122.01628, 37.96415], [-122.01473, 37.96759], [-122.0115, 37.96667], [-122.01305, 37.96324], [-122.01628, 37.96415]]]} | Open Access 1 | Concord Community Park | 17575 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 30.16 | Concord Community Park | ||
6694 | 6694 | 6693 | {"type": "Polygon", "coordinates": [[[-122.00772, 37.96146], [-122.00602, 37.96186], [-122.00616, 37.96268], [-122.0044, 37.96289], [-122.00424, 37.96211], [-122.00411, 37.96209], [-122.00429, 37.96314], [-122.0027, 37.9627], [-122.00307, 37.96204], [-122.00233, 37.96198], [-122.0034, 37.96113], [-122.00375, 37.96132], [-122.00441, 37.96154], [-122.00459, 37.96152], [-122.0048, 37.96143], [-122.00488, 37.96147], [-122.00471, 37.96167], [-122.00471, 37.96169], [-122.00528, 37.96161], [-122.00536, 37.96166], [-122.00544, 37.96166], [-122.00552, 37.96162], [-122.00554, 37.96153], [-122.00557, 37.96149], [-122.00588, 37.96164], [-122.00602, 37.96148], [-122.00606, 37.96148], [-122.0069, 37.96049], [-122.00714, 37.9607], [-122.00725, 37.96082], [-122.00772, 37.96146]]]} | Open Access 1 | Markham Nature Park | 21873 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 13.553 | Markham Nature Park | ||
3890 | 3890 | 3889 | {"type": "Polygon", "coordinates": [[[-121.99146, 37.97453], [-121.99058, 37.97532], [-121.99037, 37.97521], [-121.98999, 37.97556], [-121.98999, 37.97558], [-121.99037, 37.97587], [-121.98946, 37.97664], [-121.9878, 37.97615], [-121.9878, 37.97611], [-121.98775, 37.97606], [-121.98775, 37.97602], [-121.98778, 37.97599], [-121.98847, 37.97539], [-121.98856, 37.97527], [-121.98861, 37.97514], [-121.99058, 37.97349], [-121.99064, 37.97351], [-121.99041, 37.97374], [-121.99146, 37.97453]]]} | Open Access 1 | El Dorado Fields | 18499 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 11.725 | El Dorado Fields | ||
3137 | 3137 | 3136 | {"type": "Polygon", "coordinates": [[[-121.98729, 37.97617], [-121.98563, 37.97757], [-121.9843, 37.97657], [-121.98544, 37.97561], [-121.98729, 37.97617]]]} | Open Access 1 | Concord Boulevard Park | 17574 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 7.136 | Concord Boulevard Park | ||
2212 | 2212 | 2211 | {"type": "Polygon", "coordinates": [[[-121.97034, 37.96168], [-121.96971, 37.96159], [-121.96914, 37.96141], [-121.96863, 37.96092], [-121.96855, 37.96075], [-121.96845, 37.9607], [-121.96879, 37.96024], [-121.9691, 37.96038], [-121.96943, 37.96035], [-121.96958, 37.9604], [-121.96963, 37.96034], [-121.96978, 37.96044], [-121.97034, 37.96168]]]} | Open Access 1 | Brazil Quarry Park | 16338 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 3.648 | Brazil Quarry Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);