units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 363, MNG_AG_LEV = 3 and PARK_URL = "http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1439 | 1439 | 1438 | {"type": "Polygon", "coordinates": [[[-117.05558, 34.05159], [-117.05545, 34.05175], [-117.05444, 34.0525], [-117.05184, 34.05424], [-117.05145, 34.05409], [-117.05134, 34.05427], [-117.05134, 34.05498], [-117.0513, 34.05528], [-117.05108, 34.05543], [-117.0508, 34.05546], [-117.05046, 34.0553], [-117.05017, 34.05522], [-117.04994, 34.05551], [-117.04958, 34.05577], [-117.04936, 34.05601], [-117.04886, 34.0572], [-117.04871, 34.05734], [-117.04842, 34.05741], [-117.04818, 34.05735], [-117.04804, 34.05738], [-117.04789, 34.05753], [-117.04769, 34.05762], [-117.04748, 34.05764], [-117.04732, 34.05762], [-117.04713, 34.05751], [-117.04697, 34.05731], [-117.04663, 34.05717], [-117.0467, 34.05696], [-117.04647, 34.05691], [-117.04591, 34.05682], [-117.04577, 34.05674], [-117.04569, 34.05659], [-117.04538, 34.05693], [-117.04483, 34.05699], [-117.04455, 34.05717], [-117.04449, 34.05742], [-117.0447, 34.05762], [-117.04386, 34.05799], [-117.04366, 34.05721], [-117.04564, 34.05461], [-117.04584, 34.05406], [-117.04551, 34.05387], [-117.04517, 34.05357], [-117.04519, 34.05127], [-117.04077, 34.05125], [-117.04071, 34.05101], [-117.04064, 34.05078], [-117.04044, 34.05037], [-117.04033, 34.05004], [-117.04028, 34.04854], [-117.04063, 34.0485], [-117.04379, 34.04851], [-117.0438, 34.04906], [-117.04521, 34.04906], [-117.04521, 34.04884], [-117.04512, 34.0486], [-117.0491, 34.04862], [-117.04886, 34.04874], [-117.04844, 34.04904], [-117.04816, 34.04953], [-117.04817, 34.04955], [-117.0485, 34.04939], [-117.04964, 34.04906], [-117.05035, 34.04876], [-117.05074, 34.04867], [-117.0512, 34.04874], [-117.0515, 34.04885], [-117.05136, 34.04943], [-117.05254, 34.04955], [-117.05255, 34.04987], [-117.05273, 34.05013], [-117.053, 34.05018], [-117.05322, 34.05005], [-117.05421, 34.05028], [-117.05444, 34.0504], [-117.05501, 34.05105], [-117.05545, 34.05101], [-117.05558, 34.05159]], [[-117.04938, 34.05312], [-117.0481, 34.05208], [-117.04792, 34.05228], [-117.04803, 34.05297], [-117.04757, 34.05379], [-117.04726, 34.05442], [-117.04744, 34.05453], [-117.04785, 34.05438], [-117.0478, 34.0547], [-117.04726, 34.05476], [-117.04733, 34.05513], [-117.04728, 34.05535], [-117.04702, 34.05543], [-117.04661, 34.0555], [-117.04655, 34.05569], [-117.04689, 34.05589], [-117.04715, 34.05586], [-117.04751, 34.05546], [-117.04772, 34.05526], [-117.04798, 34.05513], [-117.04819, 34.05481], [-117.0484, 34.05459], [-117.04892, 34.05429], [-117.04892, 34.0537], [-117.04938, 34.05312]], [[-117.04926, 34.05164], [-117.04952, 34.05207], [-117.04972, 34.05212], [-117.04993, 34.05207], [-117.05045, 34.05144], [-117.05102, 34.04999], [-117.04996, 34.04954], [-117.0497, 34.04938], [-117.04965, 34.04987], [-117.04952, 34.05034], [-117.04959, 34.05071], [-117.04952, 34.05097], [-117.04928, 34.05144], [-117.04926, 34.05164]]]} | Open Access 1 | 6427 | Yucaipa Regional Park | 10147 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx | San Bernardino 22 | 172.247 | Yucaipa RP | 0 | Local Park 2 | 4 |
13179 | 13179 | 13178 | {"type": "Polygon", "coordinates": [[[-117.06064, 34.05543], [-117.05008, 34.05571], [-117.05057, 34.05535], [-117.0508, 34.05546], [-117.05108, 34.05543], [-117.05129, 34.05529], [-117.05134, 34.05498], [-117.05134, 34.05478], [-117.0542, 34.05266], [-117.05444, 34.0525], [-117.05545, 34.05175], [-117.05574, 34.05152], [-117.05554, 34.05141], [-117.05545, 34.05101], [-117.05501, 34.05105], [-117.05444, 34.05041], [-117.05421, 34.05028], [-117.05322, 34.05005], [-117.05311, 34.05012], [-117.05255, 34.04982], [-117.05253, 34.04955], [-117.05192, 34.04949], [-117.05141, 34.04922], [-117.0515, 34.04885], [-117.05121, 34.04874], [-117.05074, 34.04867], [-117.05035, 34.04876], [-117.05008, 34.04888], [-117.0485, 34.04939], [-117.04965, 34.04839], [-117.05093, 34.04832], [-117.05093, 34.0483], [-117.0506, 34.04789], [-117.05506, 34.04434], [-117.06032, 34.04116], [-117.06044, 34.04116], [-117.0605, 34.04564], [-117.06049, 34.04844], [-117.06054, 34.04845], [-117.06064, 34.05543]]]} | Open Access 1 | 35154 | Yucaipa Regional Park | 10147 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx | San Bernardino 22 | 241.688 | Yucaipa RP | 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]);