units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 385 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3630 | 3630 | 3629 | {"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.04423, 37.9966], [-122.04444, 37.99633], [-122.0447, 37.99554], [-122.0451, 37.99563], [-122.04584, 37.99596], [-122.04786, 37.99682], [-122.0452, 37.99613], [-122.04504, 37.99652], [-122.04783, 37.99725], [-122.04817, 37.99731]]]} | Open Access 1 | 13530 | Hillcrest Community Park | 19965 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 22.958 | Hillcrest Community Park | 0 | Local Park 2 | 4 | |
3629 | 3629 | 3628 | {"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.00362], [-122.03447, 38.0033], [-122.03476, 38.00343], [-122.03573, 38.00376]]]} | Open Access 1 | 13528 | Sun Terrace Park | 25978 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 2.594 | Sun Terrace Park | 0 | Local Park 2 | 4 | |
3628 | 3628 | 3627 | {"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.02446, 38.00749], [-122.02483, 38.00787], [-122.02532, 38.00815], [-122.02596, 38.00835]]]} | Open Access 1 | 13525 | Bayview Circle Park | 15900 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.32 | Bayview Circle Park | 0 | Local Park 2 | 4 | |
3333 | 3333 | 3332 | {"type": "Polygon", "coordinates": [[[-122.03097, 37.96818], [-122.0305, 37.96804], [-122.0304, 37.96765], [-122.03042, 37.96764], [-122.03041, 37.96759], [-122.03061, 37.96755], [-122.03072, 37.96749], [-122.03085, 37.96758], [-122.0309, 37.96779], [-122.03087, 37.96778], [-122.03087, 37.96779], [-122.03097, 37.96818]]]} | Open Access 1 | 23690 | Concord Skate Park | 17576 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 0.597 | Concord Skate Park | 0 | Local Recreation Area 3 | 4 | |
1799 | 1799 | 1798 | {"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 | 13550 | Concord Community Park | 17575 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 30.162 | Concord Community Park | 0 | Local Park 2 | 4 | |
1798 | 1798 | 1797 | {"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 | 13547 | Meadow Homes Park | 22072 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 7.701 | Meadow Homes Park | 0 | Local Park 2 | 4 | |
1795 | 1795 | 1794 | {"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 | 13536 | Todos Santos | 26388 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 2.043 | Todos Santos | None 141 | |||
1600 | 1600 | 1599 | {"type": "MultiPolygon", "coordinates": [[[[-122.03172, 37.98378], [-122.02817, 37.98545], [-122.02703, 37.98392], [-122.02735, 37.98377], [-122.0275, 37.9839], [-122.0277, 37.98399], [-122.02785, 37.98403], [-122.028, 37.98403], [-122.02822, 37.984], [-122.03039, 37.98299], [-122.03056, 37.98287], [-122.03064, 37.98277], [-122.03069, 37.98265], [-122.03071, 37.98247], [-122.03068, 37.98234], [-122.03063, 37.98222], [-122.03098, 37.98206], [-122.03172, 37.98378]]], [[[-122.03053, 37.98227], [-122.0306, 37.98246], [-122.0306, 37.98257], [-122.03058, 37.98267], [-122.03052, 37.98276], [-122.03045, 37.98284], [-122.03028, 37.98295], [-122.02818, 37.98392], [-122.02805, 37.98395], [-122.02792, 37.98395], [-122.0278, 37.98393], [-122.02768, 37.98389], [-122.02757, 37.98384], [-122.02744, 37.98372], [-122.03053, 37.98227]]]]} | Open Access 1 | 13534 | Baldwin Park | 15779 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 17.805 | Baldwin Park | 0 | Local Park 2 | 4 | |
1599 | 1599 | 1598 | {"type": "MultiPolygon", "coordinates": [[[[-122.02054, 37.98502], [-122.01997, 37.98528], [-122.01976, 37.9854], [-122.01948, 37.98561], [-122.01903, 37.98604], [-122.01742, 37.98529], [-122.01715, 37.98514], [-122.01703, 37.98505], [-122.01682, 37.98483], [-122.01587, 37.98356], [-122.01718, 37.98295], [-122.0186, 37.98485], [-122.01994, 37.98422], [-122.02054, 37.98502]]], [[[-122.02351, 37.99321], [-122.0232, 37.99333], [-122.02241, 37.99272], [-122.02244, 37.99269], [-122.02224, 37.99248], [-122.02216, 37.99237], [-122.0221, 37.99225], [-122.02204, 37.99207], [-122.02132, 37.98904], [-122.02126, 37.98885], [-122.02119, 37.9887], [-122.02109, 37.98856], [-122.01954, 37.98648], [-122.01938, 37.9863], [-122.01924, 37.98618], [-122.01969, 37.98576], [-122.01993, 37.98557], [-122.02068, 37.98522], [-122.02264, 37.98785], [-122.02207, 37.98863], [-122.02247, 37.98882], [-122.02351, 37.99321]]]]} | Open Access 1 | 13532 | Willow Pass Community Park | 27586 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 40.392 | Willow Pass Community 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]);