units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
211 rows where COUNTY = 2 and DES_TP = 2 sorted by UNIT_NAME
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, PARK_URL, YR_EST
MNG_AGENCY 11
MNG_AG_TYP 3
- City Agency 188
- County Agency 22
- Irrigation District 1
ACCESS_TYP 2
- Open Access 207
- Restricted Access 4
DES_TP 1
- Local Park · 211 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13039 | 13039 | 13038 | {"type": "Polygon", "coordinates": [[[-121.03563, 37.30465], [-121.03559, 37.3065], [-121.03527, 37.3065], [-121.0351, 37.30646], [-121.03494, 37.30641], [-121.03479, 37.30634], [-121.03459, 37.3062], [-121.03448, 37.30609], [-121.0344, 37.30596], [-121.03433, 37.30583], [-121.03429, 37.30562], [-121.0343, 37.30547], [-121.03434, 37.30532], [-121.03445, 37.30511], [-121.03456, 37.30499], [-121.03469, 37.30488], [-121.03485, 37.30479], [-121.03502, 37.30472], [-121.0352, 37.30467], [-121.03539, 37.30465], [-121.03563, 37.30465]]]} | Open Access 1 | 34878 | Alfred A. "Bush" Rose, Jr. Park | 30997 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 4.821 | Alfred A. "Bush" Rose, Jr. Park | 0 | Local Park 2 | 4 | |
5797 | 5797 | 5796 | {"type": "Polygon", "coordinates": [[[-121.1509, 37.46277], [-121.1508, 37.46292], [-121.14988, 37.46396], [-121.14979, 37.46412], [-121.14974, 37.46424], [-121.14971, 37.46426], [-121.14957, 37.46426], [-121.14958, 37.46277], [-121.1509, 37.46277]]]} | Open Access 1 | 55 | Amaryllis Park | 15440 | 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 | 2.566 | Amaryllis Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 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 | 4.088 | Ambercot 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 | |
5802 | 5802 | 5801 | {"type": "Polygon", "coordinates": [[[-121.15135, 37.46576], [-121.15132, 37.46714], [-121.15127, 37.46718], [-121.15088, 37.46718], [-121.15078, 37.46715], [-121.15072, 37.46715], [-121.15063, 37.46719], [-121.1506, 37.46725], [-121.15028, 37.46725], [-121.15029, 37.46575], [-121.15059, 37.46575], [-121.15063, 37.46573], [-121.15072, 37.46575], [-121.15088, 37.46571], [-121.1513, 37.46572], [-121.15135, 37.46576]]]} | Open Access 1 | 71 | Aprigold Park | 15545 | 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 | 3.755 | Aprigold Park | 0 | Local Park 2 | 4 | |
2762 | 2762 | 2761 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02374, 37.69383], [-121.02259, 37.69381], [-121.02257, 37.69257], [-121.02258, 37.69254], [-121.02262, 37.69253], [-121.02407, 37.69255], [-121.0241, 37.69426]]]} | Open Access 1 | 18461 | Aqueduct Park | 15550 | 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 | 5.048 | Aqueduct Park | 0 | Local Park 2 | 4 | |
10431 | 10431 | 10430 | {"type": "Polygon", "coordinates": [[[-120.98579, 37.65634], [-120.9858, 37.65675], [-120.98577, 37.65684], [-120.98545, 37.65716], [-120.98541, 37.65717], [-120.98537, 37.65716], [-120.98535, 37.65713], [-120.98535, 37.65634], [-120.98538, 37.65633], [-120.98577, 37.65633], [-120.98579, 37.65634]]]} | Open Access 1 | 18465 | Asby Park | 15644 | 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 | 0.745 | Asby Park | 0 | Local Park 2 | 4 | |
21 | 21 | 20 | {"type": "Polygon", "coordinates": [[[-121.14743, 37.47816], [-121.14709, 37.47823], [-121.14693, 37.47771], [-121.14719, 37.47764], [-121.14726, 37.47767], [-121.14743, 37.47816]]]} | Open Access 1 | 77 | Aurora Park | 15710 | 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.447 | Aurora Park | 0 | Local Park 2 | 4 | |
32 | 32 | 31 | {"type": "Polygon", "coordinates": [[[-121.1459, 37.47051], [-121.14458, 37.47106], [-121.14385, 37.46995], [-121.14391, 37.4699], [-121.1459, 37.47051]]]} | Open Access 1 | 81 | Autumn Royal Park | 15718 | 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 | 2.417 | Autumn Royal Park | 0 | Local Park 2 | 4 | |
11371 | 11371 | 11370 | {"type": "Polygon", "coordinates": [[[-120.8714, 37.53098], [-120.8714, 37.53114], [-120.87138, 37.53133], [-120.87014, 37.53131], [-120.87015, 37.53099], [-120.8714, 37.53098]]]} | Open Access 1 | 48065 | BMX Bike Park | 32557 | 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.024 | BMX Bike Park | 0 | Local Park 2 | 4 | |
2883 | 2883 | 2882 | {"type": "Polygon", "coordinates": [[[-121.01423, 37.32012], [-121.01422, 37.32074], [-121.01419, 37.32091], [-121.01419, 37.32123], [-121.01408, 37.32125], [-121.01408, 37.32153], [-121.01412, 37.3216], [-121.01413, 37.32195], [-121.01309, 37.32191], [-121.01304, 37.32011], [-121.01423, 37.32012]]]} | Open Access 1 | 18902 | Barrigton Park | 15834 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 4.855 | Barrigton Park | 0 | Local Park 2 | 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 | |
10444 | 10444 | 10443 | {"type": "Polygon", "coordinates": [[[-120.98797, 37.63102], [-120.98782, 37.63105], [-120.98769, 37.63112], [-120.9876, 37.63122], [-120.98755, 37.63134], [-120.98756, 37.63144], [-120.98769, 37.63207], [-120.98769, 37.63241], [-120.98746, 37.63481], [-120.98743, 37.63494], [-120.98734, 37.63511], [-120.98719, 37.63526], [-120.987, 37.63539], [-120.98658, 37.63562], [-120.98635, 37.63571], [-120.98587, 37.63584], [-120.98562, 37.63589], [-120.98536, 37.63591], [-120.98496, 37.63592], [-120.98479, 37.63596], [-120.98468, 37.63601], [-120.98461, 37.63607], [-120.98453, 37.63619], [-120.9845, 37.6363], [-120.98445, 37.6363], [-120.98445, 37.63621], [-120.98452, 37.63607], [-120.98468, 37.63589], [-120.9847, 37.6358], [-120.98482, 37.63569], [-120.9849, 37.6355], [-120.98502, 37.6354], [-120.98593, 37.63485], [-120.98628, 37.63448], [-120.98648, 37.63411], [-120.98669, 37.63385], [-120.98708, 37.63311], [-120.98702, 37.6324], [-120.98701, 37.6321], [-120.98694, 37.63191], [-120.98671, 37.63156], [-120.98666, 37.63125], [-120.98667, 37.631], [-120.98797, 37.63102]]]} | Open Access 1 | 18474 | Beard Brook Park | 15935 | 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 | 12.394 | Beard Brook Park | 0 | Local Park 2 | 4 | |
165 | 165 | 164 | {"type": "Polygon", "coordinates": [[[-120.76076, 37.6464], [-120.76076, 37.64658], [-120.75582, 37.64658], [-120.75582, 37.64643], [-120.75633, 37.64642], [-120.75634, 37.64604], [-120.75632, 37.64567], [-120.75587, 37.64566], [-120.75616, 37.6455], [-120.76076, 37.64548], [-120.76075, 37.64558], [-120.76054, 37.64558], [-120.76053, 37.6464], [-120.76076, 37.6464]]]} | Open Access 1 | 436 | Beard Park | 15936 | 1372 | Waterford, City of 57 | City 2 | City Agency 2 | http://www.cityofwaterford.org/departments/parks-and-recreation/ | City 2 | 1372 | Waterford, City of 55 | City 2 | City Agency 2 | Stanislaus 2 | 11.565 | Beard Park | 0 | Local Park 2 | 4 | |
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 | |
14001 | 14001 | 14000 | {"type": "Polygon", "coordinates": [[[-120.87498, 37.75001], [-120.87494, 37.75005], [-120.8733, 37.75089], [-120.87321, 37.7509], [-120.87317, 37.75088], [-120.87276, 37.75033], [-120.87275, 37.75029], [-120.8728, 37.75023], [-120.87334, 37.74997], [-120.87362, 37.74989], [-120.87425, 37.74979], [-120.87439, 37.74975], [-120.87467, 37.74963], [-120.87473, 37.74963], [-120.87498, 37.74997], [-120.87498, 37.75001]]]} | Open Access 1 | 48841 | Blue Park | 33561 | 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.353 | Blue Park | 0 | Local Park 2 | 4 | |
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 | |
6364 | 6364 | 6363 | {"type": "Polygon", "coordinates": [[[-120.91097, 37.55865], [-120.91094, 37.56187], [-120.91083, 37.56198], [-120.91056, 37.56195], [-120.9103, 37.56185], [-120.91004, 37.5617], [-120.91003, 37.56159], [-120.91014, 37.56136], [-120.9102, 37.56113], [-120.91018, 37.56085], [-120.91011, 37.56065], [-120.90964, 37.55999], [-120.90964, 37.55861], [-120.90972, 37.55856], [-120.91088, 37.55856], [-120.91097, 37.55865]]]} | Open Access 1 | 48893 | Bonita Ranch Park | 33610 | 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 | 8.735 | Bonita Ranch 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]);