units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, GAP_STS
DES_TP 4
MNG_AGENCY 3
MNG_AG_TYP 1
- Open Space District · 7 ✖
MNG_AG_LEV 1 ✖
ACCESS_TYP 1
- Restricted Access · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7268 | 7268 | 7267 | {"type": "Polygon", "coordinates": [[[-118.66547, 34.09257], [-118.66492, 34.09257], [-118.66491, 34.09075], [-118.66545, 34.09076], [-118.66547, 34.09257]]]} | Restricted Access 2 | 6488 | Cold Creek Canyon Preserve | 17481 | 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 | 2.52 | Cold Creek Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
14384 | 14384 | 14383 | {"type": "Polygon", "coordinates": [[[-118.96126, 34.18591], [-118.96086, 34.18776], [-118.96044, 34.1877], [-118.96044, 34.18733], [-118.96018, 34.1869], [-118.95949, 34.18737], [-118.95917, 34.18749], [-118.95899, 34.18751], [-118.95881, 34.18751], [-118.95863, 34.18749], [-118.9584, 34.18742], [-118.95807, 34.18736], [-118.95816, 34.18723], [-118.9582, 34.18686], [-118.95811, 34.18649], [-118.95798, 34.18627], [-118.95764, 34.18647], [-118.95748, 34.18629], [-118.95768, 34.18611], [-118.95782, 34.18623], [-118.9585, 34.18623], [-118.95851, 34.18593], [-118.96126, 34.18591]]]} | Restricted Access 2 | 47116 | Alta Vista Open Space | 30792 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Alta Vista | Ventura 8 | 10.982 | Alta Vista OS | 0 | Local Recreation Area 3 | 4 |
806 | 806 | 805 | {"type": "Polygon", "coordinates": [[[-118.36891, 33.73931], [-118.36872, 33.73989], [-118.36801, 33.74037], [-118.3676, 33.74059], [-118.36705, 33.7408], [-118.36659, 33.74091], [-118.36593, 33.741], [-118.36518, 33.74102], [-118.36184, 33.74064], [-118.36135, 33.74054], [-118.36085, 33.74039], [-118.36043, 33.74023], [-118.35991, 33.74], [-118.36013, 33.7397], [-118.36194, 33.73906], [-118.36225, 33.73793], [-118.36307, 33.73841], [-118.36421, 33.7389], [-118.36458, 33.73893], [-118.36486, 33.73874], [-118.36576, 33.73874], [-118.36599, 33.73867], [-118.36603, 33.73842], [-118.36669, 33.73848], [-118.36759, 33.73837], [-118.36825, 33.73811], [-118.3684, 33.7379], [-118.36858, 33.73667], [-118.36844, 33.73652], [-118.36862, 33.73606], [-118.36885, 33.7361], [-118.36869, 33.73753], [-118.36863, 33.73839], [-118.36868, 33.73907], [-118.36891, 33.73931]]]} | Restricted Access 2 | 5870 | Abalone Cove Shoreline Archery Range | 29497 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.317 | Abalone Cove Shoreline Archery Range | None 73 | |||
16119 | 16119 | 16118 | {"type": "MultiPolygon", "coordinates": [[[[-118.91157, 34.19061], [-118.91076, 34.19098], [-118.91079, 34.19125], [-118.911, 34.19126], [-118.90934, 34.19128], [-118.90916, 34.18971], [-118.90747, 34.18972], [-118.90516, 34.18937], [-118.90334, 34.18882], [-118.90226, 34.18875], [-118.90207, 34.18833], [-118.90224, 34.18766], [-118.90207, 34.1868], [-118.90146, 34.1862], [-118.90071, 34.18638], [-118.90034, 34.18671], [-118.89968, 34.18636], [-118.89939, 34.18597], [-118.8996, 34.18536], [-118.89983, 34.18592], [-118.90024, 34.18605], [-118.90052, 34.18607], [-118.90077, 34.18597], [-118.90168, 34.18602], [-118.90188, 34.1861], [-118.90246, 34.18627], [-118.90261, 34.1866], [-118.9027, 34.18712], [-118.90335, 34.18712], [-118.90335, 34.18611], [-118.90369, 34.18701], [-118.9037, 34.18779], [-118.904, 34.18822], [-118.90469, 34.18838], [-118.90498, 34.18818], [-118.90534, 34.18789], [-118.90668, 34.18786], [-118.90717, 34.18746], [-118.90691, 34.18584], [-118.90689, 34.18532], [-118.9073, 34.18556], [-118.90727, 34.18568], [-118.9075, 34.18631], [-118.90799, 34.18703], [-118.9081, 34.18785], [-118.90807, 34.18793], [-118.90808, 34.18799], [-118.90797, 34.18804], [-118.9079, 34.18827], [-118.90834, 34.18839], [-118.90859, 34.18831], [-118.90902, 34.18861], [-118.90954, 34.18851], [-118.90973, 34.18863], [-118.90982, 34.18875], [-118.90985, 34.18899], [-118.91008, 34.18913], [-118.91032, 34.18918], [-118.91061, 34.18937], [-118.9112, 34.18927], [-118.91131, 34.19008], [-118.9114, 34.19032], [-118.91157, 34.19061]]], [[[-118.91331, 34.19124], [-118.91268, 34.19124], [-118.91244, 34.19109], [-118.91221, 34.1909], [-118.91203, 34.1907], [-118.91188, 34.19049], [-118.91174, 34.1902], [-118.91164, 34.18986], [-118.9116, 34.1894], [-118.9115, 34.18847], [-118.9115, 34.18844], [-118.91153, 34.18841], [-118.91159, 34.18839], [-118.91201, 34.18843], [-118.91254, 34.18845], [-118.91253, 34.18868], [-118.91258, 34.18896], [-118.91248, 34.18913], [-118.91206, 34.18905], [-118.91205, 34.18906], [-118.91206, 34.18938], [-118.91213, 34.18948], [-118.91211, 34.18952], [-118.91212, 34.18957], [-118.91217, 34.18964], [-118.91226, 34.18966], [-118.91226, 34.19009], [-118.91221, 34.19009], [-118.9122, 34.1901], [-118.91229, 34.1904], [-118.91253, 34.19035], [-118.91262, 34.19028], [-118.91273, 34.19029], [-118.91279, 34.19069], [-118.91287, 34.19067], [-118.91331, 34.19124]]]]} | Restricted Access 2 | 15697 | Arroyo Conejo - South Arroyo Conejo Open Space | 15611 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 51.646 | Arroyo Conejo - South Arroyo Conejo OS | 0 | Local Recreation Area 3 | 4 | |
10164 | 10164 | 10163 | {"type": "MultiPolygon", "coordinates": [[[[-118.84855, 34.24985], [-118.84596, 34.24985], [-118.84425, 34.24637], [-118.8434, 34.24584], [-118.84348, 34.24568], [-118.84353, 34.2455], [-118.84364, 34.24539], [-118.84364, 34.24532], [-118.84504, 34.24501], [-118.84474, 34.24411], [-118.84854, 34.24411], [-118.84855, 34.24985]]], [[[-118.86474, 34.23439], [-118.86447, 34.23463], [-118.8643, 34.23484], [-118.86396, 34.23521], [-118.86369, 34.23541], [-118.86334, 34.23555], [-118.86303, 34.23572], [-118.86225, 34.23593], [-118.86198, 34.23603], [-118.86159, 34.23626], [-118.86079, 34.23677], [-118.86038, 34.23699], [-118.86021, 34.23727], [-118.86016, 34.23752], [-118.86024, 34.2378], [-118.86038, 34.23806], [-118.86057, 34.23827], [-118.85764, 34.23997], [-118.85732, 34.23972], [-118.85688, 34.23922], [-118.8567, 34.23937], [-118.85642, 34.23902], [-118.85632, 34.23895], [-118.85636, 34.23903], [-118.85548, 34.23835], [-118.85571, 34.2381], [-118.85492, 34.23698], [-118.85492, 34.23632], [-118.85719, 34.23503], [-118.85722, 34.23505], [-118.86194, 34.23376], [-118.86385, 34.23405], [-118.86474, 34.23439]]]]} | Restricted Access 2 | 17739 | McCrea Wildlife Preserve | 22017 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 128.567 | McCrea Wildlife Preserve | 0 | Local Conservation Area 4 | 2 | |
4117 | 4117 | 4116 | {"type": "Polygon", "coordinates": [[[-118.921, 34.20591], [-118.92099, 34.2097], [-118.92022, 34.20901], [-118.91855, 34.20853], [-118.91575, 34.2074], [-118.91433, 34.20701], [-118.91473, 34.20578], [-118.91189, 34.20579], [-118.9117, 34.20575], [-118.91279, 34.20491], [-118.91208, 34.20449], [-118.91277, 34.2032], [-118.9125, 34.20197], [-118.91026, 34.20222], [-118.91025, 34.20301], [-118.90929, 34.20311], [-118.90827, 34.20385], [-118.90696, 34.2037], [-118.90725, 34.20331], [-118.90673, 34.20267], [-118.90598, 34.20258], [-118.90596, 34.20197], [-118.90453, 34.20257], [-118.90433, 34.20209], [-118.90377, 34.2021], [-118.90312, 34.20204], [-118.90268, 34.20197], [-118.90262, 34.20193], [-118.90248, 34.20157], [-118.90165, 34.20139], [-118.90109, 34.20142], [-118.90064, 34.20099], [-118.9011, 34.20077], [-118.90071, 34.20017], [-118.90045, 34.19943], [-118.90145, 34.19998], [-118.90194, 34.20006], [-118.90259, 34.20052], [-118.90294, 34.20059], [-118.90276, 34.20086], [-118.90277, 34.20088], [-118.90468, 34.20126], [-118.90661, 34.20099], [-118.90665, 34.19895], [-118.90804, 34.19813], [-118.9085, 34.19838], [-118.90889, 34.19713], [-118.9089, 34.19649], [-118.90846, 34.19588], [-118.90768, 34.1956], [-118.9071, 34.19509], [-118.90751, 34.19409], [-118.90785, 34.1934], [-118.90894, 34.19318], [-118.9091, 34.19293], [-118.9093, 34.19275], [-118.90933, 34.19127], [-118.911, 34.19126], [-118.91101, 34.1914], [-118.91095, 34.19154], [-118.91103, 34.19163], [-118.91106, 34.19169], [-118.91111, 34.19186], [-118.91111, 34.192], [-118.91106, 34.19213], [-118.91116, 34.1923], [-118.91116, 34.19248], [-118.91129, 34.19264], [-118.91135, 34.19285], [-118.91127, 34.19297], [-118.91104, 34.19313], [-118.91103, 34.19338], [-118.9108, 34.19329], [-118.91064, 34.1936], [-118.91064, 34.19367], [-118.91055, 34.19375], [-118.90995, 34.19372], [-118.90974, 34.19392], [-118.90962, 34.19409], [-118.90927, 34.19439], [-118.90938, 34.19465], [-118.90922, 34.19486], [-118.90942, 34.19502], [-118.90926, 34.19514], [-118.90954, 34.19538], [-118.90995, 34.19536], [-118.91013, 34.19551], [-118.91029, 34.19567], [-118.91041, 34.19587], [-118.91035, 34.19614], [-118.91072, 34.19618], [-118.91065, 34.19663], [-118.91071, 34.19694], [-118.91087, 34.19722], [-118.91113, 34.19744], [-118.91129, 34.19763], [-118.91135, 34.19776], [-118.91142, 34.1981], [-118.91148, 34.19823], [-118.91165, 34.19849], [-118.91179, 34.19862], [-118.91205, 34.19879], [-118.9123, 34.1989], [-118.91286, 34.19901], [-118.91325, 34.19911], [-118.91352, 34.19922], [-118.91366, 34.19974], [-118.91397, 34.1999], [-118.91393, 34.20004], [-118.91396, 34.20005], [-118.91437, 34.20007], [-118.91468, 34.20014], [-118.91526, 34.20037], [-118.91563, 34.20035], [-118.91584, 34.20027], [-118.91613, 34.2], [-118.91631, 34.19948], [-118.91671, 34.20002], [-118.91669, 34.20093], [-118.91789, 34.20173], [-118.91847, 34.20202], [-118.91823, 34.20298], [-118.91848, 34.20348], [-118.91938, 34.20376], [-118.91977, 34.20424], [-118.91963, 34.2053], [-118.91977, 34.20562], [-118.92032, 34.20592], [-118.92069, 34.20595], [-118.921, 34.20591]]]} | Restricted Access 2 | 47117 | Arroyo Conejo Nature Preserve | 30793 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Arroyo Conejo | Ventura 8 | 250.878 | Arroyo Conejo Nature Preserve | 0 | Local Conservation Area 4 | 2 |
12231 | 12231 | 12230 | {"type": "MultiPolygon", "coordinates": [[[[-117.01207, 33.89306], [-117.00799, 33.89306], [-117.00392, 33.89308], [-117.0039, 33.88945], [-117.01204, 33.88947], [-117.01207, 33.89306]]], [[[-117.01712, 33.86029], [-117.01212, 33.86432], [-117.01211, 33.86385], [-117.00876, 33.86381], [-117.00888, 33.8632], [-117.00883, 33.86293], [-117.00883, 33.86274], [-117.00884, 33.86255], [-117.00889, 33.86234], [-117.00903, 33.86202], [-117.00962, 33.86102], [-117.00969, 33.8606], [-117.00985, 33.86032], [-117.01712, 33.86029]]], [[[-117.02922, 33.86478], [-117.01849, 33.87513], [-117.01632, 33.87516], [-117.01639, 33.86746], [-117.01212, 33.86747], [-117.01212, 33.86543], [-117.0185, 33.86028], [-117.0225, 33.86027], [-117.02922, 33.86478]]], [[[-117.04925, 33.8737], [-117.03855, 33.87392], [-117.0338, 33.86787], [-117.03376, 33.87467], [-117.02487, 33.87505], [-117.02495, 33.88948], [-117.01632, 33.88948], [-117.01639, 33.88239], [-117.01635, 33.87839], [-117.01978, 33.87511], [-117.02996, 33.86528], [-117.03062, 33.86572], [-117.03126, 33.86602], [-117.0333, 33.8668], [-117.03366, 33.86691], [-117.03409, 33.86698], [-117.03432, 33.86699], [-117.03472, 33.86697], [-117.03495, 33.86694], [-117.03521, 33.86689], [-117.03625, 33.86661], [-117.03763, 33.86615], [-117.03793, 33.86609], [-117.03815, 33.86607], [-117.03847, 33.86609], [-117.03878, 33.86616], [-117.03898, 33.86623], [-117.03927, 33.86639], [-117.04041, 33.86722], [-117.04227, 33.86874], [-117.0427, 33.86904], [-117.04318, 33.8693], [-117.04421, 33.86972], [-117.04453, 33.86988], [-117.04685, 33.87167], [-117.04741, 33.87209], [-117.04768, 33.8723], [-117.04925, 33.8737]]]]} | Restricted Access 2 | 25437 | Wolfskill-Driscoll Properties | 27673 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 1135.825 | Wolfskill-Driscoll Properties | 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]);