units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
270 rows where ACCESS_TYP = 1, COUNTY = 39 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
528 | 528 | 527 | {"type": "Polygon", "coordinates": [[[-120.99373, 37.80488], [-120.99366, 37.80493], [-120.99264, 37.80493], [-120.99262, 37.80436], [-120.99338, 37.80437], [-120.99339, 37.80445], [-120.99372, 37.80445], [-120.99373, 37.80488]]]} | Open Access 1 | 48896 | Sunrise Park | 33613 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 1.418 | Sunrise Park | 0 | Local Park 2 | 4 | |
1418 | 1418 | 1417 | {"type": "Polygon", "coordinates": [[[-120.98454, 37.80016], [-120.9842, 37.8001], [-120.9829, 37.80009], [-120.98285, 37.80005], [-120.9829, 37.79972], [-120.98291, 37.79909], [-120.98454, 37.79912], [-120.98454, 37.80016]]]} | Open Access 1 | 24699 | Brentwood Park | 16359 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 3.969 | Brentwood Park | 0 | Local Park 2 | 4 | |
1521 | 1521 | 1520 | {"type": "Polygon", "coordinates": [[[-120.99672, 37.80546], [-120.99665, 37.80552], [-120.99623, 37.80552], [-120.99623, 37.80524], [-120.99672, 37.80525], [-120.99672, 37.80546]]]} | Open Access 1 | 24700 | Dinosaur Park | 18157 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 0.329 | Dinosaur Park | 0 | Local Park 2 | 4 | |
1626 | 1626 | 1625 | {"type": "Polygon", "coordinates": [[[-121.4747, 37.74883], [-121.47108, 37.75046], [-121.47055, 37.74971], [-121.4706, 37.7496], [-121.47262, 37.74865], [-121.47268, 37.74866], [-121.47276, 37.74864], [-121.47341, 37.74834], [-121.4747, 37.74883]]]} | Open Access 1 | 24718 | Clyde Bland Park | 17450 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 8.607 | Clyde Bland Park | 0 | Local Park 2 | 4 | |
2077 | 2077 | 2076 | {"type": "Polygon", "coordinates": [[[-121.46933, 37.73897], [-121.46926, 37.73902], [-121.46447, 37.73903], [-121.4644, 37.73898], [-121.4644, 37.73676], [-121.46924, 37.73675], [-121.4693, 37.73708], [-121.46932, 37.73731], [-121.46933, 37.73897]]]} | Open Access 1 | 24719 | Busch Park | 16537 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 27.011 | Busch Park | 0 | Local Park 2 | 4 | |
2102 | 2102 | 2101 | {"type": "Polygon", "coordinates": [[[-121.24742, 37.78011], [-121.24712, 37.78043], [-121.24704, 37.78042], [-121.24697, 37.78038], [-121.24671, 37.78028], [-121.24642, 37.7802], [-121.24629, 37.78019], [-121.24604, 37.78017], [-121.24437, 37.78015], [-121.24434, 37.77915], [-121.24664, 37.77916], [-121.24685, 37.77948], [-121.247, 37.77966], [-121.24742, 37.78011]]]} | Open Access 1 | 17326 | Dutra Farms Park | 18322 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 6.845 | Dutra Farms Park | 0 | Local Park 2 | 4 | |
2103 | 2103 | 2102 | {"type": "Polygon", "coordinates": [[[-121.22907, 37.96168], [-121.22714, 37.96217], [-121.2263, 37.96022], [-121.22824, 37.95977], [-121.22907, 37.96168]]]} | Open Access 1 | 17329 | East Side Community Park | 18381 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 9.964 | East Side Community Park | 0 | Local Park 2 | 4 | |
2113 | 2113 | 2112 | {"type": "Polygon", "coordinates": [[[-121.21493, 37.83128], [-121.21276, 37.83129], [-121.21216, 37.8312], [-121.21197, 37.83116], [-121.21241, 37.83019], [-121.21203, 37.83013], [-121.21229, 37.83013], [-121.21297, 37.8302], [-121.21302, 37.82992], [-121.21309, 37.82994], [-121.21307, 37.8302], [-121.21358, 37.83025], [-121.21406, 37.83028], [-121.21458, 37.83048], [-121.21483, 37.83072], [-121.21495, 37.83107], [-121.21493, 37.83128]]]} | Open Access 1 | 17356 | Raymus Village Park | 24207 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 6.539 | Raymus Village Park | 0 | Local Park 2 | 4 | |
2152 | 2152 | 2151 | {"type": "Polygon", "coordinates": [[[-121.00859, 37.79287], [-121.00736, 37.7929], [-121.00734, 37.79128], [-121.0082, 37.79129], [-121.00852, 37.79131], [-121.00856, 37.79155], [-121.00858, 37.79228], [-121.00861, 37.79243], [-121.00862, 37.79269], [-121.00859, 37.79287]]]} | Open Access 1 | 17451 | Charlie Sanchez Park | 17147 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 4.728 | Charlie Sanchez Park | 0 | Local Park 2 | 4 | |
2155 | 2155 | 2154 | {"type": "Polygon", "coordinates": [[[-121.29053, 38.10816], [-121.28925, 38.10816], [-121.28872, 38.10812], [-121.28828, 38.10812], [-121.28822, 38.1081], [-121.2882, 38.10806], [-121.28819, 38.10742], [-121.28812, 38.10692], [-121.28795, 38.10643], [-121.28759, 38.10582], [-121.28759, 38.10578], [-121.28763, 38.10575], [-121.28782, 38.10569], [-121.28839, 38.10557], [-121.28897, 38.10552], [-121.28911, 38.10553], [-121.28928, 38.10558], [-121.28944, 38.10567], [-121.28956, 38.10568], [-121.28976, 38.10608], [-121.29045, 38.10607], [-121.29053, 38.10816]]]} | Open Access 1 | 17475 | Beckman Park | 15946 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 14.259 | Beckman 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 | |
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 | |
2196 | 2196 | 2195 | {"type": "Polygon", "coordinates": [[[-121.30277, 38.02613], [-121.30065, 38.02612], [-121.30063, 38.02519], [-121.30068, 38.02516], [-121.30275, 38.02517], [-121.30278, 38.02522], [-121.30277, 38.02613]]]} | Open Access 1 | 17836 | Cortez Park | 17663 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.922 | Cortez Park | 0 | Local Park 2 | 4 | |
2226 | 2226 | 2225 | {"type": "Polygon", "coordinates": [[[-121.26759, 37.95177], [-121.26567, 37.95226], [-121.26566, 37.95227], [-121.2657, 37.95235], [-121.26318, 37.95299], [-121.26262, 37.95157], [-121.26601, 37.95053], [-121.26631, 37.95045], [-121.26724, 37.95031], [-121.26752, 37.95152], [-121.26759, 37.95177]]]} | Open Access 1 | 17937 | Stribley Park | 25923 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 17.823 | Stribley Park | 0 | Local Park 2 | 4 | |
2242 | 2242 | 2241 | {"type": "Polygon", "coordinates": [[[-121.42572, 37.74329], [-121.42566, 37.7433], [-121.42566, 37.74341], [-121.42126, 37.74341], [-121.42125, 37.74213], [-121.42571, 37.74214], [-121.42572, 37.74329]]]} | Open Access 1 | 18006 | Lincoln Park | 21273 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 13.731 | Lincoln Park | 0 | Local Park 2 | 4 | |
2397 | 2397 | 2396 | {"type": "Polygon", "coordinates": [[[-121.27344, 38.10513], [-121.27328, 38.10722], [-121.27288, 38.10726], [-121.27209, 38.10742], [-121.27084, 38.10783], [-121.27025, 38.1079], [-121.26982, 38.10791], [-121.26976, 38.10786], [-121.2697, 38.10529], [-121.27344, 38.10513]]]} | Open Access 1 | 17559 | Salas Park | 24793 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 20.79 | Salas Park | 0 | Local Park 2 | 4 | |
2439 | 2439 | 2438 | {"type": "Polygon", "coordinates": [[[-121.3286, 37.97085], [-121.32856, 37.9709], [-121.32746, 37.97116], [-121.32692, 37.96977], [-121.32799, 37.96951], [-121.32807, 37.96952], [-121.32826, 37.96996], [-121.3286, 37.97085]]]} | Open Access 1 | 17340 | Madison Park | 21658 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 4.222 | Madison Park | 0 | Local Park 2 | 4 | |
2444 | 2444 | 2443 | {"type": "Polygon", "coordinates": [[[-121.30752, 37.78825], [-121.30752, 37.78843], [-121.30743, 37.78897], [-121.30731, 37.78924], [-121.30701, 37.79015], [-121.30278, 37.79034], [-121.30342, 37.78935], [-121.30752, 37.78825]]]} | Open Access 1 | 17346 | Mossdale Crossing Regional Park | 22514 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 13.925 | Mossdale Crossing RP | 0 | Local Park 2 | 4 | |
2445 | 2445 | 2444 | {"type": "Polygon", "coordinates": [[[-121.37192, 38.0577], [-121.37186, 38.05778], [-121.3718, 38.05781], [-121.37037, 38.05782], [-121.36106, 38.05763], [-121.36026, 38.05038], [-121.36994, 38.05064], [-121.3703, 38.05175], [-121.37157, 38.05586], [-121.37192, 38.0577]]]} | Open Access 1 | 17349 | Oak Grove Regional Park | 22975 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 179.768 | Oak Grove RP | 0 | Local Park 2 | 4 | |
2471 | 2471 | 2470 | {"type": "Polygon", "coordinates": [[[-121.00052, 37.80476], [-120.99775, 37.80476], [-120.99775, 37.80422], [-120.997, 37.80422], [-120.99695, 37.80279], [-120.99712, 37.80268], [-120.99762, 37.80272], [-120.9979, 37.80278], [-120.99828, 37.80295], [-120.99856, 37.80313], [-121.00052, 37.80476]]]} | Open Access 1 | 17457 | Hogan Park | 20025 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 10.311 | Hogan 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]);