units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 16, MNG_AG_TYP = 3 and SUID_NMA = 26756
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16333 | 16333 | 16332 | {"type": "Polygon", "coordinates": [[[-118.66861, 34.44198], [-118.66831, 34.44226], [-118.66816, 34.44237], [-118.66793, 34.44249], [-118.66779, 34.44259], [-118.66774, 34.44269], [-118.66776, 34.44294], [-118.66774, 34.44303], [-118.66767, 34.44315], [-118.66703, 34.44367], [-118.66696, 34.44381], [-118.66696, 34.44411], [-118.66692, 34.4443], [-118.66684, 34.44446], [-118.66669, 34.4447], [-118.66662, 34.44488], [-118.66661, 34.44505], [-118.66662, 34.44519], [-118.66667, 34.44536], [-118.66674, 34.44547], [-118.66805, 34.44548], [-118.66804, 34.44624], [-118.66768, 34.44695], [-118.66731, 34.44666], [-118.6673, 34.44667], [-118.66731, 34.44689], [-118.66619, 34.44672], [-118.66528, 34.44694], [-118.66464, 34.4469], [-118.66462, 34.44689], [-118.66461, 34.44686], [-118.66486, 34.44614], [-118.66477, 34.4461], [-118.66437, 34.44726], [-118.66435, 34.44728], [-118.66431, 34.44728], [-118.66405, 34.44722], [-118.66325, 34.44703], [-118.66334, 34.44676], [-118.66305, 34.4467], [-118.66273, 34.4463], [-118.66226, 34.44593], [-118.66268, 34.44593], [-118.66264, 34.44587], [-118.66204, 34.44586], [-118.66183, 34.44559], [-118.66294, 34.44558], [-118.66293, 34.44194], [-118.66861, 34.44198]], [[-118.6673, 34.44659], [-118.66653, 34.44659], [-118.66591, 34.44649], [-118.66589, 34.44636], [-118.66677, 34.44563], [-118.66677, 34.44561], [-118.66667, 34.44561], [-118.66584, 34.44631], [-118.66586, 34.44652], [-118.66653, 34.44662], [-118.66729, 34.44663], [-118.6673, 34.44659]]]} | Open Access 1 | 7289 | Val Verde Community Regional Park | 26756 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.422 | Val Verde Community 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]);