superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where MNG_AGENCY = 481 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9637 | 9637 | 9636 | {"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.19042, 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.19296, 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.19401, 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 | Sierra Creek Park | 25452 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.862 | Sierra Creek Park | ||
1822 | 1822 | 1821 | {"type": "Polygon", "coordinates": [[[-121.22305, 37.80575], [-121.22272, 37.80574], [-121.22144, 37.80574], [-121.22138, 37.80482], [-121.22142, 37.80477], [-121.22263, 37.80477], [-121.22305, 37.80482], [-121.22311, 37.80548], [-121.2231, 37.80563], [-121.22305, 37.80575]]]} | Open Access 1 | Bay Meadows Park | 15875 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.898 | Bay Meadows Park | ||
6783 | 6783 | 6782 | {"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 | Mayors Park | 21980 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.912 | Mayors Park | ||
4359 | 4359 | 4358 | {"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 | Franciscan Park | 19045 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.933 | Franciscan Park | ||
9474 | 9474 | 9473 | {"type": "Polygon", "coordinates": [[[-121.22922, 37.78828], [-121.22926, 37.78884], [-121.22924, 37.78909], [-121.22919, 37.7892], [-121.22909, 37.78923], [-121.22898, 37.78921], [-121.22759, 37.7892], [-121.22755, 37.78907], [-121.22756, 37.78902], [-121.22752, 37.78879], [-121.22738, 37.78829], [-121.22761, 37.78827], [-121.22922, 37.78828]]]} | Open Access 1 | Sequoia Park | 25309 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.933 | Sequoia Park | ||
3330 | 3330 | 3329 | {"type": "Polygon", "coordinates": [[[-121.22324, 37.8247], [-121.22272, 37.8247], [-121.22257, 37.82467], [-121.22247, 37.82469], [-121.22242, 37.82464], [-121.2208, 37.82465], [-121.22082, 37.82401], [-121.22083, 37.82398], [-121.22089, 37.82396], [-121.22247, 37.82396], [-121.22266, 37.82398], [-121.22324, 37.82418], [-121.22324, 37.8247]]]} | Open Access 1 | Crestwood Park | 17817 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.942 | Crestwood Park | ||
9875 | 9875 | 9874 | {"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 | Springtime Park | 25750 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.953 | Springtime Park | ||
3379 | 3379 | 3378 | {"type": "Polygon", "coordinates": [[[-121.20332, 37.79621], [-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]]]} | Open Access 1 | Curran Grove Park | 17860 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.424 | Curran Grove Park | ||
7407 | 7407 | 7406 | {"type": "Polygon", "coordinates": [[[-121.31182, 37.80165], [-121.3115, 37.80161], [-121.31149, 37.80059], [-121.31153, 37.80017], [-121.31152, 37.79944], [-121.3115, 37.79919], [-121.31146, 37.799], [-121.31134, 37.79861], [-121.31125, 37.79843], [-121.31109, 37.79816], [-121.31093, 37.79795], [-121.31078, 37.79779], [-121.31044, 37.79748], [-121.3102, 37.79731], [-121.30996, 37.79717], [-121.31023, 37.79717], [-121.31046, 37.79732], [-121.3114, 37.79785], [-121.3117, 37.79795], [-121.31179, 37.79803], [-121.31184, 37.79812], [-121.31194, 37.79858], [-121.31196, 37.79879], [-121.31192, 37.79935], [-121.3118, 37.80059], [-121.31179, 37.80135], [-121.31182, 37.80165]]]} | Open Access 1 | River Park South | 24423 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.562 | River Park South | ||
7687 | 7687 | 7686 | {"type": "Polygon", "coordinates": [[[-121.24032, 37.81621], [-121.24028, 37.81637], [-121.23903, 37.81637], [-121.23895, 37.81613], [-121.23885, 37.81594], [-121.23875, 37.81564], [-121.23879, 37.81504], [-121.23925, 37.81503], [-121.2395, 37.81506], [-121.24031, 37.81507], [-121.24032, 37.81621]]]} | Open Access 1 | Saint Francis Park | 24788 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.687 | Saint Francis Park | ||
4753 | 4753 | 4752 | {"type": "Polygon", "coordinates": [[[-121.23277, 37.80927], [-121.23117, 37.80928], [-121.2311, 37.80828], [-121.23114, 37.80805], [-121.23274, 37.80803], [-121.23276, 37.80831], [-121.23277, 37.80927]]]} | Open Access 1 | Greystone Park | 19507 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.867 | Greystone Park | ||
3112 | 3112 | 3111 | {"type": "Polygon", "coordinates": [[[-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], [-121.2315, 37.81396], [-121.23155, 37.81401]]]} | Open Access 1 | Colony Park | 17537 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.869 | Colony Park | ||
8831 | 8831 | 8830 | {"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 | Roberts Park | 24495 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.899 | Roberts Park | ||
11436 | 11436 | 11435 | {"type": "Polygon", "coordinates": [[[-121.23294, 37.79362], [-121.23054, 37.79275], [-121.23052, 37.79234], [-121.23286, 37.79226], [-121.23294, 37.79362]]]} | Open Access 1 | Yosemite Park | 27784 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 4.99 | Yosemite Park | ||
5399 | 5399 | 5398 | {"type": "Polygon", "coordinates": [[[-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.76583], [-121.19984, 37.76481], [-121.20187, 37.76481], [-121.20189, 37.76569], [-121.20187, 37.76576]]]} | Open Access 1 | Pillsbury Park | 33013 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 5.05 | Pillsbury Park | ||
1500 | 1500 | 1499 | {"type": "Polygon", "coordinates": [[[-121.23232, 37.77858], [-121.23225, 37.77861], [-121.231, 37.77862], [-121.23097, 37.77861], [-121.23094, 37.77856], [-121.23093, 37.7773], [-121.23094, 37.77728], [-121.23098, 37.77725], [-121.23129, 37.77721], [-121.23148, 37.77716], [-121.2317, 37.77706], [-121.23203, 37.77687], [-121.23209, 37.7769], [-121.23222, 37.77703], [-121.23228, 37.77715], [-121.23231, 37.77728], [-121.23232, 37.77858]]]} | Open Access 1 | Antigua Park | 15518 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 5.062 | Antigua Park | ||
3748 | 3748 | 3747 | {"type": "Polygon", "coordinates": [[[-121.26434, 37.77727], [-121.2643, 37.7773], [-121.26279, 37.77758], [-121.26273, 37.77757], [-121.2627, 37.77753], [-121.2627, 37.77614], [-121.26277, 37.7761], [-121.26424, 37.77609], [-121.26429, 37.77611], [-121.26431, 37.77614], [-121.26432, 37.77709], [-121.26434, 37.77727]]]} | Open Access 1 | Dutra Estates Park | 18321 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 5.252 | Dutra Estates Park | ||
521 | 521 | 520 | {"type": "MultiPolygon", "coordinates": [[[[-121.24019, 37.77305], [-121.24018, 37.7731], [-121.23998, 37.77337], [-121.23992, 37.77352], [-121.23989, 37.7737], [-121.23988, 37.77402], [-121.23987, 37.77407], [-121.23984, 37.77409], [-121.23979, 37.77409], [-121.23941, 37.77402], [-121.23859, 37.77402], [-121.23855, 37.77223], [-121.23874, 37.77223], [-121.23887, 37.77211], [-121.24016, 37.773], [-121.24019, 37.77305]]], [[[-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346]]]]} | Open Access 1 | Palmer Memorial | 33520 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 5.463 | Palmer Memorial | ||
10890 | 10890 | 10889 | {"type": "Polygon", "coordinates": [[[-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.24923, 37.80843], [-121.24918, 37.80841], [-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], [-121.25061, 37.80706], [-121.25063, 37.80709], [-121.25094, 37.80823]]]} | Open Access 1 | Villa Ticino Park | 27107 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 5.592 | Villa Ticino Park | ||
3605 | 3605 | 3604 | {"type": "Polygon", "coordinates": [[[-121.19336, 37.81421], [-121.19333, 37.81426], [-121.19313, 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]]]} | Open Access 1 | Diamond Oaks Park | 18145 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 6.455 | Diamond Oaks 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]);