calands: units_with_maps: 4 rows where COUNTY = 1, MNG_AG_TYP = 5 and YR

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where COUNTY = 1, MNG_AG_TYP = 5 and YR_EST = 0

Search:

descending

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	COUNTY	ACRES	LABEL_NAME	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	State Resource Management Area 55	3
15549	15549	15548	{"type": "Polygon", "coordinates": [[[-121.08092, 35.57253], [-121.07853, 35.58086], [-121.07824, 35.58086], [-121.07506, 35.56806], [-121.07741, 35.56778], [-121.07727, 35.56735], [-121.0795, 35.5668], [-121.08092, 35.57253]]]}	Restricted Access 2	605	Cambria Pines Ecological Reserve	30728	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	111.579	Cambria Pines ER	State Conservation Area 8	2
15570	15570	15569	{"type": "MultiPolygon", "coordinates": [[[[-120.78423, 35.35484], [-120.78407, 35.35512], [-120.78188, 35.35428], [-120.78066, 35.35491], [-120.77891, 35.35839], [-120.77894, 35.35915], [-120.77833, 35.35929], [-120.77818, 35.35951], [-120.77779, 35.35943], [-120.77772, 35.35931], [-120.77747, 35.35929], [-120.77729, 35.35952], [-120.77685, 35.35978], [-120.77648, 35.35961], [-120.77572, 35.35942], [-120.77514, 35.35971], [-120.77472, 35.35951], [-120.77383, 35.36014], [-120.77382, 35.36038], [-120.77367, 35.36051], [-120.77325, 35.35995], [-120.77254, 35.36024], [-120.77179, 35.36037], [-120.77134, 35.3605], [-120.7713, 35.36079], [-120.77098, 35.36083], [-120.77068, 35.3607], [-120.7699, 35.35921], [-120.76874, 35.3547], [-120.76848, 35.35451], [-120.7687, 35.35423], [-120.76534, 35.35444], [-120.76491, 35.3543], [-120.7642, 35.35361], [-120.76483, 35.35339], [-120.76831, 35.35102], [-120.77096, 35.34875], [-120.77352, 35.35089], [-120.77408, 35.35133], [-120.77452, 35.35163], [-120.77497, 35.35191], [-120.77544, 35.35217], [-120.77592, 35.3524], [-120.77676, 35.35275], [-120.77892, 35.35352], [-120.78125, 35.35414], [-120.78179, 35.35416], [-120.78423, 35.35484]]], [[[-120.78839, 35.35056], [-120.7849, 35.35448], [-120.78472, 35.35418], [-120.78437, 35.35413], [-120.7843, 35.35428], [-120.78204, 35.35366], [-120.78173, 35.35352], [-120.77937, 35.35286], [-120.77904, 35.35288], [-120.77819, 35.35262], [-120.77625, 35.35182], [-120.77603, 35.35178], [-120.77528, 35.3514], [-120.77307, 35.34976], [-120.77275, 35.34935], [-120.77231, 35.34912], [-120.76626, 35.34409], [-120.77364, 35.33965], [-120.7789, 35.34466], [-120.78354, 35.34942], [-120.78839, 35.35056]]]]}	Restricted Access 2	6147	Chorro Creek Ecological Reserve	17221	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	583.097	Chorro Creek ER	State Conservation Area 8	2
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	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]);