units_with_maps

Table actions

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

14 rows where GAP_STS = 2, 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 ✖

DES_TP 1

ACCESS_TYP 1

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
196 196 195 {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} No Public Access 3 46830 Palmer Property 30298 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 2.548 Palmer Property 0 Private Conservation 16 2
3308 3308 3307 {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-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 46828 La Cresta Hills Property 30296 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 12.874 La Cresta Hills Property 0 Private Conservation 16 2
3309 3309 3308 {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} No Public Access 3 46829 Michelson Property 30297 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 91.593 Michelson Property 0 Private Conservation 16 2
3313 3313 3312 {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} No Public Access 3 46834 Ulrich Property 30302 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 93.312 Ulrich Property 0 Private Conservation 16 2
11527 11527 11526 {"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 46835 Walker Priest/La Cresta Property 30303 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 25.204 Walker Priest/La Cresta Property 0 Private Conservation 16 2
11530 11530 11529 {"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 46826 Harbison Canyon Property 30294 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 40.355 Harbison Canyon Property 0 Private Conservation 16 2
11539 11539 11538 {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 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 46831 Sarjay/La Cresta Property 30299 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 21.548 Sarjay/La Cresta Property 0 Private Conservation 16 2
11540 11540 11539 {"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 46832 Saxena/La Cresta Property 30300 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 4.044 Saxena/La Cresta Property 0 Private Conservation 16 2
11541 11541 11540 {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88489, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87185, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86273, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86725, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88467, 32.80066], [-116.88552, 32.79991], [-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.88653, 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.88883, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} No Public Access 3 46833 South Crest Properties 30301 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 586.423 South Crest Properties 0 Private Conservation 16 2
11544 11544 11543 {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19482, 33.0613], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06393], [-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 46822 Bridges Property 30290 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 96.326 Bridges Property 0 Private Conservation 16 2
11545 11545 11544 {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83782, 32.83791], [-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.83431], [-116.83922, 32.83545]]]} No Public Access 3 46823 Gibson Property 30291 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 251.399 Gibson Property 0 Private Conservation 16 2
11546 11546 11545 {"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 46824 Guyot/La Cresta Property 30292 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 1.954 Guyot/La Cresta Property 0 Private Conservation 16 2
11547 11547 11546 {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90258, 32.86929], [-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.89778, 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.86538], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} No Public Access 3 46825 Hanson Property 30293 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 141.528 Hanson Property 0 Private Conservation 16 2
14177 14177 14176 {"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.83027, 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.83634, 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 46827 Kemerko Property 30295 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 122.681 Kemerko Property 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]);