units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 3, DES_TP = 82, MNG_AGENCY = 142 and MNG_AG_LEV = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Army Corps of Engineers · 2 ✖
DES_TP 1
- Resource Management Area · 2 ✖
ACCESS_TYP 1
- No Public Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);