units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 9, DES_TP = 55 and MNG_AGENCY = 73
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California State Lands Commission · 3 ✖
DES_TP 1
- State Resource Management Area · 3 ✖
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10097 | 10097 | 10096 | {"type": "MultiPolygon", "coordinates": [[[[-120.38851, 36.07903], [-120.38402, 36.07898], [-120.38402, 36.07506], [-120.38845, 36.07502], [-120.38851, 36.07903]]], [[[-120.58648, 36.28432], [-120.56898, 36.28448], [-120.56891, 36.27347], [-120.57736, 36.27346], [-120.57738, 36.27704], [-120.58181, 36.27708], [-120.58182, 36.26987], [-120.58634, 36.26983], [-120.58625, 36.27704], [-120.58648, 36.28432]]], [[[-120.6209, 36.31956], [-120.62001, 36.31988], [-120.61962, 36.31972], [-120.61915, 36.31943], [-120.619, 36.31927], [-120.61892, 36.31921], [-120.61858, 36.31915], [-120.61844, 36.31908], [-120.61826, 36.31897], [-120.61801, 36.31877], [-120.61788, 36.31886], [-120.6177, 36.31914], [-120.61751, 36.31933], [-120.6173, 36.31945], [-120.61713, 36.3195], [-120.61694, 36.31946], [-120.61638, 36.3195], [-120.61612, 36.31957], [-120.61591, 36.31965], [-120.61558, 36.31993], [-120.61533, 36.32007], [-120.61508, 36.32025], [-120.6149, 36.32029], [-120.61468, 36.32026], [-120.61445, 36.32021], [-120.61406, 36.32021], [-120.61354, 36.32026], [-120.61338, 36.32031], [-120.61326, 36.32052], [-120.6131, 36.32067], [-120.61297, 36.32075], [-120.61283, 36.32087], [-120.61252, 36.32107], [-120.61216, 36.32146], [-120.61215, 36.32158], [-120.61226, 36.32178], [-120.6125, 36.32199], [-120.61255, 36.32226], [-120.61265, 36.32263], [-120.61277, 36.32284], [-120.61288, 36.32297], [-120.61297, 36.3233], [-120.61303, 36.32359], [-120.61295, 36.3239], [-120.61272, 36.32415], [-120.61251, 36.32431], [-120.6118, 36.32462], [-120.61154, 36.32465], [-120.61134, 36.32462], [-120.61079, 36.32436], [-120.61013, 36.32425], [-120.60988, 36.32425], [-120.60926, 36.32432], [-120.609, 36.32433], [-120.60875, 36.3243], [-120.60844, 36.32432], [-120.60822, 36.32437], [-120.60805, 36.32437], [-120.60753, 36.32427], [-120.60703, 36.3242], [-120.6068, 36.32419], [-120.60648, 36.32424], [-120.60597, 36.32425], [-120.60558, 36.32429], [-120.60535, 36.32425], [-120.60516, 36.32415], [-120.605, 36.32415], [-120.60461, 36.32434], [-120.6044, 36.32455], [-120.60423, 36.32467], [-120.60403, 36.32474], [-120.60394, 36.32491], [-120.6039, 36.32523], [-120.60382, 36.32541], [-120.60365, 36.32549], [-120.60346, 36.32547], [-120.60308, 36.3255], [-120.60257, 36.3255], [-120.60229, 36.32564], [-120.60214, 36.32573], [-120.60196, 36.32626], [-120.59657, 36.32616], [-120.59655, 36.32505], [-120.59647, 36.32298], [-120.59616, 36.31099], [-120.60401, 36.31092], [-120.61261, 36.31081], [-120.61716, 36.31079], [-120.62084, 36.31061], [-120.6209, 36.31956]]]]} | Open Access 1 | 17485 | 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 | Fresno 9 | 1266.224 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} | Open Access 1 | 44769 | 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 | Fresno 9 | 78.552 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | 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 | Fresno 9 | 242.067 | 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]);