units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where AGNCY_LEV = 2 and MNG_AGENCY = 481 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 35
- Local Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 41
MNG_AGENCY 1
- Manteca, City of · 41 ✖
ACCESS_TYP 1
- Open Access 41
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10119 | 10119 | 10118 | {"type": "Polygon", "coordinates": [[[-121.25861, 37.77984], [-121.25857, 37.78083], [-121.25735, 37.78084], [-121.2573, 37.7808], [-121.25728, 37.78071], [-121.25721, 37.78056], [-121.25614, 37.77942], [-121.2555, 37.77893], [-121.25576, 37.77866], [-121.25602, 37.7788], [-121.25645, 37.77894], [-121.25659, 37.77898], [-121.25687, 37.779], [-121.25856, 37.77901], [-121.2586, 37.77905], [-121.25861, 37.77984]]]} | Open Access 1 | 17588 | Bella Vista Park | 15979 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 9.359 | Bella Vista Park | 0 | Local Park 2 | 4 | |
10125 | 10125 | 10124 | {"type": "Polygon", "coordinates": [[[-121.23082, 37.81398], [-121.2315, 37.81396], [-121.23155, 37.81401], [-121.23156, 37.81455], [-121.23146, 37.81486], [-121.23138, 37.81497], [-121.23135, 37.81505], [-121.2313, 37.81511], [-121.23092, 37.81506], [-121.22966, 37.81507], [-121.22961, 37.81404], [-121.23082, 37.81398]]]} | Open Access 1 | 17595 | Colony Park | 17537 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.869 | Colony Park | 0 | Local Park 2 | 4 | |
10133 | 10133 | 10132 | {"type": "Polygon", "coordinates": [[[-121.2254, 37.81112], [-121.22386, 37.81112], [-121.22362, 37.81108], [-121.22367, 37.81098], [-121.22372, 37.81071], [-121.22374, 37.81015], [-121.22496, 37.81013], [-121.22535, 37.81016], [-121.2254, 37.81112]]]} | Open Access 1 | 17638 | Franciscan Park | 19045 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.934 | Franciscan Park | 0 | Local Park 2 | 4 | |
10139 | 10139 | 10138 | {"type": "Polygon", "coordinates": [[[-121.24613, 37.78883], [-121.24613, 37.78889], [-121.2461, 37.78907], [-121.24602, 37.78931], [-121.24602, 37.78936], [-121.24599, 37.78945], [-121.24406, 37.78946], [-121.24404, 37.78867], [-121.24414, 37.78839], [-121.24427, 37.78823], [-121.24437, 37.78823], [-121.24451, 37.78833], [-121.24468, 37.78841], [-121.24488, 37.78848], [-121.24518, 37.78853], [-121.24609, 37.78854], [-121.24613, 37.78883]]]} | Open Access 1 | 17720 | Roberts Park | 24495 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.899 | Roberts Park | 0 | Local Park 2 | 4 | |
10142 | 10142 | 10141 | {"type": "Polygon", "coordinates": [[[-121.22006, 37.79845], [-121.21965, 37.79845], [-121.21964, 37.79861], [-121.2194, 37.79861], [-121.22001, 37.79782], [-121.22006, 37.79786], [-121.22006, 37.79845]]]} | Open Access 1 | 17659 | Library Park | 21219 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.513 | Library Park | 0 | Local Park 2 | 4 | |
10145 | 10145 | 10144 | {"type": "Polygon", "coordinates": [[[-121.20724, 37.79526], [-121.20494, 37.79527], [-121.20495, 37.79509], [-121.20501, 37.7948], [-121.20519, 37.79442], [-121.20525, 37.7942], [-121.20528, 37.79385], [-121.20719, 37.79382], [-121.20724, 37.79526]]]} | Open Access 1 | 17666 | Lincoln Park | 21267 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 7.26 | Lincoln Park | 0 | Local Park 2 | 4 | |
10150 | 10150 | 10149 | {"type": "Polygon", "coordinates": [[[-121.24114, 37.80988], [-121.24104, 37.8099], [-121.24096, 37.80995], [-121.24079, 37.81012], [-121.24064, 37.81024], [-121.24051, 37.81032], [-121.24041, 37.81036], [-121.23939, 37.80978], [-121.23887, 37.80945], [-121.23932, 37.80893], [-121.23935, 37.80886], [-121.23935, 37.80875], [-121.24032, 37.80931], [-121.24114, 37.80988]]]} | Open Access 1 | 17688 | Mayors Park | 21980 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.912 | Mayors Park | 0 | Local Park 2 | 4 | |
10154 | 10154 | 10153 | {"type": "Polygon", "coordinates": [[[-121.22073, 37.79865], [-121.22073, 37.79901], [-121.22027, 37.79901], [-121.22029, 37.79865], [-121.22073, 37.79865]]]} | Open Access 1 | 17691 | Mini Park | 22267 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.39 | MP | 0 | Local Park 2 | 4 | |
10159 | 10159 | 10158 | {"type": "Polygon", "coordinates": [[[-121.25016, 37.81507], [-121.24994, 37.81531], [-121.24982, 37.8153], [-121.24971, 37.81534], [-121.24929, 37.81578], [-121.24925, 37.8158], [-121.2492, 37.81579], [-121.2489, 37.81566], [-121.24857, 37.81557], [-121.24832, 37.81552], [-121.24785, 37.81548], [-121.24782, 37.81545], [-121.24779, 37.81505], [-121.24774, 37.81486], [-121.24771, 37.81449], [-121.24769, 37.81437], [-121.2476, 37.81417], [-121.24748, 37.81402], [-121.24784, 37.81371], [-121.25016, 37.81507]]]} | Open Access 1 | 17712 | Primavera Park | 24001 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 6.925 | Primavera Park | 0 | Local Park 2 | 4 | |
10160 | 10160 | 10159 | {"type": "Polygon", "coordinates": [[[-121.23212, 37.78489], [-121.23152, 37.78491], [-121.23108, 37.78497], [-121.231, 37.78491], [-121.23083, 37.78468], [-121.2307, 37.78456], [-121.23035, 37.78431], [-121.23078, 37.78383], [-121.23103, 37.7839], [-121.23144, 37.78405], [-121.23208, 37.78435], [-121.23212, 37.78489]]]} | Open Access 1 | 17716 | Quail Ridge Park | 24051 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.043 | Quail Ridge Park | 0 | Local Park 2 | 4 | |
10168 | 10168 | 10167 | {"type": "Polygon", "coordinates": [[[-121.21125, 37.81585], [-121.21089, 37.81586], [-121.21067, 37.81584], [-121.21045, 37.81575], [-121.21022, 37.81557], [-121.20987, 37.81529], [-121.20976, 37.81512], [-121.2097, 37.81494], [-121.2097, 37.81461], [-121.20975, 37.81458], [-121.21122, 37.81459], [-121.21127, 37.81557], [-121.21125, 37.81585]]]} | Open Access 1 | 17740 | Springtime Park | 25750 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.953 | Springtime Park | 0 | Local Park 2 | 4 | |
10169 | 10169 | 10168 | {"type": "Polygon", "coordinates": [[[-121.23839, 37.80105], [-121.23511, 37.80103], [-121.23506, 37.79926], [-121.23513, 37.79923], [-121.23557, 37.79922], [-121.23585, 37.79927], [-121.23611, 37.79938], [-121.23623, 37.79946], [-121.23639, 37.79962], [-121.23655, 37.79972], [-121.23672, 37.7998], [-121.23694, 37.79986], [-121.23717, 37.79988], [-121.23835, 37.79988], [-121.23839, 37.80105]]]} | Open Access 1 | 17743 | Union Road Park | 26660 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 11.131 | Union Road Park | 0 | Local Park 2 | 4 | |
10171 | 10171 | 10170 | {"type": "Polygon", "coordinates": [[[-121.25056, 37.80705], [-121.25061, 37.80706], [-121.25063, 37.80709], [-121.25094, 37.80823], [-121.25093, 37.80826], [-121.25089, 37.80829], [-121.25057, 37.80833], [-121.24972, 37.80834], [-121.24948, 37.80837], [-121.24922, 37.80843], [-121.24918, 37.80842], [-121.24901, 37.80815], [-121.24891, 37.8079], [-121.24887, 37.80764], [-121.24885, 37.80719], [-121.24886, 37.80716], [-121.24891, 37.80714], [-121.24995, 37.80713], [-121.25056, 37.80705]]]} | Open Access 1 | 17749 | Villa Ticino Park | 27107 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 5.592 | Villa Ticino Park | 0 | Local Park 2 | 4 | |
10173 | 10173 | 10172 | {"type": "Polygon", "coordinates": [[[-121.21889, 37.79865], [-121.21889, 37.79885], [-121.21877, 37.79901], [-121.21842, 37.799], [-121.21843, 37.79865], [-121.21889, 37.79865]]]} | Open Access 1 | 17752 | Wilson Park | 27611 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.381 | Wilson Park | 0 | Local Park 2 | 4 | |
10175 | 10175 | 10174 | {"type": "Polygon", "coordinates": [[[-121.22434, 37.82096], [-121.22365, 37.82096], [-121.22364, 37.82003], [-121.22433, 37.82003], [-121.22434, 37.82096]]]} | Open Access 1 | 17755 | William Martin Park | 33016 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 1.561 | William Martin Park | 0 | Local Park 2 | 4 | |
10178 | 10178 | 10177 | {"type": "Polygon", "coordinates": [[[-121.20663, 37.77323], [-121.20849, 37.77322], [-121.20868, 37.77323], [-121.20887, 37.77326], [-121.20916, 37.77337], [-121.20939, 37.77352], [-121.20962, 37.77377], [-121.2097, 37.7739], [-121.20974, 37.77411], [-121.20976, 37.77421], [-121.20976, 37.77437], [-121.20972, 37.77452], [-121.20968, 37.7746], [-121.20963, 37.77491], [-121.20964, 37.77564], [-121.20233, 37.77567], [-121.20231, 37.77265], [-121.20237, 37.77263], [-121.20266, 37.7726], [-121.20287, 37.77254], [-121.20305, 37.77248], [-121.2033, 37.77234], [-121.20351, 37.77225], [-121.2038, 37.77216], [-121.20417, 37.77212], [-121.20449, 37.77213], [-121.20484, 37.77221], [-121.20546, 37.77246], [-121.20566, 37.7725], [-121.20598, 37.77254], [-121.20606, 37.77256], [-121.20607, 37.77291], [-121.20604, 37.77307], [-121.20606, 37.77314], [-121.20612, 37.77321], [-121.20621, 37.77325], [-121.2063, 37.77326], [-121.20663, 37.77323]]]} | Open Access 1 | 17764 | Woodward Community Park | 27752 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 50.537 | Woodward Community Park | 0 | Local Park 2 | 4 | |
12030 | 12030 | 12029 | {"type": "Polygon", "coordinates": [[[-121.24736, 37.82366], [-121.2473, 37.82386], [-121.24727, 37.82401], [-121.24726, 37.82509], [-121.24724, 37.82513], [-121.2472, 37.82514], [-121.24513, 37.82514], [-121.24509, 37.82513], [-121.24506, 37.8251], [-121.24506, 37.82351], [-121.2451, 37.82347], [-121.24639, 37.82342], [-121.24662, 37.82343], [-121.24698, 37.8235], [-121.24732, 37.8236], [-121.24736, 37.82363], [-121.24736, 37.82366]]]} | Open Access 1 | 24706 | Chadwick Square Park | 17111 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 8.992 | Chadwick Square Park | 0 | Local Park 2 | 4 | |
12031 | 12031 | 12030 | {"type": "Polygon", "coordinates": [[[-121.20328, 37.79622], [-121.20193, 37.79624], [-121.20188, 37.79622], [-121.20186, 37.79619], [-121.20182, 37.79503], [-121.20183, 37.795], [-121.20188, 37.79497], [-121.20319, 37.79497], [-121.20324, 37.79499], [-121.20326, 37.79502], [-121.20328, 37.79564], [-121.20332, 37.79584], [-121.20334, 37.79617], [-121.20332, 37.79621], [-121.20328, 37.79622]]]} | Open Access 1 | 24707 | Curran Grove Park | 17860 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.424 | Curran Grove Park | 0 | Local Park 2 | 4 | |
12032 | 12032 | 12031 | {"type": "Polygon", "coordinates": [[[-121.19203, 37.81431], [-121.19202, 37.8143], [-121.19131, 37.81431], [-121.19097, 37.81436], [-121.19056, 37.81446], [-121.19047, 37.81446], [-121.19043, 37.81442], [-121.19042, 37.81398], [-121.19035, 37.81362], [-121.19039, 37.81358], [-121.19076, 37.81348], [-121.19122, 37.81339], [-121.19198, 37.81338], [-121.19199, 37.81336], [-121.19319, 37.81336], [-121.19324, 37.81338], [-121.19325, 37.81341], [-121.19326, 37.8139], [-121.1933, 37.81406], [-121.19336, 37.81421], [-121.19333, 37.81426], [-121.19313, 37.8143], [-121.19203, 37.81431]]]} | Open Access 1 | 24708 | Diamond Oaks Park | 18145 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 6.451 | Diamond Oaks Park | 0 | Local Park 2 | 4 | |
12033 | 12033 | 12032 | {"type": "Polygon", "coordinates": [[[-121.24785, 37.78372], [-121.24783, 37.78443], [-121.24754, 37.78437], [-121.24756, 37.78431], [-121.24752, 37.78426], [-121.24744, 37.7842], [-121.24734, 37.78416], [-121.247, 37.78416], [-121.24695, 37.78411], [-121.24669, 37.78399], [-121.24646, 37.78392], [-121.24658, 37.7836], [-121.24785, 37.78372]]]} | Open Access 1 | 24709 | Dutra Northeast | 18323 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 1.665 | Dutra Northeast | None 1058 |
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]);