units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 3 and DES_TP = 82 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 3
PARK_URL 1 ✖
MNG_AG_TYP 1
DES_TP 1
- Resource Management Area · 4 ✖
ACCESS_TYP 1
- No Public Access · 4 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
1162 | 1162 | 1161 | {"type": "Polygon", "coordinates": [[[-117.68625, 34.15373], [-117.68578, 34.15427], [-117.68557, 34.15448], [-117.68493, 34.15499], [-117.6846, 34.15528], [-117.6843, 34.15564], [-117.68412, 34.15595], [-117.684, 34.15622], [-117.6839, 34.1566], [-117.68388, 34.15675], [-117.68382, 34.15766], [-117.68376, 34.15794], [-117.68368, 34.15812], [-117.68357, 34.15832], [-117.68344, 34.15847], [-117.68287, 34.15907], [-117.68274, 34.15924], [-117.68258, 34.15954], [-117.68245, 34.15995], [-117.68242, 34.16023], [-117.68245, 34.16069], [-117.68245, 34.16105], [-117.68208, 34.16106], [-117.68184, 34.16148], [-117.68206, 34.16189], [-117.68218, 34.16224], [-117.68202, 34.16262], [-117.6817, 34.16279], [-117.68157, 34.16302], [-117.68115, 34.16313], [-117.68121, 34.16295], [-117.68133, 34.1628], [-117.68117, 34.1626], [-117.68101, 34.16231], [-117.68074, 34.16231], [-117.68054, 34.16287], [-117.6798, 34.16408], [-117.6797, 34.16453], [-117.67949, 34.16491], [-117.67921, 34.16514], [-117.67876, 34.1658], [-117.67853, 34.1662], [-117.67814, 34.16752], [-117.67796, 34.16804], [-117.67739, 34.17048], [-117.67647, 34.17048], [-117.67648, 34.17002], [-117.67851, 34.16199], [-117.68171, 34.15583], [-117.68322, 34.15063], [-117.68362, 34.15063], [-117.68354, 34.15367], [-117.68625, 34.15373]]]} | No Public Access 3 | 6785 | San Antonio Channel & Dam | 24827 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 102.402 | San Antonio Channel & Dam | 0 | Resource Management Area 82 | 3 | |
8199 | 8199 | 8198 | {"type": "MultiPolygon", "coordinates": [[[[-118.41192, 34.30466], [-118.41068, 34.30557], [-118.40898, 34.30398], [-118.40892, 34.30416], [-118.41053, 34.30568], [-118.40755, 34.30785], [-118.40753, 34.3079], [-118.40684, 34.30791], [-118.40702, 34.30699], [-118.40687, 34.30638], [-118.40668, 34.30644], [-118.40655, 34.30641], [-118.40685, 34.30618], [-118.40733, 34.30605], [-118.40767, 34.3052], [-118.40766, 34.30519], [-118.40753, 34.30518], [-118.40761, 34.30442], [-118.40774, 34.30388], [-118.40879, 34.30236], [-118.40906, 34.30219], [-118.40936, 34.30229], [-118.40954, 34.30196], [-118.40968, 34.30176], [-118.41031, 34.30204], [-118.41001, 34.30253], [-118.41191, 34.30338], [-118.4117, 34.30415], [-118.41192, 34.30466]]], [[[-118.41297, 34.30697], [-118.41202, 34.30909], [-118.41195, 34.30938], [-118.41166, 34.30947], [-118.4113, 34.30955], [-118.41094, 34.3096], [-118.41057, 34.30961], [-118.40749, 34.3094], [-118.40745, 34.30938], [-118.40743, 34.30868], [-118.40746, 34.30848], [-118.4076, 34.30811], [-118.40756, 34.30807], [-118.41066, 34.3058], [-118.41184, 34.30691], [-118.41185, 34.30691], [-118.41187, 34.30669], [-118.41081, 34.30569], [-118.41208, 34.30477], [-118.4123, 34.30503], [-118.4125, 34.30531], [-118.41297, 34.30697]]], [[[-118.412, 34.31043], [-118.41147, 34.31141], [-118.4113, 34.31165], [-118.41041, 34.31081], [-118.4119, 34.30973], [-118.412, 34.31043]]], [[[-118.41175, 34.30962], [-118.4109, 34.31024], [-118.40853, 34.31197], [-118.40856, 34.30964], [-118.41057, 34.30978], [-118.41115, 34.30974], [-118.41141, 34.3097], [-118.41175, 34.30962]]], [[[-118.4089, 34.31192], [-118.40887, 34.31212], [-118.40862, 34.31212], [-118.4089, 34.31192], [-118.4089, 34.31192]]]]} | No Public Access 3 | 12454 | Lopez Reservoir and Dam | 21465 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 92.431 | Lopez Reservoir and Dam | 0 | Resource Management Area 82 | 3 | |
15539 | 15539 | 15538 | {"type": "Polygon", "coordinates": [[[-121.45281, 36.81548], [-121.44951, 36.81827], [-121.45206, 36.82029], [-121.45168, 36.82097], [-121.44825, 36.82238], [-121.44786, 36.82617], [-121.44667, 36.82857], [-121.45008, 36.82903], [-121.44932, 36.83003], [-121.44877, 36.83058], [-121.44768, 36.83141], [-121.44442, 36.83059], [-121.44261, 36.8296], [-121.44256, 36.82816], [-121.4406, 36.82749], [-121.4363, 36.82466], [-121.43536, 36.82021], [-121.43324, 36.81847], [-121.43417, 36.81602], [-121.43598, 36.81561], [-121.43922, 36.81527], [-121.44188, 36.81378], [-121.44228, 36.81358], [-121.44972, 36.81478], [-121.44982, 36.8147], [-121.45066, 36.8154], [-121.45255, 36.81527], [-121.45281, 36.81548]], [[-121.44867, 36.81812], [-121.4488, 36.818], [-121.4488, 36.81777], [-121.44678, 36.81613], [-121.44618, 36.81566], [-121.44504, 36.81584], [-121.44509, 36.81601], [-121.44509, 36.8161], [-121.44517, 36.81636], [-121.44515, 36.81653], [-121.44509, 36.8166], [-121.44485, 36.81675], [-121.44454, 36.81683], [-121.44435, 36.81683], [-121.44423, 36.81677], [-121.44376, 36.81639], [-121.4437, 36.81632], [-121.44361, 36.81629], [-121.44356, 36.8163], [-121.44353, 36.81634], [-121.44351, 36.81652], [-121.44342, 36.81666], [-121.44324, 36.81675], [-121.44303, 36.81678], [-121.44242, 36.81655], [-121.44233, 36.81666], [-121.44235, 36.81682], [-121.44242, 36.81706], [-121.44241, 36.81722], [-121.44226, 36.81734], [-121.44215, 36.81739], [-121.44167, 36.81747], [-121.44133, 36.81742], [-121.44115, 36.81742], [-121.44066, 36.81751], [-121.44039, 36.81766], [-121.44015, 36.81767], [-121.43983, 36.81759], [-121.43977, 36.81754], [-121.43972, 36.81756], [-121.43966, 36.81752], [-121.43964, 36.81741], [-121.4397, 36.81735], [-121.43972, 36.81729], [-121.43982, 36.81713], [-121.43959, 36.81694], [-121.43947, 36.81681], [-121.43939, 36.81667], [-121.43936, 36.81656], [-121.43936, 36.81627], [-121.4392, 36.81615], [-121.43915, 36.81605], [-121.43915, 36.816], [-121.43908, 36.81594], [-121.43896, 36.81591], [-121.43887, 36.81595], [-121.43885, 36.81602], [-121.43891, 36.8161], [-121.43892, 36.81614], [-121.43885, 36.8162], [-121.43885, 36.81625], [-121.43889, 36.81634], [-121.43889, 36.81647], [-121.43886, 36.81653], [-121.43878, 36.8166], [-121.43872, 36.81662], [-121.43863, 36.8166], [-121.43856, 36.81661], [-121.43857, 36.81666], [-121.43854, 36.81673], [-121.43846, 36.81676], [-121.43837, 36.81673], [-121.43814, 36.81682], [-121.43793, 36.81681], [-121.4377, 36.81668], [-121.43765, 36.81655], [-121.43763, 36.81646], [-121.43764, 36.81629], [-121.43746, 36.81642], [-121.43736, 36.81641], [-121.43727, 36.8163], [-121.43716, 36.81628], [-121.43655, 36.81658], [-121.43637, 36.8167], [-121.43628, 36.81672], [-121.43618, 36.81672], [-121.43609, 36.8167], [-121.43598, 36.81666], [-121.43583, 36.81657], [-121.43555, 36.81646], [-121.43518, 36.81661], [-121.43501, 36.81677], [-121.43496, 36.81684], [-121.43499, 36.81693], [-121.435, 36.81714], [-121.43499, 36.81722], [-121.43485, 36.81746], [-121.43457, 36.81777], [-121.43435, 36.81797], [-121.43398, 36.81821], [-121.43385, 36.81834], [-121.43383, 36.81844], [-121.43394, 36.81849], [-121.43409, 36.81845], [-121.43415, 36.81845], [-121.4342, 36.81847], [-121.43423, 36.81853], [-121.4343, 36.81876], [-121.43435, 36.81869], [-121.43439, 36.81852], [-121.43449, 36.81846], [-121.43469, 36.81839], [-121.43501, 36.81833], [-121.43523, 36.81832], [-121.43536, 36.8183], [-121.43546, 36.8183], [-121.43553, 36.81834], [-121.43578, 36.81853], [-121.436, 36.81867], [-121.43613, 36.81874], [-121.4363, 36.81879], [-121.43639, 36.81878], [-121.43646, 36.81871], [-121.43657, 36.81836], [-121.4366, 36.81822], [-121.43669, 36.81818], [-121.43691, 36.81824], [-121.43701, 36.8183], [-121.43767, 36.8188], [-121.43778, 36.81892], [-121.43786, 36.81905], [-121.4379, 36.81919], [-121.43787, 36.81925], [-121.43769, 36.81945], [-121.43736, 36.81956], [-121.43732, 36.81962], [-121.43737, 36.81974], [-121.43745, 36.81986], [-121.43746, 36.82], [-121.43757, 36.82027], [-121.43773, 36.82038], [-121.43841, 36.8204], [-121.43853, 36.82022], [-121.43874, 36.8201], [-121.43897, 36.82], [-121.43915, 36.81998], [-121.43923, 36.81991], [-121.43929, 36.81978], [-121.43944, 36.81963], [-121.43953, 36.81957], [-121.43974, 36.81958], [-121.44037, 36.81974], [-121.4407, 36.8198], [-121.44076, 36.81995], [-121.44096, 36.82018], [-121.44143, 36.82046], [-121.44153, 36.8206], [-121.44153, 36.82073], [-121.44141, 36.82087], [-121.44112, 36.82098], [-121.44082, 36.82111], [-121.44061, 36.82123], [-121.44023, 36.82126], [-121.43986, 36.82141], [-121.4396, 36.82142], [-121.43923, 36.82131], [-121.43894, 36.82128], [-121.43885, 36.82131], [-121.43857, 36.82123], [-121.43772, 36.82093], [-121.43755, 36.82079], [-121.43742, 36.82074], [-121.43726, 36.82076], [-121.43689, 36.821], [-121.43626, 36.82113], [-121.43608, 36.8212], [-121.43609, 36.82128], [-121.43626, 36.82134], [-121.43648, 36.82137], [-121.43663, 36.82147], [-121.43699, 36.82159], [-121.43718, 36.82169], [-121.43722, 36.82184], [-121.4372, 36.82197], [-121.4372, 36.82211], [-121.43735, 36.82211], [-121.43753, 36.82214], [-121.43803, 36.82239], [-121.43814, 36.8225], [-121.43816, 36.82261], [-121.43785, 36.82289], [-121.43772, 36.82312], [-121.43767, 36.82319], [-121.43767, 36.82329], [-121.43776, 36.8234], [-121.43786, 36.82347], [-121.43799, 36.82344], [-121.43812, 36.82337], [-121.43836, 36.82328], [-121.43857, 36.82324], [-121.43864, 36.82324], [-121.4387, 36.82327], [-121.43879, 36.82337], [-121.43902, 36.82371], [-121.43905, 36.82397], [-121.43905, 36.82403], [-121.43908, 36.8241], [-121.43914, 36.82414], [-121.43927, 36.82409], [-121.43966, 36.82409], [-121.43972, 36.82407], [-121.43979, 36.824], [-121.44082, 36.82373], [-121.44091, 36.82373], [-121.44104, 36.82378], [-121.44121, 36.82392], [-121.44146, 36.82409], [-121.44159, 36.82421], [-121.44173, 36.82429], [-121.44185, 36.82428], [-121.44208, 36.82423], [-121.44223, 36.82418], [-121.44235, 36.82413], [-121.44244, 36.82403], [-121.4425, 36.82393], [-121.44259, 36.82393], [-121.44289, 36.82454], [-121.44263, 36.825], [-121.44263, 36.82513], [-121.44265, 36.82519], [-121.44282, 36.82546], [-121.44278, 36.82567], [-121.44256, 36.82588], [-121.44242, 36.82597], [-121.44238, 36.82611], [-121.4425, 36.82615], [-121.44275, 36.8262], [-121.44295, 36.82632], [-121.44295, 36.82639], [-121.44293, 36.82651], [-121.44278, 36.82682], [-121.44266, 36.82702], [-121.44266, 36.82708], [-121.44302, 36.8271], [-121.44443, 36.82707], [-121.44666, 36.82701], [-121.44655, 36.82691], [-121.44656, 36.8267], [-121.4466, 36.82652], [-121.44661, 36.8262], [-121.44652, 36.82611], [-121.44642, 36.82604], [-121.44635, 36.82594], [-121.44615, 36.82549], [-121.44609, 36.82527], [-121.44607, 36.82512], [-121.44611, 36.82499], [-121.44609, 36.82486], [-121.44608, 36.82456], [-121.44612, 36.82449], [-121.44619, 36.82445], [-121.44628, 36.82444], [-121.4466, 36.82445], [-121.44688, 36.82443], [-121.44697, 36.82437], [-121.44699, 36.82425], [-121.44692, 36.82416], [-121.44685, 36.82402], [-121.44679, 36.82378], [-121.44673, 36.82365], [-121.44663, 36.82353], [-121.4466, 36.82343], [-121.44656, 36.82324], [-121.44649, 36.82309], [-121.44637, 36.82298], [-121.44634, 36.82277], [-121.44628, 36.82257], [-121.44614, 36.82242], [-121.44578, 36.82214], [-121.44571, 36.82207], [-121.44565, 36.82199], [-121.44562, 36.8218], [-121.44566, 36.82172], [-121.44571, 36.82155], [-121.44578, 36.82137], [-121.44585, 36.82124], [-121.44598, 36.82103], [-121.44602, 36.82099], [-121.44608, 36.82096], [-121.44631, 36.82091], [-121.44636, 36.82096], [-121.44644, 36.82096], [-121.44672, 36.82106], [-121.44734, 36.82137], [-121.44757, 36.82144], [-121.44782, 36.82142], [-121.44801, 36.82134], [-121.44825, 36.82131], [-121.44842, 36.82118], [-121.44852, 36.82108], [-121.44842, 36.821], [-121.44839, 36.82094], [-121.44837, 36.8208], [-121.4484, 36.82073], [-121.44868, 36.82059], [-121.44876, 36.82057], [-121.44883, 36.82049], [-121.44879, 36.82044], [-121.44847, 36.8202], [-121.44839, 36.82007], [-121.44837, 36.81967], [-121.44833, 36.81947], [-121.44829, 36.81938], [-121.4482, 36.81928], [-121.44819, 36.81921], [-121.44821, 36.819], [-121.44819, 36.81872], [-121.44851, 36.81842], [-121.44867, 36.81824], [-121.44867, 36.81812]]]} | No Public Access 3 | 48968 | San Justo Reservoir | 33666 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | https://www.cosb.us/county-departments/public-works/parks-recreation/regional-parks/san-justo/ | San Benito 38 | 281.271 | San Justo Reservoir | 0 | Resource Management Area 82 | 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]);