units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 | |||
15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
15248 | 15248 | 15247 | {"type": "MultiPolygon", "coordinates": [[[[-117.82076, 34.50651], [-117.81973, 34.50699], [-117.81803, 34.50778], [-117.81802, 34.50641], [-117.81848, 34.50646], [-117.81894, 34.50649], [-117.82076, 34.50651]]], [[[-117.82283, 34.50772], [-117.82137, 34.5084], [-117.82128, 34.50829], [-117.82054, 34.50863], [-117.82054, 34.50864], [-117.82062, 34.50875], [-117.81915, 34.50943], [-117.81813, 34.50793], [-117.82116, 34.50651], [-117.82201, 34.50652], [-117.82283, 34.50772]]], [[[-117.82395, 34.50937], [-117.82028, 34.51109], [-117.81925, 34.50958], [-117.82071, 34.5089], [-117.8208, 34.50901], [-117.82121, 34.50882], [-117.82154, 34.50867], [-117.82147, 34.50855], [-117.82293, 34.50787], [-117.82395, 34.50937]]], [[[-117.82134, 34.50864], [-117.82087, 34.50885], [-117.82074, 34.50866], [-117.82121, 34.50845], [-117.82134, 34.50864]]], [[[-117.82342, 34.50815], [-117.82232, 34.50652], [-117.82232, 34.50652], [-117.82341, 34.50648], [-117.82342, 34.50815]]]]} | No Public Access 3 | 46291 | Shady Bend Park | 29584 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 42.987 | Shady Bend Park | 0 | Local Park 2 | 4 | |
16112 | 16112 | 16111 | {"type": "Polygon", "coordinates": [[[-121.93713, 36.48166], [-121.93589, 36.48169], [-121.93565, 36.48218], [-121.93525, 36.48195], [-121.93482, 36.48164], [-121.93419, 36.48187], [-121.93391, 36.48199], [-121.93358, 36.48189], [-121.93342, 36.48203], [-121.93338, 36.48229], [-121.93301, 36.48226], [-121.93275, 36.48226], [-121.93231, 36.48216], [-121.93191, 36.48198], [-121.93176, 36.48178], [-121.93152, 36.48157], [-121.93128, 36.48133], [-121.93093, 36.48159], [-121.93042, 36.48151], [-121.92961, 36.48143], [-121.92935, 36.48143], [-121.929, 36.48119], [-121.92854, 36.48094], [-121.92841, 36.48085], [-121.9281, 36.48118], [-121.92781, 36.48121], [-121.92739, 36.48114], [-121.92715, 36.4812], [-121.92708, 36.48092], [-121.92701, 36.48085], [-121.92674, 36.48095], [-121.92636, 36.48143], [-121.92627, 36.48162], [-121.92607, 36.48167], [-121.92587, 36.48128], [-121.92554, 36.48106], [-121.92515, 36.48102], [-121.92488, 36.48087], [-121.92456, 36.48089], [-121.9244, 36.48062], [-121.92422, 36.48052], [-121.9239, 36.48052], [-121.92367, 36.48066], [-121.92325, 36.48067], [-121.92305, 36.48075], [-121.92282, 36.4806], [-121.92245, 36.48067], [-121.92225, 36.48048], [-121.92171, 36.48029], [-121.92126, 36.48027], [-121.9208, 36.48003], [-121.92055, 36.48], [-121.92003, 36.47982], [-121.91977, 36.47967], [-121.91945, 36.47943], [-121.9191, 36.47929], [-121.91882, 36.47951], [-121.91847, 36.47948], [-121.91822, 36.47935], [-121.91808, 36.47913], [-121.91787, 36.47903], [-121.91757, 36.47903], [-121.91711, 36.4787], [-121.91625, 36.4786], [-121.91605, 36.47854], [-121.92713, 36.47357], [-121.9276, 36.47357], [-121.92774, 36.47311], [-121.9288, 36.47271], [-121.93027, 36.47271], [-121.93103, 36.47268], [-121.93147, 36.47258], [-121.93188, 36.47516], [-121.93333, 36.47501], [-121.93331, 36.47464], [-121.93435, 36.47461], [-121.93547, 36.47413], [-121.93627, 36.47837], [-121.93633, 36.47859], [-121.93644, 36.47889], [-121.9369, 36.47982], [-121.93702, 36.48021], [-121.93711, 36.48089], [-121.93713, 36.48134], [-121.93713, 36.48166]]]} | No Public Access 3 | 16442 | County Open Space | 17714 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 288.367 | County OS | 0 | Local Recreation Area 3 | 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]);