units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, LABEL_NAME = "Beverly Glen Park" and MNG_AGENCY = 27
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 1 ✖
DES_TP 1
- Local Park · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7227 | 7227 | 7226 | {"type": "MultiPolygon", "coordinates": [[[[-118.44706, 34.11605], [-118.44644, 34.11605], [-118.44654, 34.11542], [-118.44655, 34.11514], [-118.44658, 34.1151], [-118.44665, 34.1151], [-118.44668, 34.11513], [-118.44706, 34.11605]]], [[[-118.44618, 34.11604], [-118.44484, 34.11604], [-118.44484, 34.1151], [-118.44451, 34.1151], [-118.4445, 34.11352], [-118.44396, 34.11337], [-118.44376, 34.11384], [-118.44371, 34.11405], [-118.44371, 34.11421], [-118.44373, 34.11433], [-118.44387, 34.11474], [-118.44384, 34.1148], [-118.44378, 34.11479], [-118.44346, 34.11499], [-118.44346, 34.11536], [-118.44338, 34.11548], [-118.44279, 34.11594], [-118.44274, 34.11612], [-118.44265, 34.11627], [-118.44222, 34.11633], [-118.44215, 34.11642], [-118.4422, 34.11662], [-118.44246, 34.11684], [-118.44251, 34.11711], [-118.4426, 34.11728], [-118.44245, 34.11747], [-118.44228, 34.11752], [-118.44193, 34.11748], [-118.4418, 34.11756], [-118.44158, 34.11756], [-118.44113, 34.11732], [-118.44103, 34.11704], [-118.44049, 34.11692], [-118.44021, 34.11673], [-118.44021, 34.11602], [-118.4379, 34.11601], [-118.4379, 34.1145], [-118.43905, 34.11444], [-118.44021, 34.1146], [-118.44022, 34.10877], [-118.44407, 34.10878], [-118.44428, 34.10927], [-118.44309, 34.1102], [-118.44397, 34.11237], [-118.44555, 34.11239], [-118.44635, 34.11437], [-118.44631, 34.11477], [-118.44631, 34.11523], [-118.44628, 34.1155], [-118.44618, 34.11604]]]]} | Open Access 1 | 6394 | Beverly Glen Park | 29532 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 95.504 | Beverly Glen 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]);