units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "26.118", DES_TP = 14 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 Other or Unknown · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4740 | 4740 | 4739 | {"type": "MultiPolygon", "coordinates": [[[[-118.35337, 34.23918], [-118.35319, 34.2395], [-118.35304, 34.2395], [-118.35303, 34.23943], [-118.35127, 34.23943], [-118.35142, 34.23811], [-118.35184, 34.23811], [-118.352, 34.23858], [-118.35234, 34.23863], [-118.35337, 34.23918]]], [[[-118.35488, 34.2381], [-118.35477, 34.23818], [-118.35466, 34.23833], [-118.35452, 34.2384], [-118.35437, 34.23855], [-118.35406, 34.23883], [-118.3537, 34.23896], [-118.35353, 34.23905], [-118.35342, 34.23907], [-118.35338, 34.23914], [-118.35235, 34.2386], [-118.35242, 34.23843], [-118.35308, 34.23826], [-118.35331, 34.238], [-118.35443, 34.23796], [-118.35468, 34.23784], [-118.35488, 34.2381]]], [[[-118.35726, 34.23947], [-118.35442, 34.23949], [-118.35324, 34.2395], [-118.35345, 34.2391], [-118.35355, 34.23908], [-118.35372, 34.23899], [-118.35408, 34.23886], [-118.3544, 34.23858], [-118.35454, 34.23842], [-118.35469, 34.23835], [-118.3548, 34.2382], [-118.35495, 34.2381], [-118.35505, 34.23795], [-118.35551, 34.23767], [-118.35574, 34.23749], [-118.3559, 34.23743], [-118.35597, 34.23735], [-118.35618, 34.23718], [-118.3564, 34.23693], [-118.35643, 34.23685], [-118.35724, 34.23682], [-118.35726, 34.23947]]], [[[-118.35724, 34.23678], [-118.35641, 34.23682], [-118.35636, 34.23692], [-118.35615, 34.23716], [-118.35594, 34.23733], [-118.35587, 34.23741], [-118.35572, 34.23746], [-118.35548, 34.23765], [-118.35502, 34.23793], [-118.35491, 34.23808], [-118.35471, 34.23782], [-118.35527, 34.23753], [-118.35604, 34.23678], [-118.3564, 34.23665], [-118.35724, 34.23664], [-118.35724, 34.23678]]]]} | Unknown Access 4 | 46397 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 26.118 | 0 | Local Other or Unknown 14 | 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]);