units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 3, DES_TP = 104 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 3 ✖
DES_TP 1
- State Other or Unknown · 3 ✖
ACCESS_TYP 1
- No Public Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6906 | 6906 | 6905 | {"type": "Polygon", "coordinates": [[[-121.85532, 36.96849], [-121.8553, 36.97036], [-121.85531, 36.97247], [-121.8493, 36.97206], [-121.84933, 36.97197], [-121.84969, 36.9715], [-121.84967, 36.97143], [-121.85036, 36.97084], [-121.85035, 36.97049], [-121.85054, 36.97015], [-121.85084, 36.97007], [-121.85123, 36.96986], [-121.85152, 36.96938], [-121.85532, 36.96849]]]} | No Public Access 3 | 47542 | San Andreas Creek - King Property | 31250 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 39.619 | San Andreas Creek - King Property | 0 | State Other or Unknown 104 | 4 | |
| 7566 | 7566 | 7565 | {"type": "MultiPolygon", "coordinates": [[[[-118.79086, 34.75249], [-118.7905, 34.75269], [-118.78995, 34.75282], [-118.78833, 34.75304], [-118.7856, 34.75305], [-118.78493, 34.75343], [-118.7845, 34.75351], [-118.78357, 34.75316], [-118.78272, 34.7538], [-118.78126, 34.75417], [-118.78017, 34.75394], [-118.77903, 34.75547], [-118.77894, 34.75664], [-118.77779, 34.75756], [-118.77848, 34.758], [-118.77841, 34.75986], [-118.77886, 34.75987], [-118.77913, 34.76202], [-118.77761, 34.76518], [-118.77755, 34.76574], [-118.77634, 34.76582], [-118.77522, 34.7637], [-118.77346, 34.76262], [-118.77195, 34.76241], [-118.77418, 34.76093], [-118.7718, 34.76016], [-118.7718, 34.75988], [-118.77251, 34.75988], [-118.77253, 34.75986], [-118.77541, 34.75987], [-118.77538, 34.75716], [-118.76641, 34.75721], [-118.76641, 34.7563], [-118.76211, 34.75628], [-118.76217, 34.75101], [-118.76215, 34.74996], [-118.76216, 34.74903], [-118.74905, 34.74906], [-118.74903, 34.74547], [-118.74904, 34.73837], [-118.75789, 34.73825], [-118.75783, 34.7453], [-118.75784, 34.74543], [-118.76664, 34.74538], [-118.76648, 34.75269], [-118.78437, 34.75246], [-118.79086, 34.75249]]], [[[-118.81161, 34.69934], [-118.80281, 34.69927], [-118.80282, 34.70238], [-118.80001, 34.70204], [-118.79731, 34.7014], [-118.79715, 34.70135], [-118.79688, 34.70122], [-118.79659, 34.70101], [-118.79636, 34.70072], [-118.79535, 34.69892], [-118.79396, 34.69519], [-118.79373, 34.69386], [-118.79362, 34.6936], [-118.79348, 34.69334], [-118.7933, 34.69308], [-118.7926, 34.69251], [-118.79179, 34.69207], [-118.79171, 34.69193], [-118.79408, 34.69176], [-118.80275, 34.69201], [-118.80714, 34.69205], [-118.80718, 34.69567], [-118.81157, 34.69571], [-118.81161, 34.69934]]], [[[-118.7954, 34.74528], [-118.79529, 34.74598], [-118.79517, 34.74694], [-118.79477, 34.7469], [-118.79447, 34.74857], [-118.79437, 34.74895], [-118.79362, 34.75118], [-118.79356, 34.75131], [-118.79347, 34.75144], [-118.79333, 34.75159], [-118.79322, 34.75168], [-118.79317, 34.74518], [-118.7953, 34.74521], [-118.7954, 34.74528]]]]} | No Public Access 3 | 7259 | DWR Mitigation -- L.A. Property | 32152 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Los Angeles 6 | 999.598 | DWR Mitigation -- L.A. Property | 0 | State Other or Unknown 104 | 4 | |
| 10013 | 10013 | 10012 | {"type": "Polygon", "coordinates": [[[-121.0344, 37.04936], [-121.02559, 37.04938], [-121.02568, 37.04211], [-121.02537, 37.0413], [-121.02528, 37.04058], [-121.02522, 37.04034], [-121.03435, 37.04041], [-121.03434, 37.04218], [-121.0344, 37.04936]]]} | No Public Access 3 | 17275 | Jasper Sears Mitigation Parcel | 32192 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 192.527 | Jasper Sears Mitigation Parcel | 0 | State Other or Unknown 104 | 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]);