units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
249 rows where ACCESS_TYP = 1 and COUNTY = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY 18
- Modesto, City of 78
- Patterson, City of 32
- Turlock, City of 32
- Stanislaus, County of 23
- Oakdale, City of 21
- Riverbank, City of 15
- Ceres, City of 14
- Newman, City of 9
- Waterford, City of 5
- United States Army Corps of Engineers 5
- Hughson, City of 4
- California Department of Fish and Wildlife 3
- California Department of Parks and Recreation 2
- Modesto Irrigation District 2
- United States Bureau of Land Management 1
- Other State 1
- Sacramento and San Joaquin Drainage District 1
- Turlock Irrigation District 1
DES_TP 17
MNG_AG_TYP 6
ACCESS_TYP 1
- Open Access · 249 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10348 | 10348 | 10347 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47822], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04645, 37.48354], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04563, 37.48339], [-121.04538, 37.48317], [-121.0453, 37.48304], [-121.04517, 37.48265], [-121.04504, 37.48171], [-121.04405, 37.48162], [-121.04261, 37.48197], [-121.04182, 37.4817], [-121.04167, 37.48135], [-121.0417, 37.48091], [-121.04211, 37.4806], [-121.04288, 37.48066], [-121.04371, 37.48094], [-121.04433, 37.48094], [-121.04465, 37.48038], [-121.04424, 37.4798], [-121.04404, 37.47886], [-121.0446, 37.47887], [-121.0447, 37.47961], [-121.04544, 37.48016], [-121.04697, 37.48112], [-121.04678, 37.48136], [-121.04678, 37.48138], [-121.04738, 37.4816], [-121.04842, 37.48149], [-121.04888, 37.48106], [-121.04885, 37.48074], [-121.04816, 37.4803], [-121.04815, 37.47982], [-121.04869, 37.47938], [-121.04871, 37.47807], [-121.04954, 37.47726], [-121.0498, 37.47675], [-121.04997, 37.47686], [-121.05008, 37.47695]], [[-121.04619, 37.48132], [-121.04606, 37.48124], [-121.04563, 37.48131], [-121.04513, 37.481], [-121.04492, 37.48099], [-121.04425, 37.48114], [-121.04401, 37.48116], [-121.04369, 37.4811], [-121.04297, 37.4808], [-121.04251, 37.48072], [-121.04228, 37.48073], [-121.04216, 37.48077], [-121.04206, 37.48082], [-121.04184, 37.48098], [-121.04186, 37.48134], [-121.04193, 37.48152], [-121.04206, 37.4816], [-121.04247, 37.48166], [-121.0427, 37.48174], [-121.0429, 37.48173], [-121.04383, 37.48147], [-121.0441, 37.48146], [-121.04487, 37.48158], [-121.04516, 37.48153], [-121.04569, 37.48173], [-121.0459, 37.48179], [-121.04622, 37.48158], [-121.04625, 37.48144], [-121.04619, 37.48132]]]} | Open Access 1 | 18274 | Gomes Lake | 19387 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Stanislaus 2 | 42.26 | Gomes Lake | 0 | None 906 | |||
12197 | 12197 | 12196 | {"type": "Polygon", "coordinates": [[[-120.46492, 37.66834], [-120.46421, 37.66774], [-120.4619, 37.66728], [-120.4618, 37.66725], [-120.46168, 37.66715], [-120.46163, 37.66704], [-120.46164, 37.66696], [-120.4617, 37.66675], [-120.46266, 37.66675], [-120.4649, 37.66747], [-120.46492, 37.66834]]]} | Open Access 1 | 35662 | Tuolumne River Restoration Center | 26580 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Stanislaus 2 | 4.72 | Tuolumne River Restoration Ctr. | None 1063 | ||||
7402 | 7402 | 7401 | {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86681, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} | Open Access 1 | 48438 | Lebright Fields | 33140 | 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 | 8.156 | Lebright Fields | 2018 | Local Recreation Area 3 | 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 | |
10438 | 10438 | 10437 | {"type": "Polygon", "coordinates": [[[-120.87001, 37.60462], [-120.86928, 37.60462], [-120.86923, 37.60469], [-120.86911, 37.60469], [-120.86906, 37.60462], [-120.86833, 37.60463], [-120.86828, 37.60469], [-120.86822, 37.60468], [-120.86816, 37.60469], [-120.86811, 37.60463], [-120.86774, 37.60463], [-120.86773, 37.6033], [-120.86852, 37.6033], [-120.86852, 37.60303], [-120.86999, 37.60304], [-120.87001, 37.60462]]]} | Open Access 1 | 18444 | Roland Starn Park | 24572 | 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 | 8.244 | Roland Starn Park | 0 | Local Park 2 | 4 | |
14915 | 14915 | 14914 | {"type": "Polygon", "coordinates": [[[-120.85566, 37.59835], [-120.85565, 37.59919], [-120.85521, 37.59921], [-120.85504, 37.59926], [-120.85484, 37.59934], [-120.85474, 37.5992], [-120.85469, 37.59905], [-120.85469, 37.59835], [-120.85566, 37.59835]]]} | Open Access 1 | 45484 | Andrew Fontana Memorial Park | 28314 | 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 | 2.054 | Andrew Fontana Memorial Park | 0 | Local Park 2 | 4 | |
3793 | 3793 | 3792 | {"type": "Polygon", "coordinates": [[[-120.94887, 37.71219], [-120.94872, 37.71223], [-120.94872, 37.71191], [-120.94887, 37.71187], [-120.94887, 37.71219]]]} | Open Access 1 | 48818 | Sorensen Park | 33537 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/facilities/facility/details/Sorensen-Park-12 | Stanislaus 2 | 0.115 | Sorensen 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 | |
2335 | 2335 | 2334 | {"type": "Polygon", "coordinates": [[[-120.97968, 37.58915], [-120.97831, 37.58915], [-120.97831, 37.58769], [-120.97967, 37.58769], [-120.97972, 37.58896], [-120.97968, 37.58915]]]} | Open Access 1 | 18429 | Strawberry Fields Park | 25915 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 4.903 | Strawberry Fields Park | 0 | Local Recreation Area 3 | 4 | |
2721 | 2721 | 2720 | {"type": "Polygon", "coordinates": [[[-120.95224, 37.6058], [-120.95224, 37.60697], [-120.95222, 37.60699], [-120.95151, 37.60702], [-120.95099, 37.60708], [-120.95093, 37.60708], [-120.95091, 37.60706], [-120.95089, 37.60612], [-120.9509, 37.60586], [-120.95094, 37.60585], [-120.95177, 37.60584], [-120.95218, 37.60577], [-120.95222, 37.60578], [-120.95224, 37.6058]]]} | Open Access 1 | 18358 | Barry Grove Park | 15836 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 3.887 | Barry Grove Park | 0 | Local Park 2 | 4 | |
2722 | 2722 | 2721 | {"type": "Polygon", "coordinates": [[[-120.96627, 37.599], [-120.96527, 37.59814], [-120.96148, 37.59482], [-120.96379, 37.59484], [-120.96612, 37.59486], [-120.96627, 37.599]]]} | Open Access 1 | 18361 | Ceres Memorial Park | 17081 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 23.33 | Ceres Memorial Park | 0 | Local Park 2 | 4 | |
2730 | 2730 | 2729 | {"type": "Polygon", "coordinates": [[[-120.96592, 37.58393], [-120.96591, 37.58527], [-120.9659, 37.5853], [-120.96586, 37.58531], [-120.96435, 37.5853], [-120.9643, 37.58527], [-120.9643, 37.58448], [-120.96437, 37.58432], [-120.96433, 37.58423], [-120.9646, 37.58392], [-120.96592, 37.58393]]]} | Open Access 1 | 18368 | Don Pedro Park | 18208 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 5.24 | Don Pedro Park | 0 | Local Park 2 | 4 | |
2738 | 2738 | 2737 | {"type": "Polygon", "coordinates": [[[-120.93564, 37.59838], [-120.93399, 37.59838], [-120.93373, 37.59838], [-120.93376, 37.59827], [-120.9338, 37.59819], [-120.93397, 37.59797], [-120.93404, 37.59783], [-120.93407, 37.59769], [-120.93407, 37.59738], [-120.93524, 37.59738], [-120.93525, 37.59821], [-120.93563, 37.59822], [-120.93564, 37.59838]]]} | Open Access 1 | 18393 | Persephone Park | 23616 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 3.269 | Persephone Park | 0 | Local Park 2 | 4 | |
3190 | 3190 | 3189 | {"type": "Polygon", "coordinates": [[[-120.94781, 37.60194], [-120.94356, 37.60194], [-120.94345, 37.60167], [-120.94342, 37.60149], [-120.94339, 37.5984], [-120.94548, 37.5984], [-120.94549, 37.60016], [-120.94778, 37.60016], [-120.94781, 37.60194]]]} | Open Access 1 | 22106 | Smyrna Park | 25579 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 27.695 | Smyrna Park | 0 | Local Park 2 | 4 | |
10391 | 10391 | 10390 | {"type": "Polygon", "coordinates": [[[-120.93019, 37.61576], [-120.9297, 37.61597], [-120.92932, 37.61605], [-120.92867, 37.61599], [-120.928, 37.61589], [-120.92722, 37.61566], [-120.92709, 37.61558], [-120.9268, 37.61546], [-120.92651, 37.6153], [-120.92628, 37.61524], [-120.92582, 37.61503], [-120.92529, 37.61484], [-120.92526, 37.60941], [-120.93014, 37.6094], [-120.93019, 37.61576]]]} | Open Access 1 | 18364 | Ceres River Bluff Regional Park | 17082 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 73.839 | Ceres River Bluff RP | 0 | Local Park 2 | 4 | |
10393 | 10393 | 10392 | {"type": "Polygon", "coordinates": [[[-120.96996, 37.6059], [-120.9699, 37.60591], [-120.96985, 37.60594], [-120.96982, 37.60599], [-120.96983, 37.60604], [-120.96949, 37.60604], [-120.96948, 37.60525], [-120.96927, 37.60507], [-120.96885, 37.60507], [-120.96864, 37.60521], [-120.96865, 37.60569], [-120.96836, 37.60569], [-120.96821, 37.60565], [-120.96819, 37.6052], [-120.96837, 37.60514], [-120.96811, 37.60455], [-120.96836, 37.60448], [-120.96992, 37.6044], [-120.96996, 37.6059]]]} | Open Access 1 | 18372 | Independence Park | 20188 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 4.347 | Independence Park | 0 | Local Park 2 | 4 | |
10397 | 10397 | 10396 | {"type": "Polygon", "coordinates": [[[-120.93129, 37.60201], [-120.92682, 37.60202], [-120.92682, 37.60191], [-120.92921, 37.6019], [-120.92923, 37.60028], [-120.93127, 37.60027], [-120.93127, 37.60084], [-120.93129, 37.60085], [-120.93129, 37.60201]]]} | Open Access 1 | 18376 | Neel Park | 22683 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 9.374 | Neel Park | 0 | Local Park 2 | 4 | |
10408 | 10408 | 10407 | {"type": "Polygon", "coordinates": [[[-120.9455, 37.5854], [-120.9455, 37.58566], [-120.94365, 37.58566], [-120.9437, 37.58551], [-120.94381, 37.58542], [-120.94386, 37.58541], [-120.9451, 37.5854], [-120.94545, 37.58537], [-120.94548, 37.58538], [-120.9455, 37.5854]]]} | Open Access 1 | 18403 | Redwood Park | 24247 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 1.161 | Redwood Park | 0 | Local Park 2 | 4 | |
10410 | 10410 | 10409 | {"type": "Polygon", "coordinates": [[[-120.94561, 37.61224], [-120.94561, 37.61288], [-120.94559, 37.61289], [-120.94559, 37.61327], [-120.94522, 37.61345], [-120.94506, 37.61349], [-120.94487, 37.61351], [-120.94454, 37.61351], [-120.94438, 37.61349], [-120.9442, 37.61344], [-120.94391, 37.61331], [-120.94391, 37.61259], [-120.94396, 37.61253], [-120.94398, 37.61246], [-120.94395, 37.6124], [-120.94386, 37.61234], [-120.94382, 37.61229], [-120.94381, 37.61223], [-120.94383, 37.61218], [-120.94403, 37.61218], [-120.94434, 37.61223], [-120.94457, 37.61225], [-120.94561, 37.61224]]]} | Open Access 1 | 18413 | Riverview Park | 24464 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 4.98 | Riverview Park | 0 | Local Park 2 | 4 | |
10414 | 10414 | 10413 | {"type": "Polygon", "coordinates": [[[-120.94271, 37.58977], [-120.9427, 37.59037], [-120.94262, 37.59076], [-120.9426, 37.59099], [-120.94258, 37.59102], [-120.94069, 37.59103], [-120.94068, 37.58974], [-120.94267, 37.58974], [-120.94271, 37.58977]]]} | Open Access 1 | 18418 | Roeding Heights Park | 24556 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 6.195 | Roeding Heights 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]);