units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where AGNCY_WEB = "http://www.slc.ca.gov/" and COUNTY = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME, GAP_STS
MNG_AGENCY 4
DES_TP 4
MNG_AG_TYP 2
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7960 | 7960 | 7959 | {"type": "Polygon", "coordinates": [[[-116.77151, 33.12419], [-116.76285, 33.1242], [-116.76283, 33.12035], [-116.7715, 33.12036], [-116.77151, 33.12419]]]} | Open Access 1 | 12841 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 85.079 | SLC | 0 | State Resource Management Area 55 | 3 | |
14803 | 14803 | 14802 | {"type": "MultiPolygon", "coordinates": [[[[-116.17464, 32.69733], [-116.15733, 32.69758], [-116.15691, 32.68285], [-116.17365, 32.68294], [-116.17464, 32.69733]]], [[[-116.67842, 32.77602], [-116.67832, 32.78694], [-116.67406, 32.78701], [-116.67408, 32.77962], [-116.67412, 32.77604], [-116.67842, 32.77602]]]]} | Open Access 1 | 45219 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 757.572 | SLC | 0 | State Resource Management Area 55 | 3 | |
15637 | 15637 | 15636 | {"type": "MultiPolygon", "coordinates": [[[[-117.29913, 33.08782], [-117.296, 33.08783], [-117.2961, 33.09165], [-117.29506, 33.09132], [-117.29447, 33.09119], [-117.29399, 33.09112], [-117.29368, 33.09104], [-117.2933, 33.09101], [-117.29317, 33.09104], [-117.29273, 33.09131], [-117.29159, 33.09153], [-117.29145, 33.09161], [-117.29119, 33.09195], [-117.29122, 33.09209], [-117.29092, 33.09265], [-117.29069, 33.09263], [-117.29055, 33.09233], [-117.29061, 33.09211], [-117.29034, 33.09156], [-117.29014, 33.09155], [-117.28933, 33.09103], [-117.28869, 33.09113], [-117.28836, 33.09138], [-117.28839, 33.09145], [-117.28751, 33.09185], [-117.2875, 33.09199], [-117.28707, 33.09197], [-117.28667, 33.09191], [-117.28609, 33.09218], [-117.28594, 33.09218], [-117.2858, 33.09243], [-117.28541, 33.09235], [-117.28503, 33.09256], [-117.28438, 33.09257], [-117.28374, 33.09245], [-117.28356, 33.09233], [-117.28362, 33.0918], [-117.28297, 33.09161], [-117.28264, 33.09145], [-117.28199, 33.09146], [-117.28169, 33.09166], [-117.28148, 33.09219], [-117.28178, 33.09255], [-117.28098, 33.09295], [-117.28058, 33.09312], [-117.27922, 33.09404], [-117.2787, 33.09397], [-117.27868, 33.09395], [-117.27849, 33.09399], [-117.27823, 33.09392], [-117.27784, 33.09398], [-117.27746, 33.09412], [-117.27715, 33.09402], [-117.27744, 33.09379], [-117.27735, 33.09355], [-117.27702, 33.09357], [-117.2769, 33.09367], [-117.27653, 33.09371], [-117.2765, 33.09377], [-117.27625, 33.09371], [-117.27629, 33.09347], [-117.27598, 33.09332], [-117.27567, 33.09331], [-117.27499, 33.09352], [-117.27495, 33.09385], [-117.27485, 33.09385], [-117.27477, 33.09351], [-117.27465, 33.09352], [-117.27448, 33.0933], [-117.27448, 33.09326], [-117.27439, 33.09324], [-117.27412, 33.09316], [-117.27415, 33.09308], [-117.27414, 33.09307], [-117.27356, 33.09311], [-117.27351, 33.09329], [-117.27325, 33.09329], [-117.27313, 33.09348], [-117.27233, 33.09352], [-117.27149, 33.09332], [-117.27163, 33.09308], [-117.27099, 33.09295], [-117.27071, 33.09282], [-117.27048, 33.09283], [-117.2703, 33.09301], [-117.27011, 33.09307], [-117.27011, 33.09336], [-117.26959, 33.09349], [-117.26939, 33.09361], [-117.26927, 33.09402], [-117.26884, 33.09406], [-117.2691, 33.09349], [-117.26905, 33.09328], [-117.26915, 33.09306], [-117.2692, 33.09274], [-117.2694, 33.09233], [-117.26939, 33.09232], [-117.26909, 33.09228], [-117.26959, 33.09091], [-117.26969, 33.09051], [-117.26974, 33.09006], [-117.26973, 33.08974], [-117.26968, 33.0893], [-117.26914, 33.08688], [-117.26907, 33.08645], [-117.26905, 33.08621], [-117.26895, 33.0858], [-117.26896, 33.08569], [-117.26901, 33.0856], [-117.2691, 33.08553], [-117.2692, 33.08549], [-117.26995, 33.08542], [-117.27, 33.08634], [-117.27226, 33.08537], [-117.27266, 33.08545], [-117.27305, 33.08556], [-117.2735, 33.08574], [-117.27549, 33.08667], [-117.27723, 33.08753], [-117.27774, 33.08773], [-117.27833, 33.0879], [-117.27866, 33.08808], [-117.27893, 33.08802], [-117.2795, 33.08807], [-117.28, 33.08809], [-117.28049, 33.08806], [-117.28089, 33.08801], [-117.28337, 33.08757], [-117.28557, 33.08736], [-117.28897, 33.08739], [-117.29074, 33.08746], [-117.29403, 33.08635], [-117.29551, 33.08529], [-117.29563, 33.08547], [-117.29694, 33.08588], [-117.29866, 33.08722], [-117.29913, 33.08782]], [[-117.28911, 33.08744], [-117.28912, 33.08742], [-117.2891, 33.08742], [-117.2891, 33.08744], [-117.28911, 33.08744]]], [[[-117.30633, 33.0891], [-117.30621, 33.08968], [-117.3061, 33.08989], [-117.30599, 33.09005], [-117.30585, 33.09021], [-117.30547, 33.09053], [-117.30534, 33.09068], [-117.30452, 33.09207], [-117.30327, 33.09029], [-117.3049, 33.08911], [-117.30633, 33.0891]]], [[[-117.30981, 33.08934], [-117.30886, 33.08952], [-117.30803, 33.08948], [-117.30787, 33.08951], [-117.30774, 33.08955], [-117.30767, 33.08964], [-117.30769, 33.0898], [-117.30752, 33.08981], [-117.30679, 33.0891], [-117.3097, 33.08909], [-117.30981, 33.08934]]], [[[-117.31196, 33.08767], [-117.31147, 33.08776], [-117.31087, 33.08784], [-117.31081, 33.08787], [-117.3108, 33.08792], [-117.31083, 33.08801], [-117.31145, 33.0887], [-117.31157, 33.08893], [-117.3115, 33.08908], [-117.31131, 33.08917], [-117.31094, 33.08932], [-117.3106, 33.0894], [-117.30986, 33.08747], [-117.31032, 33.08713], [-117.31097, 33.08695], [-117.31177, 33.08717], [-117.31196, 33.08767]]]]} | Restricted Access 2 | 44945 | Batiquitos Lagoon Ecological Reserve | 15864 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 410.657 | Batiquitos Lagoon ER | 1983 | State Conservation Area 8 | 2 |
15863 | 15863 | 15862 | {"type": "MultiPolygon", "coordinates": [[[[-117.1224, 32.59828], [-117.12207, 32.59885], [-117.11716, 32.59546], [-117.11515, 32.59482], [-117.11503, 32.59405], [-117.11241, 32.59327], [-117.11025, 32.59329], [-117.10748, 32.5947], [-117.10747, 32.59472], [-117.10785, 32.59544], [-117.10556, 32.59675], [-117.10535, 32.59862], [-117.10509, 32.60151], [-117.10412, 32.60232], [-117.10235, 32.60392], [-117.10065, 32.60418], [-117.0985, 32.60523], [-117.09818, 32.60519], [-117.09805, 32.60689], [-117.09875, 32.60901], [-117.09863, 32.60984], [-117.0988, 32.61037], [-117.09841, 32.61236], [-117.09592, 32.61163], [-117.09606, 32.61062], [-117.09626, 32.61002], [-117.09618, 32.60967], [-117.09528, 32.60833], [-117.09524, 32.60766], [-117.09464, 32.60685], [-117.09424, 32.60674], [-117.09388, 32.60586], [-117.09397, 32.60586], [-117.09402, 32.60477], [-117.09407, 32.60476], [-117.09456, 32.60103], [-117.09339, 32.60089], [-117.09276, 32.60077], [-117.09285, 32.59869], [-117.09295, 32.59868], [-117.09296, 32.59823], [-117.09301, 32.59774], [-117.09343, 32.59671], [-117.09402, 32.59611], [-117.09712, 32.594], [-117.09712, 32.59392], [-117.10133, 32.59103], [-117.10132, 32.59085], [-117.09712, 32.59374], [-117.0971, 32.58904], [-117.10134, 32.58922], [-117.10134, 32.58948], [-117.10186, 32.5895], [-117.10408, 32.588], [-117.10557, 32.58755], [-117.10558, 32.58818], [-117.10595, 32.58805], [-117.10626, 32.58796], [-117.10676, 32.58789], [-117.10716, 32.58788], [-117.10757, 32.58792], [-117.10793, 32.58799], [-117.10895, 32.58831], [-117.10919, 32.58859], [-117.10932, 32.58882], [-117.10933, 32.58886], [-117.10944, 32.58904], [-117.10957, 32.58919], [-117.10969, 32.58928], [-117.10977, 32.58955], [-117.10998, 32.58969], [-117.11059, 32.58967], [-117.11112, 32.58959], [-117.11162, 32.58956], [-117.11182, 32.5895], [-117.11182, 32.58943], [-117.112, 32.58943], [-117.11226, 32.58946], [-117.11292, 32.58961], [-117.11332, 32.58965], [-117.11461, 32.59036], [-117.11477, 32.59053], [-117.11498, 32.59068], [-117.1161, 32.59115], [-117.11648, 32.59126], [-117.11684, 32.59134], [-117.11751, 32.59137], [-117.11778, 32.59134], [-117.11842, 32.59139], [-117.11837, 32.59142], [-117.11838, 32.59144], [-117.1193, 32.59151], [-117.11999, 32.59172], [-117.12088, 32.59216], [-117.12108, 32.59229], [-117.12132, 32.59247], [-117.12153, 32.59266], [-117.12183, 32.59299], [-117.12196, 32.59317], [-117.1221, 32.59341], [-117.12227, 32.5938], [-117.12237, 32.59419], [-117.12229, 32.59687], [-117.12227, 32.59688], [-117.12226, 32.59733], [-117.12224, 32.59743], [-117.12224, 32.59757], [-117.12234, 32.59805], [-117.1224, 32.59828]]], [[[-117.10811, 32.5879], [-117.10787, 32.58784], [-117.1075, 32.58777], [-117.10718, 32.58775], [-117.10696, 32.58775], [-117.10696, 32.58758], [-117.108, 32.58758], [-117.10803, 32.58772], [-117.10811, 32.5879]]], [[[-117.11454, 32.59024], [-117.11454, 32.59024], [-117.11347, 32.58967], [-117.11393, 32.58968], [-117.11412, 32.58972], [-117.1142, 32.58976], [-117.11439, 32.58992], [-117.11443, 32.58999], [-117.11454, 32.59024]]], [[[-117.12232, 32.59233], [-117.12072, 32.59168], [-117.1201, 32.59147], [-117.11983, 32.5914], [-117.11945, 32.59133], [-117.11861, 32.59124], [-117.11864, 32.58762], [-117.11997, 32.58761], [-117.12059, 32.58709], [-117.1209, 32.58698], [-117.12109, 32.58698], [-117.12132, 32.58759], [-117.12148, 32.58761], [-117.12166, 32.58797], [-117.12181, 32.58835], [-117.12196, 32.58886], [-117.12198, 32.58891], [-117.12175, 32.58899], [-117.12159, 32.58912], [-117.12178, 32.58947], [-117.12201, 32.59009], [-117.12216, 32.59031], [-117.12232, 32.59233]]], [[[-117.12241, 32.59358], [-117.12226, 32.59325], [-117.12207, 32.59296], [-117.12187, 32.59272], [-117.12157, 32.59243], [-117.12131, 32.59224], [-117.1209, 32.59202], [-117.12234, 32.59256], [-117.12241, 32.59339], [-117.12241, 32.59358]]]]} | Open Access 1 | 44825 | San Diego Bay National Wildlife Refuge | 13940 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/san_diego_bay/ | San Diego 4 | 721.883 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 |
16472 | 16472 | 16471 | {"type": "Polygon", "coordinates": [[[-117.20426, 32.64359], [-117.16473, 32.66737], [-117.16448, 32.66717], [-117.16425, 32.66694], [-117.16363, 32.66626], [-117.16331, 32.66598], [-117.16307, 32.66571], [-117.1626, 32.66505], [-117.1621, 32.66445], [-117.16187, 32.66422], [-117.16165, 32.66393], [-117.16114, 32.66336], [-117.16064, 32.66286], [-117.16043, 32.66261], [-117.16029, 32.66237], [-117.16021, 32.66217], [-117.16003, 32.66169], [-117.15987, 32.66144], [-117.15963, 32.66114], [-117.15946, 32.66097], [-117.15929, 32.66077], [-117.15889, 32.66005], [-117.15812, 32.65921], [-117.15793, 32.65906], [-117.15755, 32.65871], [-117.15739, 32.65851], [-117.1571, 32.65799], [-117.15694, 32.65776], [-117.15677, 32.65757], [-117.15658, 32.65739], [-117.15621, 32.65698], [-117.15593, 32.65663], [-117.15578, 32.6564], [-117.15564, 32.65609], [-117.15498, 32.65501], [-117.15477, 32.65474], [-117.15427, 32.65402], [-117.15389, 32.65331], [-117.15368, 32.65306], [-117.15319, 32.65226], [-117.153, 32.65202], [-117.15283, 32.65174], [-117.15258, 32.6512], [-117.15201, 32.65045], [-117.15173, 32.65013], [-117.1509, 32.64872], [-117.15066, 32.64835], [-117.15043, 32.64805], [-117.15027, 32.64776], [-117.15012, 32.64743], [-117.14982, 32.64691], [-117.14918, 32.64598], [-117.14897, 32.64562], [-117.1489, 32.64538], [-117.14861, 32.64471], [-117.14842, 32.64437], [-117.14816, 32.64397], [-117.14802, 32.64365], [-117.14779, 32.64331], [-117.14732, 32.6424], [-117.14691, 32.64169], [-117.14656, 32.64096], [-117.14644, 32.64064], [-117.14626, 32.64031], [-117.14614, 32.64002], [-117.14562, 32.63901], [-117.14545, 32.63873], [-117.1452, 32.63826], [-117.14512, 32.63797], [-117.14503, 32.63777], [-117.14467, 32.63727], [-117.14454, 32.63704], [-117.14446, 32.63682], [-117.14416, 32.63629], [-117.14406, 32.63614], [-117.14395, 32.63587], [-117.14362, 32.63521], [-117.14283, 32.63397], [-117.14276, 32.63383], [-117.14262, 32.63341], [-117.14251, 32.63318], [-117.14224, 32.63271], [-117.14204, 32.63231], [-117.14196, 32.6321], [-117.14173, 32.63142], [-117.14161, 32.63129], [-117.14151, 32.63109], [-117.14126, 32.63036], [-117.14114, 32.63008], [-117.14105, 32.62976], [-117.1408, 32.6292], [-117.14066, 32.62885], [-117.14041, 32.62835], [-117.13984, 32.62683], [-117.1397, 32.6265], [-117.13956, 32.62608], [-117.13928, 32.62534], [-117.13923, 32.62505], [-117.13922, 32.62478], [-117.13908, 32.62439], [-117.1389, 32.62397], [-117.13855, 32.62303], [-117.13822, 32.62189], [-117.1381, 32.62158], [-117.13798, 32.6211], [-117.13789, 32.62083], [-117.13776, 32.62055], [-117.13766, 32.62025], [-117.13757, 32.61987], [-117.13745, 32.61957], [-117.13716, 32.61865], [-117.13664, 32.6167], [-117.13652, 32.61631], [-117.13626, 32.61523], [-117.13614, 32.61471], [-117.13604, 32.61446], [-117.13583, 32.61371], [-117.1358, 32.6134], [-117.1357, 32.61295], [-117.13556, 32.61213], [-117.13489, 32.60924], [-117.18518, 32.60043], [-117.18826, 32.60889], [-117.19042, 32.6163], [-117.19451, 32.62552], [-117.19672, 32.63018], [-117.19795, 32.63266], [-117.2007, 32.6379], [-117.20216, 32.64043], [-117.20426, 32.64359]]]} | Open Access 1 | 44948 | Silver Strand State Beach | 1743 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=654 | San Diego 4 | 7227.929 | Silver Strand SB | 1932 | State Park 15 | 4 |
16878 | 16878 | 16877 | {"type": "MultiPolygon", "coordinates": [[[[-116.37736, 32.77099], [-116.37719, 32.78545], [-116.36908, 32.78539], [-116.36111, 32.78551], [-116.36094, 32.771], [-116.36789, 32.77098], [-116.37736, 32.77099]]], [[[-116.63182, 32.82654], [-116.63151, 32.83004], [-116.62895, 32.83016], [-116.62861, 32.82978], [-116.62829, 32.82938], [-116.62737, 32.8277], [-116.62747, 32.82664], [-116.63182, 32.82654]]], [[[-116.76726, 33.09473], [-116.76721, 33.0981], [-116.763, 33.09817], [-116.76306, 33.09471], [-116.76726, 33.09473]]], [[[-116.84133, 33.00435], [-116.84115, 33.00636], [-116.83671, 33.00635], [-116.83673, 33.00778], [-116.83244, 33.00778], [-116.83252, 33.00417], [-116.84133, 33.00435]]], [[[-117.14854, 33.31086], [-117.14411, 33.31101], [-117.14413, 33.30739], [-117.14836, 33.30736], [-117.14854, 33.31086]]]]} | Open Access 1 | 23401 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 775.732 | SLC | 0 | State Resource Management Area 55 | 3 |
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]);