units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_LEV = 3, DES_TP = 2, MNG_AG_TYP = 3 and PARK_URL = "http://cms.sbcounty.gov/parks/Parks/GlenHelenRegionalPark.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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6500 | 6500 | 6499 | {"type": "Polygon", "coordinates": [[[-117.40908, 34.21288], [-117.40875, 34.21316], [-117.4084, 34.21341], [-117.40818, 34.21347], [-117.40775, 34.21354], [-117.40726, 34.21384], [-117.40712, 34.21446], [-117.40677, 34.21473], [-117.40587, 34.2146], [-117.40556, 34.21359], [-117.40562, 34.21341], [-117.40574, 34.21322], [-117.40764, 34.21164], [-117.40908, 34.21288]]]} | Open Access 1 | 2355 | Glen Helen Regional Park | 10137 | 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/GlenHelenRegionalPark.aspx | San Bernardino 22 | 13.615 | Glen Helen RP | 0 | Local Park 2 | 4 |
16274 | 16274 | 16273 | {"type": "Polygon", "coordinates": [[[-117.41472, 34.20176], [-117.41407, 34.20238], [-117.41109, 34.20186], [-117.41057, 34.20238], [-117.41049, 34.2034], [-117.4103, 34.20659], [-117.41069, 34.20676], [-117.4107, 34.20714], [-117.41069, 34.20743], [-117.41061, 34.20762], [-117.40932, 34.2088], [-117.40903, 34.20844], [-117.40855, 34.20787], [-117.40826, 34.20791], [-117.40764, 34.20832], [-117.4072, 34.20879], [-117.4064, 34.2094], [-117.40631, 34.20975], [-117.40631, 34.21013], [-117.4064, 34.21047], [-117.40657, 34.21073], [-117.40587, 34.21111], [-117.40408, 34.21002], [-117.40353, 34.20918], [-117.40299, 34.20852], [-117.40249, 34.2076], [-117.40167, 34.20731], [-117.40052, 34.20708], [-117.39918, 34.20674], [-117.39917, 34.20677], [-117.3982, 34.2065], [-117.39716, 34.20607], [-117.39589, 34.20576], [-117.3951, 34.20539], [-117.39447, 34.20493], [-117.39387, 34.20422], [-117.39345, 34.20338], [-117.39275, 34.20261], [-117.39196, 34.20194], [-117.3915, 34.20129], [-117.3911, 34.20051], [-117.3903, 34.19952], [-117.38951, 34.19851], [-117.38914, 34.19758], [-117.38917, 34.19612], [-117.38887, 34.19529], [-117.38625, 34.19133], [-117.38765, 34.19059], [-117.3899, 34.19324], [-117.39133, 34.1946], [-117.39245, 34.1954], [-117.39308, 34.19534], [-117.39375, 34.19413], [-117.3952, 34.19285], [-117.3965, 34.19235], [-117.39746, 34.19278], [-117.39817, 34.19325], [-117.39822, 34.19377], [-117.39859, 34.19433], [-117.39911, 34.1947], [-117.39997, 34.19494], [-117.40072, 34.19556], [-117.40136, 34.19621], [-117.4018, 34.19698], [-117.40225, 34.1976], [-117.40389, 34.19676], [-117.40445, 34.19561], [-117.40619, 34.19601], [-117.40669, 34.19768], [-117.40689, 34.19976], [-117.40852, 34.19808], [-117.41472, 34.20176]]]} | Open Access 1 | 1031 | Glen Helen Regional Park | 10137 | 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/GlenHelenRegionalPark.aspx | San Bernardino 22 | 613.207 | Glen Helen 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]);