units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 2, COUNTY = 19 and DES_TP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15409 | 15409 | 15408 | {"type": "Polygon", "coordinates": [[[-121.74686, 37.21397], [-121.74675, 37.21408], [-121.74406, 37.21175], [-121.74273, 37.21269], [-121.74273, 37.2127], [-121.74574, 37.2153], [-121.74476, 37.21633], [-121.74487, 37.21644], [-121.74242, 37.21804], [-121.73356, 37.21042], [-121.73299, 37.2099], [-121.73292, 37.20993], [-121.72971, 37.20676], [-121.73058, 37.20587], [-121.73123, 37.20514], [-121.73217, 37.20435], [-121.73262, 37.20404], [-121.73268, 37.20403], [-121.73275, 37.20405], [-121.73301, 37.20386], [-121.733, 37.2038], [-121.73303, 37.20375], [-121.73596, 37.20169], [-121.73672, 37.20173], [-121.74017, 37.2049], [-121.74035, 37.2051], [-121.74145, 37.20611], [-121.74142, 37.20618], [-121.74165, 37.20638], [-121.74173, 37.20637], [-121.7461, 37.21033], [-121.74654, 37.21065], [-121.74691, 37.21362], [-121.74686, 37.21397]]]} | Restricted Access 2 | 49043 | Northern Coyote Valley Conservation Area | 33748 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 326.66 | Northern Coyote Valley Conservation Area | 0 | Local Conservation Area 4 | 2 | |
15522 | 15522 | 15521 | {"type": "MultiPolygon", "coordinates": [[[[-121.76287, 37.21275], [-121.76286, 37.21293], [-121.76232, 37.21425], [-121.76156, 37.21457], [-121.75906, 37.21586], [-121.75756, 37.21692], [-121.75681, 37.21661], [-121.75677, 37.2165], [-121.75526, 37.21583], [-121.75502, 37.2157], [-121.75509, 37.21561], [-121.75502, 37.21557], [-121.75493, 37.21565], [-121.75319, 37.21469], [-121.75016, 37.21265], [-121.74665, 37.2101], [-121.74643, 37.20993], [-121.7455, 37.20914], [-121.74074, 37.20483], [-121.74055, 37.20464], [-121.74057, 37.20462], [-121.73814, 37.20241], [-121.73713, 37.20145], [-121.73718, 37.20083], [-121.73835, 37.20002], [-121.73913, 37.20073], [-121.73972, 37.20031], [-121.73945, 37.1997], [-121.73921, 37.19949], [-121.73914, 37.19948], [-121.74116, 37.19815], [-121.74122, 37.1982], [-121.74157, 37.19796], [-121.74319, 37.20032], [-121.74378, 37.20104], [-121.74407, 37.20122], [-121.74544, 37.20166], [-121.74641, 37.20203], [-121.74615, 37.20311], [-121.74637, 37.20329], [-121.7467, 37.20335], [-121.74933, 37.20352], [-121.74953, 37.20417], [-121.74961, 37.20654], [-121.75096, 37.20684], [-121.75129, 37.20723], [-121.75125, 37.20755], [-121.75157, 37.20836], [-121.75306, 37.20872], [-121.75332, 37.20916], [-121.75357, 37.20931], [-121.7554, 37.20946], [-121.75584, 37.20998], [-121.75725, 37.21072], [-121.75917, 37.21126], [-121.76136, 37.21145], [-121.76287, 37.21275]]], [[[-121.74608, 37.21559], [-121.74531, 37.21653], [-121.7452, 37.21672], [-121.74475, 37.21634], [-121.74574, 37.2153], [-121.74608, 37.21559]]], [[[-121.75111, 37.21385], [-121.75028, 37.21433], [-121.74959, 37.21442], [-121.74862, 37.21468], [-121.74773, 37.21479], [-121.74709, 37.21504], [-121.74681, 37.21488], [-121.74704, 37.21434], [-121.74675, 37.21408], [-121.74686, 37.21397], [-121.74691, 37.21362], [-121.74654, 37.21065], [-121.74935, 37.21263], [-121.75111, 37.21385]]]]} | Restricted Access 2 | 49042 | Northern Coyote Valley Conservation Area | 33748 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 374.267 | Northern Coyote Valley Conservation Area | 0 | Local Conservation Area 4 | 2 | |
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 |
15918 | 15918 | 15917 | {"type": "Polygon", "coordinates": [[[-121.85815, 37.22884], [-121.85695, 37.22901], [-121.85587, 37.22908], [-121.85461, 37.22903], [-121.85434, 37.22903], [-121.85412, 37.22913], [-121.85392, 37.22915], [-121.84989, 37.22873], [-121.84963, 37.22856], [-121.84824, 37.2282], [-121.84765, 37.22588], [-121.84714, 37.22428], [-121.84524, 37.22443], [-121.84525, 37.22462], [-121.8443, 37.22466], [-121.84366, 37.22463], [-121.84346, 37.22335], [-121.8435, 37.2233], [-121.84431, 37.22403], [-121.8454, 37.2238], [-121.84606, 37.22367], [-121.84744, 37.22335], [-121.84798, 37.22337], [-121.84832, 37.22282], [-121.84828, 37.22297], [-121.84831, 37.22313], [-121.84837, 37.22323], [-121.84843, 37.22328], [-121.84859, 37.22337], [-121.84801, 37.2235], [-121.84835, 37.22396], [-121.84894, 37.22421], [-121.84983, 37.2247], [-121.84979, 37.22477], [-121.84967, 37.22532], [-121.84947, 37.22559], [-121.84898, 37.22589], [-121.84897, 37.22613], [-121.84915, 37.22614], [-121.84856, 37.22667], [-121.84856, 37.22669], [-121.8501, 37.22725], [-121.85178, 37.22751], [-121.8518, 37.22756], [-121.85275, 37.22781], [-121.85286, 37.22778], [-121.85307, 37.22767], [-121.8534, 37.22777], [-121.85375, 37.2276], [-121.8542, 37.22755], [-121.85524, 37.22754], [-121.85548, 37.22748], [-121.85626, 37.22758], [-121.85664, 37.22779], [-121.8577, 37.22855], [-121.85815, 37.22884]]]} | Restricted Access 2 | 49045 | Santa Teresa Foothills Open Space Preserve | 33751 | 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 | Santa Clara 19 | 53.071 | Santa Teresa Foothills OSP | 0 | Local Conservation Area 4 | 2 | |
15928 | 15928 | 15927 | {"type": "Polygon", "coordinates": [[[-122.01096, 37.17045], [-122.01066, 37.17058], [-122.0105, 37.17074], [-122.0103, 37.17084], [-122.00975, 37.17124], [-122.00965, 37.17139], [-122.00932, 37.17152], [-122.00919, 37.17162], [-122.00907, 37.17163], [-122.00898, 37.17167], [-122.00854, 37.17155], [-122.00786, 37.17166], [-122.00758, 37.17183], [-122.00748, 37.17194], [-122.0073, 37.17197], [-122.00706, 37.17214], [-122.00678, 37.17245], [-122.00663, 37.1725], [-122.00652, 37.17265], [-122.00631, 37.17276], [-122.00628, 37.17289], [-122.00607, 37.17308], [-122.00594, 37.17325], [-122.00586, 37.17333], [-122.00564, 37.17343], [-122.00553, 37.17351], [-122.00539, 37.17356], [-122.00523, 37.17371], [-122.0052, 37.17384], [-122.00478, 37.17427], [-122.00493, 37.17449], [-122.00529, 37.1748], [-122.00566, 37.17501], [-122.00595, 37.17514], [-122.00624, 37.17533], [-122.00649, 37.17542], [-122.0068, 37.17558], [-122.00708, 37.17577], [-122.00746, 37.17586], [-122.00912, 37.17491], [-122.00915, 37.17502], [-122.00921, 37.17511], [-122.00935, 37.17526], [-122.00979, 37.17563], [-122.00993, 37.1757], [-122.01007, 37.17574], [-122.01035, 37.17576], [-122.01039, 37.17602], [-122.01024, 37.17631], [-122.01016, 37.17661], [-122.00971, 37.17712], [-122.00978, 37.17759], [-122.00995, 37.17776], [-122.01007, 37.17791], [-122.0101, 37.17808], [-122.01006, 37.1782], [-122.01002, 37.17823], [-122.00978, 37.17824], [-122.00927, 37.17869], [-122.00968, 37.17911], [-122.00968, 37.17931], [-122.00955, 37.17977], [-122.00931, 37.1799], [-122.00893, 37.17991], [-122.00843, 37.17999], [-122.00776, 37.17978], [-122.00713, 37.18034], [-122.00687, 37.18045], [-122.00652, 37.18045], [-122.00617, 37.18083], [-122.0057, 37.18106], [-122.0053, 37.18114], [-122.00509, 37.18109], [-122.0048, 37.18086], [-122.00442, 37.1804], [-122.00418, 37.18021], [-122.00373, 37.18015], [-122.00288, 37.18041], [-122.00259, 37.18084], [-122.00256, 37.18115], [-122.0031, 37.18184], [-122.00354, 37.18234], [-122.00452, 37.18287], [-122.00463, 37.18315], [-122.00485, 37.18341], [-122.00503, 37.18392], [-122.00501, 37.18399], [-122.00497, 37.18401], [-122.00443, 37.18397], [-122.00423, 37.18399], [-122.00388, 37.18413], [-122.00329, 37.1843], [-122.0032, 37.18431], [-122.00307, 37.18427], [-122.00275, 37.18414], [-122.00239, 37.18403], [-122.00238, 37.18429], [-122.0026, 37.1847], [-122.00273, 37.18509], [-122.0031, 37.18521], [-122.00276, 37.18561], [-122.00258, 37.18563], [-122.00218, 37.18559], [-122.00186, 37.18569], [-122.00186, 37.18571], [-122.00188, 37.18572], [-122.00154, 37.18585], [-122.00154, 37.18588], [-122.00128, 37.18594], [-122.00051, 37.18632], [-121.99863, 37.187], [-121.9984, 37.18703], [-121.99796, 37.18715], [-121.9978, 37.18717], [-121.99763, 37.18714], [-121.99731, 37.18705], [-121.99615, 37.18697], [-121.99586, 37.18703], [-121.99546, 37.18716], [-121.99524, 37.18728], [-121.9951, 37.18749], [-121.99508, 37.18772], [-121.99465, 37.18773], [-121.99471, 37.18951], [-121.99455, 37.18969], [-121.99421, 37.18993], [-121.99378, 37.19009], [-121.99339, 37.18947], [-121.99281, 37.1891], [-121.99224, 37.18819], [-121.99172, 37.18702], [-121.99235, 37.18586], [-121.99179, 37.18542], [-121.99214, 37.18481], [-121.9925, 37.18442], [-121.99327, 37.18282], [-121.99434, 37.18216], [-121.99402, 37.18107], [-121.99486, 37.17957], [-121.99613, 37.17899], [-121.99618, 37.17738], [-121.9968, 37.17713], [-121.99712, 37.17722], [-121.99772, 37.17722], [-121.99788, 37.17741], [-121.99816, 37.17741], [-121.99819, 37.1777], [-121.99827, 37.17777], [-121.99871, 37.17777], [-121.99875, 37.17773], [-121.99877, 37.17761], [-121.99923, 37.17747], [-121.99934, 37.17719], [-121.99966, 37.17714], [-121.9996, 37.17693], [-122.00016, 37.17675], [-122.00024, 37.17649], [-122.00024, 37.17631], [-122.00015, 37.176], [-122.00003, 37.17262], [-122.00092, 37.17054], [-122.00091, 37.17053], [-122.00017, 37.17054], [-122.00011, 37.16903], [-122.00007, 37.16708], [-122.0, 37.16707], [-121.9999, 37.1636], [-122.0034, 37.1636], [-122.00335, 37.15994], [-122.00784, 37.15996], [-122.008, 37.17047], [-122.01096, 37.17045]]]} | Restricted Access 2 | 18511 | Bear Creek Redwoods Open Space Preserve | 31478 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 577.047 | Bear Creek Redwoods OSP | 2003 | 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]);