units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 36
This data as json, copyable, CSV (advanced)
DES_TP 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
9895 | 9895 | 9894 | {"type": "MultiPolygon", "coordinates": [[[[-121.897, 36.58544], [-121.89666, 36.58594], [-121.89617, 36.58566], [-121.89549, 36.58624], [-121.89258, 36.58592], [-121.89131, 36.58632], [-121.89112, 36.58746], [-121.89093, 36.58779], [-121.89094, 36.58805], [-121.89099, 36.58827], [-121.89023, 36.58847], [-121.88896, 36.59007], [-121.88856, 36.59085], [-121.88747, 36.59219], [-121.8873, 36.59308], [-121.88755, 36.59354], [-121.88785, 36.59374], [-121.88758, 36.59385], [-121.88743, 36.59395], [-121.88732, 36.59409], [-121.88725, 36.59427], [-121.88659, 36.59373], [-121.88637, 36.59296], [-121.88639, 36.59207], [-121.88721, 36.59086], [-121.89009, 36.58763], [-121.89006, 36.58735], [-121.88981, 36.58735], [-121.88975, 36.5865], [-121.88985, 36.58615], [-121.88994, 36.58569], [-121.89047, 36.58526], [-121.89077, 36.58481], [-121.89071, 36.58376], [-121.89099, 36.58383], [-121.89156, 36.58357], [-121.89154, 36.58374], [-121.89168, 36.58418], [-121.89194, 36.58463], [-121.89191, 36.58485], [-121.89325, 36.58537], [-121.89503, 36.58558], [-121.89604, 36.58498], [-121.897, 36.58544]]], [[[-121.88834, 36.59487], [-121.88763, 36.59472], [-121.88759, 36.5947], [-121.88748, 36.59442], [-121.88746, 36.59434], [-121.88748, 36.5942], [-121.88757, 36.59407], [-121.8877, 36.59399], [-121.88819, 36.59378], [-121.88832, 36.59399], [-121.88821, 36.59465], [-121.88834, 36.59487]]], [[[-121.89446, 36.58141], [-121.89429, 36.58159], [-121.89419, 36.58151], [-121.89404, 36.58146], [-121.89342, 36.58146], [-121.89328, 36.58144], [-121.89312, 36.58139], [-121.89295, 36.58129], [-121.89281, 36.58118], [-121.89246, 36.58062], [-121.89225, 36.58081], [-121.89178, 36.58144], [-121.8915, 36.58212], [-121.89147, 36.58264], [-121.89152, 36.58282], [-121.89105, 36.58277], [-121.89092, 36.58283], [-121.89093, 36.58262], [-121.89101, 36.58193], [-121.89196, 36.58067], [-121.8923, 36.58034], [-121.8925, 36.58029], [-121.89294, 36.58103], [-121.89305, 36.58115], [-121.89318, 36.58122], [-121.89329, 36.58127], [-121.89344, 36.58129], [-121.89412, 36.5813], [-121.89431, 36.58135], [-121.89446, 36.58141]]]]} | Open Access 1 | 16969 | Iris Canyon Greenbelt | 20232 | 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 | 44.704 | Iris Canyon Greenbelt | 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 | |
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 | |
10245 | 10245 | 10244 | {"type": "MultiPolygon", "coordinates": [[[[-121.88765, 36.60006], [-121.88751, 36.60019], [-121.88747, 36.6002], [-121.88747, 36.6007], [-121.87892, 36.60047], [-121.87884, 36.60016], [-121.8822, 36.60025], [-121.88222, 36.60002], [-121.8822, 36.59999], [-121.88235, 36.59999], [-121.88235, 36.60028], [-121.88389, 36.60032], [-121.88391, 36.60003], [-121.88765, 36.60006]]], [[[-121.88875, 36.60014], [-121.88869, 36.60035], [-121.88845, 36.60033], [-121.888, 36.60032], [-121.88797, 36.60017], [-121.88778, 36.60014], [-121.8878, 36.60006], [-121.88829, 36.60006], [-121.88875, 36.60014]]]]} | Open Access 1 | 17936 | Monterey Bay Waterfront Park / Window on the Bay | 22418 | 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.638 | Monterey Bay Waterfront Park / Window on the Bay | None 891 | |||
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 | |
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 | |||
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 | |
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 |
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]);