superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 2 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1069 | 1069 | 1068 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | Sunflower Park | http://www.cityofelcentro.org | 32835 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 18.448 | Sunflower Park | 2000 |
4297 | 4297 | 4296 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19284, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36487], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.1858, 37.36661], [-122.18362, 37.36569], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36061], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33775], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.34881], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.19921, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | Foothills Park | 18984 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1303.416 | Foothills Park | 2000 | |
5474 | 5474 | 5473 | {"type": "MultiPolygon", "coordinates": [[[[-119.20631, 36.19626], [-119.18947, 36.19617], [-119.1893, 36.18901], [-119.20624, 36.18912], [-119.20631, 36.19626]]], [[[-119.20652, 36.21066], [-119.19441, 36.21065], [-119.19394, 36.19634], [-119.20632, 36.19639], [-119.20652, 36.21066]]]]} | Restricted Access 2 | James K. Herbert Wetland Prairie Preserve | 20345 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 729.169 | James K. Herbert Wetland Prairie Preserve | 2000 | |
6239 | 6239 | 6238 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37943], [-121.89269, 37.38197], [-121.8899, 37.37992], [-121.88744, 37.38246], [-121.88659, 37.38185], [-121.88541, 37.38076], [-121.88537, 37.38074], [-121.88537, 37.38072], [-121.88526, 37.38062], [-121.88521, 37.38053], [-121.88521, 37.38051], [-121.88453, 37.37987], [-121.88736, 37.37696], [-121.88571, 37.37551], [-121.88156, 37.37982], [-121.88142, 37.37967], [-121.88134, 37.37955], [-121.88131, 37.37944], [-121.88131, 37.37918], [-121.88142, 37.3789], [-121.88145, 37.37874], [-121.88145, 37.37859], [-121.8814, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.88109, 37.37801], [-121.88083, 37.37784], [-121.88082, 37.37781], [-121.88084, 37.37775], [-121.88072, 37.37768], [-121.8857, 37.3726], [-121.88699, 37.37171], [-121.88727, 37.37166], [-121.88755, 37.37144], [-121.88849, 37.37243], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88949, 37.37414], [-121.88976, 37.37467], [-121.89069, 37.37628], [-121.89054, 37.3768], [-121.89386, 37.37757], [-121.89432, 37.37694], [-121.8944, 37.37697], [-121.89454, 37.37694], [-121.89449, 37.37699], [-121.89448, 37.37703], [-121.89448, 37.37706], [-121.89453, 37.37712], [-121.8946, 37.37714], [-121.89468, 37.37713], [-121.89481, 37.37704], [-121.89517, 37.37697], [-121.89523, 37.37698], [-121.89525, 37.37701], [-121.89534, 37.37741], [-121.8954, 37.37782], [-121.89544, 37.3783], [-121.89545, 37.37859], [-121.89545, 37.37896], [-121.89541, 37.37943]]], [[[-121.89521, 37.37684], [-121.89516, 37.37689], [-121.89478, 37.37696], [-121.89463, 37.37692], [-121.8952, 37.37682], [-121.89521, 37.37684]]]]} | Restricted Access 2 | San Jose Municipal Golf Course | 33028 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 169.667 | San Jose Municipal GC | 2000 | |
8434 | 8434 | 8433 | {"type": "MultiPolygon", "coordinates": [[[[-119.39379, 35.43488], [-119.39371, 35.44209], [-119.37609, 35.44202], [-119.3762, 35.43124], [-119.38496, 35.43125], [-119.38494, 35.43487], [-119.39379, 35.43488]]], [[[-119.41258, 35.45679], [-119.41249, 35.47134], [-119.40359, 35.47126], [-119.40357, 35.46033], [-119.40141, 35.46031], [-119.40139, 35.45941], [-119.39919, 35.45941], [-119.39919, 35.4585], [-119.40141, 35.45853], [-119.40142, 35.45941], [-119.40356, 35.45942], [-119.40356, 35.45673], [-119.39418, 35.45671], [-119.38581, 35.45664], [-119.38587, 35.45269], [-119.38589, 35.44222], [-119.40357, 35.44228], [-119.40356, 35.45301], [-119.40357, 35.45672], [-119.41258, 35.45679]]], [[[-119.39918, 35.4603], [-119.39916, 35.46398], [-119.39024, 35.46394], [-119.39027, 35.46027], [-119.39918, 35.4603]]]]} | Restricted Access 2 | Buttonwillow Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Buttonwillow-ER | 16613 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1446.216 | Buttonwillow ER | 2000 |
14779 | 14779 | 14778 | {"type": "MultiPolygon", "coordinates": [[[[-121.79333, 37.13188], [-121.79238, 37.13241], [-121.79211, 37.13263], [-121.79195, 37.1328], [-121.79174, 37.13309], [-121.79157, 37.13338], [-121.79142, 37.13374], [-121.79129, 37.13416], [-121.79119, 37.13462], [-121.79113, 37.13477], [-121.79102, 37.13536], [-121.79099, 37.13544], [-121.79086, 37.13567], [-121.79066, 37.1359], [-121.79049, 37.13604], [-121.79026, 37.13618], [-121.78941, 37.13636], [-121.78913, 37.13648], [-121.78877, 37.13669], [-121.78845, 37.13689], [-121.7881, 37.13707], [-121.78762, 37.13726], [-121.78744, 37.13735], [-121.78647, 37.13794], [-121.78628, 37.13807], [-121.78616, 37.13818], [-121.78605, 37.13835], [-121.78595, 37.13854], [-121.78592, 37.13885], [-121.78583, 37.13916], [-121.78603, 37.13977], [-121.78614, 37.14004], [-121.78613, 37.14012], [-121.78591, 37.14035], [-121.78575, 37.14044], [-121.78551, 37.1405], [-121.78492, 37.14049], [-121.78462, 37.14052], [-121.78414, 37.1406], [-121.78401, 37.14064], [-121.78391, 37.14069], [-121.78384, 37.14076], [-121.78383, 37.14084], [-121.78386, 37.14121], [-121.78384, 37.14142], [-121.78372, 37.14172], [-121.78362, 37.14183], [-121.78329, 37.14207], [-121.78321, 37.14219], [-121.78307, 37.14237], [-121.78294, 37.14247], [-121.78279, 37.14255], [-121.78241, 37.1427], [-121.78219, 37.14282], [-121.78198, 37.14305], [-121.78189, 37.14319], [-121.78174, 37.14332], [-121.78162, 37.14339], [-121.7814, 37.14345], [-121.78078, 37.14345], [-121.78049, 37.14347], [-121.78022, 37.14354], [-121.78014, 37.14358], [-121.78011, 37.14363], [-121.78012, 37.14376], [-121.7802, 37.14391], [-121.78029, 37.14405], [-121.78031, 37.14414], [-121.78029, 37.14422], [-121.78022, 37.14431], [-121.78, 37.14453], [-121.77947, 37.14479], [-121.77905, 37.14502], [-121.77871, 37.14522], [-121.7784, 37.14537], [-121.77796, 37.14566], [-121.77783, 37.14578], [-121.77769, 37.14593], [-121.77705, 37.14545], [-121.77673, 37.14548], [-121.77614, 37.14532], [-121.77581, 37.14548], [-121.77551, 37.14567], [-121.77532, 37.1459], [-121.77476, 37.14624], [-121.77443, 37.1468], [-121.77454, 37.14748], [-121.77428, 37.14783], [-121.76345, 37.13979], [-121.76651, 37.13763], [-121.76651, 37.13761], [-121.74558, 37.12204], [-121.74134, 37.12008], [-121.74137, 37.11983], [-121.74137, 37.11958], [-121.74148, 37.11951], [-121.74153, 37.11938], [-121.7416, 37.11915], [-121.74174, 37.11896], [-121.74279, 37.11838], [-121.74308, 37.11838], [-121.74338, 37.11846], [-121.74372, 37.11851], [-121.7447, 37.11852], [-121.74492, 37.11844], [-121.74502, 37.1182], [-121.74829, 37.11806], [-121.7491, 37.11698], [-121.75102, 37.11648], [-121.75061, 37.11495], [-121.75284, 37.11195], [-121.76286, 37.11685], [-121.76549, 37.11806], [-121.77168, 37.1212], [-121.79333, 37.13188]]], [[[-121.8305, 37.1323], [-121.82138, 37.13232], [-121.82134, 37.12872], [-121.82128, 37.12507], [-121.83043, 37.12505], [-121.8305, 37.1323]]], [[[-121.8415, 37.16061], [-121.84057, 37.16122], [-121.83917, 37.1616], [-121.83798, 37.16174], [-121.83576, 37.16133], [-121.83397, 37.15718], [-121.8395, 37.15564], [-121.8415, 37.16061]]]]} | Restricted Access 2 | Rancho Cañada del Oro Open Space Preserve | http://www.openspaceauthority.org | 31572 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2087.272 | Rancho Cañada del Oro OSP | 2000 |
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]);