units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 131, DES_TP = 1181 and MNG_AGENCY = 128
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13738 | 13738 | 13737 | {"type": "Polygon", "coordinates": [[[-120.73667, 39.47016], [-120.73657, 39.47755], [-120.73196, 39.47752], [-120.73198, 39.48087], [-120.72711, 39.48102], [-120.72718, 39.48469], [-120.71771, 39.48463], [-120.7177, 39.49196], [-120.70865, 39.49214], [-120.70863, 39.49212], [-120.70882, 39.49178], [-120.70902, 39.4913], [-120.70912, 39.49113], [-120.70917, 39.49097], [-120.70929, 39.49081], [-120.70943, 39.49075], [-120.70989, 39.49065], [-120.71016, 39.49061], [-120.71064, 39.49068], [-120.71091, 39.49069], [-120.71122, 39.49065], [-120.71147, 39.49057], [-120.71164, 39.49046], [-120.71209, 39.49036], [-120.71225, 39.49019], [-120.71234, 39.48997], [-120.71239, 39.48977], [-120.71244, 39.48947], [-120.71253, 39.48925], [-120.71269, 39.48915], [-120.71298, 39.48912], [-120.71314, 39.48915], [-120.71338, 39.48923], [-120.71365, 39.4893], [-120.71392, 39.48935], [-120.71436, 39.48936], [-120.71476, 39.48932], [-120.71496, 39.48924], [-120.71527, 39.48928], [-120.71557, 39.48935], [-120.71584, 39.4894], [-120.71611, 39.48939], [-120.71629, 39.48932], [-120.71662, 39.48934], [-120.71683, 39.48934], [-120.71696, 39.48928], [-120.71714, 39.48907], [-120.71714, 39.48881], [-120.71702, 39.48861], [-120.71686, 39.48842], [-120.71684, 39.48799], [-120.71669, 39.4878], [-120.71645, 39.48759], [-120.71633, 39.48739], [-120.71626, 39.48713], [-120.71631, 39.48674], [-120.71625, 39.48657], [-120.71522, 39.48607], [-120.71507, 39.48595], [-120.71503, 39.48582], [-120.71503, 39.48565], [-120.71507, 39.48543], [-120.71518, 39.48516], [-120.71518, 39.48491], [-120.71506, 39.48448], [-120.71469, 39.48396], [-120.71459, 39.48379], [-120.71418, 39.48348], [-120.71379, 39.48317], [-120.71369, 39.48301], [-120.71382, 39.48274], [-120.71396, 39.48257], [-120.71423, 39.48206], [-120.71437, 39.48184], [-120.71504, 39.48126], [-120.71528, 39.48112], [-120.71539, 39.48111], [-120.71585, 39.48096], [-120.71598, 39.48089], [-120.71616, 39.48074], [-120.71628, 39.48054], [-120.7165, 39.48037], [-120.71702, 39.48002], [-120.71729, 39.4799], [-120.71785, 39.47963], [-120.71859, 39.47937], [-120.71888, 39.47923], [-120.71904, 39.47907], [-120.71934, 39.47886], [-120.71958, 39.47875], [-120.7199, 39.47853], [-120.72018, 39.47839], [-120.72036, 39.47822], [-120.7206, 39.47792], [-120.72105, 39.47745], [-120.72157, 39.47687], [-120.72185, 39.4766], [-120.72236, 39.47622], [-120.72293, 39.4757], [-120.72376, 39.47521], [-120.72404, 39.475], [-120.72434, 39.47473], [-120.72459, 39.47439], [-120.72484, 39.47399], [-120.72523, 39.47327], [-120.72546, 39.47295], [-120.72562, 39.47283], [-120.7261, 39.47262], [-120.72634, 39.47248], [-120.72651, 39.47235], [-120.72713, 39.47198], [-120.72754, 39.47184], [-120.7279, 39.47168], [-120.7283, 39.47154], [-120.7288, 39.47127], [-120.72948, 39.47101], [-120.72964, 39.47099], [-120.72991, 39.47104], [-120.73014, 39.47115], [-120.73043, 39.47123], [-120.73063, 39.47123], [-120.73087, 39.47114], [-120.73112, 39.47073], [-120.73146, 39.47029], [-120.73205, 39.4699], [-120.73229, 39.46983], [-120.73256, 39.46986], [-120.73285, 39.46985], [-120.73315, 39.46982], [-120.73346, 39.46975], [-120.73384, 39.46976], [-120.73421, 39.4698], [-120.73502, 39.46992], [-120.73616, 39.47012], [-120.73663, 39.47013], [-120.73667, 39.47016]]]} | Open Access 1 | 36232 | Other State 27 | 8209 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | http://asi.ucdavis.edu/rr | Sierra 58 | 481.401 | Other State 27 | None 1181 |
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]);