calands: units_with_maps: 3 rows where COUNTY = 20, DES_TP = 55 and MNG_AG

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

3 rows where COUNTY = 20, DES_TP = 55 and MNG_AG_TYP = 5

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
3490	3490	3489	{"type": "MultiPolygon", "coordinates": [[[[-115.13976, 33.41494], [-115.13975, 33.4189], [-115.13539, 33.41889], [-115.13545, 33.41469], [-115.13976, 33.41494]]], [[[-115.19698, 33.413], [-115.18761, 33.41303], [-115.18762, 33.40954], [-115.1968, 33.40952], [-115.19681, 33.40939], [-115.19685, 33.40941], [-115.19698, 33.413]]], [[[-115.21504, 33.39466], [-115.20553, 33.39498], [-115.20542, 33.3912], [-115.21496, 33.39121], [-115.21504, 33.39466]]]]}	No Public Access 3	25902	Tabaseca	32324	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	Imperial 20	215.634	Tabaseca	State Resource Management Area 55	3
16574	16574	16573	{"type": "MultiPolygon", "coordinates": [[[[-114.95504, 33.26685], [-114.93776, 33.26689], [-114.93775, 33.26702], [-114.93746, 33.26702], [-114.93746, 33.26668], [-114.93718, 33.26668], [-114.93713, 33.2594], [-114.93712, 33.25216], [-114.95448, 33.25207], [-114.95504, 33.26685]]], [[[-114.98888, 33.26647], [-114.98008, 33.26656], [-114.97992, 33.25954], [-114.97989, 33.25216], [-114.98884, 33.25215], [-114.98888, 33.26647]]]]}	No Public Access 3	44921	Smoketree Valley - Chocolate Mountains	32312	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	Imperial 20	990.532	Smoketree Valley - Chocolate Mtns.	State Resource Management Area 55	3
16871	16871	16870	{"type": "MultiPolygon", "coordinates": [[[[-114.5213, 32.92055], [-114.5041, 32.92046], [-114.50398, 32.90755], [-114.50582, 32.9074], [-114.50578, 32.90587], [-114.52127, 32.90586], [-114.5213, 32.92055]]], [[[-114.56488, 32.84766], [-114.56484, 32.86185], [-114.54737, 32.86186], [-114.54742, 32.84765], [-114.56488, 32.84766]]], [[[-114.62574, 33.00801], [-114.60854, 33.00799], [-114.60846, 33.00111], [-114.60796, 32.99297], [-114.62554, 32.99319], [-114.62555, 32.9935], [-114.62574, 32.99351], [-114.62576, 33.0], [-114.62579, 33.0011], [-114.62574, 33.00801]]], [[[-114.61887, 32.72903], [-114.61886, 32.73241], [-114.61813, 32.73196], [-114.61742, 32.73173], [-114.61617, 32.73092], [-114.6154, 32.72974], [-114.61545, 32.72912], [-114.61579, 32.72869], [-114.61575, 32.72839], [-114.61602, 32.72826], [-114.61628, 32.72823], [-114.61666, 32.72822], [-114.61696, 32.72823], [-114.61756, 32.72831], [-114.61788, 32.72834], [-114.61887, 32.7286], [-114.61887, 32.72903]]], [[[-114.66817, 32.84834], [-114.66745, 32.86356], [-114.64962, 32.86342], [-114.65082, 32.84829], [-114.66817, 32.84834]]], [[[-114.66772, 32.95353], [-114.64979, 32.95351], [-114.64975, 32.9387], [-114.66766, 32.93874], [-114.66772, 32.95353]]], [[[-114.65934, 32.77462], [-114.65502, 32.77464], [-114.655, 32.771], [-114.65931, 32.77098], [-114.65934, 32.77462]]], [[[-114.72113, 32.89363], [-114.72094, 32.90858], [-114.7033, 32.90878], [-114.70327, 32.89406], [-114.72113, 32.89363]]], [[[-114.77158, 32.84998], [-114.77157, 32.86309], [-114.75436, 32.86307], [-114.7544, 32.84855], [-114.77006, 32.84852], [-114.768, 32.84915], [-114.76838, 32.85073], [-114.77128, 32.85002], [-114.77158, 32.84998]], [[-114.76325, 32.85763], [-114.76326, 32.85764], [-114.76457, 32.85816], [-114.76638, 32.8547], [-114.76507, 32.85415], [-114.76325, 32.85763]]], [[[-114.7734, 33.13311], [-114.75611, 33.13297], [-114.75612, 33.1184], [-114.77337, 33.11773], [-114.7734, 33.13311]]], [[[-114.77351, 33.22183], [-114.75627, 33.22177], [-114.75622, 33.20733], [-114.77346, 33.20732], [-114.77351, 33.22183]]], [[[-114.77409, 33.38936], [-114.77405, 33.40343], [-114.76516, 33.40414], [-114.76506, 33.39995], [-114.76082, 33.39987], [-114.76069, 33.3965], [-114.75652, 33.39642], [-114.75655, 33.38946], [-114.77409, 33.38936]]], [[[-114.7761, 32.93864], [-114.77586, 32.95352], [-114.75794, 32.95358], [-114.75799, 32.93854], [-114.7761, 32.93864]]], [[[-114.82902, 32.98377], [-114.829, 32.99846], [-114.8115, 32.99756], [-114.81185, 32.98336], [-114.82902, 32.98377]]], [[[-114.8293, 33.16378], [-114.82922, 33.1783], [-114.812, 33.17824], [-114.81203, 33.16378], [-114.8293, 33.16378]]], [[[-114.82918, 33.07478], [-114.82918, 33.08946], [-114.81205, 33.08935], [-114.81202, 33.07474], [-114.82918, 33.07478]]], [[[-114.83066, 33.34102], [-114.83066, 33.35554], [-114.81365, 33.35554], [-114.81365, 33.35524], [-114.81361, 33.35493], [-114.81343, 33.34102], [-114.83066, 33.34102]]], [[[-114.83032, 32.89606], [-114.83031, 32.91063], [-114.81368, 32.91062], [-114.8139, 32.89609], [-114.83032, 32.89606]]], [[[-114.8804, 32.9394], [-114.87981, 32.95481], [-114.86327, 32.95386], [-114.86362, 32.93935], [-114.8804, 32.9394]]], [[[-114.88125, 33.2219], [-114.86376, 33.22183], [-114.8638, 33.20726], [-114.88122, 33.20728], [-114.88125, 33.2219]]], [[[-114.88103, 33.13298], [-114.86376, 33.13215], [-114.8639, 33.11847], [-114.88101, 33.11859], [-114.88103, 33.13298]]], [[[-114.88196, 33.31124], [-114.86468, 33.31123], [-114.86448, 33.29663], [-114.88175, 33.2966], [-114.88196, 33.31124]]], [[[-114.88254, 33.38408], [-114.88243, 33.3985], [-114.86517, 33.39852], [-114.86514, 33.384], [-114.88254, 33.38408]]], [[[-114.93746, 33.26702], [-114.91968, 33.26718], [-114.91965, 33.25216], [-114.93712, 33.25217], [-114.93713, 33.2594], [-114.93718, 33.26667], [-114.93746, 33.26668], [-114.93746, 33.26702]]], [[[-114.93709, 33.16376], [-114.93696, 33.17823], [-114.91971, 33.17823], [-114.91975, 33.16371], [-114.93709, 33.16376]]], [[[-114.93714, 33.08936], [-114.91985, 33.08942], [-114.9198, 33.0748], [-114.93705, 33.07475], [-114.93714, 33.08936]]], [[[-114.99157, 33.31103], [-114.97373, 33.31113], [-114.97366, 33.29635], [-114.99151, 33.29628], [-114.99157, 33.31103]]], [[[-114.99209, 33.3987], [-114.97441, 33.39878], [-114.97428, 33.38428], [-114.99206, 33.38419], [-114.99209, 33.3987]]], [[[-115.01881, 33.06597], [-115.0188, 33.0748], [-115.00161, 33.07475], [-114.98884, 33.07472], [-114.98474, 33.07475], [-114.98459, 33.06586], [-115.01881, 33.06597]]], [[[-115.47581, 33.26357], [-115.45835, 33.26353], [-115.45836, 33.24907], [-115.4758, 33.24906], [-115.47581, 33.26357]]], [[[-115.52525, 33.22721], [-115.52112, 33.2272], [-115.52109, 33.22007], [-115.52524, 33.22008], [-115.52525, 33.22721]]], [[[-115.57736, 33.33966], [-115.5773, 33.35428], [-115.57225, 33.35435], [-115.57171, 33.35341], [-115.57012, 33.35227], [-115.56942, 33.3516], [-115.56879, 33.35127], [-115.56834, 33.35058], [-115.56732, 33.34927], [-115.56676, 33.34837], [-115.56644, 33.34778], [-115.56604, 33.34709], [-115.56584, 33.34663], [-115.56559, 33.34632], [-115.56535, 33.34609], [-115.56421, 33.34516], [-115.56357, 33.34456], [-115.56235, 33.34349], [-115.56139, 33.34259], [-115.56076, 33.34205], [-115.56004, 33.34181], [-115.56003, 33.34144], [-115.55992, 33.33951], [-115.56236, 33.33951], [-115.56237, 33.33964], [-115.57736, 33.33966]]], [[[-115.66474, 33.3651], [-115.66474, 33.36874], [-115.6466, 33.36869], [-115.64659, 33.36506], [-115.65522, 33.36508], [-115.65523, 33.36145], [-115.65955, 33.36145], [-115.65956, 33.3542], [-115.66474, 33.3542], [-115.66474, 33.36147], [-115.65956, 33.36146], [-115.65955, 33.36508], [-115.66474, 33.3651]]], [[[-115.68363, 33.17655], [-115.68363, 33.1766], [-115.68352, 33.1766], [-115.68351, 33.17655], [-115.66649, 33.17658], [-115.6665, 33.16209], [-115.68349, 33.16209], [-115.68352, 33.17654], [-115.68363, 33.17655]]], [[[-115.72667, 33.1186], [-115.72666, 33.12581], [-115.71821, 33.12581], [-115.7182, 33.11861], [-115.72667, 33.1186]]], [[[-115.73545, 33.11858], [-115.73528, 33.11858], [-115.73528, 33.11849], [-115.73545, 33.11849], [-115.73545, 33.11858]]], [[[-115.78714, 33.41238], [-115.76938, 33.4124], [-115.76939, 33.39806], [-115.78685, 33.39805], [-115.78714, 33.41238]]], [[[-115.7875, 33.16218], [-115.78748, 33.16924], [-115.78742, 33.17649], [-115.77029, 33.17658], [-115.77031, 33.16213], [-115.7875, 33.16218]]], [[[-115.83908, 33.29477], [-115.839, 33.30915], [-115.82163, 33.30907], [-115.82174, 33.29467], [-115.83908, 33.29477]]], [[[-115.83938, 33.22019], [-115.83921, 33.22019], [-115.8392, 33.22016], [-115.83506, 33.22015], [-115.83505, 33.21342], [-115.83074, 33.21347], [-115.83073, 33.20974], [-115.82643, 33.20981], [-115.82642, 33.20609], [-115.83934, 33.20583], [-115.83938, 33.22019]]], [[[-115.88958, 33.26228], [-115.88931, 33.26244], [-115.88791, 33.26249], [-115.88737, 33.2634], [-115.88737, 33.26357], [-115.88745, 33.26364], [-115.88846, 33.26375], [-115.88901, 33.26396], [-115.88911, 33.26416], [-115.88734, 33.26416], [-115.88699, 33.26432], [-115.88644, 33.26528], [-115.88647, 33.26545], [-115.87432, 33.26542], [-115.87416, 33.25324], [-115.87449, 33.25314], [-115.875, 33.25282], [-115.87585, 33.25296], [-115.87625, 33.25305], [-115.87663, 33.25385], [-115.87712, 33.25396], [-115.87753, 33.25435], [-115.87854, 33.25499], [-115.88105, 33.25589], [-115.88148, 33.25626], [-115.88184, 33.25628], [-115.88306, 33.2571], [-115.88331, 33.2574], [-115.88413, 33.25786], [-115.88609, 33.25864], [-115.88623, 33.25878], [-115.88666, 33.2599], [-115.88672, 33.26077], [-115.88691, 33.26093], [-115.88751, 33.26105], [-115.88751, 33.26123], [-115.88767, 33.26139], [-115.88917, 33.26192], [-115.88947, 33.2621], [-115.88958, 33.26228]]], [[[-115.94414, 33.25096], [-115.92667, 33.25092], [-115.92666, 33.25088], [-115.92663, 33.25087], [-115.92663, 33.24702], [-115.9265, 33.2359], [-115.90913, 33.23594], [-115.90913, 33.23456], [-115.90907, 33.23455], [-115.90875, 33.22013], [-115.91981, 33.22022], [-115.92011, 33.2209], [-115.92193, 33.22468], [-115.923, 33.22625], [-115.92658, 33.22992], [-115.92661, 33.2347], [-115.93128, 33.23473], [-115.93241, 33.23588], [-115.94403, 33.23583], [-115.94414, 33.25096]]], [[[-116.03214, 33.29505], [-116.01463, 33.29503], [-116.01474, 33.30969], [-115.99716, 33.30971], [-115.99708, 33.29504], [-116.01461, 33.29503], [-116.01462, 33.29502], [-116.01444, 33.28037], [-115.99704, 33.28037], [-115.99671, 33.27266], [-115.99668, 33.2657], [-116.01305, 33.2657], [-116.01306, 33.26572], [-116.01425, 33.26573], [-116.01444, 33.28036], [-116.03119, 33.28035], [-116.0312, 33.28057], [-116.03202, 33.28057], [-116.03214, 33.29505]]], [[[-116.00793, 33.33871], [-116.00774, 33.33878], [-116.00766, 33.33883], [-116.00761, 33.33893], [-116.00762, 33.33902], [-115.99835, 33.33904], [-115.99826, 33.33141], [-115.99819, 33.32831], [-115.99875, 33.32823], [-115.9992, 33.3281], [-115.99936, 33.3281], [-116.00078, 33.32924], [-116.00769, 33.33836], [-116.00793, 33.33871]]], [[[-116.01532, 32.90388], [-116.01533, 32.90526], [-116.0153, 32.9182], [-116.01099, 32.9182], [-116.011, 32.91439], [-116.00642, 32.91436], [-116.00641, 32.91437], [-116.00642, 32.91821], [-116.00235, 32.91821], [-116.00234, 32.91818], [-116.00084, 32.91818], [-116.00084, 32.91465], [-115.9982, 32.91428], [-115.99824, 32.90381], [-116.00553, 32.90381], [-116.01532, 32.90388]], [[-116.01115, 32.90777], [-116.01114, 32.90743], [-116.00682, 32.90743], [-116.0068, 32.91106], [-116.01112, 32.91106], [-116.01115, 32.90777]]], [[[-116.0445, 32.75809], [-116.03595, 32.75813], [-116.03596, 32.75446], [-116.03594, 32.74721], [-116.02843, 32.74718], [-116.02846, 32.74353], [-116.03577, 32.74355], [-116.03592, 32.74016], [-116.03697, 32.74016], [-116.03698, 32.7471], [-116.0444, 32.74721], [-116.0445, 32.75809]]], [[[-116.0679, 32.96159], [-116.05046, 32.96162], [-116.05046, 32.94736], [-116.06789, 32.94726], [-116.0679, 32.96159]]]]}	Open Access 1	12982	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	Imperial 20	27276.887	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]);