calands: superunits_with_maps: 4 rows where ACCESS_TYP = 1 and AGNCY

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

4 rows where ACCESS_TYP = 1 and AGNCY_WEB = "http://www.sierrafoothill.org/"

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME
1104	1104	1103	{"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.79889], [-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.37983, 36.80713], [-119.37991, 36.81081], [-119.37752, 36.81081], [-119.37751, 36.81082], [-119.37753, 36.81201], [-119.38127, 36.81266], [-119.37942, 36.81404], [-119.37911, 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.8154], [-119.37558, 36.8154], [-119.37558, 36.81544], [-119.37541, 36.81538], [-119.37524, 36.8153], [-119.37508, 36.81516], [-119.37497, 36.81503], [-119.37469, 36.81486], [-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.36513, 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.8144], [-119.3711, 36.81082], [-119.37544, 36.8108], [-119.37533, 36.80713], [-119.37615, 36.80711], [-119.37617, 36.80512], [-119.37668, 36.80432], [-119.3763, 36.80397], [-119.3762, 36.80344], [-119.37672, 36.80284], [-119.37729, 36.80262], [-119.37743, 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	Tivy Mountain Preserve	http://awww.sierrafoothill.org/index.php/land/preserves/tivy-mountain-pres/	12510	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	900.327	Tivy Mtn. Preserve
12235	12235	12234	{"type": "Polygon", "coordinates": [[[-119.66327, 37.0625], [-119.66314, 37.06353], [-119.66138, 37.0647], [-119.65862, 37.06475], [-119.65876, 37.07194], [-119.64976, 37.0721], [-119.64984, 37.07601], [-119.64542, 37.07604], [-119.64531, 37.07218], [-119.64087, 37.07225], [-119.64076, 37.0686], [-119.64049, 37.053], [-119.64067, 37.05309], [-119.64084, 37.05329], [-119.64091, 37.05368], [-119.64137, 37.05397], [-119.64155, 37.05409], [-119.64166, 37.05429], [-119.64169, 37.05443], [-119.64189, 37.05453], [-119.64209, 37.05451], [-119.64242, 37.05471], [-119.64319, 37.05515], [-119.64338, 37.05528], [-119.64368, 37.05533], [-119.64414, 37.05549], [-119.64445, 37.05564], [-119.64456, 37.05592], [-119.64467, 37.05587], [-119.64518, 37.05592], [-119.64575, 37.05609], [-119.64606, 37.05627], [-119.64647, 37.0567], [-119.64632, 37.05755], [-119.64626, 37.05769], [-119.64649, 37.05762], [-119.64746, 37.05767], [-119.64828, 37.05787], [-119.64878, 37.05812], [-119.64917, 37.05849], [-119.64981, 37.059], [-119.64991, 37.05929], [-119.64999, 37.05943], [-119.64994, 37.05955], [-119.65011, 37.0597], [-119.65024, 37.05986], [-119.65022, 37.06019], [-119.65016, 37.06064], [-119.65057, 37.06084], [-119.6507, 37.06075], [-119.65074, 37.06087], [-119.65113, 37.06158], [-119.65127, 37.06211], [-119.65114, 37.06251], [-119.65108, 37.063], [-119.65074, 37.06296], [-119.6505, 37.063], [-119.65052, 37.06319], [-119.65116, 37.06333], [-119.65151, 37.06315], [-119.65151, 37.06273], [-119.65166, 37.06234], [-119.65174, 37.06197], [-119.65093, 37.06041], [-119.65092, 37.06034], [-119.65094, 37.06009], [-119.65099, 37.05981], [-119.6508, 37.05948], [-119.65094, 37.05926], [-119.65064, 37.05925], [-119.65048, 37.05896], [-119.65048, 37.05875], [-119.65037, 37.05826], [-119.65003, 37.05815], [-119.64985, 37.05791], [-119.64996, 37.05748], [-119.64973, 37.05721], [-119.64972, 37.05699], [-119.64952, 37.05698], [-119.64932, 37.05686], [-119.64903, 37.05672], [-119.64899, 37.05653], [-119.64873, 37.05661], [-119.64832, 37.05646], [-119.64798, 37.05623], [-119.6478, 37.05604], [-119.64751, 37.05606], [-119.64684, 37.05557], [-119.64648, 37.05521], [-119.64632, 37.05497], [-119.64616, 37.05498], [-119.64605, 37.05492], [-119.64586, 37.05475], [-119.64566, 37.05477], [-119.64545, 37.05476], [-119.64466, 37.05454], [-119.6443, 37.05433], [-119.64416, 37.05419], [-119.64383, 37.0541], [-119.64187, 37.05206], [-119.64172, 37.05176], [-119.64163, 37.05133], [-119.64169, 37.05115], [-119.64213, 37.05093], [-119.64393, 37.05058], [-119.64468, 37.05119], [-119.64492, 37.05133], [-119.64411, 37.05199], [-119.64408, 37.05208], [-119.64449, 37.05224], [-119.64459, 37.05232], [-119.64473, 37.05272], [-119.64537, 37.05225], [-119.64593, 37.05232], [-119.64594, 37.05245], [-119.6459, 37.05278], [-119.64632, 37.05262], [-119.64668, 37.05269], [-119.64683, 37.05329], [-119.64729, 37.05316], [-119.64884, 37.05419], [-119.64893, 37.0543], [-119.649, 37.05436], [-119.64916, 37.05442], [-119.64937, 37.05445], [-119.64961, 37.05443], [-119.64984, 37.05438], [-119.64999, 37.05439], [-119.65031, 37.05447], [-119.6505, 37.05446], [-119.65089, 37.05442], [-119.65109, 37.05444], [-119.65197, 37.05508], [-119.65199, 37.06246], [-119.6541, 37.06247], [-119.65525, 37.06358], [-119.65853, 37.06243], [-119.66327, 37.0625]]]}	Open Access 1	Austin and Mary Ewell Fine Gold Creek Preserve	http://awww.sierrafoothill.org/index.php/land/preserves/austin-mary-ewell-preserve	29215	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	703.748	Austin and Mary Ewell Fine Gold Creek Preserve
12285	12285	12284	{"type": "MultiPolygon", "coordinates": [[[[-119.60987, 37.02875], [-119.60983, 37.03609], [-119.6054, 37.036], [-119.60535, 37.04334], [-119.60094, 37.04317], [-119.60083, 37.03959], [-119.59636, 37.03951], [-119.58765, 37.03928], [-119.58772, 37.03207], [-119.58351, 37.03196], [-119.58349, 37.02828], [-119.60987, 37.02875]]], [[[-119.62016, 36.98167], [-119.62, 36.99254], [-119.61088, 36.99257], [-119.6108, 36.99615], [-119.60629, 36.99623], [-119.60626, 36.99977], [-119.60708, 37.01076], [-119.6112, 37.01077], [-119.61269, 37.0108], [-119.61253, 37.018], [-119.61704, 37.01804], [-119.61691, 37.02165], [-119.61245, 37.0217], [-119.61235, 37.02519], [-119.58355, 37.02477], [-119.58357, 37.01186], [-119.58414, 37.01168], [-119.58501, 37.01105], [-119.58616, 37.01007], [-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.5945, 36.99569], [-119.59582, 36.99434], [-119.59686, 36.99207], [-119.5976, 36.98957], [-119.59804, 36.98886], [-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.61545, 36.98162], [-119.62016, 36.98167]]], [[[-119.63971, 37.01813], [-119.62609, 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	Ruth McKenzie Table Mountain Preserve	http://awww.sierrafoothill.org/index.php/land/preserves/mckenzie-preser/	29279	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	3331.359	Ruth McKenzie Table Mtn. Preserve
15520	15520	15519	{"type": "Polygon", "coordinates": [[[-119.48101, 37.00954], [-119.47739, 37.01125], [-119.47204, 37.01411], [-119.47069, 37.01486], [-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.462, 37.02735], [-119.46646, 37.02738], [-119.46647, 37.02727], [-119.46726, 37.02728], [-119.46728, 37.02724], [-119.46817, 37.02723], [-119.46838, 37.02694], [-119.46854, 37.02692], [-119.46852, 37.02545], [-119.46871, 37.02564], [-119.46871, 37.02728], [-119.46864, 37.0273], [-119.46876, 37.03083], [-119.47022, 37.03086], [-119.47022, 37.03104], [-119.46884, 37.03101], [-119.46206, 37.03098], [-119.46198, 37.02735], [-119.45751, 37.02724], [-119.45742, 37.02365], [-119.453, 37.02364], [-119.45298, 37.01999], [-119.45282, 37.01641], [-119.44827, 37.01635], [-119.44815, 37.01283], [-119.44373, 37.0128], [-119.43919, 37.01275], [-119.43493, 37.0126], [-119.43499, 37.00904], [-119.42135, 37.00884], [-119.42131, 36.99474], [-119.43021, 36.99511], [-119.43034, 37.00213], [-119.43485, 37.00214], [-119.43494, 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.47049, 37.00924], [-119.48101, 37.00954]], [[-119.43034, 37.00216], [-119.42582, 37.00207], [-119.42588, 37.00554], [-119.43037, 37.00554], [-119.43034, 37.00216]]]}	Open Access 1	Mary Elizabeth Miller Preserve at Black Mountain	http://awww.sierrafoothill.org/index.php/land/preserves/mary-elizabeth-miller-preserve/	29280	3077	Sierra Foothill Conservancy 320	Non Profit 6	Non Profit - Land Trust 10	http://www.sierrafoothill.org/	Non Governmental Organization 10	1461.105	Mary Elizabeth Miller Preserve at Black Mtn.

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);