units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 49, LABEL_NAME = "Lake Oroville SRA" and LAYER = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16652 | 16652 | 16651 | {"type": "MultiPolygon", "coordinates": [[[[-121.33461, 39.6131], [-121.31605, 39.61339], [-121.31622, 39.60442], [-121.31812, 39.60418], [-121.31902, 39.60466], [-121.31785, 39.60728], [-121.32003, 39.6088], [-121.32015, 39.61032], [-121.32494, 39.61183], [-121.32956, 39.61096], [-121.3345, 39.60636], [-121.33461, 39.6131]]], [[[-121.38939, 39.57026], [-121.38831, 39.5722], [-121.37386, 39.57152], [-121.37218, 39.57253], [-121.3693, 39.57456], [-121.36005, 39.57437], [-121.35685, 39.57515], [-121.35318, 39.57973], [-121.35293, 39.58002], [-121.35312, 39.57084], [-121.37186, 39.57039], [-121.37613, 39.57039], [-121.38939, 39.57026]]], [[[-121.37239, 39.5835], [-121.36235, 39.5847], [-121.36047, 39.58492], [-121.36112, 39.58351], [-121.36342, 39.5813], [-121.36738, 39.58167], [-121.37228, 39.58081], [-121.37239, 39.5835]]], [[[-121.41255, 39.53317], [-121.40968, 39.53597], [-121.40825, 39.53691], [-121.40698, 39.53824], [-121.40501, 39.53809], [-121.40185, 39.54051], [-121.39557, 39.53793], [-121.39535, 39.53787], [-121.39184, 39.53341], [-121.39125, 39.52643], [-121.39007, 39.52606], [-121.39007, 39.52247], [-121.39661, 39.52252], [-121.40404, 39.52262], [-121.40863, 39.52265], [-121.40863, 39.52551], [-121.40853, 39.53326], [-121.41255, 39.53317]]], [[[-121.41778, 39.53304], [-121.41781, 39.53482], [-121.41774, 39.54104], [-121.41677, 39.54105], [-121.41632, 39.54103], [-121.4152, 39.54094], [-121.41343, 39.5382], [-121.41519, 39.53673], [-121.41499, 39.53311], [-121.41778, 39.53304]]], [[[-121.47715, 39.61377], [-121.47689, 39.61377], [-121.47693, 39.61193], [-121.47658, 39.61142], [-121.4762, 39.61067], [-121.47607, 39.61038], [-121.47584, 39.61007], [-121.4751, 39.6089], [-121.47488, 39.60852], [-121.47431, 39.60848], [-121.47448, 39.60358], [-121.47232, 39.60196], [-121.46978, 39.60278], [-121.46972, 39.60251], [-121.46971, 39.6025], [-121.46794, 39.60314], [-121.46491, 39.60289], [-121.46491, 39.60256], [-121.46773, 39.60252], [-121.46977, 39.60214], [-121.47183, 39.60171], [-121.47316, 39.6022], [-121.4763, 39.60498], [-121.47488, 39.60825], [-121.47714, 39.61191], [-121.47715, 39.61377]]], [[[-121.48148, 39.62159], [-121.48141, 39.62196], [-121.47868, 39.62337], [-121.47636, 39.62164], [-121.47618, 39.62042], [-121.47709, 39.61843], [-121.47516, 39.61686], [-121.47411, 39.61496], [-121.47419, 39.61391], [-121.47445, 39.61391], [-121.47445, 39.61502], [-121.47518, 39.61662], [-121.47733, 39.61814], [-121.47626, 39.62035], [-121.4764, 39.62124], [-121.47908, 39.62289], [-121.48148, 39.62159]]], [[[-121.47666, 39.63437], [-121.47659, 39.6344], [-121.47593, 39.63336], [-121.47664, 39.63437], [-121.47666, 39.63437]]], [[[-121.4788, 39.63005], [-121.47727, 39.63148], [-121.47694, 39.63178], [-121.4787, 39.6299], [-121.4788, 39.63005]]], [[[-121.48367, 39.62027], [-121.48362, 39.62118], [-121.48152, 39.62358], [-121.48145, 39.62362], [-121.48319, 39.62101], [-121.48198, 39.62024], [-121.48212, 39.61968], [-121.48367, 39.62027]]], [[[-121.4956, 39.64608], [-121.48977, 39.64966], [-121.48874, 39.6519], [-121.48775, 39.6542], [-121.48614, 39.65417], [-121.48627, 39.63993], [-121.49088, 39.63996], [-121.4897, 39.63481], [-121.48913, 39.63382], [-121.49006, 39.63534], [-121.49148, 39.64016], [-121.49546, 39.6459], [-121.4956, 39.64608]]], [[[-121.50553, 39.64585], [-121.50555, 39.64725], [-121.5055, 39.65445], [-121.49996, 39.65438], [-121.49971, 39.6538], [-121.49976, 39.65343], [-121.5048, 39.65008], [-121.50553, 39.64585]]], [[[-121.50551, 39.6446], [-121.50551, 39.64436], [-121.50384, 39.64059], [-121.50364, 39.64005], [-121.50545, 39.64006], [-121.50551, 39.6446]]], [[[-121.55677, 39.72776], [-121.54164, 39.73016], [-121.54146, 39.7292], [-121.54144, 39.72695], [-121.54655, 39.7257], [-121.55136, 39.72491], [-121.5514, 39.72398], [-121.55418, 39.72367], [-121.55659, 39.72639], [-121.55677, 39.72776]]], [[[-121.55407, 39.71999], [-121.55049, 39.72214], [-121.55064, 39.72394], [-121.55061, 39.72394], [-121.55048, 39.722], [-121.55151, 39.72139], [-121.55169, 39.71689], [-121.54693, 39.71727], [-121.54728, 39.71236], [-121.5519, 39.71244], [-121.55345, 39.71242], [-121.55339, 39.71505], [-121.55274, 39.71723], [-121.55407, 39.71999]]], [[[-121.57043, 39.70493], [-121.57032, 39.70854], [-121.56567, 39.70854], [-121.5656, 39.7122], [-121.56099, 39.71221], [-121.56084, 39.72711], [-121.56017, 39.72722], [-121.56033, 39.72525], [-121.558, 39.72249], [-121.55754, 39.71731], [-121.55872, 39.71635], [-121.55821, 39.71232], [-121.55816, 39.7116], [-121.56114, 39.71058], [-121.56255, 39.71003], [-121.56395, 39.70842], [-121.5671, 39.70584], [-121.5669, 39.70491], [-121.57043, 39.70493]], [[-121.56098, 39.7122], [-121.56102, 39.7109], [-121.55851, 39.71179], [-121.55849, 39.71226], [-121.56098, 39.7122]]]]} | Open Access 1 | 16331 | Lake Oroville State Recreation Area | 20957 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Butte 42 | 1861.059 | Lake Oroville SRA | 1967 | Recreation Management Area 49 | 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]);