superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 3 and YR_EST = 1999
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7478 | 7478 | 7477 | {"type": "Polygon", "coordinates": [[[-122.21545, 38.1406], [-122.21382, 38.14057], [-122.21368, 38.14204], [-122.21291, 38.14191], [-122.21264, 38.14192], [-122.21255, 38.14225], [-122.21271, 38.14271], [-122.2134, 38.14303], [-122.21288, 38.14606], [-122.20837, 38.14896], [-122.20598, 38.14589], [-122.19995, 38.14373], [-122.19935, 38.14304], [-122.19853, 38.14245], [-122.19668, 38.14098], [-122.19475, 38.13958], [-122.19412, 38.13869], [-122.19448, 38.13723], [-122.19423, 38.13573], [-122.19408, 38.13498], [-122.19238, 38.13178], [-122.19208, 38.13161], [-122.19179, 38.13148], [-122.19139, 38.13124], [-122.19095, 38.13094], [-122.19068, 38.13063], [-122.19033, 38.13018], [-122.18977, 38.1297], [-122.18938, 38.12931], [-122.18901, 38.1289], [-122.18861, 38.12857], [-122.18982, 38.12792], [-122.19073, 38.12752], [-122.19077, 38.12764], [-122.19086, 38.12773], [-122.19143, 38.12808], [-122.19189, 38.12829], [-122.192, 38.12829], [-122.19217, 38.12822], [-122.19363, 38.13011], [-122.19405, 38.13058], [-122.19453, 38.13106], [-122.19501, 38.13153], [-122.19554, 38.132], [-122.19607, 38.1323], [-122.1969, 38.13267], [-122.19794, 38.13308], [-122.19855, 38.13337], [-122.19901, 38.13361], [-122.19996, 38.1342], [-122.20165, 38.13531], [-122.20208, 38.13557], [-122.20272, 38.13596], [-122.20326, 38.13619], [-122.20352, 38.13629], [-122.20489, 38.13665], [-122.20612, 38.13692], [-122.20724, 38.13706], [-122.20548, 38.13798], [-122.20544, 38.13823], [-122.20762, 38.13847], [-122.20991, 38.13874], [-122.20972, 38.1398], [-122.20974, 38.13982], [-122.21088, 38.13993], [-122.21174, 38.14005], [-122.21297, 38.14019], [-122.2131, 38.13937], [-122.21532, 38.13962], [-122.21525, 38.14005], [-122.21545, 38.1406]]]} | No Public Access 3 | Northgate | 22870 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 435.524 | Northgate | 1999 | |
8966 | 8966 | 8965 | {"type": "MultiPolygon", "coordinates": [[[[-122.49991, 37.92691], [-122.49942, 37.92654], [-122.49818, 37.92572], [-122.49764, 37.92506], [-122.49509, 37.9251], [-122.49504, 37.92293], [-122.49312, 37.92144], [-122.49266, 37.92106], [-122.49265, 37.92043], [-122.49443, 37.92114], [-122.4948, 37.92124], [-122.49531, 37.9213], [-122.49545, 37.92131], [-122.49582, 37.92128], [-122.49619, 37.92123], [-122.49656, 37.92115], [-122.49691, 37.92104], [-122.4973, 37.92089], [-122.49736, 37.92428], [-122.49981, 37.92613], [-122.49991, 37.92691]]], [[[-122.50704, 37.92484], [-122.50678, 37.92501], [-122.50662, 37.925], [-122.50631, 37.92523], [-122.5058, 37.92533], [-122.50532, 37.92522], [-122.50562, 37.92509], [-122.50587, 37.92491], [-122.50632, 37.9244], [-122.50704, 37.92484]]]]} | No Public Access 3 | Triangle Marsh | 26529 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 33.892 | Triangle Marsh | 1999 | |
14714 | 14714 | 14713 | {"type": "Polygon", "coordinates": [[[-121.54022, 37.10117], [-121.538, 37.10111], [-121.49069, 37.10122], [-121.49064, 37.11611], [-121.48137, 37.11606], [-121.48129, 37.11235], [-121.48601, 37.11232], [-121.48598, 37.10493], [-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.10003], [-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.51182, 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.51837, 37.08052], [-121.51899, 37.08061], [-121.51934, 37.08044], [-121.51975, 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.52186, 37.08147], [-121.52223, 37.08136], [-121.52307, 37.0817], [-121.52435, 37.08246], [-121.5245, 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.52713, 37.08554], [-121.52731, 37.08556], [-121.52732, 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.53146, 37.08895], [-121.53159, 37.08934], [-121.53196, 37.09028], [-121.53223, 37.09071], [-121.53232, 37.09076], [-121.53234, 37.09078], [-121.53303, 37.0911], [-121.53316, 37.09136], [-121.53314, 37.09154], [-121.53305, 37.09136], [-121.53303, 37.09136], [-121.53301, 37.09179], [-121.53296, 37.09201], [-121.53267, 37.09224], [-121.53277, 37.09228], [-121.53275, 37.0923], [-121.53276, 37.09231], [-121.53298, 37.09241], [-121.53298, 37.09282], [-121.53337, 37.09333], [-121.53351, 37.09353], [-121.53351, 37.09375], [-121.53335, 37.09405], [-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.53904, 37.10023], [-121.53933, 37.10004], [-121.53951, 37.1001], [-121.53994, 37.1006], [-121.54022, 37.10117]]]} | No Public Access 3 | Palassou Ridge Open Space Preserve | http://www.openspaceauthority.org | 23327 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 3513.427 | Palassou Ridge OSP | 1999 |
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]);