units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where ACCESS_TYP = 1 and MNG_AGENCY = 385
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
16108 | 16108 | 16107 | {"type": "MultiPolygon", "coordinates": [[[[-122.00967, 37.94586], [-122.00952, 37.94591], [-122.00941, 37.94602], [-122.00899, 37.94612], [-122.00897, 37.94632], [-122.00913, 37.94646], [-122.00941, 37.94711], [-122.00889, 37.94735], [-122.00664, 37.94859], [-122.00624, 37.94885], [-122.00591, 37.94917], [-122.00342, 37.94738], [-122.00151, 37.94903], [-122.00138, 37.94895], [-122.00123, 37.94907], [-122.00212, 37.94786], [-122.00224, 37.94764], [-122.0023, 37.94739], [-122.00181, 37.94679], [-122.00167, 37.94673], [-122.00155, 37.94675], [-122.00161, 37.94667], [-122.00176, 37.94656], [-122.0019, 37.94652], [-122.00219, 37.94651], [-122.0022, 37.9465], [-122.00212, 37.94644], [-122.00183, 37.94647], [-122.00163, 37.94656], [-122.00148, 37.94671], [-122.00146, 37.94665], [-122.00045, 37.94623], [-121.99951, 37.94525], [-121.99895, 37.94491], [-121.9986, 37.94451], [-121.99851, 37.94448], [-121.99821, 37.94454], [-121.99813, 37.94479], [-121.99805, 37.94479], [-121.998, 37.94482], [-121.99773, 37.94464], [-121.99719, 37.94475], [-121.99714, 37.94479], [-121.99676, 37.94536], [-121.99606, 37.94618], [-121.99548, 37.94667], [-121.99454, 37.94688], [-121.9935, 37.94728], [-121.99343, 37.94737], [-121.99342, 37.94764], [-121.99263, 37.94735], [-121.99262, 37.94731], [-121.99262, 37.94728], [-121.99267, 37.94724], [-121.99336, 37.9469], [-121.99402, 37.94664], [-121.99515, 37.94574], [-121.99578, 37.94503], [-121.99604, 37.94467], [-121.99637, 37.94411], [-121.99704, 37.94279], [-122.00198, 37.94633], [-122.00696, 37.94264], [-122.00742, 37.94316], [-122.00785, 37.94345], [-122.00821, 37.94397], [-122.00875, 37.94434], [-122.00904, 37.94447], [-122.00945, 37.9449], [-122.00953, 37.9453], [-122.00914, 37.9459], [-122.00967, 37.94586]]], [[[-122.02574, 37.96133], [-122.0244, 37.96249], [-122.01489, 37.9556], [-122.01438, 37.95671], [-122.01256, 37.9554], [-122.0127, 37.95515], [-122.01158, 37.95438], [-122.01211, 37.95359], [-122.00802, 37.95065], [-122.00706, 37.94997], [-122.00704, 37.94998], [-122.00619, 37.94935], [-122.00643, 37.94911], [-122.00663, 37.94895], [-122.00684, 37.94882], [-122.0093, 37.94748], [-122.01228, 37.94845], [-122.01623, 37.94976], [-122.01674, 37.95062], [-122.01847, 37.95119], [-122.01858, 37.95209], [-122.01801, 37.95237], [-122.01679, 37.95287], [-122.01542, 37.95293], [-122.01551, 37.95348], [-122.01773, 37.95536], [-122.01891, 37.956], [-122.01957, 37.95594], [-122.01965, 37.95608], [-122.01976, 37.95631], [-122.01982, 37.9565], [-122.01986, 37.95678], [-122.01989, 37.95685], [-122.01997, 37.95698], [-122.02014, 37.95714], [-122.02029, 37.95722], [-122.02045, 37.95727], [-122.02063, 37.9573], [-122.02084, 37.95729], [-122.02091, 37.95734], [-122.02207, 37.95766], [-122.02234, 37.95872], [-122.02276, 37.95931], [-122.0238, 37.96047], [-122.02383, 37.96046], [-122.02405, 37.96071], [-122.0248, 37.96111], [-122.02562, 37.96126], [-122.02574, 37.96133]]]]} | Open Access 1 | 13556 | Lime Ridge Open Space | 2535 | 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 | http://www.walnut-creek.org/citygov/depts/ps/openspace/limeridge.asp | Contra Costa 12 | 264.399 | Lime Ridge OS | 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]);