superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 36 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5177 | 5177 | 5176 | {"type": "Polygon", "coordinates": [[[-121.92087, 36.60896], [-121.92013, 36.60931], [-121.91907, 36.60807], [-121.91942, 36.60787], [-121.91968, 36.60816], [-121.92003, 36.60798], [-121.92087, 36.60896]]]} | Open Access 1 | Hilltop Park | 19988 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 2.833 | Hilltop Park | ||
10813 | 10813 | 10812 | {"type": "Polygon", "coordinates": [[[-121.91374, 36.59667], [-121.91373, 36.5967], [-121.91363, 36.59689], [-121.91356, 36.59709], [-121.91351, 36.59768], [-121.91346, 36.5979], [-121.91319, 36.59851], [-121.91314, 36.59864], [-121.91329, 36.59942], [-121.91326, 36.59957], [-121.91315, 36.59972], [-121.91355, 36.60008], [-121.9107, 36.60216], [-121.90991, 36.60197], [-121.91001, 36.60166], [-121.91, 36.60165], [-121.90665, 36.60085], [-121.90669, 36.60069], [-121.90582, 36.60048], [-121.9059, 36.60027], [-121.90678, 36.60047], [-121.90734, 36.59897], [-121.90784, 36.59962], [-121.90801, 36.59973], [-121.90822, 36.5998], [-121.9084, 36.59981], [-121.90855, 36.59977], [-121.90863, 36.59972], [-121.90888, 36.59949], [-121.909, 36.59943], [-121.9091, 36.59943], [-121.90954, 36.59954], [-121.90976, 36.59956], [-121.91003, 36.59954], [-121.9102, 36.59949], [-121.91026, 36.59946], [-121.9103, 36.59941], [-121.91032, 36.59937], [-121.91033, 36.59932], [-121.91031, 36.59926], [-121.90946, 36.59834], [-121.90931, 36.59759], [-121.91086, 36.5971], [-121.91224, 36.59592], [-121.913, 36.59651], [-121.91369, 36.59663], [-121.91374, 36.59667]]]} | Open Access 1 | Veterans Memorial Park | 27028 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 54.632 | Veterans Memorial Park | ||
3392 | 3392 | 3391 | {"type": "Polygon", "coordinates": [[[-121.91061, 36.60941], [-121.91005, 36.60972], [-121.90966, 36.60927], [-121.91022, 36.60896], [-121.91061, 36.60941]]]} | Open Access 1 | Cypress Park | 17879 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 0.919 | Cypress Park | ||
7574 | 7574 | 7573 | {"type": "Polygon", "coordinates": [[[-121.90768, 36.60961], [-121.9071, 36.60989], [-121.90663, 36.60934], [-121.90603, 36.60842], [-121.90675, 36.60842], [-121.90711, 36.60881], [-121.90705, 36.60884], [-121.90705, 36.60886], [-121.90768, 36.60961]]]} | Open Access 1 | Oak Newton Park | 22992 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 2.585 | Oak Newton Park | ||
10853 | 10853 | 10852 | {"type": "Polygon", "coordinates": [[[-121.9059, 36.59368], [-121.90579, 36.59373], [-121.90477, 36.59385], [-121.90452, 36.59389], [-121.90419, 36.594], [-121.90391, 36.59415], [-121.90373, 36.59345], [-121.90362, 36.59341], [-121.90337, 36.59263], [-121.90371, 36.59256], [-121.90388, 36.59247], [-121.90396, 36.5924], [-121.90402, 36.59232], [-121.90411, 36.59207], [-121.90415, 36.59203], [-121.90421, 36.592], [-121.90443, 36.59197], [-121.90471, 36.59198], [-121.90537, 36.59209], [-121.90554, 36.59208], [-121.90577, 36.59201], [-121.90583, 36.59201], [-121.90624, 36.59257], [-121.90631, 36.59273], [-121.90634, 36.59294], [-121.90633, 36.59307], [-121.90631, 36.59315], [-121.90625, 36.59322], [-121.90606, 36.59334], [-121.90599, 36.59341], [-121.90594, 36.59352], [-121.90593, 36.59363], [-121.9059, 36.59368]]]} | Open Access 1 | Via Paraiso Park | 27067 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 10.867 | Via Paraiso Park | ||
5197 | 5197 | 5196 | {"type": "Polygon", "coordinates": [[[-121.9057, 36.61125], [-121.90505, 36.61162], [-121.90486, 36.6114], [-121.90517, 36.61122], [-121.90517, 36.6112], [-121.90499, 36.61099], [-121.90466, 36.61117], [-121.90428, 36.61071], [-121.90493, 36.61035], [-121.9057, 36.61125]]]} | Open Access 1 | Hoffman Park | 20022 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.883 | Hoffman Park | ||
9397 | 9397 | 9396 | {"type": "Polygon", "coordinates": [[[-121.89957, 36.61125], [-121.89928, 36.61142], [-121.89946, 36.61164], [-121.89915, 36.61181], [-121.89857, 36.61114], [-121.89919, 36.6108], [-121.89957, 36.61125]]]} | Open Access 1 | Scholze Park | 25190 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.267 | Scholze Park | ||
8397 | 8397 | 8396 | {"type": "Polygon", "coordinates": [[[-121.89896, 36.60742], [-121.89812, 36.60754], [-121.89778, 36.6077], [-121.89763, 36.60792], [-121.89754, 36.60846], [-121.89681, 36.60819], [-121.89539, 36.60759], [-121.89512, 36.60744], [-121.89498, 36.60735], [-121.89476, 36.60709], [-121.89472, 36.60703], [-121.89462, 36.60679], [-121.89461, 36.60647], [-121.89463, 36.60634], [-121.89509, 36.60549], [-121.89517, 36.60528], [-121.89521, 36.60511], [-121.8952, 36.60492], [-121.89517, 36.60469], [-121.89518, 36.60465], [-121.89567, 36.60458], [-121.89598, 36.60477], [-121.89608, 36.60434], [-121.89623, 36.60436], [-121.89614, 36.60485], [-121.89639, 36.60483], [-121.89669, 36.6049], [-121.89698, 36.60499], [-121.89717, 36.60525], [-121.8975, 36.60535], [-121.89771, 36.60527], [-121.89821, 36.60526], [-121.89877, 36.60499], [-121.89896, 36.60742]]]} | Open Access 1 | Presidio | 23990 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 27.972 | Presidio | ||
4423 | 4423 | 4422 | {"type": "Polygon", "coordinates": [[[-121.89797, 36.59707], [-121.89766, 36.59789], [-121.89726, 36.59781], [-121.89703, 36.59843], [-121.89654, 36.5983], [-121.89716, 36.5969], [-121.89797, 36.59707]]]} | Open Access 1 | Friendly Plaza | 19116 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 2.61 | Friendly Plaza | ||
9162 | 9162 | 9161 | {"type": "Polygon", "coordinates": [[[-121.897, 36.61092], [-121.89662, 36.61113], [-121.89653, 36.61109], [-121.8965, 36.61109], [-121.89645, 36.61117], [-121.89637, 36.6112], [-121.89631, 36.61117], [-121.8963, 36.61114], [-121.8963, 36.61112], [-121.89633, 36.6111], [-121.89646, 36.61107], [-121.89655, 36.61095], [-121.89656, 36.61087], [-121.89648, 36.61079], [-121.89676, 36.61064], [-121.897, 36.61092]]]} | Open Access 1 | San Carlos Beach Park | 24845 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 0.399 | San Carlos Beach Park | ||
7144 | 7144 | 7143 | {"type": "Polygon", "coordinates": [[[-121.89656, 36.60906], [-121.89624, 36.60912], [-121.89595, 36.60879], [-121.8956, 36.60848], [-121.89501, 36.60847], [-121.89499, 36.60839], [-121.89488, 36.60822], [-121.89479, 36.60806], [-121.89465, 36.60793], [-121.89446, 36.60781], [-121.89422, 36.60774], [-121.89416, 36.60768], [-121.89411, 36.6076], [-121.89417, 36.60735], [-121.89418, 36.60721], [-121.894, 36.607], [-121.89398, 36.6069], [-121.8941, 36.60679], [-121.89421, 36.60662], [-121.89445, 36.60609], [-121.8943, 36.60651], [-121.89432, 36.6067], [-121.8944, 36.60698], [-121.89455, 36.60727], [-121.89471, 36.60746], [-121.89515, 36.60772], [-121.89561, 36.60791], [-121.89577, 36.60806], [-121.89596, 36.60831], [-121.89605, 36.60847], [-121.89656, 36.60906]]]} | Open Access 1 | Monterey Bay Coastal Trail | 22416 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.706 | Monterey Bay Coastal Trail | ||
7160 | 7160 | 7159 | {"type": "Polygon", "coordinates": [[[-121.89457, 36.59756], [-121.89454, 36.5976], [-121.89449, 36.59761], [-121.89418, 36.59759], [-121.89428, 36.59721], [-121.89431, 36.59721], [-121.89457, 36.59751], [-121.89457, 36.59756]]]} | Open Access 1 | Monterey State Historic Park | 22433 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 0.228 | Monterey SHP | 1916 | |
6441 | 6441 | 6440 | {"type": "Polygon", "coordinates": [[[-121.89403, 36.60846], [-121.89279, 36.60845], [-121.89238, 36.60732], [-121.89352, 36.60702], [-121.89403, 36.60846]]]} | Open Access 1 | Lower Presidio Historic Park | 21563 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.927 | Lower Presidio Historic Park | ||
5449 | 5449 | 5448 | {"type": "Polygon", "coordinates": [[[-121.89178, 36.59798], [-121.89141, 36.59939], [-121.89035, 36.59922], [-121.89056, 36.59809], [-121.89178, 36.59798]]]} | Open Access 1 | Jacks Ball Park | 20318 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 3.576 | Jacks Ball Park | ||
3900 | 3900 | 3899 | {"type": "Polygon", "coordinates": [[[-121.88751, 36.59549], [-121.8875, 36.59504], [-121.88814, 36.59515], [-121.88888, 36.59523], [-121.889, 36.59529], [-121.88904, 36.59535], [-121.88906, 36.59542], [-121.88886, 36.59649], [-121.88878, 36.59676], [-121.8887, 36.59691], [-121.88858, 36.59707], [-121.88841, 36.59724], [-121.88802, 36.59752], [-121.88781, 36.59774], [-121.88764, 36.598], [-121.88751, 36.59832], [-121.88722, 36.59963], [-121.88718, 36.59971], [-121.88708, 36.59978], [-121.88695, 36.59981], [-121.88365, 36.59977], [-121.8836, 36.59975], [-121.88352, 36.59944], [-121.88341, 36.59876], [-121.88336, 36.59858], [-121.88325, 36.59833], [-121.88301, 36.59802], [-121.88293, 36.59786], [-121.88273, 36.5971], [-121.88272, 36.59696], [-121.88273, 36.59684], [-121.88285, 36.59632], [-121.88284, 36.59602], [-121.88277, 36.59574], [-121.88248, 36.59502], [-121.88241, 36.59478], [-121.88247, 36.59437], [-121.88255, 36.59418], [-121.88259, 36.59412], [-121.88273, 36.59403], [-121.88289, 36.59401], [-121.88338, 36.59412], [-121.88277, 36.59439], [-121.88284, 36.59456], [-121.88291, 36.59479], [-121.88304, 36.59496], [-121.88332, 36.59527], [-121.88338, 36.59542], [-121.88343, 36.59604], [-121.88338, 36.59643], [-121.8834, 36.59675], [-121.88352, 36.597], [-121.88473, 36.59709], [-121.8848, 36.59689], [-121.88533, 36.59698], [-121.88541, 36.59674], [-121.88717, 36.59705], [-121.88771, 36.59573], [-121.88751, 36.59549]]]} | Open Access 1 | El Estero Park | 18510 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 41.718 | El Estero Park | ||
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.88549, 36.5946], [-121.88475, 36.59709], [-121.88351, 36.597], [-121.8834, 36.59675], [-121.88338, 36.59643], [-121.88343, 36.59604], [-121.88338, 36.59542], [-121.88332, 36.59527], [-121.88304, 36.59496], [-121.88291, 36.59479], [-121.88284, 36.59457], [-121.88276, 36.59438], [-121.88338, 36.59412], [-121.88549, 36.5946]]]} | Open Access 1 | Cementerio El Encinal | 17006 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 12.672 | Cementerio El Encinal | ||
8060 | 8060 | 8059 | {"type": "Polygon", "coordinates": [[[-121.86747, 36.59748], [-121.867, 36.59835], [-121.86617, 36.59777], [-121.86625, 36.59767], [-121.86747, 36.59748]]]} | Open Access 1 | Peter Ferrante Park | 23626 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.352 | Peter Ferrante Park | ||
3505 | 3505 | 3504 | {"type": "Polygon", "coordinates": [[[-121.86248, 36.57835], [-121.86239, 36.57909], [-121.8616, 36.57872], [-121.86205, 36.57832], [-121.86248, 36.57835]]]} | Open Access 1 | Deer Flats Park | 17996 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.0 | Deer Flats Park | ||
5997 | 5997 | 5996 | {"type": "Polygon", "coordinates": [[[-121.86176, 36.5992], [-121.86104, 36.59978], [-121.86034, 36.59922], [-121.86066, 36.59896], [-121.86102, 36.59923], [-121.86141, 36.59892], [-121.86176, 36.5992]]]} | Open Access 1 | Montecito Park | 22410 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1.452 | Montecito Park | ||
7159 | 7159 | 7158 | {"type": "Polygon", "coordinates": [[[-121.86014, 36.60946], [-121.85999, 36.60944], [-121.85981, 36.60945], [-121.85967, 36.60949], [-121.85951, 36.60957], [-121.85989, 36.6092], [-121.86014, 36.60946]]]} | Open Access 1 | Monterey State Beach | http://www.parks.ca.gov/?page_id=576 | 22432 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 0.171 | Monterey SB | 1960 |
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]);