units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 1 and DES_TP = 55
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14333 | 14333 | 14332 | {"type": "MultiPolygon", "coordinates": [[[[-119.95169, 35.34039], [-119.95158, 35.34385], [-119.94704, 35.34383], [-119.947, 35.3511], [-119.93381, 35.35103], [-119.93382, 35.34373], [-119.94283, 35.34379], [-119.94285, 35.34034], [-119.95169, 35.34039]]], [[[-119.96505, 35.33683], [-119.96502, 35.344], [-119.96043, 35.34409], [-119.96043, 35.3477], [-119.9559, 35.34767], [-119.95603, 35.34409], [-119.96042, 35.34409], [-119.96057, 35.33683], [-119.96505, 35.33683]]], [[[-119.98747, 35.33683], [-119.98735, 35.34411], [-119.96942, 35.34398], [-119.96961, 35.33682], [-119.98747, 35.33683]]], [[[-120.11221, 35.42515], [-120.11212, 35.43976], [-120.07625, 35.43965], [-120.07684, 35.425], [-120.05856, 35.4248], [-120.05869, 35.41023], [-120.04079, 35.41018], [-120.04076, 35.39937], [-120.03647, 35.39935], [-120.03645, 35.40289], [-120.03174, 35.40286], [-120.03178, 35.39558], [-120.02291, 35.39551], [-120.02283, 35.39752], [-120.01828, 35.39748], [-120.0183, 35.39549], [-120.01409, 35.39544], [-120.0141, 35.39176], [-120.01834, 35.39181], [-120.0183, 35.39548], [-120.01842, 35.39548], [-120.01843, 35.38431], [-120.01407, 35.3843], [-120.01398, 35.40633], [-120.02291, 35.40637], [-120.02291, 35.41006], [-120.01397, 35.4101], [-120.01396, 35.40745], [-119.98714, 35.40745], [-119.98723, 35.39547], [-119.98728, 35.38073], [-119.98721, 35.36616], [-120.00498, 35.36619], [-120.00533, 35.3516], [-120.03916, 35.35179], [-120.03919, 35.35942], [-120.03263, 35.35936], [-120.03223, 35.35888], [-120.03236, 35.35539], [-120.03276, 35.35491], [-120.03265, 35.35331], [-120.02691, 35.35331], [-120.02685, 35.35475], [-120.02724, 35.35502], [-120.02737, 35.38091], [-120.02717, 35.38092], [-120.02729, 35.3881], [-120.03183, 35.38814], [-120.03182, 35.38883], [-120.03183, 35.38884], [-120.03414, 35.38879], [-120.03698, 35.38817], [-120.04584, 35.38823], [-120.04587, 35.39171], [-120.04986, 35.39171], [-120.0499, 35.39568], [-120.0588, 35.39569], [-120.05897, 35.38872], [-120.06823, 35.38878], [-120.06818, 35.3957], [-120.08401, 35.39576], [-120.084, 35.40312], [-120.09426, 35.40318], [-120.09436, 35.42495], [-120.11221, 35.42515]], [[-120.00951, 35.36991], [-120.00952, 35.3699], [-120.00951, 35.36985], [-120.00509, 35.36985], [-120.00507, 35.36913], [-120.00505, 35.36913], [-120.00507, 35.3699], [-120.00951, 35.36991]], [[-120.01411, 35.38086], [-120.01412, 35.38085], [-120.0141, 35.38006], [-120.01409, 35.38085], [-120.01411, 35.38086]]], [[[-120.04067, 35.38442], [-120.03626, 35.3844], [-120.03623, 35.38094], [-120.04065, 35.38097], [-120.04067, 35.38442]]], [[[-120.09453, 35.35203], [-120.09446, 35.35604], [-120.09433, 35.35941], [-120.0943, 35.36646], [-120.08626, 35.36648], [-120.07741, 35.36647], [-120.07697, 35.36631], [-120.07702, 35.35933], [-120.07701, 35.35682], [-120.07617, 35.35678], [-120.07177, 35.35231], [-120.07016, 35.35227], [-120.07016, 35.35184], [-120.06997, 35.34965], [-120.06845, 35.34954], [-120.06851, 35.34831], [-120.0667, 35.34825], [-120.06668, 35.34663], [-120.06482, 35.34664], [-120.06478, 35.34488], [-120.0647, 35.3448], [-120.05734, 35.3449], [-120.05727, 35.34647], [-120.0543, 35.34645], [-120.05427, 35.34491], [-120.05033, 35.34496], [-120.0502, 35.34824], [-120.04715, 35.3482], [-120.04698, 35.3597], [-120.04063, 35.3597], [-120.04082, 35.33879], [-120.04089, 35.33879], [-120.05021, 35.34175], [-120.05287, 35.34161], [-120.0528, 35.33703], [-120.07704, 35.33706], [-120.07698, 35.35187], [-120.09453, 35.35203]]], [[[-120.09423, 35.37925], [-120.09423, 35.38101], [-120.09421, 35.38124], [-120.08206, 35.38118], [-120.08205, 35.38115], [-120.07786, 35.38119], [-120.0779, 35.37486], [-120.07979, 35.37486], [-120.08205, 35.37552], [-120.08204, 35.36856], [-120.08214, 35.3686], [-120.08215, 35.37614], [-120.09141, 35.37927], [-120.09423, 35.37925]]]]} | No Public Access 3 | 44336 | California Valley | 32084 | 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 | San Luis Obispo 1 | 12379.201 | California Valley | 0 | State Resource Management Area 55 | 3 | |
| 16582 | 16582 | 16581 | {"type": "MultiPolygon", "coordinates": [[[[-119.71974, 35.2303], [-119.71972, 35.23372], [-119.71531, 35.23371], [-119.71533, 35.23026], [-119.70652, 35.23018], [-119.70654, 35.22655], [-119.70214, 35.2265], [-119.70217, 35.22287], [-119.70658, 35.22291], [-119.70661, 35.21927], [-119.71102, 35.21932], [-119.71099, 35.22295], [-119.70658, 35.22291], [-119.70655, 35.22654], [-119.71537, 35.22663], [-119.71534, 35.23026], [-119.71974, 35.2303]]], [[[-119.77399, 35.04841], [-119.76497, 35.04846], [-119.7649, 35.04519], [-119.76936, 35.04515], [-119.76928, 35.04158], [-119.75627, 35.04163], [-119.75623, 35.03425], [-119.77383, 35.03421], [-119.77399, 35.04841]]]]} | Open Access 1 | 44756 | 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 | San Luis Obispo 1 | 638.28 | 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]);