units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 36 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 9
- Local Park 20
- Local Recreation Area 4
- Local Other or Unknown 2
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Monterey, City of · 32 ✖
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10256 | 10256 | 10255 | {"type": "Polygon", "coordinates": [[[-121.86014, 36.60946], [-121.85999, 36.60944], [-121.85981, 36.60945], [-121.85968, 36.60949], [-121.85951, 36.60957], [-121.85989, 36.6092], [-121.86014, 36.60946]]]} | Open Access 1 | 17950 | Monterey State Beach | 22432 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=576 | Monterey 14 | 0.171 | Monterey SB | 1960 | None 893 | |
16464 | 16464 | 16463 | {"type": "Polygon", "coordinates": [[[-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], [-121.89454, 36.5976]]]} | Open Access 1 | 17961 | Monterey State Historic Park | 22433 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 0.229 | Monterey SHP | 1916 | None 1406 | ||
129 | 129 | 128 | {"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 | 322 | San Carlos Beach Park | 24845 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 0.398 | San Carlos Beach Park | 0 | Local Park 2 | 4 | |
5472 | 5472 | 5471 | {"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 | 12196 | Cypress Park | 17879 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 0.919 | Cypress Park | 0 | Local Park 2 | 4 | |
1756 | 1756 | 1755 | {"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 | 13079 | Deer Flats Park | 17996 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.0 | Deer Flats Park | 0 | Local Park 2 | 4 | |
1855 | 1855 | 1854 | {"type": "Polygon", "coordinates": [[[-121.85534, 36.57982], [-121.85529, 36.57987], [-121.85525, 36.57992], [-121.85519, 36.57986], [-121.85475, 36.58], [-121.85446, 36.57938], [-121.85489, 36.57925], [-121.85494, 36.57919], [-121.85503, 36.57922], [-121.85515, 36.57922], [-121.85534, 36.57982]]]} | Open Access 1 | 15857 | Fishermans Flats Park | 18924 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.106 | Fishermans Flats Park | 0 | Local Park 2 | 4 | |
6004 | 6004 | 6003 | {"type": "Polygon", "coordinates": [[[-121.89957, 36.61125], [-121.89927, 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 | 655 | Scholze Park | 25190 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.264 | Scholze Park | 0 | Local Park 2 | 4 | |
762 | 762 | 761 | {"type": "Polygon", "coordinates": [[[-121.85224, 36.59449], [-121.85177, 36.59488], [-121.85075, 36.59406], [-121.85181, 36.59419], [-121.85195, 36.59425], [-121.85224, 36.59449]]]} | Open Access 1 | 4961 | Casanova Oak Knoll Park | 16933 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.296 | Casanova Oak Knoll Park | 0 | Local Park 2 | 4 | |
2772 | 2772 | 2771 | {"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 | 18508 | Peter Ferrante Park | 23626 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.352 | Peter Ferrante Park | 0 | Local Park 2 | 4 | |
9749 | 9749 | 9748 | {"type": "Polygon", "coordinates": [[[-121.86176, 36.5992], [-121.86104, 36.59978], [-121.86034, 36.59922], [-121.86066, 36.59896], [-121.86102, 36.59924], [-121.86141, 36.59892], [-121.86176, 36.5992]]]} | Open Access 1 | 17910 | Montecito Park | 22410 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.45 | Montecito Park | 0 | Local Park 2 | 4 | |
9885 | 9885 | 9884 | {"type": "Polygon", "coordinates": [[[-121.9057, 36.61125], [-121.90505, 36.61162], [-121.90486, 36.6114], [-121.90518, 36.61122], [-121.90518, 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 | 16922 | Hoffman Park | 20022 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.881 | Hoffman Park | 0 | Local Park 2 | 4 | |
561 | 561 | 560 | {"type": "MultiPolygon", "coordinates": [[[[-121.89934, 36.58954], [-121.89907, 36.58978], [-121.8988, 36.59009], [-121.8983, 36.58996], [-121.89825, 36.58981], [-121.89898, 36.58939], [-121.89929, 36.58932], [-121.89934, 36.58954]]], [[[-121.90001, 36.58937], [-121.90007, 36.58941], [-121.90009, 36.58947], [-121.90007, 36.58958], [-121.90002, 36.58967], [-121.89991, 36.58979], [-121.89972, 36.5899], [-121.8996, 36.59001], [-121.89922, 36.59052], [-121.89907, 36.59044], [-121.89912, 36.59037], [-121.89885, 36.59024], [-121.89916, 36.58987], [-121.89947, 36.5896], [-121.89971, 36.58945], [-121.89988, 36.5894], [-121.90001, 36.58937]]]]} | Open Access 1 | 1860 | Whispering Pines Park | 27458 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 2.381 | Whispering Pines Park | 0 | Local Park 2 | 4 | |
2671 | 2671 | 2670 | {"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 | 18196 | Oak Newton Park | 22992 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 2.585 | Oak Newton Park | 0 | Local Park 2 | 4 | |
9643 | 9643 | 9642 | {"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 | 16230 | Friendly Plaza | 19116 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 2.607 | Friendly Plaza | 0 | Local Park 2 | 4 | |
2007 | 2007 | 2006 | {"type": "Polygon", "coordinates": [[[-121.92087, 36.60896], [-121.92013, 36.60931], [-121.91907, 36.60807], [-121.91942, 36.60787], [-121.91968, 36.60817], [-121.92003, 36.60798], [-121.92087, 36.60896]]]} | Open Access 1 | 16912 | Hilltop Park | 19988 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 2.831 | Hilltop Park | 0 | Local Park 2 | 4 | |
9742 | 9742 | 9741 | {"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 | 16999 | Jacks Ball Park | 20318 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.577 | Jacks Ball Park | 0 | Local Recreation Area 3 | 4 | |
10242 | 10242 | 10241 | {"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.60699], [-121.89454, 36.60727], [-121.89471, 36.60746], [-121.89516, 36.60772], [-121.89561, 36.60791], [-121.89577, 36.60806], [-121.89596, 36.60831], [-121.89604, 36.60847], [-121.89656, 36.60906]]]} | Open Access 1 | 17923 | Monterey Bay Coastal Trail | 22416 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.703 | Monterey Bay Coastal Trail | 0 | Local Recreation Area 3 | 4 | |
9982 | 9982 | 9981 | {"type": "MultiPolygon", "coordinates": [[[[-121.85322, 36.59869], [-121.8531, 36.59879], [-121.85312, 36.59882], [-121.85274, 36.59888], [-121.85271, 36.5989], [-121.85269, 36.59894], [-121.85273, 36.59905], [-121.8528, 36.59913], [-121.85303, 36.59901], [-121.85316, 36.59914], [-121.85305, 36.59915], [-121.85295, 36.59918], [-121.85296, 36.59924], [-121.85295, 36.59928], [-121.85291, 36.59931], [-121.85286, 36.59933], [-121.85276, 36.59931], [-121.85271, 36.5992], [-121.85249, 36.59927], [-121.85247, 36.59932], [-121.85249, 36.5994], [-121.85234, 36.59934], [-121.85195, 36.5988], [-121.85199, 36.59879], [-121.85199, 36.59839], [-121.85212, 36.59853], [-121.85224, 36.59854], [-121.85234, 36.59866], [-121.85237, 36.59875], [-121.85247, 36.59884], [-121.85251, 36.59879], [-121.85257, 36.59877], [-121.8532, 36.59867], [-121.85322, 36.59869]]], [[[-121.85704, 36.60304], [-121.85675, 36.60327], [-121.85588, 36.60271], [-121.85607, 36.60248], [-121.85614, 36.60233], [-121.85704, 36.60304]]], [[[-121.85813, 36.60391], [-121.85768, 36.60427], [-121.85757, 36.60412], [-121.85722, 36.60377], [-121.85694, 36.60343], [-121.85687, 36.60337], [-121.85716, 36.60314], [-121.85813, 36.60391]]]]} | Open Access 1 | 17179 | Laguna Grande Regional Park | 20854 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.765 | Laguna Grande RP | 0 | Local Park 2 | 4 | |
10099 | 10099 | 10098 | {"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 | 17491 | Lower Presidio Historic Park | 21563 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.927 | Lower Presidio Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
5512 | 5512 | 5511 | {"type": "MultiPolygon", "coordinates": [[[[-121.86779, 36.60347], [-121.86767, 36.60351], [-121.86754, 36.60329], [-121.86767, 36.60324], [-121.86779, 36.60347]]], [[[-121.86999, 36.60466], [-121.86781, 36.60545], [-121.86756, 36.605], [-121.86974, 36.60421], [-121.86999, 36.60466]]], [[[-121.87023, 36.60511], [-121.86814, 36.60605], [-121.86787, 36.60555], [-121.87004, 36.60477], [-121.87023, 36.60511]]], [[[-121.87071, 36.60374], [-121.86996, 36.60401], [-121.86984, 36.60379], [-121.86971, 36.60383], [-121.86959, 36.60361], [-121.86971, 36.60356], [-121.86983, 36.60378], [-121.86996, 36.60374], [-121.87008, 36.60369], [-121.86996, 36.60347], [-121.87008, 36.60343], [-121.87021, 36.60365], [-121.87058, 36.60352], [-121.87071, 36.60374]]], [[[-121.87151, 36.60411], [-121.87014, 36.60461], [-121.86989, 36.60416], [-121.87126, 36.60366], [-121.87151, 36.60411]]], [[[-121.87171, 36.60447], [-121.87038, 36.60504], [-121.8702, 36.60471], [-121.87157, 36.60422], [-121.87171, 36.60447]]], [[[-121.87052, 36.60288], [-121.8704, 36.60292], [-121.87027, 36.6027], [-121.8704, 36.60265], [-121.87052, 36.60288]]], [[[-121.87096, 36.60365], [-121.87083, 36.6037], [-121.87071, 36.60347], [-121.87083, 36.60343], [-121.87096, 36.60365]]]]} | Open Access 1 | 968 | South Monterey Dunes Beach | 25665 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 9.489 | South Monterey Dunes Beach | 0 | Local Park 2 | 4 |
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]);