units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, COUNTY = 3 and DES_TP = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7956 | 7956 | 7955 | {"type": "Polygon", "coordinates": [[[-117.77053, 33.59072], [-117.7686, 33.593], [-117.76454, 33.58976], [-117.7642, 33.5901], [-117.76309, 33.58823], [-117.76246, 33.58625], [-117.762, 33.58582], [-117.76259, 33.58473], [-117.76199, 33.58343], [-117.76189, 33.58343], [-117.76179, 33.583], [-117.76357, 33.58416], [-117.76405, 33.5845], [-117.76434, 33.58553], [-117.76703, 33.58678], [-117.76652, 33.58743], [-117.77053, 33.59072]]]} | Open Access 1 | 12836 | Laguna Laurel Ecological Reserve | 32199 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Laguna-Laurel-ER | Orange 3 | 78.251 | Laguna Laurel ER | 1994 | State Conservation Area 8 | 2 |
15593 | 15593 | 15592 | {"type": "MultiPolygon", "coordinates": [[[[-117.89222, 33.64467], [-117.89145, 33.6457], [-117.89113, 33.64628], [-117.89089, 33.64677], [-117.89083, 33.64719], [-117.89084, 33.64753], [-117.89089, 33.64759], [-117.89093, 33.64785], [-117.89083, 33.64873], [-117.89054, 33.64966], [-117.89017, 33.65045], [-117.8898, 33.65087], [-117.88872, 33.65156], [-117.88812, 33.65187], [-117.88788, 33.65189], [-117.88622, 33.65225], [-117.88611, 33.652], [-117.88486, 33.65232], [-117.8843, 33.65248], [-117.87916, 33.65141], [-117.87837, 33.65117], [-117.87713, 33.65074], [-117.87657, 33.6506], [-117.87613, 33.65052], [-117.87553, 33.65046], [-117.87501, 33.65045], [-117.87457, 33.65048], [-117.87406, 33.65056], [-117.87356, 33.65068], [-117.87325, 33.65078], [-117.87276, 33.65097], [-117.8725, 33.6511], [-117.8725, 33.65114], [-117.87218, 33.65124], [-117.87103, 33.65164], [-117.87, 33.65204], [-117.8698, 33.65216], [-117.86922, 33.65227], [-117.8687, 33.65232], [-117.86833, 33.65235], [-117.86765, 33.65235], [-117.86706, 33.65231], [-117.86708, 33.65218], [-117.86709, 33.65196], [-117.86707, 33.65156], [-117.86682, 33.64989], [-117.86679, 33.64957], [-117.86679, 33.64906], [-117.86683, 33.64857], [-117.86703, 33.64726], [-117.86707, 33.6472], [-117.86711, 33.64718], [-117.86734, 33.64712], [-117.8676, 33.64704], [-117.86792, 33.64689], [-117.86808, 33.6468], [-117.86834, 33.64662], [-117.86852, 33.64646], [-117.86899, 33.64595], [-117.8692, 33.64576], [-117.86944, 33.64558], [-117.86976, 33.64542], [-117.87016, 33.64527], [-117.87085, 33.64509], [-117.87095, 33.64511], [-117.87106, 33.64518], [-117.87142, 33.64535], [-117.87172, 33.64545], [-117.87183, 33.64547], [-117.87223, 33.64549], [-117.87236, 33.64548], [-117.87265, 33.64543], [-117.87291, 33.64542], [-117.87372, 33.64556], [-117.87421, 33.64568], [-117.87447, 33.6457], [-117.87515, 33.6457], [-117.8759, 33.64575], [-117.87634, 33.64582], [-117.87713, 33.64612], [-117.87762, 33.64626], [-117.87788, 33.64635], [-117.87808, 33.64647], [-117.87867, 33.6469], [-117.87881, 33.64695], [-117.87897, 33.64698], [-117.87915, 33.64697], [-117.87951, 33.64689], [-117.8799, 33.64678], [-117.88059, 33.64662], [-117.88113, 33.64644], [-117.88173, 33.64615], [-117.88198, 33.64597], [-117.88219, 33.64575], [-117.88233, 33.64554], [-117.88237, 33.64543], [-117.88239, 33.64532], [-117.8824, 33.64522], [-117.88237, 33.64482], [-117.88232, 33.64439], [-117.88232, 33.64391], [-117.88236, 33.64373], [-117.88249, 33.64346], [-117.88289, 33.64303], [-117.8835, 33.64256], [-117.88413, 33.64202], [-117.88488, 33.64141], [-117.88531, 33.64104], [-117.88556, 33.6409], [-117.88609, 33.64083], [-117.88629, 33.64071], [-117.88769, 33.63761], [-117.8869, 33.63605], [-117.88594, 33.63516], [-117.88561, 33.63453], [-117.88549, 33.6344], [-117.88509, 33.63403], [-117.88483, 33.63395], [-117.88467, 33.63377], [-117.8846, 33.63364], [-117.88329, 33.63301], [-117.88322, 33.63295], [-117.88312, 33.63284], [-117.88308, 33.63273], [-117.88302, 33.63212], [-117.883, 33.63202], [-117.88295, 33.63192], [-117.88289, 33.63186], [-117.88279, 33.63178], [-117.88204, 33.63138], [-117.88241, 33.63125], [-117.88249, 33.6312], [-117.88264, 33.63117], [-117.88405, 33.63114], [-117.88432, 33.63107], [-117.88449, 33.63099], [-117.88488, 33.63066], [-117.88499, 33.63025], [-117.88548, 33.6302], [-117.88591, 33.63007], [-117.88626, 33.6299], [-117.88612, 33.63039], [-117.88587, 33.63218], [-117.88586, 33.63288], [-117.88575, 33.63374], [-117.88578, 33.63407], [-117.88581, 33.63411], [-117.88628, 33.63495], [-117.88729, 33.63596], [-117.88751, 33.63628], [-117.88803, 33.63756], [-117.88726, 33.63909], [-117.88745, 33.63942], [-117.88748, 33.64008], [-117.88734, 33.64041], [-117.88712, 33.64036], [-117.88699, 33.63984], [-117.8868, 33.63992], [-117.88676, 33.64059], [-117.88657, 33.64098], [-117.88545, 33.64139], [-117.88378, 33.64272], [-117.88277, 33.64381], [-117.88279, 33.64569], [-117.88389, 33.64613], [-117.88438, 33.6465], [-117.8855, 33.64753], [-117.88816, 33.64607], [-117.88984, 33.63866], [-117.89034, 33.63939], [-117.89056, 33.64126], [-117.89124, 33.64184], [-117.89123, 33.64185], [-117.89199, 33.64287], [-117.892, 33.64455], [-117.89222, 33.64467]]], [[[-117.89314, 33.62071], [-117.89283, 33.62081], [-117.89246, 33.62119], [-117.89175, 33.62246], [-117.89121, 33.62441], [-117.89083, 33.62549], [-117.88925, 33.62635], [-117.88846, 33.62665], [-117.88746, 33.62641], [-117.88643, 33.62681], [-117.886, 33.62694], [-117.88567, 33.62718], [-117.88584, 33.62689], [-117.88589, 33.62528], [-117.88691, 33.62397], [-117.88723, 33.62373], [-117.88767, 33.62364], [-117.88885, 33.62448], [-117.88954, 33.6235], [-117.88998, 33.62271], [-117.89091, 33.62176], [-117.89113, 33.62077], [-117.89086, 33.62079], [-117.89175, 33.61959], [-117.89246, 33.61966], [-117.8925, 33.61989], [-117.89314, 33.62071]]], [[[-117.88963, 33.63535], [-117.88929, 33.6359], [-117.88875, 33.63601], [-117.88836, 33.63604], [-117.88836, 33.63606], [-117.88847, 33.63615], [-117.88844, 33.63635], [-117.88819, 33.6364], [-117.88797, 33.63633], [-117.88781, 33.63615], [-117.88787, 33.63609], [-117.88787, 33.63607], [-117.88765, 33.63609], [-117.88672, 33.63532], [-117.88638, 33.63492], [-117.88625, 33.63433], [-117.88639, 33.63337], [-117.88651, 33.63282], [-117.88916, 33.63443], [-117.88963, 33.63535]]], [[[-117.89083, 33.6312], [-117.89067, 33.63158], [-117.8901, 33.6319], [-117.88925, 33.63267], [-117.88746, 33.63221], [-117.88696, 33.63051], [-117.88668, 33.62896], [-117.88673, 33.62858], [-117.88728, 33.62827], [-117.8878, 33.62814], [-117.88859, 33.62791], [-117.88964, 33.6274], [-117.88979, 33.62763], [-117.88942, 33.6286], [-117.88976, 33.62886], [-117.89017, 33.62957], [-117.89074, 33.63065], [-117.89083, 33.6312]]]]} | Open Access 1 | 14907 | Upper Newport Bay Ecological Reserve | 32343 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Upper-Newport-Bay-ER | Orange 3 | 505.532 | Upper Newport Bay ER | 1975 | State Conservation Area 8 | 2 |
15607 | 15607 | 15606 | {"type": "Polygon", "coordinates": [[[-117.69319, 33.84432], [-117.69062, 33.8469], [-117.68788, 33.8496], [-117.68513, 33.85239], [-117.688, 33.85428], [-117.68589, 33.85486], [-117.68501, 33.85497], [-117.68439, 33.85571], [-117.68464, 33.85666], [-117.68536, 33.85817], [-117.68679, 33.8593], [-117.68747, 33.85956], [-117.68726, 33.85992], [-117.68759, 33.86043], [-117.68726, 33.86083], [-117.68806, 33.86152], [-117.68807, 33.86304], [-117.68743, 33.86329], [-117.68666, 33.86293], [-117.68671, 33.86241], [-117.68541, 33.86252], [-117.68546, 33.86174], [-117.68537, 33.86163], [-117.6858, 33.86096], [-117.68562, 33.86072], [-117.68491, 33.86069], [-117.68491, 33.85999], [-117.68378, 33.85932], [-117.68309, 33.85978], [-117.68326, 33.86037], [-117.68257, 33.86055], [-117.6827, 33.86157], [-117.68237, 33.86186], [-117.68256, 33.86267], [-117.68156, 33.86257], [-117.68111, 33.86218], [-117.6808, 33.86203], [-117.67982, 33.86182], [-117.6779, 33.86191], [-117.6782, 33.86274], [-117.67936, 33.86359], [-117.67909, 33.8642], [-117.67733, 33.8641], [-117.67665, 33.86349], [-117.6759, 33.86353], [-117.67551, 33.86327], [-117.67288, 33.86335], [-117.67271, 33.86201], [-117.67336, 33.8596], [-117.67207, 33.84275], [-117.67655, 33.83827], [-117.67987, 33.83499], [-117.69319, 33.84432]]]} | Open Access 1 | 17876 | Coal Canyon Ecological Reserve | 32121 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Coal-Canyon-ER | Orange 3 | 941.511 | Coal Canyon ER | 1994 | State Conservation Area 8 | 2 |
15633 | 15633 | 15632 | {"type": "Polygon", "coordinates": [[[-118.0591, 33.71145], [-118.05334, 33.71151], [-118.05324, 33.71141], [-118.05253, 33.7114], [-118.05237, 33.7115], [-118.05211, 33.71154], [-118.05202, 33.71038], [-118.04962, 33.70863], [-118.04937, 33.70848], [-118.04877, 33.70796], [-118.04785, 33.70755], [-118.0472, 33.70696], [-118.04758, 33.70679], [-118.04839, 33.70627], [-118.04939, 33.70559], [-118.04992, 33.70528], [-118.05053, 33.70499], [-118.05126, 33.7045], [-118.0521, 33.70383], [-118.05255, 33.70376], [-118.05289, 33.70379], [-118.0591, 33.71145]]]} | Open Access 1 | 29270 | Bolsa Chica Ecological Reserve | 32062 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | Orange 3 | 116.387 | Bolsa Chica ER | 1993 | State Conservation Area 8 | 2 |
15956 | 15956 | 15955 | {"type": "MultiPolygon", "coordinates": [[[[-117.84938, 33.6336], [-117.84896, 33.63375], [-117.84877, 33.63393], [-117.84868, 33.63406], [-117.84856, 33.63438], [-117.84843, 33.63446], [-117.84825, 33.63464], [-117.84802, 33.63476], [-117.84778, 33.63508], [-117.8471, 33.63637], [-117.84698, 33.63681], [-117.8468, 33.63794], [-117.84679, 33.63855], [-117.84675, 33.63878], [-117.84668, 33.63946], [-117.84657, 33.64131], [-117.84614, 33.6414], [-117.84598, 33.64145], [-117.84563, 33.64148], [-117.84524, 33.64145], [-117.84426, 33.64157], [-117.84389, 33.64167], [-117.84323, 33.64196], [-117.84338, 33.64163], [-117.84341, 33.64147], [-117.8437, 33.64134], [-117.84361, 33.64116], [-117.84375, 33.64108], [-117.84391, 33.64068], [-117.84403, 33.64028], [-117.84419, 33.63997], [-117.84442, 33.63969], [-117.84465, 33.63918], [-117.84505, 33.63843], [-117.84589, 33.63672], [-117.8455, 33.6364], [-117.84538, 33.63625], [-117.84528, 33.63604], [-117.84469, 33.63555], [-117.84475, 33.63549], [-117.84483, 33.6353], [-117.84484, 33.63475], [-117.84469, 33.63369], [-117.84439, 33.63309], [-117.84426, 33.63301], [-117.84406, 33.63299], [-117.84355, 33.63286], [-117.8429, 33.6324], [-117.84236, 33.63212], [-117.84201, 33.63176], [-117.84219, 33.63164], [-117.84408, 33.63207], [-117.84424, 33.63206], [-117.84428, 33.632], [-117.84479, 33.63213], [-117.84512, 33.63222], [-117.84534, 33.63233], [-117.84606, 33.6325], [-117.84646, 33.63263], [-117.84696, 33.63287], [-117.84718, 33.63294], [-117.84757, 33.63323], [-117.84777, 33.6333], [-117.84832, 33.63331], [-117.84883, 33.63335], [-117.84896, 33.6334], [-117.84895, 33.63345], [-117.84938, 33.6336]]], [[[-117.8551, 33.63794], [-117.85475, 33.63824], [-117.85449, 33.63843], [-117.85462, 33.63811], [-117.85467, 33.63797], [-117.8547, 33.63782], [-117.85469, 33.63758], [-117.85459, 33.63747], [-117.85451, 33.63744], [-117.85426, 33.63722], [-117.85418, 33.63704], [-117.85396, 33.63684], [-117.85368, 33.63669], [-117.85336, 33.63648], [-117.8531, 33.63611], [-117.85277, 33.63603], [-117.8526, 33.63607], [-117.85241, 33.63616], [-117.85222, 33.6363], [-117.85198, 33.6366], [-117.85182, 33.63674], [-117.85166, 33.63682], [-117.85154, 33.63694], [-117.8514, 33.63729], [-117.85131, 33.63741], [-117.85098, 33.6374], [-117.85088, 33.63733], [-117.85086, 33.63724], [-117.8509, 33.63719], [-117.85095, 33.63711], [-117.85114, 33.63695], [-117.8512, 33.63686], [-117.85137, 33.63645], [-117.85161, 33.63616], [-117.85164, 33.63607], [-117.85163, 33.63553], [-117.85159, 33.63535], [-117.85149, 33.63517], [-117.85133, 33.63499], [-117.85078, 33.63453], [-117.85025, 33.63404], [-117.85089, 33.63438], [-117.85227, 33.63535], [-117.85341, 33.63625], [-117.85353, 33.63636], [-117.85349, 33.6364], [-117.85389, 33.6367], [-117.85425, 33.63705], [-117.8544, 33.63723], [-117.8551, 33.63786], [-117.8551, 33.63794]]], [[[-117.85959, 33.64745], [-117.85951, 33.64768], [-117.85942, 33.64783], [-117.85933, 33.64794], [-117.85912, 33.64808], [-117.8588, 33.64825], [-117.85867, 33.64839], [-117.85857, 33.64864], [-117.85845, 33.64914], [-117.85843, 33.64948], [-117.85845, 33.64989], [-117.85811, 33.64992], [-117.85808, 33.64948], [-117.85805, 33.64941], [-117.85812, 33.64907], [-117.85843, 33.64823], [-117.85844, 33.6481], [-117.85843, 33.64771], [-117.85846, 33.64718], [-117.8585, 33.64714], [-117.85854, 33.64704], [-117.85915, 33.64718], [-117.85921, 33.64711], [-117.85926, 33.64697], [-117.85928, 33.64682], [-117.85927, 33.64667], [-117.85919, 33.64615], [-117.85903, 33.64548], [-117.85893, 33.64512], [-117.85871, 33.64449], [-117.8584, 33.64387], [-117.85829, 33.64377], [-117.85771, 33.64334], [-117.85771, 33.64328], [-117.85774, 33.64325], [-117.85788, 33.64321], [-117.858, 33.64311], [-117.85804, 33.64304], [-117.85805, 33.64293], [-117.8579, 33.64259], [-117.85776, 33.6423], [-117.85768, 33.64208], [-117.85745, 33.64163], [-117.85735, 33.64136], [-117.85732, 33.6412], [-117.85729, 33.64119], [-117.85723, 33.64121], [-117.85707, 33.64124], [-117.85648, 33.64124], [-117.85641, 33.64118], [-117.85639, 33.64109], [-117.85654, 33.64107], [-117.85691, 33.64047], [-117.85694, 33.64031], [-117.85689, 33.64], [-117.85673, 33.63954], [-117.85635, 33.63896], [-117.856, 33.6387], [-117.85571, 33.63855], [-117.85535, 33.6385], [-117.85478, 33.63856], [-117.85527, 33.63819], [-117.85542, 33.63837], [-117.85555, 33.63829], [-117.85566, 33.63833], [-117.85675, 33.63929], [-117.85687, 33.63944], [-117.85691, 33.63959], [-117.85692, 33.63967], [-117.85728, 33.64001], [-117.85723, 33.64005], [-117.85732, 33.64048], [-117.85752, 33.64087], [-117.85773, 33.6415], [-117.85783, 33.64175], [-117.85805, 33.64224], [-117.8584, 33.64296], [-117.8584, 33.64298], [-117.85841, 33.64302], [-117.85844, 33.64304], [-117.85856, 33.64336], [-117.85873, 33.64373], [-117.85866, 33.64382], [-117.85868, 33.64387], [-117.85882, 33.64392], [-117.85914, 33.64463], [-117.85924, 33.64491], [-117.85952, 33.64609], [-117.85964, 33.64685], [-117.85965, 33.64701], [-117.85964, 33.64712], [-117.85961, 33.64728], [-117.85954, 33.64751], [-117.85955, 33.64751], [-117.85959, 33.64745]]]]} | Open Access 1 | 14876 | University of California, Irvine Open Space Reserve | 26683 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Orange 3 | 81.364 | University of California, Irvine OSR | 0 | State Conservation Area 8 | 2 |
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]);