units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 36 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 10
- Local Other or Unknown 1
- None 1
MNG_AG_TYP 1
- City Agency 12
MNG_AGENCY 1
- Monterey, City of · 12 ✖
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13209 | 13209 | 13208 | {"type": "Polygon", "coordinates": [[[-121.80773, 36.57658], [-121.80773, 36.58183], [-121.80616, 36.58125], [-121.80561, 36.58087], [-121.80526, 36.58066], [-121.80482, 36.58044], [-121.80434, 36.58027], [-121.8037, 36.58007], [-121.80214, 36.57966], [-121.80143, 36.57949], [-121.80018, 36.57927], [-121.7979, 36.5789], [-121.79696, 36.57877], [-121.79602, 36.57867], [-121.79506, 36.57859], [-121.7945, 36.57856], [-121.7935, 36.57873], [-121.79326, 36.57873], [-121.79638, 36.57817], [-121.79781, 36.57789], [-121.80394, 36.5768], [-121.80635, 36.57633], [-121.80665, 36.57631], [-121.80695, 36.57632], [-121.80735, 36.57641], [-121.8076, 36.57651], [-121.80773, 36.57658]]]} | Open Access 1 | 35245 | Monterey holding 2 | 22422 | 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 | 77.51 | Monterey holding 2 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
10571 | 10571 | 10570 | {"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.60493], [-121.89517, 36.60469], [-121.89518, 36.60465], [-121.89567, 36.60458], [-121.89598, 36.60478], [-121.89608, 36.60434], [-121.89623, 36.60436], [-121.89613, 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 | 18828 | Presidio | 23990 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 27.963 | Presidio | None 927 | |||
2456 | 2456 | 2455 | {"type": "MultiPolygon", "coordinates": [[[[-121.90724, 36.59296], [-121.90722, 36.59322], [-121.90683, 36.59314], [-121.90652, 36.59319], [-121.90655, 36.5931], [-121.90709, 36.59296], [-121.90724, 36.59296]]], [[[-121.91227, 36.59402], [-121.91094, 36.59514], [-121.90985, 36.59461], [-121.90964, 36.5941], [-121.90818, 36.59341], [-121.90742, 36.59326], [-121.90745, 36.59297], [-121.90794, 36.593], [-121.90797, 36.59273], [-121.9079, 36.59272], [-121.90792, 36.59258], [-121.9073, 36.59174], [-121.9085, 36.59131], [-121.90941, 36.59202], [-121.90889, 36.59259], [-121.90886, 36.59304], [-121.91103, 36.59316], [-121.91108, 36.59318], [-121.91227, 36.59402]]]]} | Open Access 1 | 18856 | Quarry Park | 24057 | 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 | 17.324 | Quarry Park | 0 | Local Park 2 | 4 | |
89 | 89 | 88 | {"type": "MultiPolygon", "coordinates": [[[[-121.8271, 36.58062], [-121.82287, 36.58502], [-121.81841, 36.58218], [-121.82009, 36.58191], [-121.82254, 36.57939], [-121.82254, 36.57938], [-121.81988, 36.57848], [-121.81974, 36.57825], [-121.82001, 36.57814], [-121.82023, 36.57809], [-121.82059, 36.57806], [-121.82087, 36.57809], [-121.82109, 36.57814], [-121.82169, 36.57835], [-121.82197, 36.5784], [-121.82225, 36.5784], [-121.82261, 36.57836], [-121.82277, 36.57835], [-121.82365, 36.5784], [-121.82406, 36.57838], [-121.82441, 36.57832], [-121.82476, 36.57821], [-121.82509, 36.57804], [-121.82647, 36.57976], [-121.8271, 36.58062]]], [[[-121.82489, 36.57785], [-121.82473, 36.57794], [-121.82453, 36.57802], [-121.82383, 36.57666], [-121.82432, 36.57715], [-121.82462, 36.5775], [-121.82469, 36.57768], [-121.82489, 36.57785]]]]} | Open Access 1 | 231 | Ryan Ranch Park | 24759 | 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 | 75.676 | Ryan Ranch Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
6261 | 6261 | 6260 | {"type": "Polygon", "coordinates": [[[-121.91355, 36.60008], [-121.9107, 36.60216], [-121.90991, 36.60197], [-121.91001, 36.60165], [-121.90665, 36.60085], [-121.9067, 36.60069], [-121.90582, 36.60048], [-121.9059, 36.60027], [-121.90678, 36.60048], [-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.91002, 36.59954], [-121.91021, 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], [-121.91373, 36.5967], [-121.91363, 36.59688], [-121.91356, 36.59709], [-121.9135, 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]]]} | Open Access 1 | 1726 | Veterans Memorial Park | 27028 | 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 | 54.619 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
6375 | 6375 | 6374 | {"type": "Polygon", "coordinates": [[[-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.90605, 36.59334], [-121.90599, 36.59341], [-121.90594, 36.59352], [-121.90593, 36.59363], [-121.9059, 36.59368], [-121.9058, 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]]]} | Open Access 1 | 1742 | Via Paraiso Park | 27067 | 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 | 10.867 | Via Paraiso 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 |
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]);