units_with_maps

Table actions

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

7 rows where LAYER = 10, MNG_AGENCY = 320 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Land Trust · 7 ✖

MNG_AGENCY 1

  • Sierra Foothill Conservancy · 7 ✖
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
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 0 Private Conservation 16 2
4150 4150 4149 {"type": "Polygon", "coordinates": [[[-119.95114, 37.60758], [-119.95049, 37.61465], [-119.94827, 37.61467], [-119.94891, 37.60766], [-119.95114, 37.60758]]]} Unknown Access 4 44690 Feliciana Mountain Preserve 18865 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   Mariposa 31 37.919 Feliciana Mtn. Preserve 0 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 0 Private Conservation 16 2
14374 14374 14373 {"type": "Polygon", "coordinates": [[[-119.66327, 37.0625], [-119.66314, 37.06353], [-119.66138, 37.0647], [-119.65862, 37.06474], [-119.65876, 37.07194], [-119.64975, 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.64168, 37.05442], [-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.05593], [-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.64625, 37.0577], [-119.64649, 37.05762], [-119.64746, 37.05767], [-119.64828, 37.05787], [-119.64877, 37.05812], [-119.64917, 37.05849], [-119.64981, 37.059], [-119.64991, 37.05929], [-119.64999, 37.05943], [-119.64993, 37.05955], [-119.65011, 37.0597], [-119.65024, 37.05986], [-119.65022, 37.06019], [-119.65016, 37.06064], [-119.65058, 37.06084], [-119.6507, 37.06075], [-119.65074, 37.06087], [-119.65113, 37.06158], [-119.65127, 37.06211], [-119.65114, 37.0625], [-119.65108, 37.063], [-119.65074, 37.06296], [-119.65049, 37.063], [-119.65052, 37.06319], [-119.65116, 37.06333], [-119.65152, 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.65095, 37.05925], [-119.65064, 37.05925], [-119.65048, 37.05896], [-119.65048, 37.05875], [-119.65036, 37.05826], [-119.65003, 37.05815], [-119.64985, 37.05791], [-119.64996, 37.05748], [-119.64973, 37.05721], [-119.64972, 37.05698], [-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.64797, 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.64417, 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.052], [-119.64408, 37.05209], [-119.64449, 37.05224], [-119.64459, 37.05232], [-119.64473, 37.05273], [-119.64537, 37.05225], [-119.64593, 37.05232], [-119.64594, 37.05245], [-119.64589, 37.05279], [-119.64632, 37.05262], [-119.64668, 37.05269], [-119.64683, 37.0533], [-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.06247], [-119.6541, 37.06247], [-119.65525, 37.06358], [-119.65853, 37.06243], [-119.66327, 37.0625]]]} Open Access 1 44460 Austin and Mary Ewell Fine Gold Creek Preserve 29215 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/austin-mary-ewell-preserve Madera 48 703.543 Austin and Mary Ewell Fine Gold Creek Preserve 0 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 0 Private Conservation 16 2
14559 14559 14558 {"type": "Polygon", "coordinates": [[[-120.14581, 37.75648], [-120.14209, 37.75811], [-120.13939, 37.75472], [-120.13846, 37.75332], [-120.13822, 37.75269], [-120.13672, 37.7511], [-120.13549, 37.74983], [-120.13523, 37.74947], [-120.13547, 37.74929], [-120.13534, 37.74912], [-120.13523, 37.74734], [-120.13526, 37.74734], [-120.14372, 37.75451], [-120.14581, 37.75648]]]} Unknown Access 4 44689 Bean Creek Preserve 15919 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   Mariposa 31 79.37 Bean Creek Preserve 0 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. 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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