superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where YR_EST = 1944
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
379 | 379 | 378 | {"type": "MultiPolygon", "coordinates": [[[[-118.51765, 34.05203], [-118.51669, 34.05236], [-118.51659, 34.05249], [-118.51669, 34.05273], [-118.51712, 34.05328], [-118.5174, 34.05381], [-118.5175, 34.05393], [-118.51779, 34.0542], [-118.51784, 34.05432], [-118.51786, 34.05445], [-118.51781, 34.05461], [-118.51772, 34.05472], [-118.51761, 34.0548], [-118.51738, 34.05489], [-118.51727, 34.05498], [-118.51718, 34.0551], [-118.51713, 34.05534], [-118.51707, 34.05546], [-118.51697, 34.05555], [-118.51669, 34.05573], [-118.51662, 34.05582], [-118.51658, 34.05589], [-118.51655, 34.05602], [-118.51656, 34.05629], [-118.51662, 34.05652], [-118.51662, 34.05666], [-118.51643, 34.05721], [-118.51641, 34.0573], [-118.51642, 34.05742], [-118.51651, 34.05759], [-118.51653, 34.05768], [-118.51654, 34.05794], [-118.51649, 34.05809], [-118.51606, 34.05885], [-118.51605, 34.05896], [-118.51608, 34.0591], [-118.51609, 34.0592], [-118.51602, 34.0595], [-118.51553, 34.05986], [-118.51539, 34.06017], [-118.51513, 34.0603], [-118.51478, 34.06051], [-118.51459, 34.06072], [-118.51336, 34.06112], [-118.5124, 34.06122], [-118.51233, 34.06132], [-118.51243, 34.06155], [-118.51256, 34.06173], [-118.51308, 34.06185], [-118.51325, 34.06201], [-118.51351, 34.06222], [-118.51316, 34.06215], [-118.51285, 34.06202], [-118.51204, 34.06199], [-118.51204, 34.06194], [-118.51202, 34.06188], [-118.51194, 34.0618], [-118.51115, 34.06158], [-118.51041, 34.0612], [-118.51024, 34.06109], [-118.50985, 34.06073], [-118.50962, 34.05985], [-118.50951, 34.05958], [-118.50975, 34.05935], [-118.50965, 34.05916], [-118.50935, 34.05875], [-118.50922, 34.05818], [-118.50928, 34.05781], [-118.50895, 34.05766], [-118.50891, 34.05705], [-118.50865, 34.05664], [-118.5082, 34.05629], [-118.50823, 34.05602], [-118.5084, 34.05526], [-118.50846, 34.05527], [-118.50874, 34.05499], [-118.50854, 34.05468], [-118.50854, 34.05463], [-118.50839, 34.05443], [-118.50841, 34.0543], [-118.50812, 34.0541], [-118.50803, 34.05408], [-118.50803, 34.05401], [-118.50806, 34.054], [-118.50817, 34.0538], [-118.50841, 34.05361], [-118.50853, 34.05347], [-118.50858, 34.05338], [-118.5088, 34.05281], [-118.50887, 34.0527], [-118.50897, 34.05258], [-118.50915, 34.05245], [-118.50975, 34.05221], [-118.51002, 34.05206], [-118.51014, 34.05197], [-118.51028, 34.05183], [-118.51049, 34.05156], [-118.51067, 34.05138], [-118.51072, 34.05126], [-118.51094, 34.05121], [-118.51119, 34.0511], [-118.51139, 34.05096], [-118.51153, 34.05082], [-118.51154, 34.05079], [-118.51151, 34.05078], [-118.51159, 34.05066], [-118.51164, 34.05053], [-118.51191, 34.04929], [-118.51197, 34.04912], [-118.51207, 34.04895], [-118.51234, 34.04865], [-118.51243, 34.04852], [-118.51305, 34.04754], [-118.51312, 34.04739], [-118.51318, 34.04722], [-118.51321, 34.04722], [-118.51323, 34.04726], [-118.51324, 34.04736], [-118.51301, 34.04769], [-118.51294, 34.04783], [-118.51288, 34.04802], [-118.51284, 34.0483], [-118.51279, 34.0484], [-118.51268, 34.04852], [-118.5122, 34.04889], [-118.51214, 34.04895], [-118.51211, 34.04902], [-118.51209, 34.0491], [-118.5121, 34.04918], [-118.51222, 34.04951], [-118.51224, 34.0497], [-118.51222, 34.04984], [-118.512, 34.05045], [-118.51199, 34.05054], [-118.51202, 34.05061], [-118.51206, 34.05066], [-118.51218, 34.05072], [-118.51234, 34.05073], [-118.51241, 34.0507], [-118.51248, 34.05064], [-118.51262, 34.05047], [-118.51271, 34.05029], [-118.51277, 34.05001], [-118.5128, 34.04957], [-118.51283, 34.04953], [-118.51288, 34.04952], [-118.51293, 34.04952], [-118.51297, 34.04954], [-118.51299, 34.04961], [-118.51292, 34.04983], [-118.51291, 34.04992], [-118.51294, 34.0502], [-118.51295, 34.05033], [-118.51293, 34.05043], [-118.51285, 34.05065], [-118.51283, 34.05076], [-118.51283, 34.05088], [-118.51285, 34.05098], [-118.51291, 34.05111], [-118.51331, 34.05181], [-118.5136, 34.05214], [-118.51394, 34.05271], [-118.51486, 34.05252], [-118.51743, 34.05151], [-118.51765, 34.05203]]], [[[-118.51383, 34.0476], [-118.51349, 34.04814], [-118.51345, 34.04862], [-118.51307, 34.04873], [-118.51236, 34.04911], [-118.51235, 34.04921], [-118.51237, 34.04932], [-118.51262, 34.04983], [-118.51265, 34.04994], [-118.51265, 34.05002], [-118.51258, 34.0503], [-118.51248, 34.05046], [-118.5124, 34.05057], [-118.51234, 34.05061], [-118.51225, 34.05062], [-118.51219, 34.0506], [-118.51213, 34.05055], [-118.51212, 34.05048], [-118.51233, 34.04989], [-118.51237, 34.04968], [-118.51234, 34.0495], [-118.51222, 34.04916], [-118.51222, 34.04908], [-118.51224, 34.04903], [-118.51229, 34.04896], [-118.51278, 34.04859], [-118.51288, 34.04848], [-118.51296, 34.04833], [-118.51301, 34.04802], [-118.51308, 34.04782], [-118.51317, 34.04767], [-118.51332, 34.04746], [-118.51337, 34.04735], [-118.51383, 34.0476]]]]} | Open Access 1 | Will Rogers State Historic Park | http://www.parks.ca.gov/?page_id=626 | 1790 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 187.885 | Will Rogers SHP | 1944 |
827 | 827 | 826 | {"type": "Polygon", "coordinates": [[[-122.1276, 37.47289], [-122.1263, 37.47477], [-122.12365, 37.4757], [-122.12364, 37.47441], [-122.12355, 37.47442], [-122.12353, 37.47435], [-122.12325, 37.47442], [-122.12322, 37.47422], [-122.12319, 37.47247], [-122.1217, 37.47234], [-122.12044, 37.47011], [-122.11894, 37.46936], [-122.1178, 37.46885], [-122.1166, 37.46744], [-122.11616, 37.46674], [-122.11562, 37.46613], [-122.11646, 37.46595], [-122.11656, 37.46588], [-122.11656, 37.46587], [-122.11625, 37.46581], [-122.11519, 37.46611], [-122.11574, 37.46572], [-122.11475, 37.46553], [-122.11433, 37.46476], [-122.11345, 37.46405], [-122.11261, 37.46368], [-122.1113, 37.46352], [-122.1105, 37.46337], [-122.10985, 37.46313], [-122.10952, 37.4632], [-122.10928, 37.46328], [-122.10889, 37.46296], [-122.10834, 37.46278], [-122.10812, 37.46256], [-122.10757, 37.46235], [-122.10736, 37.46233], [-122.10725, 37.46222], [-122.10685, 37.46171], [-122.10649, 37.46131], [-122.10608, 37.46135], [-122.10527, 37.46138], [-122.10402, 37.46218], [-122.10226, 37.4632], [-122.1018, 37.4633], [-122.10126, 37.46319], [-122.10098, 37.46294], [-122.10071, 37.46253], [-122.10066, 37.46145], [-122.10107, 37.45993], [-122.10165, 37.4583], [-122.10191, 37.45772], [-122.1019, 37.45759], [-122.10245, 37.45725], [-122.10271, 37.4567], [-122.10332, 37.4562], [-122.10383, 37.45594], [-122.10514, 37.45586], [-122.10573, 37.45593], [-122.10622, 37.45633], [-122.10628, 37.45633], [-122.10637, 37.45661], [-122.10494, 37.45838], [-122.10545, 37.45869], [-122.1055, 37.45818], [-122.10592, 37.45767], [-122.10678, 37.45759], [-122.10727, 37.457], [-122.10743, 37.45668], [-122.10806, 37.4566], [-122.10853, 37.45618], [-122.10906, 37.45529], [-122.10904, 37.45416], [-122.10883, 37.45339], [-122.10839, 37.45256], [-122.10764, 37.45168], [-122.10639, 37.45119], [-122.10575, 37.45124], [-122.10523, 37.45126], [-122.10522, 37.45157], [-122.10548, 37.45141], [-122.10699, 37.4515], [-122.10783, 37.45239], [-122.10746, 37.45216], [-122.10749, 37.45244], [-122.10764, 37.45269], [-122.10772, 37.45296], [-122.10755, 37.45305], [-122.10702, 37.45306], [-122.10702, 37.45308], [-122.10706, 37.45312], [-122.10692, 37.45311], [-122.10652, 37.45334], [-122.10653, 37.45362], [-122.10665, 37.45429], [-122.10687, 37.45471], [-122.10684, 37.45506], [-122.10633, 37.45524], [-122.10503, 37.45524], [-122.10482, 37.45521], [-122.10412, 37.4552], [-122.10391, 37.45536], [-122.1036, 37.45537], [-122.10316, 37.45548], [-122.10295, 37.4556], [-122.1024, 37.45547], [-122.10235, 37.45543], [-122.10226, 37.45545], [-122.10223, 37.45564], [-122.10214, 37.456], [-122.10156, 37.45642], [-122.10132, 37.45653], [-122.10114, 37.45629], [-122.10094, 37.45616], [-122.10067, 37.45634], [-122.10041, 37.45604], [-122.09929, 37.45514], [-122.09809, 37.45412], [-122.09636, 37.45391], [-122.09434, 37.4535], [-122.09259, 37.45305], [-122.09196, 37.45269], [-122.091, 37.45188], [-122.09012, 37.45011], [-122.09029, 37.44924], [-122.09121, 37.44893], [-122.09042, 37.44854], [-122.0905, 37.44753], [-122.09066, 37.44711], [-122.09103, 37.44667], [-122.09223, 37.4464], [-122.09357, 37.44607], [-122.09397, 37.44551], [-122.09425, 37.4447], [-122.09396, 37.44398], [-122.09305, 37.44337], [-122.09255, 37.4428], [-122.0925, 37.44239], [-122.09285, 37.44131], [-122.09333, 37.44089], [-122.09553, 37.44083], [-122.09715, 37.43923], [-122.09918, 37.43701], [-122.09964, 37.4364], [-122.09969, 37.436], [-122.0998, 37.43564], [-122.0998, 37.4355], [-122.10018, 37.43557], [-122.10019, 37.43555], [-122.10006, 37.4354], [-122.1001, 37.43531], [-122.10106, 37.43533], [-122.10258, 37.43481], [-122.10378, 37.43414], [-122.10433, 37.43342], [-122.10499, 37.43275], [-122.1057, 37.43256], [-122.10844, 37.4359], [-122.10958, 37.43713], [-122.11012, 37.43778], [-122.11126, 37.43851], [-122.11217, 37.43924], [-122.11304, 37.44003], [-122.11303, 37.44006], [-122.11359, 37.44054], [-122.11739, 37.44412], [-122.11749, 37.44449], [-122.11804, 37.44586], [-122.11777, 37.44584], [-122.11711, 37.44586], [-122.11748, 37.44684], [-122.11766, 37.44682], [-122.11759, 37.44731], [-122.11715, 37.44737], [-122.1175, 37.44882], [-122.11718, 37.44923], [-122.11653, 37.44865], [-122.11557, 37.44926], [-122.11545, 37.44916], [-122.11483, 37.44924], [-122.11448, 37.44933], [-122.11407, 37.4498], [-122.11383, 37.45016], [-122.11381, 37.45016], [-122.1138, 37.45022], [-122.10998, 37.45019], [-122.10969, 37.45038], [-122.10901, 37.45087], [-122.10829, 37.45133], [-122.10992, 37.45311], [-122.11009, 37.45376], [-122.1101, 37.45553], [-122.11017, 37.45576], [-122.11022, 37.45576], [-122.11214, 37.45712], [-122.11216, 37.45795], [-122.11225, 37.45803], [-122.11196, 37.45832], [-122.11299, 37.45945], [-122.11389, 37.46038], [-122.11464, 37.46157], [-122.11564, 37.46253], [-122.1163, 37.46273], [-122.11742, 37.46398], [-122.11792, 37.46396], [-122.11832, 37.46353], [-122.11764, 37.46219], [-122.11629, 37.46125], [-122.11517, 37.45988], [-122.11526, 37.45802], [-122.11581, 37.45719], [-122.11601, 37.45604], [-122.11685, 37.45317], [-122.11807, 37.45279], [-122.11917, 37.45274], [-122.12014, 37.45298], [-122.12098, 37.45357], [-122.12209, 37.45477], [-122.12256, 37.45551], [-122.123, 37.45633], [-122.12307, 37.45771], [-122.12408, 37.46084], [-122.12382, 37.46146], [-122.12483, 37.46429], [-122.12594, 37.46698], [-122.1276, 37.47289]]]} | Open Access 1 | Baylands Preserve | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp | 8356 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1505.618 | Baylands Preserve | 1944 |
15286 | 15286 | 15285 | {"type": "Polygon", "coordinates": [[[-123.62389, 39.64708], [-123.6238, 39.64742], [-123.62309, 39.64784], [-123.62253, 39.64744], [-123.62189, 39.64786], [-123.61327, 39.64798], [-123.61378, 39.64766], [-123.61419, 39.64711], [-123.61424, 39.64691], [-123.61469, 39.64626], [-123.61443, 39.6461], [-123.61453, 39.64591], [-123.61541, 39.6462], [-123.61604, 39.64616], [-123.61642, 39.64568], [-123.61611, 39.64514], [-123.61634, 39.64482], [-123.61905, 39.64553], [-123.62042, 39.64618], [-123.62084, 39.64617], [-123.62153, 39.64579], [-123.62214, 39.64578], [-123.62369, 39.64684], [-123.62389, 39.64708]]]} | Open Access 1 | Admiral William Standley State Recreation Area | http://www.parks.ca.gov/?page_id=424 | 1385 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 46.544 | Admiral William Standley SRA | 1944 |
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]);