units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where AGNCY_LEV = 4 and MNG_AGENCY = 598
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Hesperia Recreation and Park District · 11 ✖
ACCESS_TYP 1
- Open Access 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 | |
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 | |
8332 | 8332 | 8331 | {"type": "Polygon", "coordinates": [[[-117.27249, 34.42288], [-117.27177, 34.42391], [-117.27118, 34.42378], [-117.27014, 34.42305], [-117.27027, 34.42295], [-117.27026, 34.42293], [-117.27091, 34.42247], [-117.27093, 34.42248], [-117.27105, 34.42239], [-117.27104, 34.42237], [-117.27121, 34.42225], [-117.27154, 34.42248], [-117.27237, 34.42286], [-117.27249, 34.42288]]]} | Open Access 1 | 14765 | Timberlane Park | 26370 | 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 | 5.288 | Timberlane Park | 0 | Local Park 2 | 4 | |
11860 | 11860 | 11859 | {"type": "Polygon", "coordinates": [[[-117.36835, 34.41034], [-117.36627, 34.41034], [-117.36624, 34.40859], [-117.36742, 34.40859], [-117.36745, 34.4089], [-117.36698, 34.40923], [-117.36756, 34.40966], [-117.36759, 34.40963], [-117.36766, 34.40967], [-117.3679, 34.40948], [-117.36798, 34.40949], [-117.36798, 34.40955], [-117.36834, 34.40953], [-117.36835, 34.41034]]]} | Open Access 1 | 24297 | Rick Novack Community Center & Gym & Palm Street Park | 24344 | 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 | 6.603 | Rick Novack Community Ctr. & Gym & Palm Street Park | 0 | Local Recreation Area 3 | 4 | |
12022 | 12022 | 12021 | {"type": "Polygon", "coordinates": [[[-117.36386, 34.43854], [-117.36052, 34.43857], [-117.36051, 34.43824], [-117.3599, 34.43825], [-117.3599, 34.43767], [-117.36088, 34.43765], [-117.36087, 34.43676], [-117.35989, 34.43677], [-117.35988, 34.43496], [-117.36195, 34.43494], [-117.36196, 34.43584], [-117.36295, 34.43583], [-117.36386, 34.43854]]]} | Open Access 1 | 24691 | Hesperia Community Park | 19882 | 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 | 26.035 | Hesperia Community Park | 0 | Local Park 2 | 4 | |
12628 | 12628 | 12627 | {"type": "Polygon", "coordinates": [[[-117.35578, 34.42283], [-117.35576, 34.4229], [-117.35578, 34.42299], [-117.35577, 34.42306], [-117.35568, 34.42309], [-117.35563, 34.42305], [-117.35562, 34.42299], [-117.35559, 34.42289], [-117.35562, 34.42278], [-117.35572, 34.42277], [-117.35578, 34.42283]]]} | Open Access 1 | 29427 | Sapphire Park | 25154 | 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.12 | Sapphire Park | 0 | Local Park 2 | 4 | |
12950 | 12950 | 12949 | {"type": "Polygon", "coordinates": [[[-117.37675, 34.41209], [-117.37526, 34.41209], [-117.37526, 34.41206], [-117.37518, 34.41198], [-117.37518, 34.41058], [-117.37675, 34.41058], [-117.37675, 34.41209]]]} | Open Access 1 | 30405 | Malibu Park | 21711 | 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 | 5.965 | Malibu Park | 0 | Local Park 2 | 4 | |
12951 | 12951 | 12950 | {"type": "Polygon", "coordinates": [[[-117.31877, 34.42606], [-117.31834, 34.42783], [-117.31734, 34.42769], [-117.31772, 34.4259], [-117.31877, 34.42606]]]} | Open Access 1 | 30406 | Hesperia Civic Plaza Park | 19881 | 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 | 4.774 | Hesperia Civic Plaza Park | 0 | Local Park 2 | 4 | |
12952 | 12952 | 12951 | {"type": "Polygon", "coordinates": [[[-117.25157, 34.3868], [-117.25156, 34.38696], [-117.25149, 34.38713], [-117.2506, 34.38776], [-117.24962, 34.38824], [-117.24928, 34.38819], [-117.24921, 34.38814], [-117.24916, 34.388], [-117.24911, 34.38727], [-117.24939, 34.38712], [-117.24936, 34.38667], [-117.24954, 34.38656], [-117.24962, 34.38637], [-117.24965, 34.38562], [-117.24976, 34.38526], [-117.25013, 34.38488], [-117.25022, 34.38483], [-117.25031, 34.38489], [-117.25044, 34.38525], [-117.25031, 34.3856], [-117.25042, 34.38593], [-117.25061, 34.38599], [-117.25157, 34.3868]]]} | Open Access 1 | 30407 | 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 | 10.787 | Hesperia Lake 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]);