units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, LABEL_NAME = "San Dimas Canyon Community RP" and MNG_AGENCY = 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7387 | 7387 | 7386 | {"type": "MultiPolygon", "coordinates": [[[[-117.79911, 34.13603], [-117.79426, 34.13606], [-117.79427, 34.13251], [-117.79262, 34.13252], [-117.79263, 34.1289], [-117.78994, 34.12891], [-117.78994, 34.12886], [-117.79427, 34.12669], [-117.79427, 34.128], [-117.79472, 34.12813], [-117.79525, 34.12847], [-117.79585, 34.12921], [-117.79615, 34.12973], [-117.79675, 34.13059], [-117.79695, 34.13097], [-117.79725, 34.13136], [-117.79732, 34.13175], [-117.79767, 34.13221], [-117.79775, 34.13239], [-117.79773, 34.13284], [-117.79803, 34.13355], [-117.79827, 34.13385], [-117.79839, 34.13447], [-117.79846, 34.13468], [-117.7989, 34.13531], [-117.79911, 34.13585], [-117.79911, 34.13603]]], [[[-117.79478, 34.12804], [-117.79438, 34.12791], [-117.79438, 34.12779], [-117.79438, 34.12779], [-117.79478, 34.12804]]], [[[-117.80291, 34.1325], [-117.80286, 34.13598], [-117.79923, 34.13603], [-117.79924, 34.13583], [-117.79903, 34.13526], [-117.79859, 34.13464], [-117.79853, 34.13446], [-117.7984, 34.13381], [-117.79815, 34.13351], [-117.79786, 34.13283], [-117.79788, 34.13246], [-117.80291, 34.1325]]]]} | Open Access 1 | 6782 | San Dimas Canyon Community Regional Park | 29582 | 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 | 127.929 | San Dimas Canyon 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]);