units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 385 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8566 | 8566 | 8565 | {"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 | 13583 | Iron Horse Park | 20234 | 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.22 | Iron Horse Park | 0 | Local Park 2 | 4 | |
8569 | 8569 | 8568 | {"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.95226], [-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 | 13594 | Rick Sears Park | 24345 | 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.595 | Rick Sears 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 | |
8571 | 8571 | 8570 | {"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 | 13600 | BART Park | 15839 | 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 | 1.284 | BART 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 | |||
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 | |
8573 | 8573 | 8572 | {"type": "Polygon", "coordinates": [[[-121.96645, 37.94232], [-121.96608, 37.94253], [-121.96599, 37.94254], [-121.96473, 37.94158], [-121.96454, 37.94147], [-121.96421, 37.94134], [-121.96412, 37.94126], [-121.96395, 37.94126], [-121.96372, 37.94122], [-121.96345, 37.94119], [-121.96335, 37.94117], [-121.96308, 37.94116], [-121.96301, 37.94113], [-121.963, 37.9411], [-121.96298, 37.94078], [-121.96303, 37.94049], [-121.96311, 37.94021], [-121.96344, 37.93939], [-121.96352, 37.93926], [-121.96384, 37.93885], [-121.9639, 37.93884], [-121.96393, 37.93885], [-121.96361, 37.93926], [-121.96346, 37.93958], [-121.96341, 37.93974], [-121.96337, 37.94009], [-121.96338, 37.94027], [-121.96373, 37.94024], [-121.96375, 37.94031], [-121.96381, 37.94046], [-121.96397, 37.94065], [-121.9637, 37.94085], [-121.96387, 37.94097], [-121.96407, 37.94107], [-121.96435, 37.94116], [-121.96463, 37.94119], [-121.96488, 37.94118], [-121.96505, 37.94114], [-121.96512, 37.94122], [-121.96493, 37.94169], [-121.96542, 37.94208], [-121.96561, 37.94216], [-121.96575, 37.9422], [-121.96645, 37.94232]]]} | Open Access 1 | 13606 | Pine Hollow Estates | 23680 | 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.614 | Pine Hollow Estates | None 716 | |||
8557 | 8557 | 8556 | {"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.96959, 37.9604], [-121.96963, 37.96034], [-121.96978, 37.96044], [-121.97034, 37.96168]]]} | Open Access 1 | 13562 | Brazil Quarry Park | 16338 | 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.647 | Brazil Quarry Park | 0 | Local Park 2 | 4 | |
8561 | 8561 | 8560 | {"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 | 13573 | Len Hester Community Park | 21161 | 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.966 | Len Hester Community Park | 0 | Local Park 2 | 4 | |
8565 | 8565 | 8564 | {"type": "MultiPolygon", "coordinates": [[[[-122.03055, 37.99544], [-122.03041, 37.99559], [-122.03036, 37.99557], [-122.02781, 37.99913], [-122.02681, 38.00047], [-122.02634, 38.00104], [-122.02613, 38.0013], [-122.02602, 38.00141], [-122.0253, 38.00225], [-122.02512, 38.00215], [-122.02514, 38.0021], [-122.02511, 38.00189], [-122.02521, 38.00185], [-122.02549, 38.00144], [-122.0256, 38.00144], [-122.02568, 38.0014], [-122.02571, 38.00134], [-122.02572, 38.00127], [-122.02585, 38.00107], [-122.02616, 38.0012], [-122.02793, 37.99875], [-122.02793, 37.99874], [-122.02785, 37.9987], [-122.02795, 37.99856], [-122.02805, 37.9986], [-122.03046, 37.9953], [-122.03051, 37.99535], [-122.03055, 37.99544]]], [[[-122.03362, 37.98983], [-122.0335, 37.98983], [-122.03344, 37.9902], [-122.03335, 37.99065], [-122.03324, 37.99102], [-122.03304, 37.99156], [-122.03285, 37.99199], [-122.03273, 37.99221], [-122.03234, 37.99284], [-122.03069, 37.99515], [-122.03063, 37.99518], [-122.03058, 37.99517], [-122.03056, 37.99516], [-122.03207, 37.99308], [-122.03207, 37.99306], [-122.03203, 37.99305], [-122.03212, 37.99293], [-122.03218, 37.99294], [-122.03251, 37.99243], [-122.03271, 37.99207], [-122.03297, 37.99151], [-122.03311, 37.99113], [-122.03323, 37.99074], [-122.03336, 37.99016], [-122.03343, 37.98956], [-122.03351, 37.98956], [-122.03356, 37.98959], [-122.03356, 37.98973], [-122.03359, 37.98974], [-122.03362, 37.98983]]], [[[-122.03365, 37.98925], [-122.03361, 37.9893], [-122.03355, 37.98933], [-122.03344, 37.98934], [-122.03344, 37.98898], [-122.03342, 37.98864], [-122.03336, 37.98813], [-122.03321, 37.98746], [-122.033, 37.9868], [-122.0325, 37.98563], [-122.03255, 37.98561], [-122.03282, 37.98623], [-122.03302, 37.98653], [-122.03329, 37.9873], [-122.03346, 37.98805], [-122.0335, 37.98836], [-122.03354, 37.98891], [-122.03354, 37.98924], [-122.03365, 37.98925]]]]} | Open Access 1 | 13580 | BART Linear Park | 15838 | 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 | 5.267 | BART Linear Park | 0 | Local Park 2 | 4 | |
8560 | 8560 | 8559 | {"type": "Polygon", "coordinates": [[[-121.95868, 37.94342], [-121.95855, 37.94356], [-121.95849, 37.94365], [-121.95821, 37.94415], [-121.95553, 37.94318], [-121.95594, 37.94246], [-121.95868, 37.94342]]]} | Open Access 1 | 13570 | Highlands Neighborhood Park | 19941 | 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 | 5.734 | Highlands Neighborhood Park | 0 | Local Park 2 | 4 | |
3631 | 3631 | 3630 | {"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 | 13539 | Concord Boulevard Park | 17574 | 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.136 | Concord Boulevard 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 | |
8570 | 8570 | 8569 | {"type": "Polygon", "coordinates": [[[-122.02943, 37.96792], [-122.02914, 37.96856], [-122.02735, 37.96808], [-122.02717, 37.96843], [-122.02586, 37.96806], [-122.02578, 37.96822], [-122.02543, 37.96811], [-122.02546, 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 | 13597 | Krueger Play Fields | 20726 | 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 | 9.187 | Krueger Play Fields | 0 | Local Recreation Area 3 | 4 | |
3632 | 3632 | 3631 | {"type": "Polygon", "coordinates": [[[-122.03877, 37.97179], [-122.0379, 37.9722], [-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.03692, 37.97088], [-122.0378, 37.97047], [-122.03877, 37.97179]]]} | Open Access 1 | 13541 | Ellis Lake Park | 18592 | 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 | 9.392 | Ellis Lake Park | 0 | Local Park 2 | 4 | |
8559 | 8559 | 8558 | {"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 | 13567 | Ygnacio Valley Park | 27771 | 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 | 9.462 | Ygnacio Valley Park | 0 | Local Park 2 | 4 | |
8558 | 8558 | 8557 | {"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 | 13565 | Cambridge Park | 16752 | 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 | 10.872 | Cambridge Park | 0 | Local Park 2 | 4 | |
8567 | 8567 | 8566 | {"type": "Polygon", "coordinates": [[[-121.99146, 37.97453], [-121.99058, 37.97532], [-121.99037, 37.97521], [-121.98998, 37.97556], [-121.98999, 37.97557], [-121.99037, 37.97587], [-121.98946, 37.97664], [-121.9878, 37.97615], [-121.98781, 37.97612], [-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.9904, 37.97373], [-121.99146, 37.97453]]]} | Open Access 1 | 13585 | El Dorado Fields | 18499 | 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 | 11.719 | El Dorado Fields | 0 | Local Recreation Area 3 | 4 | |
8568 | 8568 | 8567 | {"type": "MultiPolygon", "coordinates": [[[[-121.97302, 37.94092], [-121.97294, 37.94108], [-121.97296, 37.94127], [-121.97295, 37.94139], [-121.97282, 37.94158], [-121.97251, 37.94174], [-121.97224, 37.94172], [-121.97181, 37.94243], [-121.97197, 37.9427], [-121.97208, 37.94277], [-121.97222, 37.9429], [-121.9722, 37.94303], [-121.97203, 37.94345], [-121.9721, 37.94386], [-121.97208, 37.94391], [-121.97197, 37.94399], [-121.97185, 37.94411], [-121.97176, 37.94432], [-121.97163, 37.94437], [-121.97155, 37.94442], [-121.97151, 37.94452], [-121.97152, 37.94462], [-121.9715, 37.94475], [-121.97142, 37.94483], [-121.97135, 37.94475], [-121.97105, 37.94456], [-121.97094, 37.94451], [-121.97082, 37.94448], [-121.97054, 37.94448], [-121.97039, 37.94452], [-121.97026, 37.94458], [-121.97247, 37.94073], [-121.97302, 37.94092]]], [[[-121.97244, 37.94052], [-121.97244, 37.94052], [-121.97134, 37.94243], [-121.9713, 37.94223], [-121.97124, 37.94204], [-121.97107, 37.94175], [-121.9713, 37.94162], [-121.97138, 37.94139], [-121.97135, 37.94131], [-121.97109, 37.94111], [-121.97095, 37.94105], [-121.97086, 37.94103], [-121.97091, 37.94073], [-121.97095, 37.94063], [-121.97102, 37.94053], [-121.97104, 37.94045], [-121.97105, 37.94036], [-121.97103, 37.94025], [-121.97105, 37.94016], [-121.97113, 37.94004], [-121.97244, 37.94052]]]]} | Open Access 1 | 13588 | Boatwright Fields | 16206 | 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 | 12.073 | Boatwright Fields | 0 | Local Recreation Area 3 | 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]);