superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 128 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9976 | 9976 | 9975 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.0495, 36.9493], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.0498, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | Stockton Avenue Beach | 25857 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.139 | Stockton Avenue Beach | |||
7806 | 7806 | 7805 | {"type": "Polygon", "coordinates": [[[-122.18624, 37.13506], [-122.18623, 37.13512], [-122.18606, 37.13501], [-122.18556, 37.13484], [-122.18456, 37.13439], [-122.18391, 37.13379], [-122.18339, 37.13353], [-122.18225, 37.13281], [-122.18232, 37.13094], [-122.1818, 37.1305], [-122.18216, 37.13004], [-122.18218, 37.12981], [-122.17623, 37.13003], [-122.17622, 37.13004], [-122.17628, 37.13022], [-122.17015, 37.13295], [-122.16845, 37.13183], [-122.16708, 37.13008], [-122.16652, 37.12959], [-122.1658, 37.12917], [-122.16478, 37.12861], [-122.16458, 37.12846], [-122.1644, 37.12829], [-122.16522, 37.12841], [-122.17376, 37.12442], [-122.17542, 37.12787], [-122.17618, 37.12993], [-122.18257, 37.1297], [-122.18258, 37.12968], [-122.18248, 37.12937], [-122.18309, 37.12927], [-122.18335, 37.13025], [-122.18278, 37.13035], [-122.18261, 37.1298], [-122.18228, 37.12981], [-122.18223, 37.13005], [-122.1819, 37.13048], [-122.18236, 37.1309], [-122.18229, 37.13277], [-122.18343, 37.13349], [-122.18395, 37.13375], [-122.18461, 37.13435], [-122.18557, 37.13479], [-122.1861, 37.13497], [-122.18624, 37.13506]]]} | Open Access 1 | Other State 38 | 23261 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 130.86 | Other State 38 | |||
3451 | 3451 | 3450 | {"type": "Polygon", "coordinates": [[[-122.21602, 37.02342], [-122.21509, 37.02378], [-122.2149, 37.02335], [-122.21472, 37.02237], [-122.21561, 37.02182], [-122.21602, 37.02342]]]} | Open Access 1 | Davenport Landing Beach | 17938 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.923 | Davenport Landing Beach | |||
7800 | 7800 | 7799 | {"type": "Polygon", "coordinates": [[[-122.82002, 41.67891], [-122.82001, 41.68248], [-122.81502, 41.6825], [-122.815, 41.67891], [-122.82002, 41.67891]]]} | Open Access 1 | Other State 17 | 23253 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 40.982 | Other State 17 | |||
7801 | 7801 | 7800 | {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62683, 40.48844], [-123.62684, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} | Open Access 1 | Other State 18 | 23254 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.877 | Other State 18 | |||
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} | Open Access 1 | Other State 11 | 23251 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.561 | Other State 11 | |||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} | Open Access 1 | Other State 14 | 23252 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.203 | Other State 14 | |||
7810 | 7810 | 7809 | {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} | Open Access 1 | Other State 43 | 23264 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.359 | Other State 43 | |||
2311 | 2311 | 2310 | {"type": "Polygon", "coordinates": [[[-123.78914, 39.60032], [-123.78909, 39.60039], [-123.78901, 39.60042], [-123.78893, 39.60038], [-123.78886, 39.60033], [-123.78879, 39.60031], [-123.78866, 39.6003], [-123.78856, 39.60026], [-123.78844, 39.60018], [-123.78834, 39.60018], [-123.78826, 39.60026], [-123.78819, 39.6003], [-123.78799, 39.6003], [-123.78758, 39.6002], [-123.78696, 39.59987], [-123.78686, 39.59984], [-123.78683, 39.59987], [-123.78683, 39.59993], [-123.78687, 39.59998], [-123.78716, 39.6002], [-123.78731, 39.60028], [-123.78765, 39.60043], [-123.78813, 39.60054], [-123.78851, 39.60066], [-123.7887, 39.60078], [-123.78876, 39.60087], [-123.78879, 39.60097], [-123.78877, 39.60106], [-123.78877, 39.60116], [-123.78888, 39.60133], [-123.78885, 39.60144], [-123.78878, 39.60153], [-123.78868, 39.60159], [-123.78853, 39.60172], [-123.78852, 39.60182], [-123.78854, 39.60206], [-123.78855, 39.60214], [-123.78865, 39.60234], [-123.78863, 39.60246], [-123.78868, 39.60267], [-123.78884, 39.60288], [-123.78902, 39.60336], [-123.78899, 39.60359], [-123.78901, 39.60374], [-123.78897, 39.60383], [-123.78887, 39.6039], [-123.78886, 39.60397], [-123.78881, 39.60405], [-123.78875, 39.60409], [-123.78869, 39.60409], [-123.78849, 39.60398], [-123.78823, 39.60398], [-123.78815, 39.60399], [-123.78809, 39.60405], [-123.78808, 39.6041], [-123.78815, 39.60419], [-123.78824, 39.60426], [-123.78841, 39.60428], [-123.78862, 39.60447], [-123.78878, 39.60453], [-123.78885, 39.60457], [-123.78888, 39.60464], [-123.78885, 39.60474], [-123.78887, 39.60481], [-123.78899, 39.60493], [-123.78901, 39.60499], [-123.78899, 39.60502], [-123.78887, 39.60501], [-123.78857, 39.605], [-123.78835, 39.60485], [-123.78823, 39.60468], [-123.78812, 39.60458], [-123.78803, 39.60455], [-123.78794, 39.60454], [-123.7878, 39.60459], [-123.78773, 39.60459], [-123.78764, 39.6045], [-123.78759, 39.60441], [-123.78746, 39.60435], [-123.78738, 39.60438], [-123.7873, 39.60447], [-123.78748, 39.60477], [-123.78754, 39.60484], [-123.78758, 39.60493], [-123.78754, 39.60505], [-123.78748, 39.60512], [-123.7874, 39.60514], [-123.7873, 39.60516], [-123.78706, 39.60515], [-123.78697, 39.6052], [-123.78688, 39.60536], [-123.78692, 39.60542], [-123.78701, 39.60546], [-123.78742, 39.60557], [-123.78753, 39.60563], [-123.78758, 39.60569], [-123.78759, 39.60578], [-123.78756, 39.60583], [-123.7875, 39.60588], [-123.78737, 39.60591], [-123.78726, 39.60588], [-123.78716, 39.60582], [-123.78684, 39.60558], [-123.78672, 39.60557], [-123.78664, 39.6056], [-123.78658, 39.60566], [-123.78655, 39.60582], [-123.78655, 39.606], [-123.78661, 39.6061], [-123.7867, 39.60613], [-123.787, 39.60614], [-123.78732, 39.60624], [-123.78751, 39.60643], [-123.78769, 39.60666], [-123.78773, 39.60677], [-123.78774, 39.60685], [-123.78768, 39.60691], [-123.78757, 39.60693], [-123.78753, 39.60696], [-123.78754, 39.60716], [-123.78752, 39.60724], [-123.78748, 39.60732], [-123.78744, 39.60738], [-123.78735, 39.60742], [-123.78732, 39.60747], [-123.78731, 39.60758], [-123.78741, 39.60785], [-123.78741, 39.60804], [-123.78737, 39.60809], [-123.78732, 39.60808], [-123.78712, 39.60812], [-123.78703, 39.60811], [-123.78696, 39.60808], [-123.78684, 39.60796], [-123.7868, 39.60785], [-123.78669, 39.6077], [-123.78642, 39.60752], [-123.78633, 39.6075], [-123.78615, 39.60742], [-123.78583, 39.60733], [-123.78569, 39.60732], [-123.78556, 39.60736], [-123.78548, 39.60742], [-123.78508, 39.60773], [-123.78479, 39.60798], [-123.78434, 39.60832], [-123.78424, 39.60846], [-123.78419, 39.60861], [-123.78417, 39.60876], [-123.78418, 39.60889], [-123.78421, 39.60895], [-123.78435, 39.60912], [-123.78437, 39.60923], [-123.78436, 39.6093], [-123.78432, 39.60938], [-123.78421, 39.60944], [-123.78408, 39.60946], [-123.78378, 39.60944], [-123.78362, 39.60951], [-123.78357, 39.60958], [-123.78352, 39.60975], [-123.78352, 39.61019], [-123.78342, 39.61072], [-123.78334, 39.61094], [-123.78323, 39.61114], [-123.78319, 39.61127], [-123.78332, 39.61139], [-123.78336, 39.61148], [-123.7833, 39.61155], [-123.78312, 39.6116], [-123.78306, 39.61187], [-123.78305, 39.612], [-123.78308, 39.6122], [-123.78304, 39.61251], [-123.78301, 39.61276], [-123.78294, 39.61297], [-123.78273, 39.61326], [-123.78247, 39.6134], [-123.78232, 39.61346], [-123.78227, 39.6135], [-123.78229, 39.61359], [-123.78279, 39.61404], [-123.78284, 39.61419], [-123.78283, 39.61432], [-123.78272, 39.61469], [-123.78262, 39.6149], [-123.78262, 39.61509], [-123.78267, 39.61527], [-123.78273, 39.61536], [-123.78271, 39.61559], [-123.78277, 39.61572], [-123.78277, 39.61589], [-123.78284, 39.61602], [-123.78286, 39.61619], [-123.78292, 39.61639], [-123.78294, 39.61654], [-123.78305, 39.61676], [-123.78306, 39.61699], [-123.78309, 39.61715], [-123.78316, 39.61734], [-123.78319, 39.61758], [-123.78319, 39.61772], [-123.78317, 39.61782], [-123.78301, 39.61813], [-123.7829, 39.61874], [-123.78288, 39.61922], [-123.78289, 39.62014], [-123.78285, 39.62055], [-123.78281, 39.62072], [-123.78282, 39.6209], [-123.78279, 39.62116], [-123.78269, 39.62162], [-123.78271, 39.62177], [-123.78275, 39.62186], [-123.7828, 39.62195], [-123.78303, 39.62212], [-123.78303, 39.62218], [-123.783, 39.62225], [-123.78295, 39.62229], [-123.78291, 39.62236], [-123.78292, 39.62243], [-123.78296, 39.62254], [-123.78022, 39.62297], [-123.77935, 39.62148], [-123.78008, 39.61855], [-123.7808, 39.61595], [-123.78127, 39.61553], [-123.7816, 39.61501], [-123.7817, 39.61484], [-123.78175, 39.61455], [-123.78174, 39.61444], [-123.78169, 39.61428], [-123.78163, 39.61417], [-123.78151, 39.61404], [-123.78132, 39.61392], [-123.78088, 39.61372], [-123.78054, 39.61359], [-123.78035, 39.61346], [-123.77992, 39.61323], [-123.7796, 39.61312], [-123.77852, 39.61287], [-123.77826, 39.61277], [-123.77812, 39.61269], [-123.77804, 39.61261], [-123.77802, 39.61253], [-123.77807, 39.61242], [-123.77813, 39.61236], [-123.77825, 39.61231], [-123.77841, 39.61229], [-123.77861, 39.61229], [-123.77904, 39.61238], [-123.77934, 39.61249], [-123.7797, 39.61253], [-123.78031, 39.61253], [-123.78113, 39.61271], [-123.78157, 39.61272], [-123.78181, 39.61271], [-123.78197, 39.61267], [-123.78207, 39.61262], [-123.78215, 39.6124], [-123.78214, 39.61205], [-123.78215, 39.61171], [-123.78234, 39.6113], [-123.78241, 39.61112], [-123.78249, 39.61081], [-123.78251, 39.61065], [-123.78252, 39.61052], [-123.78244, 39.60967], [-123.7825, 39.60951], [-123.78262, 39.60928], [-123.78275, 39.60909], [-123.78284, 39.60885], [-123.78283, 39.60865], [-123.78277, 39.60849], [-123.78266, 39.6083], [-123.78259, 39.60812], [-123.78256, 39.60801], [-123.78257, 39.60792], [-123.78265, 39.60772], [-123.78271, 39.60762], [-123.7828, 39.60751], [-123.78293, 39.6074], [-123.78305, 39.60735], [-123.78336, 39.6073], [-123.78353, 39.60725], [-123.78376, 39.60707], [-123.78397, 39.60671], [-123.78415, 39.60631], [-123.7843, 39.60588], [-123.78474, 39.60446], [-123.78512, 39.60357], [-123.78527, 39.60307], [-123.78551, 39.60207], [-123.78562, 39.60142], [-123.7853, 39.60079], [-123.78332, 39.59728], [-123.78196, 39.59512], [-123.78217, 39.595], [-123.78141, 39.59386], [-123.78407, 39.59295], [-123.78409, 39.59298], [-123.78415, 39.59301], [-123.78433, 39.59307], [-123.7845, 39.59317], [-123.78463, 39.59332], [-123.78477, 39.59353], [-123.78477, 39.59358], [-123.78473, 39.59363], [-123.78465, 39.59364], [-123.78454, 39.59363], [-123.78442, 39.5936], [-123.78422, 39.59342], [-123.78412, 39.59338], [-123.78403, 39.59338], [-123.78392, 39.59341], [-123.78381, 39.5935], [-123.78378, 39.59356], [-123.7838, 39.59363], [-123.78379, 39.5937], [-123.78384, 39.59376], [-123.78398, 39.5938], [-123.78423, 39.59409], [-123.7843, 39.59413], [-123.78455, 39.59431], [-123.78467, 39.59435], [-123.78475, 39.59431], [-123.78481, 39.59424], [-123.7849, 39.59429], [-123.78502, 39.59442], [-123.78503, 39.59446], [-123.78502, 39.59451], [-123.78497, 39.59457], [-123.78497, 39.59463], [-123.78503, 39.59471], [-123.78527, 39.59472], [-123.78558, 39.59483], [-123.78582, 39.59488], [-123.78591, 39.59492], [-123.78594, 39.59499], [-123.78606, 39.59508], [-123.78614, 39.59519], [-123.78645, 39.59554], [-123.78644, 39.59563], [-123.7867, 39.59601], [-123.78683, 39.59614], [-123.78709, 39.59646], [-123.7873, 39.59683], [-123.78749, 39.59709], [-123.78761, 39.59738], [-123.78767, 39.59747], [-123.78759, 39.59773], [-123.78773, 39.5978], [-123.78824, 39.59798], [-123.78829, 39.59805], [-123.78825, 39.59812], [-123.78819, 39.59814], [-123.788, 39.59812], [-123.78788, 39.59807], [-123.78773, 39.59805], [-123.78762, 39.59813], [-123.78751, 39.59817], [-123.78744, 39.59822], [-123.78745, 39.59829], [-123.78753, 39.59836], [-123.78763, 39.59838], [-123.78771, 39.59844], [-123.78789, 39.59864], [-123.78801, 39.59873], [-123.78813, 39.5988], [-123.78824, 39.59893], [-123.78848, 39.59913], [-123.78858, 39.59919], [-123.78863, 39.59928], [-123.78861, 39.59934], [-123.78853, 39.59938], [-123.78841, 39.59939], [-123.78827, 39.59936], [-123.78808, 39.59928], [-123.7877, 39.59909], [-123.78755, 39.59907], [-123.78754, 39.59912], [-123.78758, 39.59918], [-123.78764, 39.59924], [-123.7879, 39.59938], [-123.7882, 39.59953], [-123.78848, 39.5996], [-123.78863, 39.59966], [-123.78898, 39.59995], [-123.78907, 39.60007], [-123.78913, 39.60022], [-123.78914, 39.60032]]]} | Open Access 1 | Bruhel Point | 16449 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 197.475 | Bruhel Point | |||
7809 | 7809 | 7808 | {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83744, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83527, 40.46801], [-123.83421, 40.46791], [-123.83495, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46639], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} | Open Access 1 | Other State 4 | 23263 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.858 | Other State 4 | |||
7805 | 7805 | 7804 | {"type": "Polygon", "coordinates": [[[-123.84302, 40.46142], [-123.84302, 40.4623], [-123.84241, 40.46266], [-123.84217, 40.46286], [-123.84184, 40.46272], [-123.84171, 40.46257], [-123.84194, 40.46247], [-123.84193, 40.46233], [-123.84169, 40.46226], [-123.84173, 40.46216], [-123.84179, 40.46206], [-123.84179, 40.46192], [-123.84166, 40.46178], [-123.84133, 40.46157], [-123.84123, 40.46146], [-123.84168, 40.46116], [-123.8422, 40.4614], [-123.84302, 40.46142]]]} | Open Access 1 | Other State 37 | 23260 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.071 | Other State 37 | |||
7811 | 7811 | 7810 | {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} | Open Access 1 | Other State 5 | 23265 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.303 | Other State 5 | |||
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} | Unknown Access 4 | Clam Beach Ponds | 30554 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.52 | Clam Beach Ponds |
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]);