superunits_with_maps

Table actions

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

14 rows where ACCESS_TYP = 3, MNG_AGENCY = 77 and MNG_AG_TYP = 12

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Conservation · 14 ✖

MNG_AGENCY 1

  • Endangered Habitats Conservancy · 14 ✖

ACCESS_TYP 1

  • No Public Access · 14 ✖
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 YR_EST
11614 11614 11613 {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.81449], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81298], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} No Public Access 3 La Cresta Hills Property   30296 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 12.874 La Cresta Hills Property  
11615 11615 11614 {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79372], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79388], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} No Public Access 3 Michelson Property   30297 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 91.621 Michelson Property  
11616 11616 11615 {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80705, 32.84466], [-116.80824, 32.84466]]]} No Public Access 3 Palmer Property   30298 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 2.548 Palmer Property  
11617 11617 11616 {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80744], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89572, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} No Public Access 3 Sarjay/La Cresta Property   30299 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 21.557 Sarjay/La Cresta Property  
13047 13047 13046 {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88488, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87184, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86272, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86726, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88468, 32.80066], [-116.88552, 32.79992], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88652, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88884, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} No Public Access 3 South Crest Properties   30301 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 586.646 South Crest Properties  
13048 13048 13047 {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85865, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} No Public Access 3 Ulrich Property   30302 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 93.321 Ulrich Property  
13049 13049 13048 {"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]} No Public Access 3 Walker Priest/La Cresta Property   30303 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 25.207 Walker Priest/La Cresta Property  
13055 13055 13054 {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19481, 33.06132], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06394], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} No Public Access 3 Bridges Property   30290 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 96.351 Bridges Property  
13056 13056 13055 {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83783, 32.8379], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.8343], [-116.83922, 32.83545]]]} No Public Access 3 Gibson Property   30291 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 251.411 Gibson Property  
13059 13059 13058 {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} No Public Access 3 Guyot/La Cresta Property   30292 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 1.954 Guyot/La Cresta Property  
13060 13060 13059 {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90259, 32.8693], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89779, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86537], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} No Public Access 3 Hanson Property   30293 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 141.559 Hanson Property  
13061 13061 13060 {"type": "MultiPolygon", "coordinates": [[[[-116.84201, 32.81202], [-116.84191, 32.8121], [-116.84131, 32.81251], [-116.8413, 32.81202], [-116.84201, 32.81202]]], [[[-116.84567, 32.81198], [-116.84566, 32.81571], [-116.84136, 32.8157], [-116.84133, 32.81349], [-116.84145, 32.81348], [-116.84145, 32.81308], [-116.84132, 32.81295], [-116.84132, 32.81279], [-116.84209, 32.81225], [-116.84236, 32.81201], [-116.84567, 32.81198]]]]} No Public Access 3 Harbison Canyon Property   30294 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 40.355 Harbison Canyon Property  
13062 13062 13061 {"type": "MultiPolygon", "coordinates": [[[[-116.83661, 32.82754], [-116.83656, 32.83029], [-116.82414, 32.83012], [-116.82764, 32.82602], [-116.82778, 32.82508], [-116.82831, 32.82471], [-116.83026, 32.82475], [-116.83028, 32.82503], [-116.83055, 32.82502], [-116.83059, 32.82476], [-116.83239, 32.8248], [-116.8324, 32.82659], [-116.8347, 32.82661], [-116.8361, 32.82754], [-116.83622, 32.82758], [-116.83635, 32.8276], [-116.83647, 32.82759], [-116.83661, 32.82754]]], [[[-116.83662, 32.82663], [-116.83661, 32.82732], [-116.83649, 32.82741], [-116.83635, 32.82744], [-116.83626, 32.82742], [-116.83617, 32.82739], [-116.83504, 32.82663], [-116.83662, 32.82663]]]]} No Public Access 3 Kemerko Property   30295 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 122.701 Kemerko Property  
13063 13063 13062 {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} No Public Access 3 Saxena/La Cresta Property   30300 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 4.043 Saxena/La Cresta Property  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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