superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where ACCESS_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5122 | 5122 | 5121 | {"type": "Polygon", "coordinates": [[[-122.17241, 37.33079], [-122.17235, 37.33081], [-122.17235, 37.33446], [-122.16833, 37.33421], [-122.1683, 37.33438], [-122.16716, 37.3344], [-122.16717, 37.33822], [-122.17235, 37.33809], [-122.17206, 37.34613], [-122.17225, 37.35279], [-122.15952, 37.35407], [-122.15898, 37.35422], [-122.15771, 37.35417], [-122.15738, 37.3542], [-122.15695, 37.3543], [-122.1568, 37.3543], [-122.15627, 37.35425], [-122.15542, 37.35424], [-122.15514, 37.35426], [-122.15427, 37.35436], [-122.15415, 37.35434], [-122.15405, 37.3543], [-122.15304, 37.35373], [-122.15243, 37.35333], [-122.15194, 37.35306], [-122.15151, 37.35274], [-122.15122, 37.35254], [-122.15102, 37.35243], [-122.15081, 37.35234], [-122.1508, 37.35037], [-122.15078, 37.34885], [-122.15069, 37.34594], [-122.14674, 37.34599], [-122.14609, 37.33104], [-122.14611, 37.33102], [-122.14611, 37.32785], [-122.15013, 37.32779], [-122.15021, 37.32355], [-122.16012, 37.32344], [-122.16009, 37.33088], [-122.16713, 37.33079], [-122.16707, 37.32727], [-122.17228, 37.32714], [-122.1723, 37.32766], [-122.17165, 37.32804], [-122.17165, 37.3284], [-122.17233, 37.32841], [-122.17241, 37.33079]]]} | Restricted Access 2 | Hidden Villa (Duveneck Ranch) | 19921 | 3093 | Trust for Hidden Villa 909 | Non Profit 6 | Non Profit - Conservation 12 | http://www.hiddenvilla.org | Non Governmental Organization 10 | 1553.455 | Hidden Villa (Duveneck Ranch) | 1982 | |
5297 | 5297 | 5296 | {"type": "Polygon", "coordinates": [[[-124.16888, 40.85809], [-124.16824, 40.85924], [-124.16227, 40.85914], [-124.16173, 40.85708], [-124.16234, 40.85708], [-124.16254, 40.85779], [-124.16325, 40.85769], [-124.16427, 40.85767], [-124.16439, 40.85809], [-124.16888, 40.85809]]]} | Restricted Access 2 | Humboldt Coastal Nature Center | 20144 | 3127 | Friends of the Dunes 606 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofthedunes.org/ | Non Governmental Organization 10 | 19.449 | Humboldt Coastal Nature Ctr. | ||
8084 | 8084 | 8083 | {"type": "Polygon", "coordinates": [[[-122.74268, 38.6103], [-122.74242, 38.61029], [-122.74161, 38.61], [-122.74135, 38.60995], [-122.73955, 38.61012], [-122.73842, 38.61012], [-122.73808, 38.61007], [-122.73775, 38.60998], [-122.73673, 38.60997], [-122.73604, 38.61004], [-122.73532, 38.61026], [-122.73491, 38.61034], [-122.73335, 38.61045], [-122.7333, 38.60526], [-122.72456, 38.60531], [-122.72434, 38.59792], [-122.71517, 38.59794], [-122.71494, 38.5906], [-122.71444, 38.59059], [-122.70581, 38.59066], [-122.70585, 38.59346], [-122.70432, 38.59338], [-122.68741, 38.59232], [-122.68714, 38.58312], [-122.6871, 38.57991], [-122.68205, 38.57987], [-122.68198, 38.57623], [-122.68195, 38.57621], [-122.68533, 38.56871], [-122.68239, 38.5686], [-122.6827, 38.5682], [-122.68357, 38.56783], [-122.68412, 38.56731], [-122.68409, 38.56653], [-122.68558, 38.56657], [-122.68554, 38.56517], [-122.68474, 38.56513], [-122.68492, 38.56472], [-122.68504, 38.5643], [-122.6852, 38.56389], [-122.68536, 38.56376], [-122.68547, 38.56372], [-122.6856, 38.5637], [-122.68607, 38.56373], [-122.68667, 38.56406], [-122.68689, 38.56413], [-122.68712, 38.56417], [-122.68815, 38.56406], [-122.68861, 38.56383], [-122.68874, 38.56379], [-122.6889, 38.56378], [-122.68897, 38.56378], [-122.68918, 38.56382], [-122.68951, 38.56398], [-122.6897, 38.56404], [-122.68994, 38.56402], [-122.69011, 38.56392], [-122.69068, 38.56333], [-122.69093, 38.56333], [-122.69112, 38.56348], [-122.69156, 38.56498], [-122.69206, 38.56576], [-122.69608, 38.56522], [-122.69608, 38.5687], [-122.69609, 38.56871], [-122.7053, 38.56865], [-122.70533, 38.5651], [-122.70999, 38.56509], [-122.71015, 38.56896], [-122.71472, 38.56889], [-122.71925, 38.56899], [-122.72432, 38.56892], [-122.72878, 38.56905], [-122.72835, 38.56607], [-122.72834, 38.56531], [-122.73546, 38.56532], [-122.73557, 38.56536], [-122.73753, 38.56535], [-122.73778, 38.57276], [-122.72902, 38.5727], [-122.72924, 38.57622], [-122.72634, 38.5762], [-122.71941, 38.57621], [-122.71936, 38.58299], [-122.71959, 38.59055], [-122.73326, 38.59051], [-122.73326, 38.59283], [-122.73294, 38.59325], [-122.73199, 38.594], [-122.73153, 38.59417], [-122.73154, 38.59418], [-122.73326, 38.59416], [-122.73335, 38.59992], [-122.7341, 38.60016], [-122.73457, 38.60039], [-122.73503, 38.60145], [-122.74256, 38.60159], [-122.74265, 38.60433], [-122.74268, 38.6103]]]} | Restricted Access 2 | Pepperwood Ranch Natural Preserve | 23601 | 3010 | California Academy of Sciences 515 | Non Profit 6 | Non Profit - Conservation 12 | http://www.calacademy.org/ | Non Governmental Organization 10 | 3046.128 | Pepperwood Ranch Natural Preserve | ||
8679 | 8679 | 8678 | {"type": "Polygon", "coordinates": [[[-122.49639, 37.88427], [-122.49453, 37.88741], [-122.4931, 37.88965], [-122.49261, 37.8905], [-122.4923, 37.89097], [-122.49188, 37.89166], [-122.49167, 37.89196], [-122.49029, 37.89432], [-122.48955, 37.89554], [-122.48881, 37.89557], [-122.48978, 37.89388], [-122.48955, 37.89379], [-122.4886, 37.89402], [-122.48779, 37.89409], [-122.48771, 37.89414], [-122.48431, 37.8909], [-122.4841, 37.89121], [-122.48364, 37.89071], [-122.4838, 37.89046], [-122.48247, 37.88939], [-122.48215, 37.88917], [-122.48181, 37.88898], [-122.48152, 37.88884], [-122.47989, 37.88823], [-122.47879, 37.88771], [-122.47764, 37.88709], [-122.47656, 37.88639], [-122.47498, 37.8851], [-122.47325, 37.88364], [-122.48007, 37.87313], [-122.48272, 37.87462], [-122.48358, 37.87496], [-122.48609, 37.87599], [-122.48677, 37.87623], [-122.49182, 37.87836], [-122.49434, 37.87888], [-122.49639, 37.88427]], [[-122.48122, 37.88414], [-122.47846, 37.88316], [-122.47745, 37.88484], [-122.48029, 37.8859], [-122.48068, 37.88606], [-122.4814, 37.88628], [-122.48236, 37.88461], [-122.48122, 37.88414]], [[-122.48736, 37.88445], [-122.48735, 37.88443], [-122.48336, 37.88289], [-122.48239, 37.8846], [-122.48632, 37.88604], [-122.48736, 37.88445]]]} | Restricted Access 2 | Richardson Bay Audubon Center & Sanctuary | 24330 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 633.307 | Richardson Bay Audubon Ctr. & Sanctuary | ||
9689 | 9689 | 9688 | {"type": "Polygon", "coordinates": [[[-116.88449, 32.9177], [-116.88442, 32.91819], [-116.88434, 32.91843], [-116.88422, 32.91866], [-116.88382, 32.91883], [-116.88374, 32.91886], [-116.88364, 32.91887], [-116.88353, 32.91892], [-116.88342, 32.919], [-116.88329, 32.91915], [-116.88323, 32.91919], [-116.88322, 32.91923], [-116.88261, 32.91942], [-116.88177, 32.91964], [-116.88175, 32.91967], [-116.88048, 32.92002], [-116.87996, 32.92023], [-116.87923, 32.92062], [-116.87894, 32.92081], [-116.87862, 32.92107], [-116.8761, 32.92338], [-116.87568, 32.92378], [-116.87552, 32.92398], [-116.87355, 32.92403], [-116.87354, 32.92387], [-116.87288, 32.92386], [-116.8671, 32.92734], [-116.86707, 32.92253], [-116.86293, 32.92261], [-116.8629, 32.91899], [-116.85859, 32.91904], [-116.84121, 32.91914], [-116.84119, 32.9155], [-116.85857, 32.91537], [-116.85906, 32.91535], [-116.86072, 32.91536], [-116.86073, 32.91535], [-116.86072, 32.91264], [-116.86927, 32.9126], [-116.87363, 32.91259], [-116.87362, 32.91458], [-116.88181, 32.91446], [-116.88184, 32.91631], [-116.88279, 32.91634], [-116.88275, 32.91768], [-116.88449, 32.9177]]]} | Restricted Access 2 | Silverwood Wildlife Sanctuary | http://www.sandiegoaudubon.org/our-work/sanctuaries/silverwood-wildlife-sanctuary | 25502 | 3064 | San Diego Audubon Society 811 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sandiegoaudubon.org/ | Non Governmental Organization 10 | 709.33 | Silverwood Wildlife Sanctuary | |
9934 | 9934 | 9933 | {"type": "Polygon", "coordinates": [[[-117.57902, 33.58951], [-117.57896, 33.59074], [-117.57853, 33.59103], [-117.57809, 33.59189], [-117.57838, 33.59334], [-117.57721, 33.59242], [-117.57515, 33.59261], [-117.5737, 33.59287], [-117.57326, 33.59309], [-117.57276, 33.59369], [-117.57217, 33.59393], [-117.572, 33.59395], [-117.57199, 33.59445], [-117.57216, 33.59471], [-117.57252, 33.5964], [-117.57414, 33.59725], [-117.57567, 33.59836], [-117.57617, 33.59907], [-117.5757, 33.60262], [-117.57532, 33.60368], [-117.5756, 33.60429], [-117.57515, 33.60712], [-117.57356, 33.60918], [-117.5663, 33.61268], [-117.56567, 33.61584], [-117.56594, 33.6181], [-117.56581, 33.61827], [-117.56019, 33.62748], [-117.55887, 33.63202], [-117.55928, 33.63476], [-117.55686, 33.63893], [-117.55512, 33.64261], [-117.5555, 33.64417], [-117.55618, 33.64419], [-117.54794, 33.64434], [-117.54792, 33.64076], [-117.55223, 33.64069], [-117.55224, 33.63716], [-117.55241, 33.62995], [-117.54826, 33.62995], [-117.5486, 33.62269], [-117.5406, 33.62252], [-117.54049, 33.61571], [-117.53174, 33.60981], [-117.52799, 33.60743], [-117.53157, 33.60396], [-117.53515, 33.59994], [-117.53662, 33.5993], [-117.53879, 33.59767], [-117.54257, 33.59324], [-117.54437, 33.59229], [-117.54667, 33.59327], [-117.54867, 33.59127], [-117.55217, 33.59004], [-117.55576, 33.58631], [-117.55621, 33.586], [-117.55621, 33.57993], [-117.57278, 33.57994], [-117.57325, 33.58107], [-117.57331, 33.58257], [-117.57356, 33.58281], [-117.57359, 33.58295], [-117.57469, 33.58288], [-117.57554, 33.58262], [-117.57592, 33.583], [-117.5765, 33.58506], [-117.57654, 33.58697], [-117.57764, 33.58799], [-117.57902, 33.58951]]]} | Restricted Access 2 | Starr Ranch | 25808 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3822.769 | Starr Ranch | ||
12552 | 12552 | 12551 | {"type": "MultiPolygon", "coordinates": [[[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62366, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]], [[[-118.80651, 34.10388], [-118.80206, 34.10385], [-118.80208, 34.1003], [-118.80389, 34.10029], [-118.80386, 34.10035], [-118.80379, 34.10035], [-118.80373, 34.10046], [-118.80366, 34.10048], [-118.80356, 34.10055], [-118.80348, 34.10069], [-118.80348, 34.10081], [-118.80355, 34.10093], [-118.80369, 34.10102], [-118.80381, 34.10105], [-118.80395, 34.10104], [-118.80408, 34.10098], [-118.80413, 34.10093], [-118.80432, 34.10065], [-118.80438, 34.1006], [-118.80463, 34.1005], [-118.80488, 34.10029], [-118.8065, 34.10029], [-118.80651, 34.10388]]], [[[-118.80415, 34.10058], [-118.80398, 34.10082], [-118.80393, 34.10087], [-118.80386, 34.10089], [-118.80378, 34.10088], [-118.8037, 34.10083], [-118.80368, 34.10079], [-118.80368, 34.1007], [-118.80374, 34.10063], [-118.80384, 34.10061], [-118.80403, 34.10062], [-118.80415, 34.10058]]]]} | Restricted Access 2 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 39.782 | Mtns. Restoration Trust Parkland | ||
13585 | 13585 | 13584 | {"type": "Polygon", "coordinates": [[[-121.0785, 39.19346], [-121.07797, 39.19474], [-121.07782, 39.19448], [-121.07764, 39.19438], [-121.07745, 39.19437], [-121.07724, 39.19444], [-121.0769, 39.1947], [-121.07627, 39.19509], [-121.07598, 39.19532], [-121.07588, 39.19546], [-121.07579, 39.19565], [-121.07568, 39.19577], [-121.07545, 39.19579], [-121.07529, 39.19574], [-121.07508, 39.19559], [-121.0751, 39.19488], [-121.07484, 39.19487], [-121.07481, 39.19483], [-121.07424, 39.19459], [-121.07408, 39.19416], [-121.07455, 39.19399], [-121.07504, 39.19412], [-121.07623, 39.19359], [-121.07686, 39.19277], [-121.07724, 39.19273], [-121.07836, 39.19326], [-121.0783, 39.19339], [-121.0785, 39.19346]]]} | Restricted Access 2 | North Star House | http://thenorthstarhouse.org/ | 31042 | 3376 | North Star Historic Conservancy 608 | Non Profit 6 | Non Profit - Conservation 12 | http://thenorthstarhouse.org/ | Non Governmental Organization 10 | 14.166 | North Star House | |
13891 | 13891 | 13890 | {"type": "Polygon", "coordinates": [[[-120.40934, 39.2476], [-120.40929, 39.25121], [-120.40457, 39.25119], [-120.39985, 39.25119], [-120.39973, 39.25845], [-120.39016, 39.25874], [-120.38539, 39.25886], [-120.38068, 39.25907], [-120.38068, 39.26615], [-120.37146, 39.26633], [-120.37179, 39.27379], [-120.3624, 39.27407], [-120.3577, 39.27389], [-120.35726, 39.2628], [-120.35269, 39.26267], [-120.35258, 39.25909], [-120.34416, 39.25882], [-120.3441, 39.26084], [-120.34209, 39.26083], [-120.34205, 39.26443], [-120.3375, 39.26436], [-120.33748, 39.26615], [-120.33521, 39.26611], [-120.33519, 39.2697], [-120.33293, 39.26965], [-120.33292, 39.27144], [-120.32839, 39.27134], [-120.32816, 39.28612], [-120.31906, 39.28596], [-120.31909, 39.28409], [-120.31569, 39.28402], [-120.31572, 39.28215], [-120.31233, 39.28207], [-120.31241, 39.27835], [-120.31015, 39.27828], [-120.31031, 39.27083], [-120.31707, 39.27102], [-120.31706, 39.26924], [-120.32157, 39.26936], [-120.32156, 39.26758], [-120.32381, 39.26763], [-120.32381, 39.26587], [-120.32607, 39.26592], [-120.32607, 39.26415], [-120.32835, 39.26419], [-120.32796, 39.25719], [-120.31893, 39.25721], [-120.3188, 39.24999], [-120.32391, 39.25004], [-120.32851, 39.25012], [-120.32812, 39.24272], [-120.32858, 39.22863], [-120.31001, 39.22797], [-120.30937, 39.21405], [-120.32839, 39.21429], [-120.32858, 39.22861], [-120.34426, 39.22825], [-120.34426, 39.22975], [-120.34431, 39.23197], [-120.3442, 39.24435], [-120.36133, 39.2447], [-120.36157, 39.25303], [-120.38076, 39.25265], [-120.38079, 39.25174], [-120.38064, 39.2443], [-120.39759, 39.244], [-120.39998, 39.24394], [-120.39991, 39.24757], [-120.40934, 39.2476]]]} | Restricted Access 2 | Chickering American River Reserve | https://ucnrs.org/reserves/chickering-american-river-reserve/ | 33201 | 3388 | North Fork Association 868 | Non Profit 6 | Non Profit - Conservation 12 | Non Governmental Organization 10 | 5211.493 | Chickering American River Reserve |
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]);