units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where LAYER = 2 and MNG_AGENCY = 481 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13688 | 13688 | 13687 | {"type": "Polygon", "coordinates": [[[-121.23203, 37.77687], [-121.23209, 37.7769], [-121.23222, 37.77703], [-121.23228, 37.77715], [-121.23231, 37.77728], [-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]]]} | Open Access 1 | 36060 | Antigua Park | 15518 | 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.062 | Antigua Park | 0 | Local Park 2 | 4 | |
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 | |||
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 | |
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 | |
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 | |
14378 | 14378 | 14377 | {"type": "Polygon", "coordinates": [[[-121.26138, 37.79009], [-121.25703, 37.79011], [-121.25702, 37.78656], [-121.25703, 37.78652], [-121.25707, 37.78649], [-121.25712, 37.78648], [-121.26036, 37.78647], [-121.26065, 37.7865], [-121.26089, 37.78657], [-121.26113, 37.78666], [-121.26137, 37.78679], [-121.26138, 37.79009]]]} | Open Access 1 | 44470 | Big League Dreams Park | 16080 | 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 | 37.84 | Big League Dreams 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 | |
16401 | 16401 | 16400 | {"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 | 24705 | Center St Tennis Courts | 17039 | 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.461 | Ctr. St Tennis Courts | 0 | Local Recreation Area 3 | 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 | |
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 | |
10108 | 10108 | 10107 | {"type": "Polygon", "coordinates": [[[-121.22158, 37.78427], [-121.22162, 37.78428], [-121.22165, 37.7843], [-121.22173, 37.78459], [-121.22174, 37.78557], [-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.78462], [-121.22108, 37.78445], [-121.22132, 37.78435], [-121.22158, 37.78427]]]} | Open Access 1 | 17606 | Cotta Park | 17681 | 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.676 | Cotta Park | 0 | Local Park 2 | 4 | |
10064 | 10064 | 10063 | {"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 | 17618 | Crestwood Park | 17817 | 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.943 | Crestwood 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 | |
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 | |
13690 | 13690 | 13689 | {"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 | 36062 | Dutra Estates Park | 18321 | 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.252 | Dutra Estates 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 | |||
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 | |
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 | |
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 |
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]);