units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 6 and SUID_NMA = 21704
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7006 | 7006 | 7005 | {"type": "Polygon", "coordinates": [[[-118.68703, 34.06893], [-118.68702, 34.07066], [-118.68603, 34.07063], [-118.68604, 34.06901], [-118.68673, 34.06901], [-118.68688, 34.06898], [-118.68703, 34.06893]]]} | Open Access 1 | 6467 | Malibu Canyon Piuma Ridge Open Space | 21704 | 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 | 4.135 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
16045 | 16045 | 16044 | {"type": "MultiPolygon", "coordinates": [[[[-118.69358, 34.06729], [-118.69357, 34.0705], [-118.6932, 34.07055], [-118.69307, 34.07054], [-118.69296, 34.0705], [-118.69278, 34.07037], [-118.69263, 34.07018], [-118.69251, 34.07006], [-118.69228, 34.06992], [-118.69197, 34.0698], [-118.69188, 34.06973], [-118.69176, 34.06958], [-118.69168, 34.06951], [-118.69154, 34.06944], [-118.69141, 34.0694], [-118.69127, 34.06939], [-118.69113, 34.06939], [-118.69091, 34.06944], [-118.69081, 34.06943], [-118.69072, 34.0694], [-118.69065, 34.06935], [-118.69026, 34.06897], [-118.6901, 34.06878], [-118.68988, 34.06861], [-118.68987, 34.06705], [-118.69358, 34.06729]]], [[[-118.69357, 34.07067], [-118.69357, 34.07089], [-118.68918, 34.07074], [-118.68918, 34.06858], [-118.68959, 34.06869], [-118.68981, 34.06881], [-118.6905, 34.06946], [-118.69066, 34.06956], [-118.69078, 34.06959], [-118.69091, 34.0696], [-118.69127, 34.06955], [-118.69139, 34.06957], [-118.6915, 34.06961], [-118.69162, 34.06969], [-118.69172, 34.06982], [-118.69182, 34.06991], [-118.69187, 34.06994], [-118.69219, 34.07007], [-118.6924, 34.0702], [-118.69253, 34.07033], [-118.69256, 34.07039], [-118.6927, 34.07055], [-118.69287, 34.07065], [-118.69301, 34.0707], [-118.69315, 34.07072], [-118.69357, 34.07067]]]]} | Open Access 1 | 6465 | Malibu Canyon Piuma Ridge Open Space | 21704 | 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 | 35.873 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
16047 | 16047 | 16046 | {"type": "MultiPolygon", "coordinates": [[[[-118.70235, 34.07092], [-118.70224, 34.07455], [-118.69792, 34.0745], [-118.69589, 34.0745], [-118.69357, 34.07448], [-118.69357, 34.07293], [-118.6937, 34.07293], [-118.69401, 34.07288], [-118.69406, 34.07288], [-118.69417, 34.07292], [-118.69425, 34.07299], [-118.69427, 34.07305], [-118.69427, 34.0731], [-118.69422, 34.07323], [-118.69421, 34.07331], [-118.69425, 34.07345], [-118.69437, 34.07358], [-118.69447, 34.07363], [-118.69457, 34.07366], [-118.69532, 34.07369], [-118.69552, 34.07363], [-118.69562, 34.07353], [-118.6957, 34.07341], [-118.69577, 34.07336], [-118.69584, 34.07334], [-118.69651, 34.07338], [-118.69705, 34.07359], [-118.69714, 34.07365], [-118.69717, 34.07371], [-118.69716, 34.07389], [-118.69719, 34.07398], [-118.69726, 34.07408], [-118.69739, 34.07417], [-118.6975, 34.0742], [-118.69764, 34.07419], [-118.69771, 34.07418], [-118.69787, 34.07408], [-118.69791, 34.07403], [-118.69795, 34.07394], [-118.69796, 34.07384], [-118.69794, 34.07376], [-118.6979, 34.07369], [-118.69754, 34.07339], [-118.69733, 34.07327], [-118.69656, 34.07289], [-118.69642, 34.07284], [-118.69613, 34.07279], [-118.69607, 34.07276], [-118.6959, 34.07265], [-118.69579, 34.07261], [-118.69558, 34.0726], [-118.69547, 34.07257], [-118.69539, 34.07248], [-118.69518, 34.07205], [-118.69508, 34.07193], [-118.6949, 34.07183], [-118.69451, 34.07178], [-118.69443, 34.07176], [-118.69437, 34.07171], [-118.69433, 34.07165], [-118.69433, 34.07157], [-118.69442, 34.07111], [-118.69442, 34.07097], [-118.69439, 34.07089], [-118.70235, 34.07092]]], [[[-118.69776, 34.07391], [-118.69768, 34.074], [-118.69762, 34.07403], [-118.69751, 34.07403], [-118.69745, 34.07401], [-118.6974, 34.07397], [-118.69737, 34.07392], [-118.69735, 34.07365], [-118.69732, 34.07358], [-118.69724, 34.0735], [-118.69712, 34.07343], [-118.69661, 34.07324], [-118.69652, 34.07322], [-118.69593, 34.07317], [-118.69577, 34.07318], [-118.69562, 34.07325], [-118.69553, 34.07334], [-118.69543, 34.07347], [-118.69537, 34.07351], [-118.6953, 34.07353], [-118.6946, 34.0735], [-118.69452, 34.07347], [-118.69445, 34.07342], [-118.69442, 34.07335], [-118.69442, 34.07326], [-118.69447, 34.07313], [-118.69446, 34.07298], [-118.69441, 34.07289], [-118.69431, 34.0728], [-118.6942, 34.07275], [-118.69407, 34.07272], [-118.69358, 34.07277], [-118.69357, 34.07088], [-118.69418, 34.07088], [-118.69421, 34.07095], [-118.69422, 34.07108], [-118.69412, 34.07158], [-118.69414, 34.07168], [-118.6942, 34.07179], [-118.69431, 34.07189], [-118.69441, 34.07193], [-118.6948, 34.07198], [-118.69491, 34.07202], [-118.69497, 34.07207], [-118.69501, 34.07213], [-118.69523, 34.07258], [-118.69535, 34.07269], [-118.69544, 34.07274], [-118.69555, 34.07276], [-118.69575, 34.07277], [-118.69602, 34.07293], [-118.69634, 34.07299], [-118.6965, 34.07305], [-118.69728, 34.07344], [-118.69744, 34.07354], [-118.69771, 34.07375], [-118.69776, 34.07381], [-118.69776, 34.07391]]]]} | Open Access 1 | 6466 | Malibu Canyon Piuma Ridge Open Space | 21704 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 74.802 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 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]);