units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 3, DES_TP = 4 and PARK_URL = "http://www.openspaceauthority.org"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- Local Conservation Area · 6 ✖
ACCESS_TYP 1
- No Public Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13125 | 13125 | 13124 | {"type": "MultiPolygon", "coordinates": [[[[-121.66883, 37.12359], [-121.66674, 37.12357], [-121.66651, 37.12332], [-121.66627, 37.12302], [-121.66598, 37.12252], [-121.66553, 37.12198], [-121.6661, 37.12198], [-121.66632, 37.12234], [-121.66624, 37.12237], [-121.66631, 37.12246], [-121.66637, 37.12244], [-121.66821, 37.12247], [-121.66883, 37.12359]]], [[[-121.67204, 37.11703], [-121.66846, 37.11719], [-121.6659, 37.11598], [-121.66581, 37.1145], [-121.67047, 37.11431], [-121.67204, 37.11703]]]]} | No Public Access 3 | 35041 | El Toro Open Space Preserve | 18545 | 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 | 39.197 | El Toro OSP | 2010 | Local Conservation Area 4 | 2 |
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 |
14532 | 14532 | 14531 | {"type": "Polygon", "coordinates": [[[-121.86443, 37.2402], [-121.86348, 37.24014], [-121.86302, 37.23952], [-121.86246, 37.23953], [-121.8623, 37.23942], [-121.86313, 37.23732], [-121.86382, 37.23753], [-121.86443, 37.2402]]]} | No Public Access 3 | 47776 | Santa Teresa Foothills Open Space Preserve | 31575 | 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 | 8.63 | Santa Teresa Foothills OSP | 2016 | Local Conservation Area 4 | 2 |
15889 | 15889 | 15888 | {"type": "MultiPolygon", "coordinates": [[[[-121.81224, 37.1252], [-121.80327, 37.1255], [-121.80324, 37.12146], [-121.81218, 37.12145], [-121.81224, 37.1252]]], [[[-121.82981, 37.11414], [-121.8211, 37.1142], [-121.82099, 37.10693], [-121.82969, 37.10685], [-121.82981, 37.11414]]], [[[-121.83943, 37.12503], [-121.82128, 37.12507], [-121.82116, 37.11783], [-121.83035, 37.11782], [-121.83032, 37.11413], [-121.83482, 37.1141], [-121.83487, 37.119], [-121.83376, 37.11799], [-121.83248, 37.11871], [-121.83399, 37.12056], [-121.83488, 37.12053], [-121.8349, 37.12136], [-121.83939, 37.12134], [-121.83943, 37.12503]]], [[[-121.83954, 37.1359], [-121.83054, 37.13592], [-121.83047, 37.12867], [-121.83947, 37.12865], [-121.83954, 37.1359]]]]} | No Public Access 3 | 47765 | Mount Chual Open Space Preserve | 31570 | 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 | 711.546 | Mount Chual OSP | 2002 | Local Conservation Area 4 | 2 |
15901 | 15901 | 15900 | {"type": "MultiPolygon", "coordinates": [[[[-121.79163, 37.13104], [-121.78587, 37.1282], [-121.78526, 37.1279], [-121.79161, 37.12787], [-121.79163, 37.13104]]], [[[-121.79695, 37.11703], [-121.79678, 37.11735], [-121.79688, 37.11795], [-121.79666, 37.11821], [-121.7966, 37.11863], [-121.79641, 37.11911], [-121.79628, 37.1195], [-121.79608, 37.11974], [-121.79608, 37.12065], [-121.79686, 37.12065], [-121.79686, 37.12087], [-121.79642, 37.12086], [-121.79621, 37.12087], [-121.79591, 37.12093], [-121.79571, 37.121], [-121.7957, 37.12065], [-121.78705, 37.12069], [-121.787, 37.11351], [-121.79607, 37.11347], [-121.79609, 37.11703], [-121.79695, 37.11703]]], [[[-121.82152, 37.1465], [-121.80335, 37.13681], [-121.80332, 37.13293], [-121.82138, 37.13218], [-121.82152, 37.1465]]]]} | No Public Access 3 | 47775 | Rancho Cañada del Oro Open Space Preserve | 31571 | 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 | 588.021 | Rancho Cañada del Oro OSP | 2000 | Local Conservation Area 4 | 2 |
15914 | 15914 | 15913 | {"type": "Polygon", "coordinates": [[[-121.54022, 37.10117], [-121.538, 37.10111], [-121.49068, 37.10122], [-121.49064, 37.11611], [-121.48137, 37.11606], [-121.48129, 37.11235], [-121.48601, 37.11233], [-121.48598, 37.10492], [-121.48122, 37.10492], [-121.48114, 37.10124], [-121.49047, 37.10114], [-121.49053, 37.08616], [-121.47318, 37.08659], [-121.47379, 37.10131], [-121.47274, 37.10129], [-121.47269, 37.10112], [-121.47268, 37.10088], [-121.47271, 37.10068], [-121.47279, 37.10044], [-121.473, 37.10002], [-121.47298, 37.09996], [-121.47264, 37.09967], [-121.47244, 37.09944], [-121.47255, 37.09914], [-121.47178, 37.09842], [-121.47113, 37.09796], [-121.47065, 37.0974], [-121.47022, 37.09666], [-121.47013, 37.09639], [-121.47001, 37.09625], [-121.46988, 37.096], [-121.46921, 37.09514], [-121.46881, 37.09434], [-121.46853, 37.09365], [-121.46819, 37.09296], [-121.46807, 37.09267], [-121.46782, 37.09165], [-121.46781, 37.09156], [-121.46784, 37.09128], [-121.46895, 37.09058], [-121.46983, 37.08993], [-121.47006, 37.0891], [-121.46931, 37.0884], [-121.46845, 37.08802], [-121.46798, 37.08757], [-121.46754, 37.08685], [-121.46744, 37.08654], [-121.46735, 37.0861], [-121.46736, 37.0856], [-121.4675, 37.08535], [-121.46792, 37.08508], [-121.46845, 37.08492], [-121.46897, 37.08468], [-121.4695, 37.08424], [-121.47002, 37.08394], [-121.47011, 37.08316], [-121.46995, 37.08239], [-121.46965, 37.08191], [-121.46938, 37.08141], [-121.46873, 37.08104], [-121.46815, 37.08056], [-121.46789, 37.07992], [-121.46732, 37.07902], [-121.46736, 37.07844], [-121.46751, 37.07745], [-121.46796, 37.07629], [-121.46825, 37.07587], [-121.46861, 37.07529], [-121.46903, 37.07488], [-121.46963, 37.07442], [-121.4704, 37.07368], [-121.47046, 37.0736], [-121.47164, 37.07297], [-121.47305, 37.07276], [-121.47303, 37.07207], [-121.47465, 37.07247], [-121.47652, 37.07246], [-121.47738, 37.07224], [-121.4785, 37.07218], [-121.47966, 37.07226], [-121.48131, 37.07244], [-121.48231, 37.07304], [-121.48321, 37.07344], [-121.48405, 37.07339], [-121.48534, 37.07258], [-121.48659, 37.07235], [-121.48786, 37.07187], [-121.48955, 37.07201], [-121.49016, 37.07295], [-121.49009, 37.07389], [-121.48965, 37.07477], [-121.48962, 37.07528], [-121.49001, 37.07567], [-121.49234, 37.07702], [-121.49362, 37.0774], [-121.49454, 37.07746], [-121.4955, 37.07721], [-121.49655, 37.0769], [-121.49696, 37.07666], [-121.49793, 37.07595], [-121.49888, 37.0741], [-121.4997, 37.07294], [-121.50026, 37.0725], [-121.50102, 37.07243], [-121.50262, 37.0726], [-121.50339, 37.07284], [-121.50501, 37.07354], [-121.50816, 37.07481], [-121.50938, 37.0752], [-121.51047, 37.07557], [-121.51194, 37.07595], [-121.51198, 37.07601], [-121.51181, 37.07596], [-121.5118, 37.07597], [-121.51252, 37.07706], [-121.5127, 37.0771], [-121.51272, 37.07712], [-121.51356, 37.07728], [-121.51376, 37.078], [-121.51425, 37.07815], [-121.51518, 37.07847], [-121.51601, 37.07901], [-121.51701, 37.07933], [-121.51773, 37.07972], [-121.51796, 37.07993], [-121.51818, 37.08047], [-121.51835, 37.08049], [-121.51836, 37.08052], [-121.51899, 37.08061], [-121.51934, 37.08044], [-121.51976, 37.08045], [-121.52028, 37.08062], [-121.52092, 37.08097], [-121.52103, 37.08099], [-121.5211, 37.08103], [-121.5214, 37.08107], [-121.52185, 37.08127], [-121.52185, 37.08148], [-121.52223, 37.08136], [-121.52307, 37.0817], [-121.52435, 37.08246], [-121.52449, 37.08308], [-121.52525, 37.08289], [-121.52575, 37.0833], [-121.52611, 37.08403], [-121.52643, 37.08437], [-121.52675, 37.0849], [-121.52722, 37.08528], [-121.52712, 37.08554], [-121.52731, 37.08556], [-121.52731, 37.0856], [-121.52757, 37.08562], [-121.52769, 37.08568], [-121.52802, 37.086], [-121.52838, 37.08639], [-121.52893, 37.08714], [-121.52967, 37.0879], [-121.53092, 37.08829], [-121.53099, 37.08867], [-121.53123, 37.0888], [-121.53146, 37.08895], [-121.53159, 37.08934], [-121.53196, 37.09028], [-121.53223, 37.09072], [-121.53232, 37.09076], [-121.53234, 37.09078], [-121.53303, 37.0911], [-121.53316, 37.09136], [-121.53314, 37.09154], [-121.53305, 37.09135], [-121.53303, 37.09135], [-121.53301, 37.09179], [-121.53296, 37.09201], [-121.53266, 37.09224], [-121.53277, 37.09228], [-121.53275, 37.0923], [-121.53275, 37.09231], [-121.53298, 37.09241], [-121.53298, 37.09282], [-121.53337, 37.09333], [-121.53351, 37.09353], [-121.53351, 37.09375], [-121.53334, 37.09406], [-121.53381, 37.09407], [-121.53419, 37.09431], [-121.53434, 37.0946], [-121.53505, 37.09537], [-121.53525, 37.09589], [-121.53553, 37.09625], [-121.53617, 37.09665], [-121.53607, 37.09701], [-121.53654, 37.09701], [-121.53679, 37.09751], [-121.53727, 37.09779], [-121.53793, 37.09846], [-121.53831, 37.09907], [-121.5386, 37.09963], [-121.53884, 37.09978], [-121.53905, 37.10024], [-121.53933, 37.10004], [-121.53951, 37.1001], [-121.53994, 37.1006], [-121.54022, 37.10117]]]} | No Public Access 3 | 17271 | Palassou Ridge Open Space Preserve | 23327 | 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 | 3512.772 | Palassou Ridge OSP | 1999 | 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]);