units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
264 rows where COUNTY = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
MNG_AGENCY 20
- Modesto, City of 78
- Turlock, City of 32
- Patterson, City of 27
- Oakdale, City of 23
- Stanislaus, County of 21
- Riverbank, City of 15
- Ceres, City of 13
- Newman, City of 8
- California Department of Fish and Wildlife 5
- United States Army Corps of Engineers 5
- Waterford, City of 4
- Hughson, City of 4
- Modesto Irrigation District 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- Other State 1
- Sacramento and San Joaquin Drainage District 1
- Friends of the Tuolumne 1
- Turlock Irrigation District 1
- River Partners 1
DES_TP 20
- Local Park 194
- Local Recreation Area 17
- Local Other or Unknown 8
- Recreation Management Area 5
- State Conservation Area 2
- Private Conservation 2
- Local Historic or Cultural Area 2
- State Resource Management Area 2
- National Public Lands 1
- Local Conservation Area 1
- State Recreation Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 7
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9940 | 9940 | 9939 | {"type": "Polygon", "coordinates": [[[-121.02354, 37.60961], [-121.02354, 37.61087], [-121.01634, 37.61091], [-121.01632, 37.60982], [-121.02177, 37.60979], [-121.02179, 37.60913], [-121.02209, 37.60916], [-121.02354, 37.60961]]]} | Open Access 1 | 18480 | Bellenita Park | 15985 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 20.853 | Bellenita Park | 0 | Local Park 2 | 4 | |
2765 | 2765 | 2764 | {"type": "Polygon", "coordinates": [[[-120.9697, 37.69312], [-120.96964, 37.68905], [-120.97159, 37.68904], [-120.97162, 37.68908], [-120.97164, 37.68943], [-120.97171, 37.68961], [-120.97183, 37.68977], [-120.97208, 37.68996], [-120.9721, 37.68999], [-120.97178, 37.69031], [-120.9717, 37.69044], [-120.97165, 37.69064], [-120.97167, 37.69308], [-120.97163, 37.69311], [-120.9697, 37.69312]]]} | Open Access 1 | 18471 | Beyer Park | 16059 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.974 | Beyer Park | 0 | Local Park 2 | 4 | |
33 | 33 | 32 | {"type": "Polygon", "coordinates": [[[-121.14984, 37.4662], [-121.14978, 37.46625], [-121.14941, 37.46624], [-121.14942, 37.46456], [-121.1496, 37.46457], [-121.14966, 37.46461], [-121.14965, 37.46506], [-121.14967, 37.46526], [-121.1497, 37.46547], [-121.14981, 37.46593], [-121.14984, 37.4662]]]} | Open Access 1 | 87 | Blenheim Park | 16159 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.244 | Blenheim Park | 0 | Local Park 2 | 4 | |
3148 | 3148 | 3147 | {"type": "MultiPolygon", "coordinates": [[[[-120.45998, 37.64316], [-120.45993, 37.64497], [-120.45784, 37.645], [-120.45792, 37.64326], [-120.45998, 37.64316]]], [[[-120.46559, 37.64119], [-120.46545, 37.64299], [-120.4637, 37.64316], [-120.46381, 37.6411], [-120.46559, 37.64119]]], [[[-121.3307, 37.30271], [-121.3125, 37.30284], [-121.31173, 37.28836], [-121.32985, 37.28825], [-121.3307, 37.30271]]], [[[-121.38955, 37.38981], [-121.38933, 37.39681], [-121.38477, 37.39679], [-121.38478, 37.3932], [-121.37635, 37.39334], [-121.37646, 37.38986], [-121.38955, 37.38981]]], [[[-121.38719, 37.5323], [-121.38269, 37.53232], [-121.38271, 37.53599], [-121.37805, 37.53602], [-121.37792, 37.5215], [-121.38264, 37.52146], [-121.38267, 37.52498], [-121.38713, 37.52495], [-121.38719, 37.5323]]], [[[-121.39632, 37.53222], [-121.39171, 37.53226], [-121.39172, 37.52495], [-121.39624, 37.5249], [-121.39632, 37.53222]]], [[[-121.40273, 37.40393], [-121.40252, 37.4112], [-121.39352, 37.41123], [-121.39369, 37.40396], [-121.39817, 37.40393], [-121.40273, 37.40393]]], [[[-121.42546, 37.40023], [-121.42484, 37.40374], [-121.407, 37.40377], [-121.40749, 37.39687], [-121.41653, 37.39676], [-121.41636, 37.40039], [-121.42546, 37.40023]]], [[[-121.4577, 37.4105], [-121.45737, 37.41817], [-121.45005, 37.41803], [-121.45037, 37.41065], [-121.4577, 37.4105]]]]} | Open Access 1 | 21633 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Stanislaus 2 | 1652.494 | BLM | 1899 | National Public Lands 1 | 3 | |
10342 | 10342 | 10341 | {"type": "Polygon", "coordinates": [[[-120.57202, 37.62727], [-120.57198, 37.62916], [-120.56928, 37.6295], [-120.56863, 37.63018], [-120.56928, 37.63226], [-120.56871, 37.633], [-120.56806, 37.63368], [-120.56624, 37.63436], [-120.56413, 37.63468], [-120.56335, 37.63476], [-120.56189, 37.63452], [-120.56149, 37.63442], [-120.56023, 37.63381], [-120.55943, 37.63315], [-120.5586, 37.63254], [-120.55856, 37.63213], [-120.55757, 37.6314], [-120.55568, 37.63142], [-120.55362, 37.63294], [-120.54986, 37.63346], [-120.5458, 37.6323], [-120.54181, 37.632], [-120.5384, 37.63133], [-120.53578, 37.6313], [-120.53577, 37.62815], [-120.53664, 37.62825], [-120.53986, 37.62737], [-120.54071, 37.62764], [-120.54226, 37.62771], [-120.54354, 37.62769], [-120.54359, 37.62723], [-120.54357, 37.62637], [-120.54507, 37.62495], [-120.54887, 37.62484], [-120.54891, 37.62363], [-120.56284, 37.62365], [-120.56284, 37.62717], [-120.57202, 37.62727]]]} | Restricted Access 2 | 18243 | Bobcat Flat | 16214 | 3026 | Friends of the Tuolumne 948 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofthetuolumne.org | Non Governmental Organization 10 | 3026 | Friends of the Tuolumne 920 | Non Profit 6 | Non Profit - Conservation 12 | Stanislaus 2 | 601.538 | Bobcat Flat | 0 | Private Conservation 16 | 2 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.07603, 37.39301], [-121.07567, 37.39319], [-121.07512, 37.39252], [-121.07553, 37.39229], [-121.07603, 37.39291], [-121.07603, 37.39301]]]} | Open Access 1 | 18132 | Bonita Park | 16261 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 0.972 | Bonita Park | 0 | Local Park 2 | 4 | |
113 | 113 | 112 | {"type": "Polygon", "coordinates": [[[-120.83275, 37.48942], [-120.83182, 37.48941], [-120.83182, 37.48919], [-120.83251, 37.48918], [-120.83275, 37.48942]]]} | Open Access 1 | 328 | Bothun Park | 16292 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 0.451 | Bothun Park | 0 | Local Park 2 | 4 | |
12330 | 12330 | 12329 | {"type": "Polygon", "coordinates": [[[-120.88136, 37.53461], [-120.88115, 37.53479], [-120.88095, 37.53489], [-120.88068, 37.53495], [-120.88041, 37.53495], [-120.88049, 37.53372], [-120.88047, 37.5333], [-120.88062, 37.5336], [-120.88084, 37.53392], [-120.88105, 37.53417], [-120.88134, 37.53445], [-120.88133, 37.53453], [-120.88136, 37.53461]]]} | Open Access 1 | 25997 | Brad Bates Park | 16322 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.958 | Brad Bates Park | 0 | Local Park 2 | 4 | |
10304 | 10304 | 10303 | {"type": "Polygon", "coordinates": [[[-121.00441, 37.60578], [-121.00352, 37.60681], [-121.00275, 37.60737], [-121.00274, 37.6072], [-121.00281, 37.60714], [-121.00282, 37.60578], [-121.00441, 37.60578]]]} | Open Access 1 | 18136 | Bret Harte Park | 16364 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 3.342 | Bret Harte Park | 0 | Local Park 2 | 4 | |
10447 | 10447 | 10446 | {"type": "Polygon", "coordinates": [[[-121.00587, 37.60409], [-121.00558, 37.60444], [-121.00441, 37.60578], [-121.00282, 37.60578], [-121.00282, 37.60232], [-121.00457, 37.60234], [-121.00468, 37.60406], [-121.00587, 37.60409]]]} | Open Access 1 | 18484 | Bret Harte Park | 16366 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.273 | Bret Harte Park | 0 | Local Park 2 | 4 | |
10319 | 10319 | 10318 | {"type": "Polygon", "coordinates": [[[-120.96313, 37.67443], [-120.96039, 37.67444], [-120.96038, 37.67417], [-120.96046, 37.67411], [-120.96048, 37.67403], [-120.96047, 37.67397], [-120.96046, 37.67309], [-120.96051, 37.67306], [-120.9631, 37.67306], [-120.96313, 37.67309], [-120.96313, 37.67443]]]} | Open Access 1 | 18490 | Brewers Rose Park | 16368 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 8.916 | Brewers Rose Park | 0 | Local Park 2 | 4 | |
2893 | 2893 | 2892 | {"type": "Polygon", "coordinates": [[[-120.86991, 37.75616], [-120.86925, 37.7562], [-120.86889, 37.75636], [-120.86882, 37.75626], [-120.86875, 37.75609], [-120.86869, 37.75603], [-120.86862, 37.75601], [-120.86854, 37.756], [-120.86838, 37.75604], [-120.8682, 37.75603], [-120.86804, 37.75599], [-120.86796, 37.75596], [-120.86783, 37.75587], [-120.86776, 37.75581], [-120.86765, 37.75566], [-120.8677, 37.75559], [-120.86898, 37.75573], [-120.86936, 37.75571], [-120.86945, 37.75567], [-120.86972, 37.75564], [-120.86991, 37.75616]]]} | Open Access 1 | 18925 | Bridle Ridge Park | 16384 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 2.237 | Bridle Ridge Park | 0 | Local Park 2 | 4 | |
121 | 121 | 120 | {"type": "Polygon", "coordinates": [[[-120.82047, 37.5121], [-120.8204, 37.51213], [-120.82023, 37.51213], [-120.81968, 37.512], [-120.81952, 37.51198], [-120.81935, 37.51201], [-120.81911, 37.51208], [-120.81873, 37.51224], [-120.81851, 37.51228], [-120.81832, 37.51227], [-120.81822, 37.51224], [-120.81804, 37.51217], [-120.81804, 37.5121], [-120.81817, 37.51194], [-120.81835, 37.5118], [-120.81869, 37.51157], [-120.81886, 37.51136], [-120.81893, 37.51131], [-120.81903, 37.51125], [-120.81915, 37.51121], [-120.81941, 37.51118], [-120.8197, 37.51121], [-120.81977, 37.51124], [-120.82014, 37.5114], [-120.82027, 37.5115], [-120.82037, 37.51163], [-120.82044, 37.51175], [-120.82047, 37.51187], [-120.82047, 37.5121]]]} | Open Access 1 | 334 | Bristol Park | 16401 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 3.933 | Bristol Park | 0 | Local Park 2 | 4 | |
5882 | 5882 | 5881 | {"type": "Polygon", "coordinates": [[[-120.85242, 37.4975], [-120.85158, 37.49809], [-120.85103, 37.4976], [-120.85187, 37.49701], [-120.85242, 37.4975]]]} | Open Access 1 | 340 | Broadway Park | 16408 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.782 | Broadway Park | 0 | Local Park 2 | 4 | |
10451 | 10451 | 10450 | {"type": "MultiPolygon", "coordinates": [[[[-120.98486, 37.63968], [-120.98485, 37.63968], [-120.98462, 37.63914], [-120.98459, 37.63898], [-120.98438, 37.63858], [-120.98435, 37.63825], [-120.98473, 37.63825], [-120.98486, 37.63968]]], [[[-120.98577, 37.64138], [-120.98581, 37.64139], [-120.98592, 37.64161], [-120.98595, 37.64173], [-120.98597, 37.64196], [-120.98595, 37.64219], [-120.98591, 37.64231], [-120.9858, 37.64253], [-120.98578, 37.64254], [-120.98574, 37.64252], [-120.98569, 37.6423], [-120.98567, 37.64207], [-120.98567, 37.64185], [-120.9857, 37.64162], [-120.98575, 37.6414], [-120.98577, 37.64138]]]]} | Open Access 1 | 18497 | Brookway Park | 16438 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 1.408 | Brookway Park | 0 | Local Park 2 | 4 | |
2654 | 2654 | 2653 | {"type": "Polygon", "coordinates": [[[-121.02794, 37.62238], [-121.02735, 37.6224], [-121.02736, 37.62169], [-121.02793, 37.62169], [-121.02794, 37.62238]]]} | Open Access 1 | 18139 | Burbank-Paradise Park | 16507 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 0.985 | Burbank-Paradise Park | 0 | Local Park 2 | 4 | |
10623 | 10623 | 10622 | {"type": "Polygon", "coordinates": [[[-120.83726, 37.77732], [-120.83697, 37.77734], [-120.8369, 37.77736], [-120.83667, 37.77737], [-120.83585, 37.77748], [-120.83569, 37.77707], [-120.83568, 37.7768], [-120.83574, 37.77663], [-120.83579, 37.77655], [-120.83591, 37.77642], [-120.83604, 37.77633], [-120.83667, 37.77604], [-120.83688, 37.77633], [-120.83702, 37.77659], [-120.83703, 37.77671], [-120.83706, 37.77678], [-120.83715, 37.77685], [-120.8372, 37.77693], [-120.83725, 37.77713], [-120.83726, 37.77732]]]} | Open Access 1 | 18929 | Burchell Park | 16514 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.785 | Burchell Park | 0 | Local Park 2 | 4 | |
10423 | 10423 | 10422 | {"type": "Polygon", "coordinates": [[[-120.8609, 37.59602], [-120.86088, 37.59655], [-120.86009, 37.59656], [-120.86009, 37.59648], [-120.8601, 37.59647], [-120.86014, 37.59603], [-120.8609, 37.59602]]]} | Open Access 1 | 18439 | Carrie Schrader Park | 16911 | 1140 | Hughson, City of 863 | City 2 | City Agency 2 | http://hughson.org/government/city-departments/parks-and-recreations/ | City 2 | 1140 | Hughson, City of 841 | City 2 | City Agency 2 | Stanislaus 2 | 0.979 | Carrie Schrader Park | 0 | Local Park 2 | 4 | |
5872 | 5872 | 5871 | {"type": "Polygon", "coordinates": [[[-120.92888, 37.72501], [-120.92786, 37.725], [-120.92787, 37.72535], [-120.92678, 37.72536], [-120.92672, 37.72281], [-120.92884, 37.7228], [-120.92888, 37.72501]]]} | Open Access 1 | 256 | Castleberg Park | 16957 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | Stanislaus 2 | 12.167 | Castleberg Park | 0 | Local Park 2 | 4 | |
43 | 43 | 42 | {"type": "Polygon", "coordinates": [[[-121.15669, 37.46915], [-121.15657, 37.46931], [-121.15657, 37.46937], [-121.15661, 37.46943], [-121.15668, 37.46948], [-121.15648, 37.46951], [-121.15606, 37.46951], [-121.15586, 37.46948], [-121.15657, 37.46901], [-121.15669, 37.46906], [-121.15669, 37.46915]]]} | Open Access 1 | 98 | Castlebrite Park | 16958 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.519 | Castlebrite 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]);