units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 210
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
572 | 572 | 571 | {"type": "Polygon", "coordinates": [[[-117.04862, 34.87735], [-117.04763, 34.87734], [-117.04762, 34.87653], [-117.04861, 34.87654], [-117.04862, 34.87735]]]} | Open Access 1 | 1897 | Barstow Heights Park | 15837 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 2.022 | Barstow Heights Park | 0 | Local Park 2 | 4 | |
1446 | 1446 | 1445 | {"type": "Polygon", "coordinates": [[[-117.05516, 34.87007], [-117.05417, 34.87006], [-117.05417, 34.86933], [-117.05516, 34.86935], [-117.05516, 34.87007]]]} | Open Access 1 | 12546 | Panamint Park | 23386 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 1.805 | Panamint Park | 0 | Local Park 2 | 4 | |
6229 | 6229 | 6228 | {"type": "Polygon", "coordinates": [[[-117.04906, 34.88938], [-117.04767, 34.88938], [-117.04768, 34.88821], [-117.04903, 34.88823], [-117.04906, 34.88938]]]} | Open Access 1 | 1308 | H Street Soccer Fields | 19581 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 3.985 | H Street Soccer Fields | 0 | Local Recreation Area 3 | 4 | |
6491 | 6491 | 6490 | {"type": "Polygon", "coordinates": [[[-117.10551, 34.88149], [-117.10465, 34.88176], [-117.10406, 34.88048], [-117.10492, 34.88021], [-117.10551, 34.88149]]]} | Open Access 1 | 2408 | Jasper Park | 20368 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 3.17 | Jasper Park | 0 | Local Park 2 | 4 | |
6603 | 6603 | 6602 | {"type": "Polygon", "coordinates": [[[-117.01468, 34.89471], [-117.01472, 34.89472], [-117.01473, 34.89475], [-117.01474, 34.8965], [-117.01472, 34.89653], [-117.01469, 34.89654], [-117.01452, 34.8965], [-117.01439, 34.8964], [-117.01339, 34.89515], [-117.01341, 34.89511], [-117.01356, 34.89503], [-117.0138, 34.89493], [-117.01448, 34.89474], [-117.01468, 34.89471]]]} | Open Access 1 | 4142 | Lillian Park | 21236 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 3.665 | Lillian Park | 0 | Local Park 2 | 4 | |
6622 | 6622 | 6621 | {"type": "Polygon", "coordinates": [[[-117.00204, 34.87659], [-117.002, 34.8781], [-117.00178, 34.8781], [-117.00177, 34.87846], [-117.0008, 34.87847], [-117.00088, 34.87656], [-117.00204, 34.87659]]]} | Open Access 1 | 4309 | Donald A. Stringham Park | 18210 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 5.378 | Donald A. Stringham Park | 0 | Local Park 2 | 4 | |
6638 | 6638 | 6637 | {"type": "Polygon", "coordinates": [[[-117.02404, 34.88821], [-117.02401, 34.89138], [-117.02303, 34.89137], [-117.02303, 34.88821], [-117.02404, 34.88821]]]} | Open Access 1 | 4397 | Dana Park Community Center | 17910 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 7.912 | Dana Park Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
8889 | 8889 | 8888 | {"type": "Polygon", "coordinates": [[[-117.00039, 34.89899], [-116.99965, 34.89924], [-116.99954, 34.89924], [-116.99949, 34.89926], [-116.99946, 34.8993], [-116.99897, 34.89947], [-116.99893, 34.89906], [-116.99887, 34.8987], [-116.99877, 34.89835], [-116.99865, 34.898], [-116.99845, 34.89757], [-116.99821, 34.89716], [-116.99793, 34.89677], [-116.99757, 34.89637], [-116.99757, 34.89607], [-116.99925, 34.8955], [-117.00009, 34.89717], [-116.99957, 34.89736], [-117.0001, 34.8984], [-117.00008, 34.89849], [-117.00009, 34.89854], [-117.00012, 34.89858], [-117.00021, 34.89863], [-117.00039, 34.89899]]]} | Open Access 1 | 14535 | Sturnacle Park | 25939 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 13.792 | Sturnacle Park | 0 | Local Park 2 | 4 | |
9150 | 9150 | 9149 | {"type": "Polygon", "coordinates": [[[-117.02434, 34.90186], [-117.02434, 34.90224], [-117.0241, 34.90224], [-117.02368, 34.90208], [-117.02368, 34.90186], [-117.02434, 34.90186]]]} | Open Access 1 | 15196 | Waterman Park | 27304 | 1021 | Barstow, City of 214 | City 2 | City Agency 2 | http://www.barstowca.org/visitors/parks | City 2 | 1021 | Barstow, City of 210 | City 2 | City Agency 2 | San Bernardino 22 | 0.557 | Waterman 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]);