units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where ACCESS_TYP = 1, COUNTY = 22 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | Local Recreation Area 3 | 4 | ||
619 | 619 | 618 | {"type": "Polygon", "coordinates": [[[-117.07879, 34.21133], [-117.0785, 34.21198], [-117.07792, 34.2117], [-117.07815, 34.21121], [-117.07845, 34.2113], [-117.07848, 34.21124], [-117.07879, 34.21133]]]} | Open Access 1 | 2291 | Arrowbear Park Ball Field | 15606 | 2121 | Rim of the World Recreation and Park District 224 | Special District 4 | Recreation/Parks District 4 | http://www.rim-rec.org/ | Special District 4 | 2121 | Rim of the World Recreation and Park District 220 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.019 | Arrowbear Park Ball Field | 0 | Local Recreation Area 3 | 4 | |
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
2660 | 2660 | 2659 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | 18164 | Corwin Park | 17669 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.691 | Corwin Park | 0 | Local Park 2 | 4 | ||
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-116.03991, 34.14688], [-116.03988, 34.15024], [-116.03658, 34.15029], [-116.03661, 34.14692], [-116.03991, 34.14688]]]} | Open Access 1 | 24302 | Luckie Park | 21581 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 28.066 | Luckie Park | 0 | Local Park 2 | 4 | ||
3272 | 3272 | 3271 | {"type": "Polygon", "coordinates": [[[-117.35643, 34.42535], [-117.35633, 34.42549], [-117.35636, 34.42555], [-117.35633, 34.42563], [-117.35625, 34.42564], [-117.35616, 34.42559], [-117.35611, 34.42562], [-117.35602, 34.42562], [-117.35597, 34.4256], [-117.35595, 34.42557], [-117.35599, 34.42543], [-117.35597, 34.42532], [-117.356, 34.42528], [-117.3561, 34.42527], [-117.35618, 34.42529], [-117.35634, 34.42529], [-117.35643, 34.42535]]]} | Open Access 1 | 29425 | Belmont Park | 15994 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 0.334 | Belmont Park | 0 | Local Park 2 | 4 | |
3361 | 3361 | 3360 | {"type": "Polygon", "coordinates": [[[-116.94595, 34.2707], [-116.94595, 34.27072], [-116.94563, 34.27071], [-116.94562, 34.27077], [-116.94497, 34.27093], [-116.94464, 34.27093], [-116.94464, 34.27032], [-116.94497, 34.27032], [-116.94562, 34.2706], [-116.94562, 34.27069], [-116.94595, 34.2707]]]} | Open Access 1 | 24294 | Miller Park | 22245 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.155 | Miller Park | 0 | Local Park 2 | 4 | |
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30643, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | 24295 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 18.753 | Sunburst Park | 0 | Local Park 2 | 4 | ||
3476 | 3476 | 3475 | {"type": "Polygon", "coordinates": [[[-117.25211, 34.38399], [-117.25224, 34.38434], [-117.25234, 34.38472], [-117.25239, 34.38511], [-117.25239, 34.3855], [-117.25228, 34.38688], [-117.25223, 34.38719], [-117.25212, 34.38763], [-117.25199, 34.38794], [-117.25184, 34.38824], [-117.25142, 34.38807], [-117.24954, 34.38869], [-117.24644, 34.39464], [-117.24169, 34.39943], [-117.24162, 34.3841], [-117.24424, 34.38408], [-117.24545, 34.38678], [-117.24656, 34.38679], [-117.24659, 34.38405], [-117.25211, 34.38399]], [[-117.25042, 34.38594], [-117.25031, 34.3856], [-117.25044, 34.38525], [-117.25031, 34.38489], [-117.25022, 34.38483], [-117.25013, 34.38488], [-117.24976, 34.38526], [-117.24965, 34.38562], [-117.24962, 34.38637], [-117.24954, 34.38656], [-117.24936, 34.38667], [-117.24939, 34.38712], [-117.24911, 34.38728], [-117.24916, 34.38799], [-117.24921, 34.38814], [-117.24928, 34.38819], [-117.24962, 34.38824], [-117.2506, 34.38776], [-117.25149, 34.38713], [-117.25156, 34.38696], [-117.25157, 34.3868], [-117.25062, 34.386], [-117.25042, 34.38594]]]} | Open Access 1 | 25798 | Hesperia Lake Park | 4453 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/hesperia-lake-park/ | San Bernardino 22 | 223.101 | Hesperia Lake Park | 0 | Local Park 2 | 4 |
5404 | 5404 | 5403 | {"type": "Polygon", "coordinates": [[[-117.22181, 34.53488], [-117.22174, 34.535], [-117.2217, 34.53513], [-117.22168, 34.53527], [-117.22168, 34.53555], [-117.22166, 34.53558], [-117.22162, 34.5356], [-117.22091, 34.53561], [-117.2209, 34.53514], [-117.22017, 34.53515], [-117.22017, 34.53467], [-117.22045, 34.5346], [-117.22059, 34.53454], [-117.22074, 34.53444], [-117.22112, 34.53478], [-117.22124, 34.53468], [-117.22181, 34.53488]]]} | Open Access 1 | 12495 | Cramer Family Park | 17754 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 2.825 | Cramer Family Park | 0 | Local Park 2 | 4 | ||
6437 | 6437 | 6436 | {"type": "Polygon", "coordinates": [[[-117.13372, 34.48655], [-117.12931, 34.48651], [-117.12931, 34.48533], [-117.13037, 34.48459], [-117.13067, 34.48392], [-117.13217, 34.48391], [-117.1327, 34.48343], [-117.13274, 34.48292], [-117.13251, 34.48283], [-117.13251, 34.48129], [-117.13371, 34.48132], [-117.13372, 34.48655]]]} | Open Access 1 | 1957 | Horsemen's Center | 20096 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 33.691 | Horsemen's Ctr. | 0 | Local Recreation Area 3 | 4 | ||
6438 | 6438 | 6437 | {"type": "Polygon", "coordinates": [[[-117.1555, 34.55318], [-117.15316, 34.55317], [-117.15316, 34.55251], [-117.15326, 34.55248], [-117.1533, 34.55243], [-117.15331, 34.55239], [-117.1533, 34.55235], [-117.15324, 34.55222], [-117.15324, 34.55175], [-117.15329, 34.55171], [-117.15334, 34.55169], [-117.15537, 34.55167], [-117.15544, 34.55169], [-117.15548, 34.55175], [-117.1555, 34.55318]]]} | Open Access 1 | 1964 | Sycamore Rocks Park | 26142 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 8.579 | Sycamore Rocks Park | 0 | Local Park 2 | 4 | ||
6494 | 6494 | 6493 | {"type": "Polygon", "coordinates": [[[-117.2842, 34.42481], [-117.28382, 34.4266], [-117.28222, 34.42636], [-117.2826, 34.42458], [-117.2842, 34.42481]]]} | Open Access 1 | 2353 | Live Oak Park | 21374 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 7.428 | Live Oak Park | 0 | Local Park 2 | 4 | |
6533 | 6533 | 6532 | {"type": "Polygon", "coordinates": [[[-116.08355, 34.12978], [-116.08208, 34.12979], [-116.08206, 34.12438], [-116.08353, 34.12437], [-116.08355, 34.12978]]]} | Open Access 1 | 2940 | Knott Sky Park | 20705 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 20.118 | Knott Sky Park | 0 | Local Park 2 | 4 | ||
6591 | 6591 | 6590 | {"type": "Polygon", "coordinates": [[[-117.30782, 34.40725], [-117.30744, 34.40904], [-117.30711, 34.409], [-117.30688, 34.41009], [-117.30473, 34.40977], [-117.30544, 34.40652], [-117.30551, 34.4065], [-117.30775, 34.40682], [-117.30766, 34.40722], [-117.30782, 34.40725]]]} | Open Access 1 | 4164 | Lime Street Park/ Community Center | 21240 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 19.974 | Lime Street Park/ Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
6619 | 6619 | 6618 | {"type": "Polygon", "coordinates": [[[-117.21166, 34.51739], [-117.21088, 34.51795], [-117.2105, 34.51759], [-117.21131, 34.51706], [-117.21142, 34.51709], [-117.2115, 34.51715], [-117.21159, 34.51725], [-117.21166, 34.51739]]]} | Open Access 1 | 4236 | Lion's Park | 21311 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.245 | Lion's Park | 0 | Local Park 2 | 4 | ||
6773 | 6773 | 6772 | {"type": "Polygon", "coordinates": [[[-116.90495, 34.24779], [-116.90474, 34.24781], [-116.90462, 34.24807], [-116.90448, 34.24827], [-116.90431, 34.24846], [-116.90403, 34.24873], [-116.90396, 34.24889], [-116.90389, 34.24891], [-116.90385, 34.24888], [-116.90384, 34.24884], [-116.90405, 34.24859], [-116.9042, 34.24846], [-116.9043, 34.24833], [-116.90447, 34.24807], [-116.90457, 34.24781], [-116.90364, 34.24786], [-116.90349, 34.24799], [-116.90332, 34.2481], [-116.90318, 34.24817], [-116.90296, 34.24825], [-116.90253, 34.24807], [-116.90234, 34.24797], [-116.90204, 34.24794], [-116.9013, 34.24797], [-116.90048, 34.24739], [-116.89837, 34.24635], [-116.89837, 34.24628], [-116.90046, 34.24631], [-116.9026, 34.24714], [-116.90378, 34.24716], [-116.90436, 34.24666], [-116.90495, 34.24714], [-116.90495, 34.24779]]]} | Open Access 1 | 5242 | Meadow Park/ Ski Beach Park | 22077 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 14.954 | Meadow Park/ Ski Beach Park | 0 | Local Park 2 | 4 | |
6914 | 6914 | 6913 | {"type": "Polygon", "coordinates": [[[-117.21794, 34.50725], [-117.21794, 34.50766], [-117.2166, 34.50766], [-117.21659, 34.50655], [-117.21716, 34.50654], [-117.21716, 34.50697], [-117.21713, 34.5071], [-117.21716, 34.50719], [-117.21723, 34.50724], [-117.21735, 34.50728], [-117.2175, 34.50725], [-117.21794, 34.50725]]]} | Open Access 1 | 5805 | Norm Schmidt Park | 22794 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 2.378 | Norm Schmidt Park | 0 | Local Park 2 | 4 | ||
7932 | 7932 | 7931 | {"type": "Polygon", "coordinates": [[[-117.20598, 34.54853], [-117.2057, 34.54853], [-117.20553, 34.5484], [-117.20246, 34.5484], [-117.20244, 34.54399], [-117.20595, 34.54398], [-117.20598, 34.54853]]]} | Open Access 1 | 10719 | Lenny Brewster Sports Center | 21164 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 39.16 | Lenny Brewster Sports Ctr. | 0 | Local Recreation Area 3 | 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]);