units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 481 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 7
- Local Park 54
- Local Recreation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Manteca, City of · 61 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
12637 | 12637 | 12636 | {"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 | 48798 | Palmer Memorial | 33520 | 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.463 | Palmer Memorial | None 1095 | |||
12662 | 12662 | 12661 | {"type": "Polygon", "coordinates": [[[-121.20155, 37.78832], [-121.20155, 37.78832], [-121.19838, 37.78833], [-121.20016, 37.78641], [-121.20028, 37.78642], [-121.20056, 37.78639], [-121.20061, 37.78634], [-121.2015, 37.78686], [-121.20155, 37.78832]]]} | Open Access 1 | 48800 | Spreckels Park BMX | 33522 | 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 | https://www.usabmx.com/tracks/1770/pages/24 | San Joaquin 39 | 9.989 | Spreckels Park BMX | None 1098 | ||
13693 | 13693 | 13692 | {"type": "MultiPolygon", "coordinates": [[[[-121.21616, 37.79541], [-121.21614, 37.79551], [-121.21608, 37.79553], [-121.21572, 37.79539], [-121.21485, 37.79488], [-121.21484, 37.79484], [-121.21353, 37.79407], [-121.21372, 37.79384], [-121.21159, 37.79259], [-121.21138, 37.7928], [-121.20766, 37.79062], [-121.20785, 37.79039], [-121.2015, 37.78665], [-121.20149, 37.78648], [-121.21614, 37.79509], [-121.21616, 37.79541]]], [[[-121.21703, 37.79583], [-121.21651, 37.79553], [-121.21651, 37.79547], [-121.21703, 37.79577], [-121.21703, 37.79583]]], [[[-121.21762, 37.79618], [-121.2171, 37.79588], [-121.2171, 37.79581], [-121.21762, 37.79612], [-121.21762, 37.79618]]], [[[-121.21966, 37.79732], [-121.21948, 37.79732], [-121.21908, 37.79703], [-121.21781, 37.79629], [-121.2178, 37.79623], [-121.21966, 37.79732]]], [[[-121.22247, 37.79901], [-121.22206, 37.79901], [-121.22028, 37.79796], [-121.22028, 37.79785], [-121.22008, 37.79774], [-121.22011, 37.7977], [-121.22145, 37.79848], [-121.2215, 37.79844], [-121.22247, 37.79901]]], [[[-121.22609, 37.80464], [-121.22574, 37.80466], [-121.22564, 37.80175], [-121.2256, 37.80152], [-121.22552, 37.8013], [-121.2254, 37.8011], [-121.22533, 37.80109], [-121.22532, 37.80093], [-121.22287, 37.79949], [-121.22287, 37.79923], [-121.22291, 37.79923], [-121.22416, 37.79997], [-121.22446, 37.79997], [-121.22596, 37.80086], [-121.22609, 37.80464]]], [[[-121.22634, 37.81181], [-121.22599, 37.81181], [-121.2259, 37.80905], [-121.22575, 37.80482], [-121.22609, 37.8048], [-121.22634, 37.81181]]], [[[-121.22663, 37.81895], [-121.22628, 37.81895], [-121.226, 37.81204], [-121.22635, 37.81204], [-121.22663, 37.81895]]], [[[-121.22693, 37.82634], [-121.22658, 37.82634], [-121.22629, 37.81918], [-121.22663, 37.81918], [-121.22664, 37.8192], [-121.22655, 37.81921], [-121.22673, 37.82364], [-121.22682, 37.82365], [-121.22693, 37.82634]]]]} | Open Access 1 | 36063 | Tidewater Bikeway | 26349 | 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 | 35.162 | Tidewater Bikeway | None 1177 | |||
13694 | 13694 | 13693 | {"type": "Polygon", "coordinates": [[[-121.2821, 37.8378], [-121.28209, 37.83823], [-121.28203, 37.8386], [-121.28181, 37.83922], [-121.2817, 37.83927], [-121.28147, 37.83925], [-121.27935, 37.83923], [-121.27926, 37.83916], [-121.27926, 37.83863], [-121.27921, 37.83832], [-121.2791, 37.83806], [-121.27894, 37.83782], [-121.2821, 37.8378]]]} | Open Access 1 | 36065 | Apolinar Sangalang | 15536 | 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.745 | Apolinar Sangalang | None 1178 | |||
2161 | 2161 | 2160 | {"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 | 17581 | Bay Meadows Park | 15875 | 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.899 | Bay Meadows Park | 0 | Local Park 2 | 4 | |
2170 | 2170 | 2169 | {"type": "Polygon", "coordinates": [[[-121.23276, 37.80831], [-121.23277, 37.80927], [-121.23117, 37.80928], [-121.2311, 37.80828], [-121.23114, 37.80805], [-121.23274, 37.80803], [-121.23276, 37.80831]]]} | Open Access 1 | 17652 | Greystone Park | 19507 | 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 | Greystone Park | 0 | Local Park 2 | 4 | |
2517 | 2517 | 2516 | {"type": "Polygon", "coordinates": [[[-121.23998, 37.82039], [-121.24146, 37.82038], [-121.24145, 37.82168], [-121.24138, 37.82163], [-121.24131, 37.82161], [-121.24105, 37.82164], [-121.23872, 37.82166], [-121.23868, 37.82046], [-121.2394, 37.82044], [-121.23974, 37.8204], [-121.23998, 37.82039]]]} | Open Access 1 | 17628 | Doxey Park | 18257 | 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.276 | Doxey Park | 0 | Local Park 2 | 4 | |
2526 | 2526 | 2525 | {"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.7888], [-121.22738, 37.78829], [-121.22761, 37.78827], [-121.22922, 37.78828]]]} | Open Access 1 | 17730 | Sequoia Park | 25309 | 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 | Sequoia 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 | |
2529 | 2529 | 2528 | {"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 | 17737 | Southside Park | 25698 | 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.308 | Southside Park | 0 | Local Park 2 | 4 | |
2533 | 2533 | 2532 | {"type": "Polygon", "coordinates": [[[-121.23693, 37.79381], [-121.23484, 37.79382], [-121.23479, 37.79323], [-121.23566, 37.79322], [-121.23559, 37.79197], [-121.23681, 37.79198], [-121.23693, 37.79381]]]} | Open Access 1 | 17746 | Union West Park | 26663 | 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.677 | Union West Park | 0 | Local Park 2 | 4 | |
2538 | 2538 | 2537 | {"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 | 17768 | Yosemite Park | 27784 | 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.992 | Yosemite Park | 0 | Local Park 2 | 4 | |
2603 | 2603 | 2602 | {"type": "Polygon", "coordinates": [[[-121.22864, 37.8225], [-121.22678, 37.82253], [-121.22665, 37.81919], [-121.22692, 37.81918], [-121.227, 37.8192], [-121.22709, 37.8192], [-121.22738, 37.81924], [-121.22769, 37.8193], [-121.2281, 37.81944], [-121.22844, 37.8196], [-121.22864, 37.8225]]]} | Open Access 1 | 17699 | Northgate Park | 22873 | 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 | 14.058 | Northgate 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 | |
3912 | 3912 | 3911 | {"type": "Polygon", "coordinates": [[[-121.22191, 37.77801], [-121.22165, 37.77822], [-121.22106, 37.77775], [-121.22032, 37.77775], [-121.22031, 37.77702], [-121.22069, 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], [-121.2222, 37.77771], [-121.22194, 37.77788], [-121.2219, 37.77796], [-121.22191, 37.77801]]]} | Open Access 1 | 36059 | Terra Bella Park | 26251 | 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.382 | Terra Bella Park | 0 | Local Park 2 | 4 | |
5125 | 5125 | 5124 | {"type": "Polygon", "coordinates": [[[-121.22266, 37.80051], [-121.22266, 37.80092], [-121.22249, 37.80092], [-121.22249, 37.80051], [-121.22266, 37.80051]]]} | Open Access 1 | 36064 | 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.172 | MP | 0 | Local Park 2 | 4 | |
5480 | 5480 | 5479 | {"type": "Polygon", "coordinates": [[[-121.24032, 37.81621], [-121.24028, 37.81637], [-121.23903, 37.81637], [-121.23899, 37.81629], [-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 | 17727 | Saint Francis Park | 24788 | 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.69 | Saint Francis 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 | |
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 |
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]);