units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
335 rows where COUNTY = 39 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
DES_TP 29
- Local Park 270
- Local Recreation Area 20
- Local Other or Unknown 8
- State Conservation Area 5
- Private Recreation or Education 4
- Private Conservation 3
- Local Conservation Area 2
- State Resource Management Area 2
- State Park 1
- State Recreation Area 1
- Recreation Management Area 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 21
- Stockton, City of 81
- Tracy, City of 73
- Manteca, City of 61
- Lodi, City of 27
- San Joaquin, County of 21
- Ripon, City of 21
- Lathrop, City of 12
- Escalon, City of 10
- California Department of Fish and Wildlife 7
- Mountain House Community Services District 7
- California Department of Parks and Recreation 2
- The Nature Conservancy 2
- East Bay Municipal Utility District 2
- Woodbridge Owners Association 2
- Riverbank, City of 1
- United States Fish and Wildlife Service 1
- Center for Natural Lands Management 1
- United States Army Corps of Engineers 1
- California Department of Water Resources 1
- Del Webb 1
- Lincoln Village Home Association 1
MNG_AG_TYP 8
ACCESS_TYP 3
- Open Access 312
- Restricted Access 16
- No Public Access 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2605 | 2605 | 2604 | {"type": "Polygon", "coordinates": [[[-121.15097, 37.72216], [-121.15092, 37.72224], [-121.15022, 37.72251], [-121.14996, 37.72257], [-121.14906, 37.72258], [-121.14871, 37.72256], [-121.14713, 37.72287], [-121.14715, 37.71763], [-121.14757, 37.71777], [-121.14796, 37.71805], [-121.14839, 37.71831], [-121.14897, 37.71837], [-121.14937, 37.71847], [-121.14966, 37.71865], [-121.15025, 37.71934], [-121.15054, 37.71945], [-121.15091, 37.71949], [-121.15098, 37.72192], [-121.15097, 37.72216]]]} | Restricted Access 2 | 17440 | San Joaquin National Wildlife Refuge | 24912 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | San Joaquin 39 | 37.381 | San Joaquin NWR | 0 | National Wildlife Refuge 105 | 2 | |
16732 | 16732 | 16731 | {"type": "Polygon", "coordinates": [[[-121.01374, 37.75437], [-121.01373, 37.7545], [-121.01301, 37.755], [-121.01238, 37.75508], [-121.01166, 37.75503], [-121.01108, 37.75503], [-121.01074, 37.7551], [-121.0102, 37.75528], [-121.01022, 37.75749], [-121.01034, 37.75767], [-121.01005, 37.75774], [-121.01003, 37.75498], [-121.01044, 37.75499], [-121.01078, 37.75439], [-121.0108, 37.75364], [-121.01074, 37.75322], [-121.01058, 37.75288], [-121.01036, 37.75269], [-121.01021, 37.75222], [-121.00956, 37.75208], [-121.00872, 37.75173], [-121.00845, 37.75113], [-121.0084, 37.75073], [-121.00826, 37.75062], [-121.0081, 37.75058], [-121.00782, 37.7506], [-121.00752, 37.75067], [-121.00731, 37.75075], [-121.00726, 37.7507], [-121.00736, 37.75051], [-121.00732, 37.74994], [-121.00762, 37.74926], [-121.00811, 37.74904], [-121.00902, 37.74897], [-121.00982, 37.74905], [-121.01015, 37.74927], [-121.01079, 37.74964], [-121.01155, 37.74982], [-121.01204, 37.74968], [-121.01251, 37.74962], [-121.0127, 37.75005], [-121.01255, 37.75045], [-121.01216, 37.75078], [-121.01147, 37.75101], [-121.01094, 37.75128], [-121.01077, 37.75164], [-121.01095, 37.75201], [-121.01138, 37.75228], [-121.01218, 37.7526], [-121.01235, 37.75306], [-121.01234, 37.7532], [-121.01213, 37.75359], [-121.01232, 37.75404], [-121.01281, 37.75419], [-121.01333, 37.7542], [-121.01374, 37.75437]]]} | Open Access 1 | 36069 | McHenry Recreation Area | 22039 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | San Joaquin 39 | 40.217 | McHenry Rec. Area | 0 | Recreation Management Area 49 | 4 | |
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 | |
1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | 47779 | Shady Forest | 31579 | 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.969 | Shady Forest | 0 | Local Resource Management Area 83 | 3 | |
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 | |
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 | |
2156 | 2156 | 2155 | {"type": "Polygon", "coordinates": [[[-121.28501, 38.10685], [-121.28445, 38.10686], [-121.28433, 38.1068], [-121.28356, 38.1068], [-121.2835, 38.10654], [-121.28339, 38.10629], [-121.28326, 38.10609], [-121.28361, 38.10593], [-121.28346, 38.10569], [-121.28331, 38.10558], [-121.28317, 38.10552], [-121.28316, 38.10536], [-121.28332, 38.10543], [-121.2837, 38.10552], [-121.28457, 38.10553], [-121.28457, 38.10582], [-121.28463, 38.10586], [-121.2846, 38.10591], [-121.28458, 38.10598], [-121.28458, 38.10638], [-121.28463, 38.10648], [-121.2846, 38.1065], [-121.2846, 38.10679], [-121.28501, 38.1068], [-121.28501, 38.10685]]]} | Open Access 1 | 17504 | English Oaks Common | 18677 | 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 | 3.69 | English Oaks Common | None 176 | |||
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 | |
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 | |
2474 | 2474 | 2473 | {"type": "Polygon", "coordinates": [[[-121.28576, 37.81299], [-121.28485, 37.81299], [-121.28484, 37.81271], [-121.28485, 37.81246], [-121.28573, 37.81245], [-121.28576, 37.81299]]]} | Open Access 1 | 17465 | Libby Park | 21204 | 1171 | Lathrop, City of 528 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | San Joaquin 39 | 1.168 | Libby Park | 0 | Local Park 2 | 4 | |
2478 | 2478 | 2477 | {"type": "Polygon", "coordinates": [[[-121.2814, 37.82711], [-121.28042, 37.82713], [-121.28035, 37.82717], [-121.28021, 37.82736], [-121.27992, 37.82724], [-121.27981, 37.82734], [-121.27945, 37.82729], [-121.27851, 37.82729], [-121.27851, 37.82719], [-121.27836, 37.82719], [-121.27838, 37.82644], [-121.28137, 37.82643], [-121.2814, 37.82711]]]} | Open Access 1 | 17472 | Woodfield Park | 27709 | 1171 | Lathrop, City of 528 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | San Joaquin 39 | 5.76 | Woodfield 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]);