units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 4, AGNCY_LEV = 5, DES_TP = 14 and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, COUNTY
MNG_AG_TYP 1
- Open Space District · 11 ✖
MNG_AGENCY 1
DES_TP 1
- Local Other or Unknown · 11 ✖
ACCESS_TYP 1
- Unknown Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4704 | 4704 | 4703 | {"type": "Polygon", "coordinates": [[[-118.40005, 34.74273], [-118.39563, 34.7428], [-118.39551, 34.74099], [-118.39993, 34.74092], [-118.40005, 34.74273]]]} | Unknown Access 4 | 46152 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.153 | 0 | Local Other or Unknown 14 | 4 | ||
4716 | 4716 | 4715 | {"type": "Polygon", "coordinates": [[[-118.40496, 34.77529], [-118.39615, 34.77542], [-118.39603, 34.76097], [-118.39596, 34.75394], [-118.3961, 34.75369], [-118.4048, 34.75357], [-118.40496, 34.77529]]]} | Unknown Access 4 | 46228 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 480.911 | 0 | Local Other or Unknown 14 | 4 | ||
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 4 | ||
15491 | 15491 | 15490 | {"type": "Polygon", "coordinates": [[[-117.82325, 34.4706], [-117.82215, 34.47059], [-117.82215, 34.46969], [-117.82325, 34.4697], [-117.82325, 34.4706]]]} | Unknown Access 4 | 46159 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.509 | 0 | Local Other or Unknown 14 | 4 | ||
15492 | 15492 | 15491 | {"type": "Polygon", "coordinates": [[[-117.8138, 34.73502], [-117.81378, 34.73671], [-117.81322, 34.73671], [-117.81324, 34.73502], [-117.8138, 34.73502]]]} | Unknown Access 4 | 46161 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.366 | 0 | Local Other or Unknown 14 | 4 | ||
15493 | 15493 | 15492 | {"type": "Polygon", "coordinates": [[[-117.90663, 34.63311], [-117.90661, 34.63403], [-117.90551, 34.63401], [-117.90553, 34.63309], [-117.90663, 34.63311]]]} | Unknown Access 4 | 46162 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.558 | 0 | Local Other or Unknown 14 | 4 | ||
15516 | 15516 | 15515 | {"type": "MultiPolygon", "coordinates": [[[[-118.32788, 34.25114], [-118.32274, 34.2498], [-118.32247, 34.24892], [-118.32243, 34.24892], [-118.32214, 34.24798], [-118.32193, 34.24741], [-118.32174, 34.24699], [-118.32152, 34.24658], [-118.3211, 34.24592], [-118.32081, 34.24554], [-118.32051, 34.24517], [-118.32018, 34.24482], [-118.31982, 34.24448], [-118.31945, 34.24416], [-118.31906, 34.24385], [-118.31864, 34.24356], [-118.31808, 34.24321], [-118.31762, 34.24296], [-118.317, 34.24267], [-118.31652, 34.24247], [-118.31585, 34.24224], [-118.315, 34.24201], [-118.31212, 34.2414], [-118.31148, 34.24125], [-118.31101, 34.24111], [-118.31055, 34.24095], [-118.3101, 34.24077], [-118.30966, 34.24057], [-118.30896, 34.24019], [-118.3083, 34.23977], [-118.30374, 34.23646], [-118.30332, 34.23618], [-118.30289, 34.23591], [-118.30244, 34.23566], [-118.30198, 34.23543], [-118.30152, 34.23523], [-118.30087, 34.23499], [-118.30019, 34.23478], [-118.2996, 34.23463], [-118.2989, 34.2345], [-118.29819, 34.23441], [-118.29765, 34.23437], [-118.29693, 34.23435], [-118.29623, 34.23437], [-118.2962, 34.2339], [-118.29657, 34.23322], [-118.29648, 34.23295], [-118.29674, 34.2329], [-118.29728, 34.23289], [-118.29747, 34.23286], [-118.29763, 34.23282], [-118.29824, 34.23261], [-118.2986, 34.23263], [-118.29898, 34.23269], [-118.2993, 34.23277], [-118.2997, 34.23291], [-118.3001, 34.23309], [-118.3003, 34.23316], [-118.30163, 34.23351], [-118.30227, 34.23364], [-118.30351, 34.23379], [-118.30382, 34.23387], [-118.30402, 34.23394], [-118.30418, 34.23403], [-118.30515, 34.2347], [-118.30533, 34.2348], [-118.30569, 34.23494], [-118.30608, 34.23501], [-118.30641, 34.23501], [-118.30674, 34.23496], [-118.307, 34.23488], [-118.30749, 34.23467], [-118.30766, 34.23463], [-118.31037, 34.23445], [-118.31057, 34.23439], [-118.31098, 34.23419], [-118.31116, 34.23415], [-118.31135, 34.23416], [-118.31289, 34.23452], [-118.31307, 34.23452], [-118.31358, 34.23445], [-118.31375, 34.23446], [-118.31383, 34.23448], [-118.31383, 34.23581], [-118.31381, 34.23755], [-118.3198, 34.23758], [-118.31981, 34.23711], [-118.32024, 34.23729], [-118.32023, 34.23766], [-118.31938, 34.23839], [-118.31912, 34.23875], [-118.31955, 34.23953], [-118.32114, 34.23952], [-118.32237, 34.24026], [-118.32233, 34.24325], [-118.32411, 34.2432], [-118.32788, 34.25114]]], [[[-118.31383, 34.23431], [-118.31357, 34.23429], [-118.31305, 34.23435], [-118.3129, 34.23435], [-118.31139, 34.234], [-118.31115, 34.23399], [-118.31089, 34.23404], [-118.31048, 34.23424], [-118.31033, 34.23428], [-118.30762, 34.23446], [-118.30741, 34.23452], [-118.30691, 34.23473], [-118.30671, 34.23479], [-118.30642, 34.23484], [-118.30615, 34.23485], [-118.30578, 34.23479], [-118.30543, 34.23466], [-118.30528, 34.23457], [-118.30432, 34.23391], [-118.30407, 34.23378], [-118.3045, 34.23382], [-118.30494, 34.2338], [-118.30523, 34.23376], [-118.30632, 34.23354], [-118.30675, 34.2335], [-118.30719, 34.23352], [-118.30817, 34.23368], [-118.30847, 34.2337], [-118.30883, 34.23369], [-118.30913, 34.23366], [-118.30942, 34.2336], [-118.31019, 34.2334], [-118.31044, 34.23334], [-118.31074, 34.23331], [-118.31109, 34.23331], [-118.31157, 34.23338], [-118.31215, 34.23354], [-118.3125, 34.23362], [-118.31346, 34.23371], [-118.31383, 34.23378], [-118.31383, 34.23431]]], [[[-118.32181, 34.24954], [-118.32023, 34.24912], [-118.32023, 34.24885], [-118.31914, 34.24884], [-118.31477, 34.24768], [-118.31483, 34.24349], [-118.31371, 34.24354], [-118.31366, 34.24739], [-118.31147, 34.2468], [-118.31149, 34.24357], [-118.30931, 34.24364], [-118.3093, 34.24484], [-118.30829, 34.24484], [-118.30829, 34.24596], [-118.30491, 34.24506], [-118.30492, 34.24378], [-118.30503, 34.24377], [-118.30502, 34.24296], [-118.30556, 34.24288], [-118.30665, 34.24141], [-118.3061, 34.24015], [-118.30692, 34.2396], [-118.30796, 34.24034], [-118.30853, 34.2407], [-118.30929, 34.2411], [-118.31008, 34.24145], [-118.31091, 34.24174], [-118.3116, 34.24192], [-118.31467, 34.24257], [-118.31546, 34.24278], [-118.31608, 34.24299], [-118.31668, 34.24323], [-118.31722, 34.24349], [-118.31778, 34.2438], [-118.31818, 34.24405], [-118.31856, 34.24432], [-118.31892, 34.2446], [-118.31927, 34.2449], [-118.3196, 34.24521], [-118.3199, 34.24554], [-118.32019, 34.24588], [-118.32045, 34.24624], [-118.32069, 34.2466], [-118.32091, 34.24697], [-118.32122, 34.24762], [-118.32142, 34.24814], [-118.32171, 34.24907], [-118.32167, 34.24909], [-118.32181, 34.24954]]], [[[-118.30829, 34.24639], [-118.30829, 34.24709], [-118.30809, 34.24704], [-118.30747, 34.2467], [-118.30743, 34.24663], [-118.30739, 34.24634], [-118.30736, 34.24627], [-118.30728, 34.24618], [-118.30716, 34.24613], [-118.30707, 34.24612], [-118.30698, 34.24614], [-118.30615, 34.24647], [-118.30606, 34.24651], [-118.30591, 34.24663], [-118.30534, 34.24562], [-118.30829, 34.24639]]], [[[-118.30725, 34.24657], [-118.3072, 34.24639], [-118.3072, 34.24639], [-118.30723, 34.24639], [-118.30725, 34.24657]]], [[[-118.31366, 34.24782], [-118.31365, 34.24835], [-118.31337, 34.24831], [-118.31268, 34.24835], [-118.31256, 34.24832], [-118.31245, 34.24826], [-118.31261, 34.24754], [-118.31366, 34.24782]]], [[[-118.31743, 34.24883], [-118.31475, 34.24882], [-118.31476, 34.24811], [-118.31476, 34.24811], [-118.31743, 34.24883]]], [[[-118.32258, 34.25247], [-118.32018, 34.25246], [-118.32023, 34.24955], [-118.32195, 34.25001], [-118.32237, 34.25136], [-118.32258, 34.25192], [-118.32258, 34.25247]]], [[[-118.32851, 34.25262], [-118.32832, 34.25597], [-118.32778, 34.25641], [-118.32748, 34.25627], [-118.32733, 34.25616], [-118.32721, 34.25603], [-118.32672, 34.25592], [-118.32647, 34.25565], [-118.32649, 34.25532], [-118.32629, 34.25541], [-118.32623, 34.25541], [-118.32616, 34.25533], [-118.32665, 34.25502], [-118.3269, 34.25475], [-118.3272, 34.25454], [-118.3281, 34.254], [-118.32798, 34.2536], [-118.32812, 34.25287], [-118.32776, 34.25256], [-118.32709, 34.25239], [-118.32678, 34.25225], [-118.32659, 34.25202], [-118.32646, 34.25156], [-118.32619, 34.25128], [-118.32592, 34.25118], [-118.32529, 34.25124], [-118.32518, 34.25131], [-118.32498, 34.25174], [-118.32479, 34.25207], [-118.32461, 34.25251], [-118.32433, 34.25283], [-118.32486, 34.25394], [-118.32485, 34.25396], [-118.32449, 34.25355], [-118.32413, 34.25309], [-118.32389, 34.25272], [-118.32361, 34.25222], [-118.32342, 34.25184], [-118.32326, 34.25145], [-118.32289, 34.25027], [-118.32805, 34.25162], [-118.32851, 34.25262]]]]} | Unknown Access 4 | 46477 | Unnamed site - Desert and Mountain Conservation Authority | 29750 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 570.486 | 0 | Local Other or Unknown 14 | 4 | ||
15518 | 15518 | 15517 | {"type": "Polygon", "coordinates": [[[-118.6406, 34.26451], [-118.63942, 34.26478], [-118.63947, 34.26497], [-118.63903, 34.26505], [-118.63764, 34.26489], [-118.63789, 34.26483], [-118.63816, 34.26479], [-118.63839, 34.26478], [-118.63878, 34.2648], [-118.63911, 34.26477], [-118.63935, 34.2647], [-118.64053, 34.2643], [-118.6406, 34.26451]]]} | Unknown Access 4 | 46683 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | Ventura 8 | 1.348 | 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]);