calands: units_with_maps: 2 rows where LABEL_NAME = "Salton Sea - Bureau of Rec", MNG_AGENCY = 364 and MNG_AG

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

2 rows where LABEL_NAME = "Salton Sea - Bureau of Rec", MNG_AGENCY = 364 and MNG_AG_TYP = 1

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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
8369	8369	8368	{"type": "MultiPolygon", "coordinates": [[[[-116.0092, 33.42654], [-116.00913, 33.44087], [-115.9918, 33.44094], [-115.9916, 33.45547], [-115.97409, 33.4555], [-115.97389, 33.47011], [-115.99134, 33.4701], [-115.99114, 33.48451], [-115.97371, 33.48456], [-115.97378, 33.49917], [-115.99115, 33.49919], [-115.99146, 33.51068], [-115.97404, 33.51079], [-115.97378, 33.49918], [-115.95644, 33.49917], [-115.9563, 33.5002], [-115.95651, 33.50987], [-115.95652, 33.51085], [-115.93931, 33.51084], [-115.93905, 33.49918], [-115.92182, 33.49937], [-115.92185, 33.48464], [-115.93918, 33.4846], [-115.93924, 33.47014], [-115.92192, 33.47016], [-115.92195, 33.45559], [-115.90464, 33.45563], [-115.90466, 33.44096], [-115.88727, 33.44099], [-115.88723, 33.42704], [-115.9044, 33.42691], [-115.90469, 33.4272], [-115.90467, 33.44096], [-115.92196, 33.44092], [-115.92198, 33.44091], [-115.9221, 33.42682], [-115.92217, 33.42678], [-115.93945, 33.42674], [-115.93938, 33.44093], [-115.95682, 33.44096], [-115.95683, 33.44095], [-115.95693, 33.42693], [-115.95702, 33.42689], [-115.97434, 33.42665], [-115.97441, 33.42673], [-115.97423, 33.44094], [-115.99179, 33.44093], [-115.99202, 33.42654], [-116.0, 33.42649], [-116.00001, 33.42663], [-116.0092, 33.42654]], [[-115.92931, 33.44093], [-115.92197, 33.44093], [-115.92196, 33.45558], [-115.9393, 33.45555], [-115.93937, 33.44094], [-115.92931, 33.44093]], [[-115.95644, 33.48457], [-115.95219, 33.48457], [-115.9523, 33.48127], [-115.95229, 33.48126], [-115.94785, 33.48133], [-115.94782, 33.48458], [-115.93919, 33.4846], [-115.93906, 33.49918], [-115.95643, 33.49916], [-115.95644, 33.48457]], [[-115.95657, 33.47012], [-115.95672, 33.45555], [-115.9393, 33.45555], [-115.93925, 33.47013], [-115.95657, 33.47012]], [[-115.9737, 33.48456], [-115.97388, 33.47012], [-115.95658, 33.47012], [-115.95644, 33.48456], [-115.9737, 33.48456]], [[-115.97423, 33.44095], [-115.97422, 33.44094], [-115.95682, 33.44096], [-115.95672, 33.45554], [-115.9741, 33.45548], [-115.97423, 33.44095]]], [[[-115.89915, 33.48471], [-115.89576, 33.48471], [-115.89558, 33.48097], [-115.89558, 33.48097], [-115.89915, 33.48471]]], [[[-116.07001, 33.51275], [-116.06976, 33.51285], [-116.06933, 33.51281], [-116.06921, 33.51272], [-116.06837, 33.51274], [-116.06779, 33.51297], [-116.06738, 33.51334], [-116.06708, 33.514], [-116.06692, 33.51581], [-116.06645, 33.51597], [-116.06585, 33.51606], [-116.06519, 33.51574], [-116.0638, 33.51462], [-116.06339, 33.5146], [-116.06219, 33.51483], [-116.06118, 33.51482], [-116.06114, 33.51058], [-116.06996, 33.51054], [-116.07001, 33.51275]]]]}	Open Access 1	12968	Salton Sea - Bureau of Rec	13839	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1		Riverside 10	9406.511	Salton Sea - Bureau of Rec		None 700
8382	8382	8381	{"type": "MultiPolygon", "coordinates": [[[[-115.9801, 33.42661], [-115.97443, 33.42663], [-115.97442, 33.42664], [-115.97441, 33.42673], [-115.97434, 33.42665], [-115.95702, 33.42689], [-115.95693, 33.42693], [-115.95692, 33.42668], [-115.93946, 33.42674], [-115.92217, 33.42678], [-115.9221, 33.42682], [-115.92209, 33.4268], [-115.92157, 33.4268], [-115.9047, 33.42682], [-115.90469, 33.4272], [-115.9044, 33.42691], [-115.88723, 33.42704], [-115.88723, 33.42687], [-115.8872, 33.42684], [-115.87437, 33.42686], [-115.86954, 33.42685], [-115.86953, 33.4268], [-115.85711, 33.42683], [-115.8523, 33.42677], [-115.83855, 33.42687], [-115.83863, 33.41583], [-115.83444, 33.4159], [-115.83431, 33.4122], [-115.82237, 33.41239], [-115.82216, 33.40829], [-115.805, 33.40829], [-115.8046, 33.40309], [-115.80427, 33.39806], [-115.80417, 33.39805], [-115.79478, 33.39803], [-115.79427, 33.39009], [-115.78673, 33.39007], [-115.78666, 33.38349], [-115.77783, 33.38352], [-115.77784, 33.37563], [-115.7695, 33.37556], [-115.76961, 33.36901], [-115.77388, 33.36893], [-115.77389, 33.36892], [-115.77377, 33.36468], [-115.76965, 33.36466], [-115.76973, 33.35429], [-115.73443, 33.3544], [-115.73443, 33.34813], [-115.73448, 33.34815], [-115.73457, 33.33953], [-115.75236, 33.33955], [-115.75246, 33.32209], [-115.75082, 33.32207], [-115.73575, 33.32203], [-115.73573, 33.32261], [-115.73445, 33.33953], [-115.71712, 33.33982], [-115.71842, 33.32266], [-115.71842, 33.32201], [-115.70109, 33.32203], [-115.69967, 33.3396], [-115.71685, 33.33967], [-115.71677, 33.35435], [-115.69959, 33.3546], [-115.69947, 33.33984], [-115.68235, 33.33986], [-115.68391, 33.32199], [-115.66668, 33.322], [-115.66671, 33.30727], [-115.68387, 33.30725], [-115.68388, 33.30724], [-115.68377, 33.29269], [-115.66664, 33.29271], [-115.66663, 33.27821], [-115.68376, 33.2782], [-115.68377, 33.27819], [-115.68372, 33.26365], [-115.66654, 33.26369], [-115.66655, 33.25004], [-115.66651, 33.24915], [-115.68367, 33.24914], [-115.68375, 33.25004], [-115.68373, 33.26364], [-115.701, 33.2637], [-115.70108, 33.25005], [-115.70102, 33.24916], [-115.70103, 33.24913], [-115.71817, 33.24918], [-115.71823, 33.25005], [-115.71823, 33.26373], [-115.73556, 33.26381], [-115.73558, 33.2638], [-115.73558, 33.25003], [-115.73557, 33.24921], [-115.73559, 33.2492], [-115.7356, 33.24917], [-115.75081, 33.24922], [-115.75249, 33.24929], [-115.75256, 33.25004], [-115.75251, 33.26379], [-115.76992, 33.26536], [-115.76993, 33.26535], [-115.77001, 33.25062], [-115.78727, 33.25067], [-115.78726, 33.26543], [-115.80454, 33.26546], [-115.80455, 33.26545], [-115.80456, 33.25073], [-115.8218, 33.25074], [-115.8218, 33.26548], [-115.83918, 33.2655], [-115.83919, 33.26549], [-115.83917, 33.25073], [-115.85637, 33.25077], [-115.85634, 33.26547], [-115.8392, 33.2655], [-115.83925, 33.28014], [-115.85631, 33.28015], [-115.85623, 33.29485], [-115.8744, 33.29468], [-115.87406, 33.30937], [-115.89231, 33.30941], [-115.89218, 33.29486], [-115.90977, 33.29499], [-115.90982, 33.3022], [-115.9098, 33.30221], [-115.90987, 33.30952], [-115.92741, 33.30958], [-115.92745, 33.32395], [-115.93775, 33.32398], [-115.93888, 33.32469], [-115.93952, 33.32598], [-115.93964, 33.32635], [-115.93994, 33.32682], [-115.94011, 33.32694], [-115.94065, 33.32664], [-115.94254, 33.32529], [-115.94291, 33.32552], [-115.94202, 33.32621], [-115.94144, 33.32669], [-115.94089, 33.32685], [-115.94032, 33.32744], [-115.94032, 33.32802], [-115.94016, 33.32835], [-115.94054, 33.32829], [-115.94087, 33.32813], [-115.94098, 33.32754], [-115.94133, 33.32717], [-115.94234, 33.3265], [-115.94292, 33.32634], [-115.94384, 33.32635], [-115.94417, 33.32651], [-115.94412, 33.32699], [-115.94387, 33.32778], [-115.94291, 33.32804], [-115.94273, 33.32822], [-115.94256, 33.32879], [-115.94227, 33.329], [-115.94183, 33.32895], [-115.94125, 33.32866], [-115.94087, 33.32866], [-115.94062, 33.32877], [-115.94005, 33.32886], [-115.94003, 33.32931], [-115.94215, 33.32951], [-115.94368, 33.33008], [-115.94451, 33.33059], [-115.94493, 33.33105], [-115.94494, 33.33904], [-115.95674, 33.33897], [-115.9588, 33.33993], [-115.95951, 33.34061], [-115.96082, 33.34249], [-115.96208, 33.34588], [-115.96235, 33.34717], [-115.96252, 33.34744], [-115.96261, 33.34751], [-115.96262, 33.35358], [-115.96832, 33.35358], [-115.96893, 33.35413], [-115.96964, 33.3544], [-115.97019, 33.35447], [-115.97076, 33.35442], [-115.97142, 33.35397], [-115.97161, 33.35399], [-115.97166, 33.35459], [-115.97248, 33.35577], [-115.97295, 33.35619], [-115.97325, 33.3563], [-115.97472, 33.35644], [-115.97521, 33.35669], [-115.97622, 33.35777], [-115.97649, 33.35775], [-115.97704, 33.35733], [-115.97764, 33.35729], [-115.9781, 33.35738], [-115.97865, 33.35779], [-115.97952, 33.358], [-115.97987, 33.3582], [-115.97988, 33.36828], [-115.96262, 33.36831], [-115.96261, 33.35359], [-115.94492, 33.35362], [-115.94493, 33.36832], [-115.9626, 33.36832], [-115.96255, 33.38288], [-115.97992, 33.38278], [-115.97998, 33.39751], [-115.96255, 33.39761], [-115.96255, 33.41241], [-115.96256, 33.41242], [-115.98005, 33.41199], [-115.9801, 33.42661]], [[-115.68378, 33.29267], [-115.70106, 33.29273], [-115.70107, 33.27824], [-115.68377, 33.2782], [-115.68378, 33.29267]], [[-115.70108, 33.32203], [-115.70116, 33.30733], [-115.68388, 33.30725], [-115.68392, 33.32199], [-115.70108, 33.32203]], [[-115.71823, 33.26374], [-115.70101, 33.26371], [-115.70108, 33.27823], [-115.71832, 33.27827], [-115.71823, 33.26374]], [[-115.73573, 33.32203], [-115.73574, 33.32202], [-115.73572, 33.30752], [-115.7525, 33.30765], [-115.75252, 33.29293], [-115.75082, 33.29293], [-115.73564, 33.29284], [-115.73563, 33.27832], [-115.71833, 33.27827], [-115.71836, 33.29279], [-115.70106, 33.29274], [-115.70116, 33.30733], [-115.71845, 33.30744], [-115.71843, 33.322], [-115.73573, 33.32203]], [[-115.73563, 33.27831], [-115.75083, 33.27839], [-115.75248, 33.27837], [-115.75251, 33.2638], [-115.73558, 33.26381], [-115.73563, 33.27831]], [[-115.76993, 33.32338], [-115.76994, 33.32337], [-115.76998, 33.30876], [-115.75251, 33.30766], [-115.75247, 33.32209], [-115.76993, 33.32338]], [[-115.7525, 33.27838], [-115.75249, 33.27838], [-115.75252, 33.29292], [-115.76998, 33.29428], [-115.76996, 33.27998], [-115.7525, 33.27838]], [[-115.80397, 33.35408], [-115.80408, 33.33952], [-115.7871, 33.33961], [-115.78723, 33.32344], [-115.76995, 33.32338], [-115.76982, 33.3397], [-115.76973, 33.35342], [-115.76974, 33.35428], [-115.78659, 33.35416], [-115.80397, 33.35408]], [[-115.76997, 33.27997], [-115.78724, 33.28006], [-115.78726, 33.26544], [-115.76993, 33.26536], [-115.76997, 33.27997]], [[-115.78725, 33.30887], [-115.78726, 33.30886], [-115.78725, 33.29442], [-115.76999, 33.29428], [-115.76998, 33.30875], [-115.78725, 33.30887]], [[-115.78676, 33.37472], [-115.78678, 33.37471], [-115.78684, 33.3687], [-115.77808, 33.36886], [-115.77808, 33.36888], [-115.77903, 33.36936], [-115.77997, 33.37002], [-115.78015, 33.37084], [-115.78068, 33.3708], [-115.7812, 33.37082], [-115.78199, 33.37129], [-115.78256, 33.37194], [-115.7841, 33.37243], [-115.78523, 33.37354], [-115.78542, 33.37436], [-115.78631, 33.37446], [-115.78676, 33.37472]], [[-115.79099, 33.38348], [-115.791, 33.38347], [-115.79088, 33.37926], [-115.78672, 33.37925], [-115.78667, 33.38348], [-115.79099, 33.38348]], [[-115.80421, 33.3235], [-115.8043, 33.309], [-115.78726, 33.30887], [-115.78723, 33.32343], [-115.80421, 33.3235]], [[-115.78725, 33.28006], [-115.78724, 33.28007], [-115.78725, 33.29442], [-115.8044, 33.29454], [-115.80452, 33.2801], [-115.78725, 33.28006]], [[-115.80392, 33.38348], [-115.79734, 33.38347], [-115.79733, 33.38348], [-115.79921, 33.38516], [-115.79984, 33.38568], [-115.80013, 33.38599], [-115.80133, 33.38701], [-115.80156, 33.38715], [-115.80282, 33.3883], [-115.80405, 33.38956], [-115.80406, 33.38955], [-115.80392, 33.38348]], [[-115.82122, 33.36848], [-115.8213, 33.35429], [-115.80398, 33.35407], [-115.80395, 33.36857], [-115.82122, 33.36848]], [[-115.82155, 33.32358], [-115.82154, 33.32357], [-115.80422, 33.3235], [-115.8041, 33.33951], [-115.82146, 33.33939], [-115.82155, 33.32358]], [[-115.83908, 33.29477], [-115.83924, 33.28014], [-115.82177, 33.28013], [-115.82174, 33.29467], [-115.8044, 33.29454], [-115.80431, 33.30899], [-115.82162, 33.30907], [-115.82155, 33.32357], [-115.83896, 33.32365], [-115.839, 33.30915], [-115.85614, 33.30924], [-115.85622, 33.29486], [-115.85621, 33.29485], [-115.83908, 33.29477]], [[-115.80452, 33.28009], [-115.80453, 33.2801], [-115.82176, 33.28012], [-115.82179, 33.26548], [-115.80455, 33.26547], [-115.80452, 33.28009]], [[-115.81409, 33.40009], [-115.81411, 33.40008], [-115.8141, 33.40006], [-115.81409, 33.40007], [-115.81409, 33.40009]], [[-115.85645, 33.39822], [-115.85646, 33.39821], [-115.85586, 33.38346], [-115.83857, 33.38348], [-115.83855, 33.36875], [-115.82124, 33.36848], [-115.82121, 33.37503], [-115.82123, 33.38362], [-115.82163, 33.39779], [-115.82237, 33.39779], [-115.82238, 33.39801], [-115.83906, 33.39793], [-115.85645, 33.39822]], [[-115.83898, 33.32365], [-115.83881, 33.3393], [-115.84797, 33.33927], [-115.85604, 33.33922], [-115.8561, 33.3237], [-115.83898, 33.32365]], [[-115.87405, 33.30938], [-115.87404, 33.30937], [-115.85614, 33.30925], [-115.85611, 33.32369], [-115.87393, 33.32376], [-115.87405, 33.30938]], [[-115.86509, 33.40499], [-115.86468, 33.39821], [-115.85646, 33.39822], [-115.85703, 33.41234], [-115.87441, 33.41234], [-115.87442, 33.40541], [-115.86509, 33.40499]], [[-115.87395, 33.32377], [-115.87371, 33.33912], [-115.89243, 33.33909], [-115.89239, 33.32388], [-115.87395, 33.32377]], [[-115.89245, 33.35369], [-115.89243, 33.35368], [-115.87414, 33.35374], [-115.87451, 33.36866], [-115.89245, 33.36836], [-115.89245, 33.35369]], [[-115.89239, 33.32387], [-115.90996, 33.32391], [-115.90986, 33.30953], [-115.89232, 33.30942], [-115.89239, 33.32387]], [[-115.90997, 33.35365], [-115.90996, 33.33911], [-115.89243, 33.3391], [-115.89245, 33.35368], [-115.90997, 33.35365]], [[-115.89246, 33.36837], [-115.89245, 33.36838], [-115.89257, 33.38356], [-115.90995, 33.38314], [-115.90998, 33.36836], [-115.89246, 33.36837]], [[-115.90996, 33.38314], [-115.90995, 33.38315], [-115.90998, 33.39104], [-115.92745, 33.39088], [-115.92746, 33.38307], [-115.90996, 33.38314]], [[-115.90997, 33.32391], [-115.90996, 33.32392], [-115.90997, 33.33911], [-115.92745, 33.33906], [-115.92745, 33.32396], [-115.90997, 33.32391]], [[-115.92746, 33.35362], [-115.92745, 33.35361], [-115.90998, 33.35365], [-115.90999, 33.36836], [-115.92745, 33.36835], [-115.92746, 33.36833], [-115.92746, 33.35362]], [[-115.94491, 33.35361], [-115.94491, 33.33905], [-115.92745, 33.33907], [-115.92745, 33.35361], [-115.94491, 33.35361]], [[-115.94493, 33.36833], [-115.92745, 33.36835], [-115.92747, 33.38307], [-115.94509, 33.38298], [-115.94495, 33.37032], [-115.94495, 33.36834], [-115.94493, 33.36833]], [[-115.96255, 33.38289], [-115.96254, 33.38288], [-115.9451, 33.38299], [-115.9451, 33.39771], [-115.96254, 33.39762], [-115.96255, 33.38289]]], [[[-116.0247, 33.4117], [-116.01556, 33.41177], [-116.01558, 33.40443], [-116.02458, 33.40421], [-116.0247, 33.4117]]]]}	Open Access 1	12967	Salton Sea - Bureau of Rec	13839	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1		Imperial 20	57001.771	Salton Sea - Bureau of Rec		None 702

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]);