superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AG_TYP = 8 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6311 | 6311 | 6310 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 4.389 | Livorna Park | ||
8271 | 8271 | 8270 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 211.393 | Point Edith Wetlands | 2001 | |
9227 | 9227 | 9226 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.13119, 37.48389], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48261], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13606, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 94.819 | San Mateo Properties | 1930 | |
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.21997, 38.05377], [-122.21956, 38.05348], [-122.21836, 38.05306], [-122.21781, 38.05289], [-122.21792, 38.05262], [-122.21939, 38.05234], [-122.21949, 38.05202], [-122.21938, 38.05173], [-122.21992, 38.05179], [-122.21998, 38.05209], [-122.22007, 38.05311], [-122.22003, 38.05357], [-122.21997, 38.05377]]]} | Open Access 1 | Crockett | 17826 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 5.155 | Crockett | ||
6081 | 6081 | 6080 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.26919, 38.03185], [-122.26869, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 13.712 | Lefty Gomez Ballfield Complex | ||
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 0.053 | Kensington PP | ||
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91336], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28008, 37.91364], [-122.28059, 37.91414], [-122.28033, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28014, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28075, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91334], [-122.28129, 37.91319], [-122.28132, 37.9134]]]} | Open Access 1 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 8.475 | Kensington Park | ||
15583 | 15583 | 15582 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 4.395 | Montara Bay Community Ctr. | ||
7117 | 7117 | 7116 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.9994], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 8.503 | Montalvin Park | ||
8632 | 8632 | 8631 | {"type": "Polygon", "coordinates": [[[-122.40596, 37.71374], [-122.40582, 37.71397], [-122.40589, 37.71402], [-122.40573, 37.71427], [-122.4055, 37.71418], [-122.40564, 37.71394], [-122.40558, 37.7139], [-122.40573, 37.71365], [-122.40596, 37.71374]]]} | Open Access 1 | Reis Tract Lots - Arleta I | 24283 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 0.349 | Reis Tract Lots - Arleta I | ||
10062 | 10062 | 10061 | {"type": "Polygon", "coordinates": [[[-122.45243, 37.75546], [-122.45204, 37.75657], [-122.45019, 37.75667], [-122.44973, 37.75638], [-122.44965, 37.75628], [-122.4496, 37.75614], [-122.4496, 37.75594], [-122.4499, 37.75586], [-122.45005, 37.75579], [-122.45019, 37.75571], [-122.45027, 37.75565], [-122.45079, 37.75511], [-122.45094, 37.755], [-122.45106, 37.75493], [-122.45121, 37.75487], [-122.45136, 37.75483], [-122.45148, 37.75484], [-122.45154, 37.75481], [-122.45158, 37.75476], [-122.45164, 37.75442], [-122.45206, 37.75443], [-122.45208, 37.75517], [-122.45243, 37.75546]]]} | Restricted Access 2 | Summit Reservoir Water Facilities | 25969 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 9.064 | Summit Reservoir Water Facilities | ||
5150 | 5150 | 5149 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 0.079 | Hillcrest And Ocean View Lots |
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]);