units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 16, MNG_AGENCY = 665 and UNIT_NAME = "Ten Mile"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- The Conservation Fund - California · 1 ✖
DES_TP 1
- Private Conservation · 1 ✖
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14651 | 14651 | 14650 | {"type": "MultiPolygon", "coordinates": [[[[-123.75672, 39.54169], [-123.75661, 39.5417], [-123.75661, 39.54179], [-123.75658, 39.54188], [-123.75649, 39.54196], [-123.75635, 39.542], [-123.75619, 39.54198], [-123.75592, 39.54186], [-123.75556, 39.54176], [-123.75456, 39.54131], [-123.75265, 39.53993], [-123.75164, 39.53936], [-123.75094, 39.53903], [-123.74967, 39.53835], [-123.74937, 39.53821], [-123.74889, 39.53801], [-123.74859, 39.53784], [-123.74806, 39.53759], [-123.74792, 39.53747], [-123.74779, 39.53733], [-123.74772, 39.53713], [-123.74759, 39.5364], [-123.74759, 39.53625], [-123.74762, 39.5361], [-123.7477, 39.53596], [-123.74779, 39.53585], [-123.74821, 39.53551], [-123.74833, 39.53537], [-123.74844, 39.53521], [-123.74868, 39.53478], [-123.74875, 39.53458], [-123.74879, 39.5343], [-123.74879, 39.53412], [-123.74872, 39.53387], [-123.74841, 39.53339], [-123.7481, 39.53299], [-123.74776, 39.53264], [-123.74732, 39.53209], [-123.74604, 39.53053], [-123.74582, 39.53024], [-123.74523, 39.52958], [-123.74437, 39.52852], [-123.744, 39.5282], [-123.74378, 39.52805], [-123.74352, 39.52796], [-123.74258, 39.52775], [-123.74191, 39.52757], [-123.74093, 39.52745], [-123.7409, 39.52761], [-123.7414, 39.52767], [-123.74218, 39.52781], [-123.7432, 39.52803], [-123.7436, 39.52817], [-123.74389, 39.52833], [-123.74423, 39.52866], [-123.74499, 39.52958], [-123.74589, 39.5307], [-123.74636, 39.53121], [-123.74719, 39.53222], [-123.74759, 39.53276], [-123.74807, 39.53324], [-123.74846, 39.53375], [-123.74857, 39.53403], [-123.7486, 39.53421], [-123.74859, 39.53445], [-123.74855, 39.53462], [-123.7484, 39.5349], [-123.74826, 39.53517], [-123.74811, 39.53537], [-123.74798, 39.5355], [-123.74766, 39.53572], [-123.74756, 39.53584], [-123.74747, 39.53596], [-123.74741, 39.5361], [-123.74741, 39.5363], [-123.74753, 39.53708], [-123.74758, 39.53727], [-123.74766, 39.53741], [-123.74782, 39.53758], [-123.74802, 39.53773], [-123.74858, 39.53801], [-123.74815, 39.53805], [-123.74781, 39.53813], [-123.74758, 39.53821], [-123.74679, 39.53855], [-123.74498, 39.53837], [-123.74511, 39.53123], [-123.74058, 39.53121], [-123.74072, 39.52779], [-123.74071, 39.52759], [-123.74068, 39.52752], [-123.73798, 39.52756], [-123.73741, 39.52742], [-123.73702, 39.52727], [-123.73662, 39.52705], [-123.73613, 39.52673], [-123.73545, 39.52642], [-123.73509, 39.52694], [-123.73448, 39.52668], [-123.73451, 39.52661], [-123.73473, 39.52628], [-123.73447, 39.52619], [-123.73424, 39.52619], [-123.73395, 39.52622], [-123.73381, 39.52626], [-123.73393, 39.52693], [-123.73309, 39.52705], [-123.73286, 39.52512], [-123.73192, 39.52523], [-123.73197, 39.52387], [-123.7409, 39.52395], [-123.74516, 39.52394], [-123.74505, 39.52766], [-123.74954, 39.52769], [-123.74939, 39.53006], [-123.7496, 39.53027], [-123.74987, 39.53029], [-123.75022, 39.53041], [-123.75044, 39.53057], [-123.75061, 39.53079], [-123.75082, 39.53097], [-123.75148, 39.53132], [-123.75149, 39.53331], [-123.75154, 39.53459], [-123.75429, 39.5346], [-123.75607, 39.53459], [-123.75571, 39.53707], [-123.75565, 39.53771], [-123.75566, 39.53839], [-123.75577, 39.53915], [-123.75596, 39.53997], [-123.75625, 39.54082], [-123.75672, 39.54169]], [[-123.73605, 39.52571], [-123.73614, 39.52557], [-123.73548, 39.52528], [-123.73515, 39.52572], [-123.73516, 39.52573], [-123.73605, 39.52571]]], [[[-123.74648, 39.54562], [-123.74527, 39.54564], [-123.74505, 39.54313], [-123.74594, 39.54407], [-123.74613, 39.54436], [-123.74626, 39.54471], [-123.74648, 39.54562]]], [[[-123.75423, 39.54137], [-123.75357, 39.54166], [-123.75343, 39.54142], [-123.753, 39.54103], [-123.75263, 39.54058], [-123.7523, 39.54038], [-123.75157, 39.54], [-123.75065, 39.53965], [-123.74995, 39.53946], [-123.74889, 39.53933], [-123.74809, 39.53939], [-123.74698, 39.53964], [-123.74621, 39.5399], [-123.74597, 39.54009], [-123.74589, 39.54023], [-123.74589, 39.54034], [-123.74597, 39.54049], [-123.74619, 39.5407], [-123.74664, 39.54101], [-123.74686, 39.54138], [-123.74696, 39.54169], [-123.74708, 39.54196], [-123.74723, 39.54217], [-123.74737, 39.5423], [-123.74772, 39.54245], [-123.74792, 39.54257], [-123.7481, 39.54276], [-123.74817, 39.54293], [-123.74817, 39.54319], [-123.74791, 39.54404], [-123.7479, 39.54422], [-123.74796, 39.54444], [-123.74813, 39.54467], [-123.74882, 39.54535], [-123.74919, 39.54562], [-123.74666, 39.54563], [-123.7464, 39.54451], [-123.7463, 39.54427], [-123.74619, 39.54407], [-123.74593, 39.54376], [-123.74568, 39.54355], [-123.74495, 39.54275], [-123.74482, 39.54249], [-123.74478, 39.54225], [-123.74482, 39.54197], [-123.74492, 39.54153], [-123.7453, 39.54012], [-123.74544, 39.53984], [-123.74563, 39.53958], [-123.74586, 39.53931], [-123.74608, 39.53914], [-123.74699, 39.53869], [-123.74702, 39.53873], [-123.74794, 39.53834], [-123.7485, 39.53826], [-123.74881, 39.5383], [-123.74912, 39.53841], [-123.7497, 39.53871], [-123.75035, 39.53896], [-123.7512, 39.53934], [-123.75209, 39.53983], [-123.75268, 39.54022], [-123.75324, 39.54062], [-123.75423, 39.54137]]]]} | Restricted Access 2 | 44911 | Ten Mile | 26239 | 3087 | The Conservation Fund - California 675 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 388.428 | Ten Mile | 0 | Private Conservation 16 | 2 |
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]);