units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where DES_TP = 2 and MNG_AGENCY = 481 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 54
MNG_AGENCY 1
- Manteca, City of · 54 ✖
DES_TP 1
- Local Park · 54 ✖
ACCESS_TYP 1
- Open Access 54
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13687 | 13687 | 13686 | {"type": "MultiPolygon", "coordinates": [[[[-121.19186, 37.80789], [-121.19129, 37.80837], [-121.18944, 37.80838], [-121.18944, 37.80832], [-121.18948, 37.80828], [-121.18988, 37.80827], [-121.19015, 37.80824], [-121.19041, 37.8082], [-121.19082, 37.8081], [-121.19167, 37.80777], [-121.19173, 37.80778], [-121.19186, 37.80789]]], [[[-121.19492, 37.80707], [-121.19478, 37.8073], [-121.19463, 37.80736], [-121.19459, 37.80745], [-121.19451, 37.80745], [-121.19443, 37.80749], [-121.19435, 37.80743], [-121.1935, 37.80763], [-121.19295, 37.80768], [-121.19295, 37.80796], [-121.19246, 37.80796], [-121.19228, 37.80793], [-121.19206, 37.80785], [-121.19196, 37.80778], [-121.19186, 37.80769], [-121.19374, 37.80724], [-121.19402, 37.80724], [-121.19402, 37.80697], [-121.19421, 37.80697], [-121.19446, 37.807], [-121.19473, 37.80711], [-121.19482, 37.80711], [-121.19492, 37.80707]]]]} | Open Access 1 | 36058 | Sierra Creek Park | 25452 | 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.857 | Sierra Creek Park | 0 | Local Park 2 | 4 | |
12034 | 12034 | 12033 | {"type": "MultiPolygon", "coordinates": [[[[-121.24627, 37.79512], [-121.24592, 37.7952], [-121.24591, 37.79488], [-121.24626, 37.7948], [-121.24627, 37.79512]]], [[[-121.24786, 37.79474], [-121.24747, 37.79487], [-121.24738, 37.79485], [-121.2473, 37.79485], [-121.24707, 37.79493], [-121.24652, 37.79506], [-121.24646, 37.79505], [-121.24644, 37.79502], [-121.24643, 37.79476], [-121.24785, 37.79442], [-121.24786, 37.79474]]], [[[-121.2501, 37.79422], [-121.24975, 37.7943], [-121.24976, 37.79424], [-121.24983, 37.79416], [-121.24982, 37.79406], [-121.24977, 37.79401], [-121.24972, 37.79399], [-121.2496, 37.79399], [-121.24952, 37.79404], [-121.24949, 37.79411], [-121.2495, 37.79417], [-121.24957, 37.79426], [-121.24958, 37.79434], [-121.24815, 37.79468], [-121.24814, 37.79424], [-121.24821, 37.79423], [-121.24907, 37.79403], [-121.24908, 37.79376], [-121.25009, 37.79376], [-121.2501, 37.79422]]]]} | Open Access 1 | 24710 | Gonsalves Park | 19391 | 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.593 | Gonsalves Park | 0 | Local Park 2 | 4 | |
12666 | 12666 | 12665 | {"type": "MultiPolygon", "coordinates": [[[[-121.26306, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26306, 37.78131]]], [[[-121.26389, 37.78023], [-121.26379, 37.7806], [-121.26342, 37.78054], [-121.26353, 37.78016], [-121.26389, 37.78023]]]]} | Open Access 1 | 48799 | Dutra Estates Mini Park | 33521 | 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.343 | Dutra Estates MP | 0 | Local Park 2 | 4 | |
12035 | 12035 | 12034 | {"type": "Polygon", "coordinates": [[[-121.1892, 37.80763], [-121.18922, 37.80862], [-121.1892, 37.80865], [-121.18889, 37.80873], [-121.18867, 37.80881], [-121.18813, 37.80908], [-121.18786, 37.80918], [-121.18757, 37.80925], [-121.18725, 37.80929], [-121.18721, 37.8084], [-121.18685, 37.80839], [-121.18685, 37.80824], [-121.18687, 37.80811], [-121.18686, 37.80803], [-121.18703, 37.80765], [-121.1892, 37.80763]]]} | Open Access 1 | 24711 | Springport Park | 25748 | 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.1 | Springport 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 | |
13689 | 13689 | 13688 | {"type": "Polygon", "coordinates": [[[-121.19597, 37.77707], [-121.19556, 37.77889], [-121.19543, 37.7792], [-121.19507, 37.77908], [-121.19475, 37.77889], [-121.19452, 37.7787], [-121.19422, 37.77836], [-121.19399, 37.77815], [-121.19376, 37.77799], [-121.19301, 37.77755], [-121.19287, 37.77743], [-121.19287, 37.7774], [-121.19289, 37.77737], [-121.19301, 37.77732], [-121.19322, 37.77722], [-121.19355, 37.7771], [-121.19373, 37.77709], [-121.19396, 37.77716], [-121.19409, 37.77716], [-121.1942, 37.77711], [-121.19437, 37.77698], [-121.19452, 37.77694], [-121.19483, 37.77693], [-121.19515, 37.77695], [-121.19597, 37.77707]]]} | Open Access 1 | 36061 | Tesoro Park | 26270 | 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.456 | Tesoro Park | 0 | Local Park 2 | 4 | |
13685 | 13685 | 13684 | {"type": "Polygon", "coordinates": [[[-121.19669, 37.80654], [-121.19659, 37.80654], [-121.19656, 37.8066], [-121.19662, 37.80685], [-121.19659, 37.8069], [-121.19511, 37.80739], [-121.19479, 37.8073], [-121.19528, 37.80649], [-121.19539, 37.80634], [-121.19557, 37.80615], [-121.19585, 37.80592], [-121.19593, 37.80593], [-121.19669, 37.80654]]]} | Open Access 1 | 36057 | Button Estates Park | 16612 | 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.552 | Button Estates Park | 0 | Local Park 2 | 4 | |
13684 | 13684 | 13683 | {"type": "Polygon", "coordinates": [[[-121.20077, 37.81086], [-121.20103, 37.81084], [-121.20126, 37.81079], [-121.20143, 37.8107], [-121.20166, 37.81053], [-121.20172, 37.81052], [-121.20258, 37.81121], [-121.20269, 37.81132], [-121.2027, 37.81136], [-121.20267, 37.8114], [-121.20263, 37.8114], [-121.20077, 37.81141], [-121.20073, 37.81139], [-121.20071, 37.81136], [-121.20071, 37.81092], [-121.20072, 37.81088], [-121.20077, 37.81086]]]} | Open Access 1 | 36056 | Rodoni Park | 24552 | 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 | 2.74 | Rodoni Park | 0 | Local Park 2 | 4 | |
6718 | 6718 | 6717 | {"type": "Polygon", "coordinates": [[[-121.20187, 37.76481], [-121.20189, 37.76569], [-121.20187, 37.76576], [-121.20182, 37.7658], [-121.20174, 37.76582], [-121.20079, 37.76583], [-121.19993, 37.76587], [-121.19989, 37.76586], [-121.19986, 37.76584], [-121.19984, 37.76481], [-121.20187, 37.76481]]]} | Open Access 1 | 48416 | Pillsbury Park | 33013 | 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.05 | Pillsbury 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 | |
2527 | 2527 | 2526 | {"type": "Polygon", "coordinates": [[[-121.20557, 37.80651], [-121.20555, 37.80835], [-121.20549, 37.80876], [-121.20552, 37.80914], [-121.20552, 37.80924], [-121.20542, 37.80943], [-121.20537, 37.80949], [-121.2053, 37.80953], [-121.20407, 37.80857], [-121.20399, 37.80846], [-121.20396, 37.80838], [-121.20395, 37.80656], [-121.204, 37.80651], [-121.20557, 37.80651]]]} | Open Access 1 | 17733 | Shasta Park | 25369 | 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.809 | Shasta 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 | |
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 | |
14821 | 14821 | 14820 | {"type": "Polygon", "coordinates": [[[-121.21025, 37.77704], [-121.21027, 37.77717], [-121.21023, 37.77727], [-121.21013, 37.77738], [-121.20999, 37.77744], [-121.20984, 37.77746], [-121.20966, 37.77742], [-121.20953, 37.77732], [-121.20946, 37.77719], [-121.20946, 37.77709], [-121.20951, 37.77697], [-121.20962, 37.77688], [-121.20976, 37.77682], [-121.2099, 37.77681], [-121.21005, 37.77685], [-121.21019, 37.77694], [-121.21025, 37.77704]]]} | Open Access 1 | 47255 | Paseo Circle Park | 30966 | 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.978 | Paseo Circle 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 | |
3399 | 3399 | 3398 | {"type": "Polygon", "coordinates": [[[-121.21194, 37.80024], [-121.21149, 37.80025], [-121.21149, 37.7997], [-121.21192, 37.7997], [-121.21194, 37.80024]]]} | Open Access 1 | 24694 | Hildebrand Park | 19958 | 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.581 | Hildebrand Park | 0 | Local Park 2 | 4 | |
6753 | 6753 | 6752 | {"type": "Polygon", "coordinates": [[[-121.21194, 37.76483], [-121.21187, 37.76508], [-121.21159, 37.76557], [-121.21149, 37.76586], [-121.21144, 37.76588], [-121.21108, 37.76588], [-121.21081, 37.76585], [-121.21064, 37.76579], [-121.21042, 37.76566], [-121.2103, 37.76555], [-121.21018, 37.76536], [-121.21014, 37.76514], [-121.21014, 37.76454], [-121.21015, 37.7644], [-121.21024, 37.7642], [-121.21033, 37.76408], [-121.21046, 37.76397], [-121.2106, 37.76389], [-121.21085, 37.76381], [-121.21153, 37.76374], [-121.21157, 37.76377], [-121.21178, 37.76409], [-121.21187, 37.76427], [-121.21194, 37.76455], [-121.21194, 37.76483]]]} | Open Access 1 | 48417 | Evans Estates Park | 33014 | 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.541 | Evans Estates Park | 2017 | Local Park 2 | 4 | |
10087 | 10087 | 10086 | {"type": "Polygon", "coordinates": [[[-121.21854, 37.79382], [-121.21853, 37.79453], [-121.21841, 37.79453], [-121.21719, 37.79382], [-121.21854, 37.79382]]]} | Open Access 1 | 17574 | Baccilieri Park | 15748 | 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.261 | Baccilieri 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 | |
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 |
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]);