units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 4 and MNG_AGENCY = 27 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 22
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 135 ✖
ACCESS_TYP 1
- Unknown Access · 135 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | 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 | 0.191 | 0 | Local Other or Unknown 14 | 4 | ||
4725 | 4725 | 4724 | {"type": "MultiPolygon", "coordinates": [[[[-118.60336, 34.12324], [-118.60346, 34.12329], [-118.60347, 34.12333], [-118.60345, 34.12337], [-118.60339, 34.12342], [-118.60315, 34.12351], [-118.6031, 34.1234], [-118.60319, 34.12337], [-118.60321, 34.12333], [-118.60336, 34.12324]]], [[[-118.60346, 34.12362], [-118.6033, 34.12361], [-118.6033, 34.12348], [-118.60346, 34.1234], [-118.60346, 34.12362]]]]} | Unknown Access 4 | 46335 | 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 | 0.199 | 0 | Local Other or Unknown 14 | 4 | ||
13940 | 13940 | 13939 | {"type": "Polygon", "coordinates": [[[-118.51887, 34.0562], [-118.51878, 34.05646], [-118.51849, 34.05646], [-118.51849, 34.05623], [-118.51887, 34.0562]]]} | Unknown Access 4 | 46470 | 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 | 0.207 | 0 | Local Other or Unknown 14 | 4 | ||
4754 | 4754 | 4753 | {"type": "MultiPolygon", "coordinates": [[[[-118.34592, 34.12353], [-118.3458, 34.12379], [-118.34566, 34.12375], [-118.34558, 34.12371], [-118.34569, 34.12346], [-118.34592, 34.12353]]], [[[-118.34798, 34.1232], [-118.3477, 34.12337], [-118.3477, 34.12337], [-118.34767, 34.12329], [-118.34796, 34.12316], [-118.34798, 34.1232]]]]} | Unknown Access 4 | 46463 | 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 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
5685 | 5685 | 5684 | {"type": "Polygon", "coordinates": [[[-118.24162, 34.29361], [-118.24118, 34.29391], [-118.24105, 34.29377], [-118.24148, 34.29347], [-118.24162, 34.29361]]]} | Unknown Access 4 | 46196 | 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 | 0.253 | 0 | Local Other or Unknown 14 | 4 | ||
6628 | 6628 | 6627 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.6126, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | 4323 | Llano | 21388 | 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 | 0.253 | Llano | None 535 | |||
8067 | 8067 | 8066 | {"type": "Polygon", "coordinates": [[[-118.5607, 34.04133], [-118.56059, 34.04153], [-118.56053, 34.04148], [-118.56016, 34.04145], [-118.5602, 34.04121], [-118.56031, 34.04121], [-118.56045, 34.04127], [-118.5607, 34.04133]]]} | Unknown Access 4 | 11894 | Schwartz Property | 25197 | 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 | 0.266 | Schwartz Property | 0 | Local Other or Unknown 14 | 4 | |
4736 | 4736 | 4735 | {"type": "Polygon", "coordinates": [[[-118.55432, 34.0444], [-118.55397, 34.04449], [-118.55386, 34.0441], [-118.55429, 34.04411], [-118.5543, 34.04431], [-118.55432, 34.0444]]]} | Unknown Access 4 | 46381 | 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 | 0.335 | 0 | Local Other or Unknown 14 | 4 | ||
4728 | 4728 | 4727 | {"type": "Polygon", "coordinates": [[[-118.54246, 34.04096], [-118.54234, 34.04122], [-118.5418, 34.0411], [-118.54183, 34.04106], [-118.54202, 34.04093], [-118.54209, 34.04083], [-118.54246, 34.04096]]]} | Unknown Access 4 | 46350 | 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 | 0.365 | 0 | Local Other or Unknown 14 | 4 | ||
15501 | 15501 | 15500 | {"type": "Polygon", "coordinates": [[[-118.65299, 34.22381], [-118.65275, 34.22399], [-118.65269, 34.22392], [-118.65241, 34.2235], [-118.65281, 34.2235], [-118.65285, 34.22366], [-118.65299, 34.22381]]]} | Unknown Access 4 | 46175 | 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 | 0.371 | 0 | Local Other or Unknown 14 | 4 | ||
6803 | 6803 | 6802 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | 5319 | MGP Entrance | 22194 | 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 | 0.379 | MGP Entrance | None 553 | |||
15240 | 15240 | 15239 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.19749], [-118.6193, 34.19749], [-118.6193, 34.19743], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | 46238 | Bell Creek Park | 29516 | 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 | 0.384 | Bell Creek Park | 0 | Local Park 2 | 4 | |
4708 | 4708 | 4707 | {"type": "MultiPolygon", "coordinates": [[[[-118.22898, 34.11301], [-118.22892, 34.11313], [-118.22861, 34.11303], [-118.22866, 34.11291], [-118.22866, 34.1126], [-118.22868, 34.11254], [-118.22894, 34.11265], [-118.22877, 34.11291], [-118.22898, 34.11301]]], [[[-118.23051, 34.11336], [-118.23045, 34.11346], [-118.23005, 34.11334], [-118.23022, 34.11324], [-118.23051, 34.11336]]]]} | Unknown Access 4 | 46182 | 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 | 0.409 | 0 | Local Other or Unknown 14 | 4 | ||
15504 | 15504 | 15503 | {"type": "MultiPolygon", "coordinates": [[[[-118.31751, 34.11946], [-118.31731, 34.11964], [-118.31718, 34.11955], [-118.31743, 34.11938], [-118.31751, 34.11946]]], [[[-118.31844, 34.11984], [-118.31785, 34.11984], [-118.31785, 34.1198], [-118.31798, 34.11952], [-118.31808, 34.11957], [-118.31822, 34.11969], [-118.31843, 34.11974], [-118.31846, 34.11978], [-118.31844, 34.11984]]], [[[-118.31849, 34.11957], [-118.31844, 34.11966], [-118.31827, 34.11963], [-118.31817, 34.11954], [-118.31823, 34.11946], [-118.31849, 34.11957]]]]} | Unknown Access 4 | 46185 | 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 | 0.464 | 0 | Local Other or Unknown 14 | 4 | ||
4751 | 4751 | 4750 | {"type": "Polygon", "coordinates": [[[-118.58838, 34.14362], [-118.58838, 34.14286], [-118.58864, 34.14289], [-118.5888, 34.14294], [-118.58889, 34.14303], [-118.58889, 34.1431], [-118.58884, 34.14315], [-118.58857, 34.14326], [-118.5885, 34.14332], [-118.58845, 34.1434], [-118.58843, 34.14354], [-118.58838, 34.14362]]]} | Unknown Access 4 | 46457 | 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 | 0.472 | 0 | Local Other or Unknown 14 | 4 | ||
15272 | 15272 | 15271 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | 46353 | Las Tunas Beach | 29634 | 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 | 0.511 | Las Tunas Beach | 0 | Local Park 2 | 4 | |
4750 | 4750 | 4749 | {"type": "MultiPolygon", "coordinates": [[[[-118.44816, 34.11313], [-118.44785, 34.11322], [-118.44769, 34.11283], [-118.448, 34.11274], [-118.44816, 34.11313]]], [[[-118.44847, 34.11304], [-118.44822, 34.1131], [-118.44805, 34.11268], [-118.44829, 34.11261], [-118.44847, 34.11304]]]]} | Unknown Access 4 | 46451 | 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 | 0.642 | 0 | Local Other or Unknown 14 | 4 | ||
7204 | 7204 | 7203 | {"type": "Polygon", "coordinates": [[[-118.36759, 34.13349], [-118.36743, 34.13395], [-118.36738, 34.13394], [-118.36736, 34.13386], [-118.36729, 34.13382], [-118.36698, 34.13377], [-118.3668, 34.13377], [-118.36673, 34.13381], [-118.36668, 34.1337], [-118.36679, 34.13361], [-118.36681, 34.13361], [-118.36697, 34.1335], [-118.36722, 34.13344], [-118.36717, 34.13334], [-118.36759, 34.13349]]]} | Unknown Access 4 | 6892 | 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 | 0.681 | 0 | Local Other or Unknown 14 | 4 | ||
15494 | 15494 | 15493 | {"type": "MultiPolygon", "coordinates": [[[[-118.65511, 34.44077], [-118.6551, 34.4409], [-118.6542, 34.44088], [-118.6542, 34.44074], [-118.65511, 34.44077]]], [[[-118.65551, 34.44387], [-118.65551, 34.44387], [-118.6555, 34.44464], [-118.65533, 34.44456], [-118.65534, 34.44378], [-118.65539, 34.44374], [-118.65551, 34.44387]]], [[[-118.65737, 34.44004], [-118.65736, 34.44014], [-118.65709, 34.44012], [-118.65711, 34.43996], [-118.65737, 34.44004]]]]} | Unknown Access 4 | 46168 | 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 | 0.757 | 0 | Local Other or Unknown 14 | 4 | ||
4747 | 4747 | 4746 | {"type": "Polygon", "coordinates": [[[-118.52234, 34.44249], [-118.52215, 34.4426], [-118.52067, 34.44113], [-118.52081, 34.44105], [-118.52207, 34.4423], [-118.52234, 34.44249]]]} | Unknown Access 4 | 46420 | 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 | 0.824 | 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]);