superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where MNG_AGENCY = 481 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
518 | 518 | 517 | {"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 | Dutra Estates Mini Park | 33521 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.343 | Dutra Estates MP | ||
11306 | 11306 | 11305 | {"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 | Wilson Park | 27611 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.381 | Wilson Park | ||
15535 | 15535 | 15534 | {"type": "Polygon", "coordinates": [[[-121.22007, 37.79923], [-121.22006, 37.79965], [-121.21962, 37.79965], [-121.21962, 37.79923], [-121.22007, 37.79923]]]} | Open Access 1 | Center St Tennis Courts | 17039 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.461 | Ctr. St Tennis Courts | ||
6157 | 6157 | 6156 | {"type": "Polygon", "coordinates": [[[-121.22006, 37.79845], [-121.21966, 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 | Library Park | 21219 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.514 | Library Park | ||
7033 | 7033 | 7032 | {"type": "MultiPolygon", "coordinates": [[[[-121.22073, 37.79865], [-121.22073, 37.79901], [-121.22027, 37.79901], [-121.22029, 37.79865], [-121.22073, 37.79865]]], [[[-121.22266, 37.80051], [-121.22266, 37.80092], [-121.22249, 37.80092], [-121.22249, 37.80051], [-121.22266, 37.80051]]]]} | Open Access 1 | Mini Park | 22267 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.562 | MP | ||
520 | 520 | 519 | {"type": "Polygon", "coordinates": [[[-121.23282, 37.80117], [-121.23204, 37.8012], [-121.23203, 37.80089], [-121.23282, 37.80088], [-121.23282, 37.80117]]]} | Open Access 1 | Manteca Dog Park | 33519 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.571 | Manteca Dog Park | ||
5148 | 5148 | 5147 | {"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 | Hildebrand Park | 19958 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.58 | Hildebrand Park | ||
13545 | 13545 | 13544 | {"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 | Paseo Circle Park | 30966 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.977 | Paseo Circle Park | ||
1712 | 1712 | 1711 | {"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 | Baccilieri Park | 15748 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1.261 | Baccilieri Park | ||
5491 | 5491 | 5490 | {"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 | William Martin Park | 33016 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1.56 | William Martin Park | ||
3754 | 3754 | 3753 | {"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 | Dutra Northeast | 18323 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1.666 | Dutra Northeast | ||
11010 | 11010 | 11009 | {"type": "Polygon", "coordinates": [[[-121.22719, 37.80158], [-121.22687, 37.80192], [-121.22675, 37.80185], [-121.22662, 37.80184], [-121.22655, 37.80187], [-121.2265, 37.80191], [-121.22643, 37.80208], [-121.226, 37.80209], [-121.22596, 37.80086], [-121.22719, 37.80158]]]} | Open Access 1 | Walnut Place Park | 27242 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 2.045 | Walnut Place Park | ||
8898 | 8898 | 8897 | {"type": "Polygon", "coordinates": [[[-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], [-121.20103, 37.81085], [-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]]]} | Open Access 1 | Rodoni Park | 24552 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 2.74 | Rodoni Park | ||
5478 | 5478 | 5477 | {"type": "Polygon", "coordinates": [[[-121.2517, 37.81523], [-121.25103, 37.81524], [-121.24931, 37.81423], [-121.24937, 37.81417], [-121.24957, 37.81426], [-121.24958, 37.81428], [-121.24983, 37.81433], [-121.25153, 37.81434], [-121.25157, 37.81439], [-121.25158, 37.81486], [-121.25168, 37.81513], [-121.2517, 37.81523]]]} | Open Access 1 | Monte Bello Park | 33015 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 2.999 | Monte Bello Park | ||
8437 | 8437 | 8436 | {"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 | Quail Ridge Park | 24051 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.043 | Quail Ridge Park | ||
9833 | 9833 | 9832 | {"type": "Polygon", "coordinates": [[[-121.22228, 37.79526], [-121.21996, 37.79526], [-121.21992, 37.79467], [-121.22225, 37.79468], [-121.22228, 37.79526]]]} | Open Access 1 | Southside Park | 25698 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.306 | Southside Park | ||
10287 | 10287 | 10286 | {"type": "Polygon", "coordinates": [[[-121.22222, 37.77766], [-121.2222, 37.77771], [-121.22194, 37.77788], [-121.2219, 37.77796], [-121.22191, 37.77801], [-121.22165, 37.77822], [-121.22106, 37.77775], [-121.22032, 37.77775], [-121.22031, 37.77702], [-121.22068, 37.77702], [-121.22073, 37.77699], [-121.22084, 37.77702], [-121.22107, 37.777], [-121.2212, 37.777], [-121.22141, 37.77705], [-121.22159, 37.77714], [-121.22222, 37.77766]]]} | Open Access 1 | Terra Bella Park | 26251 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.383 | Terra Bella Park | ||
1731 | 1731 | 1730 | {"type": "Polygon", "coordinates": [[[-121.19669, 37.80654], [-121.19659, 37.80655], [-121.19656, 37.8066], [-121.19662, 37.80685], [-121.19659, 37.8069], [-121.19511, 37.80739], [-121.19479, 37.8073], [-121.19528, 37.8065], [-121.19539, 37.80634], [-121.19557, 37.80615], [-121.19585, 37.80592], [-121.19593, 37.80593], [-121.19669, 37.80654]]]} | Open Access 1 | Button Estates Park | 16612 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.552 | Button Estates Park | ||
4654 | 4654 | 4653 | {"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.24982, 37.79416], [-121.24982, 37.79406], [-121.24977, 37.79401], [-121.24972, 37.79399], [-121.2496, 37.79399], [-121.24952, 37.79403], [-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 | Gonsalves Park | 19391 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.595 | Gonsalves Park | ||
3220 | 3220 | 3219 | {"type": "Polygon", "coordinates": [[[-121.22173, 37.7856], [-121.22167, 37.78562], [-121.22066, 37.78563], [-121.22025, 37.78561], [-121.22021, 37.78558], [-121.2202, 37.78555], [-121.22023, 37.78544], [-121.22032, 37.78518], [-121.22044, 37.78499], [-121.22063, 37.78477], [-121.22081, 37.78461], [-121.22108, 37.78445], [-121.22132, 37.78435], [-121.22158, 37.78427], [-121.22165, 37.7843], [-121.22173, 37.78459], [-121.22174, 37.78557], [-121.22173, 37.7856]]]} | Open Access 1 | Cotta Park | 17681 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.675 | Cotta Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);