calands: units_with_maps: 6 rows where COUNTY = 9 and DES

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

6 rows where COUNTY = 9 and DES_TP = 16

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	DES_TP	GAP_STS
1132	1132	1131	{"type": "MultiPolygon", "coordinates": [[[[-119.60987, 37.02875], [-119.60983, 37.03609], [-119.60539, 37.036], [-119.60535, 37.04334], [-119.60094, 37.04317], [-119.60084, 37.03959], [-119.59636, 37.03951], [-119.58765, 37.03928], [-119.58772, 37.03206], [-119.58351, 37.03196], [-119.58349, 37.02828], [-119.60987, 37.02875]]], [[[-119.62016, 36.98167], [-119.62, 36.99254], [-119.61087, 36.99257], [-119.6108, 36.99615], [-119.60629, 36.99622], [-119.60626, 36.99977], [-119.60708, 37.01077], [-119.6112, 37.01077], [-119.61269, 37.0108], [-119.61253, 37.018], [-119.61704, 37.01804], [-119.61691, 37.02165], [-119.61244, 37.0217], [-119.61235, 37.02519], [-119.58355, 37.02477], [-119.58357, 37.01186], [-119.58414, 37.01169], [-119.58501, 37.01105], [-119.58616, 37.01006], [-119.58661, 37.00935], [-119.58687, 37.00859], [-119.58662, 37.00759], [-119.58576, 37.00655], [-119.58532, 37.00552], [-119.58473, 37.00419], [-119.58457, 37.00356], [-119.58521, 37.00227], [-119.58589, 37.00131], [-119.59153, 36.99748], [-119.59335, 36.99641], [-119.59451, 36.99569], [-119.59582, 36.99434], [-119.59686, 36.99207], [-119.5976, 36.98957], [-119.59804, 36.98885], [-119.59803, 36.98884], [-119.59273, 36.98882], [-119.59281, 36.98514], [-119.60182, 36.9852], [-119.60183, 36.98873], [-119.61064, 36.98882], [-119.61075, 36.98167], [-119.61096, 36.97803], [-119.61546, 36.97798], [-119.61544, 36.98162], [-119.62016, 36.98167]]], [[[-119.63971, 37.01813], [-119.62608, 37.01809], [-119.62622, 37.02171], [-119.62287, 37.02174], [-119.62251, 37.01075], [-119.6396, 37.01079], [-119.63971, 37.01813]]]]}	Open Access 1	6621	Ruth McKenzie Table Mountain Preserve	29279	3077	Sierra Foothill Conservancy 323	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://awww.sierrafoothill.org/index.php/land/preserves/mckenzie-preser/	Fresno 9	3330.9	Ruth McKenzie Table Mtn. Preserve	Private Conservation 16	2
7785	7785	7784	{"type": "MultiPolygon", "coordinates": [[[[-119.35775, 36.7922], [-119.35745, 36.80727], [-119.35308, 36.80684], [-119.34872, 36.80638], [-119.34431, 36.80596], [-119.3443, 36.8024], [-119.34425, 36.79888], [-119.33994, 36.79844], [-119.33987, 36.79126], [-119.34882, 36.79175], [-119.35775, 36.7922]]], [[[-119.38439, 36.80548], [-119.38364, 36.8062], [-119.38228, 36.80712], [-119.37982, 36.80713], [-119.37991, 36.81081], [-119.37752, 36.81081], [-119.37751, 36.81082], [-119.37752, 36.81201], [-119.38127, 36.81266], [-119.37942, 36.81404], [-119.3791, 36.81443], [-119.37911, 36.81444], [-119.38353, 36.81447], [-119.38367, 36.8181], [-119.37755, 36.81815], [-119.37668, 36.81728], [-119.37564, 36.81744], [-119.37559, 36.81523], [-119.37558, 36.81524], [-119.37558, 36.81544], [-119.37541, 36.81538], [-119.37524, 36.8153], [-119.37508, 36.81516], [-119.37497, 36.81503], [-119.37469, 36.81485], [-119.37448, 36.81479], [-119.37426, 36.81476], [-119.37394, 36.81477], [-119.37358, 36.81475], [-119.37328, 36.81468], [-119.37307, 36.8146], [-119.37281, 36.81452], [-119.37253, 36.81449], [-119.37241, 36.8145], [-119.37226, 36.81454], [-119.37205, 36.81466], [-119.37188, 36.81486], [-119.37176, 36.8152], [-119.37159, 36.81538], [-119.37121, 36.8154], [-119.37084, 36.81547], [-119.37066, 36.81553], [-119.37041, 36.81565], [-119.37027, 36.8157], [-119.37007, 36.8157], [-119.36974, 36.81561], [-119.36939, 36.8156], [-119.36925, 36.81562], [-119.36914, 36.81562], [-119.36902, 36.81559], [-119.36888, 36.81553], [-119.36852, 36.81548], [-119.36817, 36.81547], [-119.36785, 36.8155], [-119.36757, 36.81556], [-119.36734, 36.81562], [-119.36667, 36.81592], [-119.36602, 36.81615], [-119.36562, 36.81638], [-119.36514, 36.81655], [-119.36469, 36.81659], [-119.36323, 36.81661], [-119.36286, 36.8167], [-119.36247, 36.81676], [-119.362, 36.8168], [-119.36154, 36.8168], [-119.35761, 36.81746], [-119.35753, 36.81439], [-119.37107, 36.81441], [-119.3711, 36.81082], [-119.37544, 36.8108], [-119.37533, 36.80713], [-119.37615, 36.80712], [-119.37617, 36.80512], [-119.37668, 36.80432], [-119.3763, 36.80397], [-119.3762, 36.80344], [-119.37672, 36.80284], [-119.37728, 36.80262], [-119.37744, 36.80226], [-119.37729, 36.80189], [-119.37745, 36.80124], [-119.38434, 36.80354], [-119.38442, 36.80466], [-119.38439, 36.80548]]]]}	Open Access 1	8692	Tivy Mountain Preserve	12510	3077	Sierra Foothill Conservancy 323	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://awww.sierrafoothill.org/index.php/land/preserves/tivy-mountain-pres/	Fresno 9	900.128	Tivy Mtn. Preserve	Private Conservation 16	2
12276	12276	12275	{"type": "Polygon", "coordinates": [[[-119.90876, 36.84585], [-119.90533, 36.84896], [-119.90287, 36.84725], [-119.9036, 36.84715], [-119.90433, 36.84704], [-119.90505, 36.8469], [-119.90576, 36.84675], [-119.90647, 36.84658], [-119.90717, 36.84638], [-119.90786, 36.84617], [-119.90876, 36.84585]]]}	Unknown Access 4	25926	Riverside Restoration Area	24459	3069	San Joaquin River Parkway and Conservation Trust 649	Non Profit 6	Non Profit - Land Trust 10	http://www.riverparkway.org	Non Governmental Organization 10	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10		Fresno 9	14.792	Riverside Restoration Area	Private Conservation 16	2
14533	14533	14532	{"type": "Polygon", "coordinates": [[[-119.2126, 36.96446], [-119.21258, 36.9658], [-119.21037, 36.96576], [-119.21039, 36.97035], [-119.20819, 36.97041], [-119.20817, 36.97301], [-119.20782, 36.97306], [-119.2055, 36.96985], [-119.20388, 36.96986], [-119.20388, 36.96959], [-119.20593, 36.9695], [-119.20621, 36.9678], [-119.20389, 36.96782], [-119.20381, 36.96503], [-119.20598, 36.96497], [-119.20594, 36.96231], [-119.21142, 36.96221], [-119.21149, 36.96441], [-119.2126, 36.96446]]]}	Unknown Access 4	44691	The Haslett Basin Wildlife Preserve	26284	3077	Sierra Foothill Conservancy 323	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10		Fresno 9	125.188	The Haslett Basin Wildlife Preserve	Private Conservation 16	2
16411	16411	16410	{"type": "Polygon", "coordinates": [[[-119.75792, 36.91239], [-119.75661, 36.91246], [-119.75643, 36.91024], [-119.75775, 36.91023], [-119.75792, 36.91239]]]}	Open Access 1	25932	River Center	24407	3069	San Joaquin River Parkway and Conservation Trust 649	Non Profit 6	Non Profit - Land Trust 10	http://www.riverparkway.org	Non Governmental Organization 10	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10		Fresno 9	7.035	River Ctr.	Private Conservation 16	2
16903	16903	16902	{"type": "Polygon", "coordinates": [[[-119.4705, 37.00923], [-119.48101, 37.00954], [-119.47739, 37.01125], [-119.47204, 37.01411], [-119.47068, 37.01486], [-119.4707, 37.01538], [-119.47069, 37.01639], [-119.47003, 37.01635], [-119.46892, 37.01634], [-119.46835, 37.0174], [-119.46819, 37.01854], [-119.4683, 37.01929], [-119.46862, 37.02004], [-119.4699, 37.02217], [-119.47038, 37.02338], [-119.47044, 37.02372], [-119.46563, 37.0237], [-119.46181, 37.02347], [-119.46199, 37.02735], [-119.46646, 37.02738], [-119.46647, 37.02727], [-119.46727, 37.02728], [-119.46728, 37.02724], [-119.46817, 37.02723], [-119.46838, 37.02694], [-119.46854, 37.02693], [-119.46852, 37.02545], [-119.46871, 37.02564], [-119.46871, 37.02728], [-119.46864, 37.02729], [-119.46876, 37.03083], [-119.47022, 37.03086], [-119.47022, 37.03104], [-119.46884, 37.03101], [-119.46206, 37.03098], [-119.46199, 37.02735], [-119.45751, 37.02724], [-119.45743, 37.02365], [-119.453, 37.02364], [-119.45298, 37.01999], [-119.45282, 37.0164], [-119.44827, 37.01635], [-119.44815, 37.01283], [-119.44373, 37.0128], [-119.43919, 37.01275], [-119.43493, 37.0126], [-119.435, 37.00904], [-119.42135, 37.00884], [-119.42131, 36.99474], [-119.43021, 36.99511], [-119.43034, 37.00213], [-119.43485, 37.00214], [-119.43493, 37.00554], [-119.43947, 37.00563], [-119.45272, 37.00573], [-119.45268, 37.00919], [-119.45269, 37.0092], [-119.46145, 37.00922], [-119.46598, 37.00928], [-119.4705, 37.00923]], [[-119.43034, 37.00215], [-119.42581, 37.00206], [-119.42587, 37.00554], [-119.43037, 37.00554], [-119.43034, 37.00215]]]}	Open Access 1	7684	Mary Elizabeth Miller Preserve at Black Mountain	29280	3077	Sierra Foothill Conservancy 323	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://awww.sierrafoothill.org/index.php/land/preserves/mary-elizabeth-miller-preserve/	Fresno 9	1460.655	Mary Elizabeth Miller Preserve at Black Mtn.	Private Conservation 16	2

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