units_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: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, COUNTY, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237 | 3237 | 3236 | {"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 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
6082 | 6082 | 6081 | {"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 | 918 | James K. Herbert Wetland Prairie Preserve | 20345 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 729.195 | James K. Herbert Wetland Prairie Preserve | 2000 | Private Conservation 16 | 2 | |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-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.36062], [-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.33774], [-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.3488], [-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.1992, 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 | 16498 | Foothills Park | 18984 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
15601 | 15601 | 15600 | {"type": "MultiPolygon", "coordinates": [[[[-119.39379, 35.43488], [-119.39371, 35.44209], [-119.37609, 35.44202], [-119.3762, 35.43124], [-119.38496, 35.43125], [-119.38493, 35.43487], [-119.39379, 35.43488]]], [[[-119.39918, 35.4603], [-119.39916, 35.46398], [-119.39024, 35.46394], [-119.39027, 35.46027], [-119.39918, 35.4603]]], [[[-119.41258, 35.45679], [-119.41249, 35.47134], [-119.40359, 35.47126], [-119.40358, 35.46032], [-119.40141, 35.46031], [-119.4014, 35.45941], [-119.39919, 35.45941], [-119.39919, 35.4585], [-119.40141, 35.45853], [-119.40142, 35.45941], [-119.40357, 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]]]]} | Restricted Access 2 | 16623 | Buttonwillow Ecological Reserve | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Buttonwillow-ER | Kern 36 | 1446.039 | Buttonwillow ER | 2000 | State Conservation Area 8 | 2 |
15673 | 15673 | 15672 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37942], [-121.89269, 37.38197], [-121.8899, 37.37991], [-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.88522, 37.38051], [-121.88453, 37.37987], [-121.88737, 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.88141, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.8811, 37.37802], [-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.8885, 37.37244], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88948, 37.37413], [-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.37698], [-121.89447, 37.37703], [-121.89448, 37.37707], [-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 | 9687 | San Jose Municipal Golf Course | 33028 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 169.542 | San Jose Municipal GC | 2000 | Local Recreation Area 3 | 4 | |
15900 | 15900 | 15899 | {"type": "MultiPolygon", "coordinates": [[[[-121.79333, 37.13188], [-121.79239, 37.13241], [-121.79211, 37.13263], [-121.79195, 37.1328], [-121.79173, 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.13637], [-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.78594, 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.14206], [-121.78321, 37.14219], [-121.78307, 37.14237], [-121.78294, 37.14247], [-121.78279, 37.14255], [-121.7824, 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.78021, 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.14577], [-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.76652, 37.13763], [-121.76652, 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.75103, 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 | 47772 | Rancho Cañada del Oro Open Space Preserve | 31572 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 2087.26 | Rancho Cañada del Oro OSP | 2000 | Local Conservation Area 4 | 2 |
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]);