units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AGENCY = 468 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8216 | 8216 | 8215 | {"type": "Polygon", "coordinates": [[[-121.70445, 37.20053], [-121.70326, 37.20153], [-121.70223, 37.20075], [-121.69994, 37.20267], [-121.69238, 37.20067], [-121.67911, 37.20067], [-121.6791, 37.20242], [-121.67335, 37.20336], [-121.6702, 37.20496], [-121.67054, 37.20382], [-121.67051, 37.20373], [-121.67027, 37.20347], [-121.67054, 37.20325], [-121.67069, 37.20318], [-121.6723, 37.2027], [-121.67228, 37.20259], [-121.67223, 37.20251], [-121.67215, 37.20244], [-121.67204, 37.2024], [-121.67064, 37.20215], [-121.67045, 37.20208], [-121.67046, 37.20195], [-121.67037, 37.20194], [-121.67039, 37.20185], [-121.67086, 37.20186], [-121.67156, 37.2015], [-121.6719, 37.20147], [-121.6729, 37.20106], [-121.6731, 37.20091], [-121.67273, 37.20041], [-121.67274, 37.2], [-121.6729, 37.19964], [-121.67294, 37.19944], [-121.67264, 37.1994], [-121.67182, 37.19903], [-121.67164, 37.19869], [-121.67173, 37.19829], [-121.67147, 37.19794], [-121.67093, 37.19764], [-121.67042, 37.19752], [-121.66991, 37.19746], [-121.66957, 37.19745], [-121.66941, 37.19754], [-121.66918, 37.19753], [-121.66844, 37.19627], [-121.66841, 37.19586], [-121.66776, 37.19538], [-121.66731, 37.19526], [-121.66643, 37.19552], [-121.66593, 37.1955], [-121.66523, 37.19506], [-121.66497, 37.19493], [-121.66482, 37.19494], [-121.66444, 37.19523], [-121.66439, 37.19537], [-121.6638, 37.19579], [-121.66349, 37.19586], [-121.66327, 37.19587], [-121.66305, 37.19586], [-121.66294, 37.19584], [-121.66253, 37.19545], [-121.662, 37.19498], [-121.6617, 37.19489], [-121.66129, 37.19454], [-121.6609, 37.19442], [-121.6605, 37.19431], [-121.65989, 37.19421], [-121.65972, 37.19382], [-121.65974, 37.19354], [-121.65995, 37.19326], [-121.66037, 37.19312], [-121.66078, 37.1925], [-121.6613, 37.19151], [-121.66116, 37.19129], [-121.66012, 37.1913], [-121.65996, 37.1914], [-121.6597, 37.19149], [-121.65951, 37.19153], [-121.65932, 37.19154], [-121.65903, 37.1915], [-121.65831, 37.1913], [-121.65814, 37.19129], [-121.65797, 37.19124], [-121.65782, 37.19118], [-121.65768, 37.19109], [-121.65752, 37.19093], [-121.65744, 37.1908], [-121.65728, 37.19036], [-121.6572, 37.1902], [-121.65701, 37.18997], [-121.65677, 37.18978], [-121.65873, 37.18792], [-121.66291, 37.19106], [-121.66325, 37.19234], [-121.66577, 37.19395], [-121.66716, 37.19428], [-121.66931, 37.19621], [-121.67211, 37.19402], [-121.67332, 37.19501], [-121.67375, 37.19466], [-121.67383, 37.19394], [-121.67437, 37.19435], [-121.68242, 37.19194], [-121.68287, 37.19245], [-121.68377, 37.19207], [-121.6846, 37.19161], [-121.68551, 37.19118], [-121.68638, 37.19073], [-121.68742, 37.19049], [-121.68742, 37.19047], [-121.68702, 37.18995], [-121.68664, 37.18949], [-121.68865, 37.18836], [-121.68994, 37.1893], [-121.69016, 37.18949], [-121.69036, 37.1897], [-121.69053, 37.18992], [-121.69074, 37.19027], [-121.69084, 37.19052], [-121.69105, 37.19116], [-121.69108, 37.19133], [-121.69106, 37.19145], [-121.69102, 37.19157], [-121.69095, 37.19168], [-121.69086, 37.19177], [-121.69069, 37.19189], [-121.69056, 37.19195], [-121.69042, 37.19199], [-121.68968, 37.19185], [-121.68984, 37.19285], [-121.69031, 37.19277], [-121.69076, 37.19264], [-121.69176, 37.19272], [-121.69288, 37.19243], [-121.69449, 37.19269], [-121.69483, 37.19278], [-121.69513, 37.19291], [-121.69658, 37.19385], [-121.6948, 37.1945], [-121.69188, 37.19348], [-121.69103, 37.19408], [-121.6915, 37.19486], [-121.69268, 37.19613], [-121.6937, 37.19617], [-121.69621, 37.19724], [-121.69676, 37.19807], [-121.69838, 37.19861], [-121.6998, 37.19983], [-121.70166, 37.20045], [-121.70277, 37.20031], [-121.70325, 37.1999], [-121.7006, 37.19787], [-121.70093, 37.19744], [-121.70189, 37.19857], [-121.70445, 37.20053]], [[-121.68936, 37.19422], [-121.68936, 37.19339], [-121.68861, 37.19248], [-121.68665, 37.19622], [-121.68558, 37.19699], [-121.67959, 37.19319], [-121.67463, 37.19493], [-121.67589, 37.19574], [-121.68004, 37.19795], [-121.68235, 37.19634], [-121.68372, 37.19722], [-121.68189, 37.1985], [-121.68189, 37.19852], [-121.6879, 37.19909], [-121.68937, 37.19811], [-121.68936, 37.19422]]]} | No Public Access 3 | 47777 | Coyote Ridge | 30262 | 2305 | Santa Clara Valley Transportation Authority 887 | Special District 4 | Transportation Agency 32 | http://www.vta.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 | 553.269 | Coyote Ridge | 0 | None 685 | |
8220 | 8220 | 8219 | {"type": "MultiPolygon", "coordinates": [[[[-121.67375, 37.19466], [-121.67332, 37.19501], [-121.6721, 37.19402], [-121.66931, 37.19621], [-121.66716, 37.19428], [-121.66577, 37.19395], [-121.66325, 37.19234], [-121.66291, 37.19106], [-121.65873, 37.18793], [-121.65677, 37.18978], [-121.65701, 37.18997], [-121.6572, 37.1902], [-121.65728, 37.19036], [-121.65744, 37.1908], [-121.65752, 37.19093], [-121.65768, 37.19109], [-121.65782, 37.19118], [-121.65797, 37.19124], [-121.65814, 37.19129], [-121.65831, 37.1913], [-121.65903, 37.1915], [-121.65932, 37.19154], [-121.65951, 37.19153], [-121.6597, 37.19149], [-121.65996, 37.1914], [-121.66012, 37.1913], [-121.66116, 37.19129], [-121.6613, 37.19151], [-121.66078, 37.1925], [-121.66037, 37.19312], [-121.65995, 37.19326], [-121.65974, 37.19354], [-121.65972, 37.19382], [-121.65989, 37.19421], [-121.6605, 37.19431], [-121.6609, 37.19442], [-121.66129, 37.19454], [-121.6617, 37.19489], [-121.662, 37.19498], [-121.66253, 37.19545], [-121.66294, 37.19584], [-121.66305, 37.19586], [-121.66327, 37.19587], [-121.66349, 37.19586], [-121.6638, 37.19579], [-121.66439, 37.19537], [-121.66444, 37.19523], [-121.66481, 37.19494], [-121.66497, 37.19493], [-121.66523, 37.19506], [-121.66593, 37.1955], [-121.66643, 37.19552], [-121.66731, 37.19526], [-121.66776, 37.19538], [-121.66841, 37.19586], [-121.66844, 37.19627], [-121.66918, 37.19753], [-121.6694, 37.19754], [-121.66957, 37.19745], [-121.66991, 37.19746], [-121.67042, 37.19752], [-121.67092, 37.19764], [-121.67147, 37.19794], [-121.67173, 37.19829], [-121.67164, 37.19869], [-121.67182, 37.19903], [-121.67264, 37.1994], [-121.67294, 37.19944], [-121.6729, 37.19964], [-121.67274, 37.2], [-121.67273, 37.20041], [-121.67311, 37.2009], [-121.67291, 37.20106], [-121.6719, 37.20147], [-121.67156, 37.2015], [-121.67086, 37.20186], [-121.67039, 37.20185], [-121.67037, 37.20194], [-121.67046, 37.20195], [-121.67045, 37.20208], [-121.67064, 37.20215], [-121.6721, 37.20242], [-121.67219, 37.20247], [-121.67226, 37.20254], [-121.67229, 37.20263], [-121.6723, 37.20271], [-121.67076, 37.20315], [-121.67054, 37.20325], [-121.67028, 37.20347], [-121.67051, 37.20373], [-121.67054, 37.20382], [-121.6702, 37.20496], [-121.66781, 37.20618], [-121.66476, 37.20618], [-121.6638, 37.20497], [-121.66105, 37.20567], [-121.66095, 37.20549], [-121.65936, 37.20486], [-121.65888, 37.20465], [-121.65833, 37.20381], [-121.65789, 37.20355], [-121.65783, 37.20317], [-121.65723, 37.20271], [-121.65558, 37.20205], [-121.65509, 37.20198], [-121.65315, 37.20186], [-121.65243, 37.20147], [-121.65162, 37.20136], [-121.65087, 37.20155], [-121.6508, 37.20184], [-121.65101, 37.2022], [-121.65087, 37.20231], [-121.65047, 37.20198], [-121.65004, 37.20155], [-121.64942, 37.2015], [-121.64935, 37.20239], [-121.65039, 37.20416], [-121.65064, 37.20448], [-121.64971, 37.20385], [-121.64956, 37.20394], [-121.64947, 37.20448], [-121.64968, 37.20529], [-121.64911, 37.20421], [-121.64921, 37.2034], [-121.64911, 37.20312], [-121.64884, 37.20299], [-121.64858, 37.20242], [-121.64845, 37.20157], [-121.64816, 37.20148], [-121.64781, 37.20164], [-121.64757, 37.20189], [-121.64736, 37.20206], [-121.64705, 37.20252], [-121.64665, 37.20358], [-121.64617, 37.20431], [-121.64539, 37.20467], [-121.64594, 37.20319], [-121.64673, 37.20119], [-121.64707, 37.20093], [-121.64721, 37.20057], [-121.64569, 37.20077], [-121.64536, 37.20098], [-121.64461, 37.20026], [-121.64537, 37.20036], [-121.64596, 37.2003], [-121.64698, 37.20009], [-121.64725, 37.19995], [-121.64693, 37.19888], [-121.64662, 37.19767], [-121.64676, 37.19726], [-121.64666, 37.19657], [-121.64633, 37.19607], [-121.64615, 37.19585], [-121.64556, 37.19615], [-121.64435, 37.19653], [-121.6442, 37.19712], [-121.64375, 37.19745], [-121.6435, 37.19724], [-121.64379, 37.19688], [-121.64391, 37.19609], [-121.64415, 37.19598], [-121.64442, 37.19578], [-121.64476, 37.19564], [-121.64514, 37.19536], [-121.64532, 37.19502], [-121.64544, 37.19438], [-121.64532, 37.19405], [-121.64513, 37.19384], [-121.64466, 37.19347], [-121.64426, 37.19335], [-121.64369, 37.19288], [-121.64316, 37.19251], [-121.6469, 37.19007], [-121.64731, 37.18986], [-121.64827, 37.19022], [-121.64888, 37.19041], [-121.64927, 37.19081], [-121.64959, 37.19108], [-121.64978, 37.19134], [-121.65018, 37.19125], [-121.6506, 37.19122], [-121.65101, 37.19125], [-121.65141, 37.19134], [-121.65167, 37.19144], [-121.6519, 37.19155], [-121.65338, 37.1925], [-121.65464, 37.18997], [-121.65256, 37.18777], [-121.6494, 37.18505], [-121.65302, 37.17121], [-121.65615, 37.17223], [-121.65621, 37.17216], [-121.65783, 37.17259], [-121.65882, 37.17264], [-121.65952, 37.17264], [-121.66124, 37.17269], [-121.65752, 37.17852], [-121.65647, 37.18174], [-121.65872, 37.18298], [-121.66133, 37.18434], [-121.66205, 37.18443], [-121.66306, 37.18517], [-121.6641, 37.1855], [-121.66506, 37.18668], [-121.66659, 37.1872], [-121.66687, 37.18756], [-121.66654, 37.18865], [-121.66646, 37.18927], [-121.66776, 37.1906], [-121.66918, 37.19163], [-121.67142, 37.19208], [-121.67375, 37.19466]]], [[[-121.68743, 37.19048], [-121.68638, 37.19073], [-121.68551, 37.19118], [-121.6846, 37.19161], [-121.68377, 37.19207], [-121.68286, 37.19246], [-121.68243, 37.19194], [-121.68333, 37.19155], [-121.68419, 37.19107], [-121.68506, 37.19067], [-121.68593, 37.1902], [-121.68702, 37.18995], [-121.68743, 37.19048]]]]} | No Public Access 3 | 47778 | Coyote Ridge Property | 31578 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1178.052 | Coyote Ridge Property | 0 | Local Other or Unknown 14 | 4 | |
8336 | 8336 | 8335 | {"type": "MultiPolygon", "coordinates": [[[[-121.73013, 37.18296], [-121.72773, 37.18464], [-121.72517, 37.1823], [-121.72766, 37.18056], [-121.73013, 37.18296]]], [[[-121.73265, 37.18541], [-121.72889, 37.18806], [-121.72867, 37.18784], [-121.72637, 37.18574], [-121.73022, 37.18304], [-121.73265, 37.18541]]]]} | No Public Access 3 | 47807 | Fisher's Bend | 31689 | 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 | 62.337 | Fisher's Bend | 0 | None 694 | ||
14467 | 14467 | 14466 | {"type": "MultiPolygon", "coordinates": [[[[-121.51145, 36.97628], [-121.51125, 36.97653], [-121.51022, 36.97714], [-121.50969, 36.97749], [-121.50854, 36.97814], [-121.50827, 36.97783], [-121.50164, 36.97192], [-121.50224, 36.97069], [-121.50436, 36.96803], [-121.50527, 36.96437], [-121.50559, 36.96399], [-121.50735, 36.96397], [-121.50736, 36.96412], [-121.50781, 36.96429], [-121.50792, 36.96462], [-121.50787, 36.96464], [-121.50791, 36.96477], [-121.50819, 36.96521], [-121.50959, 36.96942], [-121.50992, 36.9707], [-121.50987, 36.97071], [-121.5099, 36.97084], [-121.50999, 36.97108], [-121.51089, 36.9744], [-121.51085, 36.97443], [-121.51087, 36.97456], [-121.51099, 36.97479], [-121.51125, 36.97585], [-121.51139, 36.9762], [-121.51145, 36.97628]]], [[[-121.51838, 36.98175], [-121.51303, 36.98347], [-121.51084, 36.98089], [-121.50895, 36.97864], [-121.50868, 36.97829], [-121.51046, 36.97728], [-121.51053, 36.97734], [-121.51185, 36.97658], [-121.51223, 36.97678], [-121.51264, 36.97693], [-121.51268, 36.97693], [-121.51272, 36.97686], [-121.5153, 36.97748], [-121.51531, 36.97751], [-121.51577, 36.97761], [-121.51604, 36.9777], [-121.51604, 36.97773], [-121.51719, 36.97823], [-121.51745, 36.97836], [-121.51781, 36.9786], [-121.51818, 36.97894], [-121.51667, 36.9798], [-121.51838, 36.98175]]], [[[-121.51521, 36.97653], [-121.51301, 36.97603], [-121.51292, 36.97602], [-121.51301, 36.97581], [-121.51416, 36.97523], [-121.51467, 36.97495], [-121.51516, 36.97605], [-121.51521, 36.97653]]]]} | No Public Access 3 | 47085 | Pajaro River Agricultural Preserve | 30739 | 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 | 283.552 | Pajaro River Agricultural Preserve | 0 | Local Conservation Area 4 | 2 |
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 | |
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 |
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]);