superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13049 | 13049 | 13048 | {"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]} | No Public Access 3 | Walker Priest/La Cresta Property | 30303 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 25.207 | Walker Priest/La Cresta Property | ||
13055 | 13055 | 13054 | {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19481, 33.06132], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06394], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} | No Public Access 3 | Bridges Property | 30290 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 96.351 | Bridges Property | ||
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83783, 32.8379], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.8343], [-116.83922, 32.83545]]]} | No Public Access 3 | Gibson Property | 30291 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 251.411 | Gibson Property | ||
13059 | 13059 | 13058 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 1.954 | Guyot/La Cresta Property | ||
13060 | 13060 | 13059 | {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90259, 32.8693], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89779, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86537], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} | No Public Access 3 | Hanson Property | 30293 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 141.559 | Hanson Property | ||
13061 | 13061 | 13060 | {"type": "MultiPolygon", "coordinates": [[[[-116.84201, 32.81202], [-116.84191, 32.8121], [-116.84131, 32.81251], [-116.8413, 32.81202], [-116.84201, 32.81202]]], [[[-116.84567, 32.81198], [-116.84566, 32.81571], [-116.84136, 32.8157], [-116.84133, 32.81349], [-116.84145, 32.81348], [-116.84145, 32.81308], [-116.84132, 32.81295], [-116.84132, 32.81279], [-116.84209, 32.81225], [-116.84236, 32.81201], [-116.84567, 32.81198]]]]} | No Public Access 3 | Harbison Canyon Property | 30294 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 40.355 | Harbison Canyon Property | ||
13062 | 13062 | 13061 | {"type": "MultiPolygon", "coordinates": [[[[-116.83661, 32.82754], [-116.83656, 32.83029], [-116.82414, 32.83012], [-116.82764, 32.82602], [-116.82778, 32.82508], [-116.82831, 32.82471], [-116.83026, 32.82475], [-116.83028, 32.82503], [-116.83055, 32.82502], [-116.83059, 32.82476], [-116.83239, 32.8248], [-116.8324, 32.82659], [-116.8347, 32.82661], [-116.8361, 32.82754], [-116.83622, 32.82758], [-116.83635, 32.8276], [-116.83647, 32.82759], [-116.83661, 32.82754]]], [[[-116.83662, 32.82663], [-116.83661, 32.82732], [-116.83649, 32.82741], [-116.83635, 32.82744], [-116.83626, 32.82742], [-116.83617, 32.82739], [-116.83504, 32.82663], [-116.83662, 32.82663]]]]} | No Public Access 3 | Kemerko Property | 30295 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 122.701 | Kemerko Property | ||
13063 | 13063 | 13062 | {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} | No Public Access 3 | Saxena/La Cresta Property | 30300 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 4.043 | Saxena/La Cresta Property | ||
13711 | 13711 | 13710 | {"type": "Polygon", "coordinates": [[[-117.76036, 33.6333], [-117.76003, 33.63457], [-117.75946, 33.63534], [-117.75959, 33.6366], [-117.75799, 33.63627], [-117.75777, 33.63505], [-117.75816, 33.6341], [-117.75829, 33.63301], [-117.75797, 33.63238], [-117.75941, 33.63136], [-117.7596, 33.63046], [-117.75905, 33.62932], [-117.75748, 33.62811], [-117.75568, 33.62795], [-117.75455, 33.62681], [-117.75287, 33.62703], [-117.75232, 33.62772], [-117.75125, 33.62755], [-117.75066, 33.62795], [-117.75052, 33.62877], [-117.75004, 33.62956], [-117.75011, 33.62997], [-117.75038, 33.63063], [-117.75039, 33.63152], [-117.75084, 33.63193], [-117.75088, 33.6331], [-117.75252, 33.63418], [-117.75221, 33.63484], [-117.75027, 33.63452], [-117.74936, 33.63421], [-117.7489, 33.63359], [-117.74782, 33.63285], [-117.74759, 33.63246], [-117.74669, 33.63253], [-117.74542, 33.63182], [-117.74514, 33.63121], [-117.74443, 33.63138], [-117.74373, 33.6308], [-117.74323, 33.63067], [-117.74136, 33.63063], [-117.74312, 33.6255], [-117.74522, 33.62259], [-117.74536, 33.6226], [-117.74545, 33.62255], [-117.7455, 33.6224], [-117.74551, 33.62219], [-117.74782, 33.61898], [-117.75092, 33.62051], [-117.75177, 33.62228], [-117.75343, 33.62336], [-117.75265, 33.62571], [-117.75348, 33.62665], [-117.75634, 33.62553], [-117.75672, 33.6262], [-117.75716, 33.62638], [-117.75796, 33.62735], [-117.75843, 33.62773], [-117.76007, 33.62971], [-117.76009, 33.62994], [-117.76033, 33.63064], [-117.75978, 33.63132], [-117.75978, 33.63168], [-117.75996, 33.63186], [-117.75977, 33.63245], [-117.76002, 33.63296], [-117.76036, 33.6333]]]} | No Public Access 3 | Veeh Creek | 31199 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | http://irconservancy.org/index.aspx | Non Governmental Organization 10 | 309.658 | Veeh Creek | ||
14825 | 14825 | 14824 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49753, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89478], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | Audubon Society Lyford House Open Space Area | 15705 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 9.091 | Audubon Society Lyford House OS Area | ||
15577 | 15577 | 15576 | {"type": "MultiPolygon", "coordinates": [[[[-118.60253, 34.07222], [-118.60241, 34.07227], [-118.60218, 34.07226], [-118.60217, 34.07263], [-118.60212, 34.07256], [-118.60205, 34.07251], [-118.60191, 34.07248], [-118.60189, 34.07202], [-118.60197, 34.072], [-118.60221, 34.07203], [-118.60233, 34.07199], [-118.6024, 34.07194], [-118.60253, 34.07222]]], [[[-118.60409, 34.06453], [-118.60408, 34.06544], [-118.60193, 34.06544], [-118.60193, 34.06453], [-118.60409, 34.06453]]], [[[-118.61183, 34.07805], [-118.61181, 34.07986], [-118.61069, 34.07986], [-118.61071, 34.07804], [-118.61183, 34.07805]]], [[[-118.61509, 34.08307], [-118.61508, 34.08325], [-118.61399, 34.08325], [-118.61398, 34.08307], [-118.61509, 34.08307]]], [[[-118.6151, 34.08172], [-118.61509, 34.08198], [-118.61399, 34.08198], [-118.61399, 34.08171], [-118.6151, 34.08172]]], [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]], [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]], [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]], [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]], [[[-118.64775, 34.04924], [-118.64555, 34.04925], [-118.64555, 34.04925], [-118.64573, 34.0491], [-118.64588, 34.04894], [-118.64619, 34.04853], [-118.64631, 34.04842], [-118.64645, 34.04834], [-118.64775, 34.04924]]], [[[-118.67434, 34.03964], [-118.67429, 34.03977], [-118.67426, 34.03993], [-118.67425, 34.04043], [-118.67418, 34.04053], [-118.67404, 34.04066], [-118.67399, 34.04073], [-118.67394, 34.04093], [-118.67391, 34.04099], [-118.67372, 34.04118], [-118.67363, 34.04133], [-118.67354, 34.04159], [-118.67352, 34.04184], [-118.67347, 34.04201], [-118.6734, 34.04213], [-118.67323, 34.04235], [-118.6733, 34.04205], [-118.6733, 34.04199], [-118.67328, 34.04194], [-118.67375, 34.04068], [-118.67374, 34.04062], [-118.67368, 34.04054], [-118.67358, 34.0405], [-118.67252, 34.04064], [-118.67253, 34.04059], [-118.6735, 34.04045], [-118.67361, 34.04045], [-118.67371, 34.04048], [-118.67376, 34.04053], [-118.6738, 34.0406], [-118.67381, 34.04064], [-118.67382, 34.04065], [-118.67387, 34.04051], [-118.67402, 34.03978], [-118.67399, 34.03952], [-118.67425, 34.03936], [-118.67428, 34.03938], [-118.67432, 34.03946], [-118.67434, 34.03964]]], [[[-118.67508, 34.03923], [-118.6749, 34.04047], [-118.67444, 34.0432], [-118.67375, 34.04319], [-118.67367, 34.04274], [-118.67333, 34.04244], [-118.67355, 34.04212], [-118.67363, 34.04194], [-118.6742, 34.04205], [-118.67422, 34.04204], [-118.67431, 34.04138], [-118.67404, 34.04102], [-118.67408, 34.04094], [-118.67409, 34.04083], [-118.67413, 34.04074], [-118.67432, 34.04056], [-118.67438, 34.04045], [-118.67439, 34.03997], [-118.67448, 34.03958], [-118.67446, 34.03948], [-118.67442, 34.03937], [-118.67421, 34.03914], [-118.67418, 34.03908], [-118.67417, 34.03901], [-118.67421, 34.03884], [-118.6742, 34.03876], [-118.67416, 34.03867], [-118.67442, 34.03858], [-118.67464, 34.039], [-118.67508, 34.03923]]], [[[-118.68988, 34.0683], [-118.68988, 34.06861], [-118.6898, 34.06857], [-118.6898, 34.06859], [-118.68956, 34.0685], [-118.68902, 34.06837], [-118.68899, 34.06726], [-118.68798, 34.06719], [-118.68796, 34.06733], [-118.68653, 34.06724], [-118.68653, 34.06684], [-118.68987, 34.06705], [-118.68988, 34.0683]]], [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]], [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]], [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]], [[[-118.77959, 34.0458], [-118.7791, 34.0458], [-118.7791, 34.04539], [-118.77959, 34.04539], [-118.77959, 34.0458]]]]} | No Public Access 3 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 31.005 | Mtns. Restoration Trust Parkland | ||
15597 | 15597 | 15596 | {"type": "MultiPolygon", "coordinates": [[[[-122.48737, 37.88444], [-122.48632, 37.88604], [-122.48238, 37.8846], [-122.4814, 37.88629], [-122.48068, 37.88606], [-122.48029, 37.8859], [-122.47745, 37.88485], [-122.47846, 37.88316], [-122.48122, 37.88414], [-122.48237, 37.88459], [-122.48336, 37.88288], [-122.48737, 37.88444]]], [[[-122.49343, 37.89369], [-122.49298, 37.89377], [-122.4913, 37.8926], [-122.49158, 37.89214], [-122.49343, 37.89369]]], [[[-122.49394, 37.89369], [-122.49366, 37.89367], [-122.49167, 37.89196], [-122.49188, 37.89166], [-122.49394, 37.89369]]], [[[-122.49543, 37.89412], [-122.49528, 37.89413], [-122.49512, 37.89406], [-122.49512, 37.89403], [-122.4923, 37.89097], [-122.49261, 37.8905], [-122.49521, 37.89278], [-122.49543, 37.89412]]], [[[-122.50011, 37.89408], [-122.49954, 37.89424], [-122.49911, 37.89369], [-122.49821, 37.89349], [-122.49747, 37.89359], [-122.49673, 37.89397], [-122.49647, 37.89479], [-122.49642, 37.89482], [-122.49621, 37.89467], [-122.49602, 37.89457], [-122.49616, 37.89407], [-122.49571, 37.89409], [-122.49547, 37.8927], [-122.49273, 37.8903], [-122.4931, 37.88965], [-122.49453, 37.88741], [-122.4975, 37.88853], [-122.49781, 37.88802], [-122.50011, 37.89408]]], [[[-122.50928, 37.87681], [-122.50822, 37.87751], [-122.50769, 37.87701], [-122.50875, 37.8763], [-122.50928, 37.87681]]], [[[-122.50932, 37.87892], [-122.50833, 37.87959], [-122.50816, 37.87951], [-122.50775, 37.87912], [-122.50879, 37.87841], [-122.50932, 37.87892]]]]} | No Public Access 3 | Richardson Bay Audubon Center & Sanctuary | 24329 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 123.816 | Richardson Bay Audubon Ctr. & Sanctuary |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);