superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, MNG_AG_TYP = 12 and YR_EST = 2001

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Conservation · 1 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • No Public Access · 1 ✖
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
1686 1686 1685 {"type": "Polygon", "coordinates": [[[-122.26297, 37.36581], [-122.26293, 37.36582], [-122.26294, 37.36592], [-122.26289, 37.366], [-122.26273, 37.36607], [-122.26276, 37.36619], [-122.26254, 37.3663], [-122.26254, 37.36633], [-122.26196, 37.3666], [-122.26183, 37.36669], [-122.26172, 37.36682], [-122.26162, 37.36682], [-122.26152, 37.36705], [-122.26144, 37.36742], [-122.26114, 37.36769], [-122.26095, 37.36784], [-122.25955, 37.36619], [-122.25746, 37.36678], [-122.25731, 37.36693], [-122.25716, 37.36693], [-122.25676, 37.36685], [-122.25657, 37.36685], [-122.25592, 37.36707], [-122.25592, 37.36709], [-122.25754, 37.36708], [-122.25735, 37.36729], [-122.25711, 37.36737], [-122.25659, 37.36747], [-122.25608, 37.3679], [-122.25625, 37.36822], [-122.25641, 37.36838], [-122.25649, 37.36878], [-122.25633, 37.36893], [-122.25575, 37.36932], [-122.25549, 37.36961], [-122.25449, 37.36977], [-122.2546, 37.37023], [-122.25415, 37.37047], [-122.25367, 37.37042], [-122.25352, 37.37051], [-122.25347, 37.37056], [-122.25198, 37.37054], [-122.25143, 37.37084], [-122.24809, 37.36765], [-122.24793, 37.36745], [-122.24782, 37.36723], [-122.24778, 37.36702], [-122.24778, 37.36678], [-122.24781, 37.36661], [-122.24803, 37.36597], [-122.24807, 37.36582], [-122.2481, 37.3655], [-122.24807, 37.36515], [-122.24799, 37.36485], [-122.24783, 37.36452], [-122.24767, 37.36428], [-122.24738, 37.36395], [-122.24723, 37.3637], [-122.24712, 37.36339], [-122.24709, 37.36316], [-122.2471, 37.36294], [-122.24714, 37.36277], [-122.2478, 37.36072], [-122.24787, 37.36035], [-122.24788, 37.35992], [-122.24784, 37.35955], [-122.24775, 37.35918], [-122.24758, 37.35877], [-122.24739, 37.35843], [-122.24716, 37.35811], [-122.24689, 37.35781], [-122.24663, 37.35758], [-122.24617, 37.35725], [-122.24499, 37.35659], [-122.24474, 37.35643], [-122.24434, 37.35615], [-122.24404, 37.35589], [-122.24309, 37.35486], [-122.24321, 37.35412], [-122.2416, 37.35277], [-122.24159, 37.35278], [-122.24157, 37.3532], [-122.24052, 37.352], [-122.24016, 37.35169], [-122.23978, 37.3514], [-122.23934, 37.35112], [-122.23684, 37.34972], [-122.23632, 37.3495], [-122.23577, 37.34935], [-122.23539, 37.34929], [-122.23472, 37.34923], [-122.23411, 37.34915], [-122.23331, 37.34901], [-122.23297, 37.34892], [-122.23255, 37.34879], [-122.23216, 37.34863], [-122.23184, 37.34848], [-122.23141, 37.34823], [-122.23091, 37.34787], [-122.23063, 37.34762], [-122.23043, 37.34741], [-122.23016, 37.34707], [-122.22922, 37.34553], [-122.22907, 37.34532], [-122.22892, 37.34515], [-122.22871, 37.34496], [-122.22832, 37.34469], [-122.22793, 37.3445], [-122.22719, 37.34426], [-122.22658, 37.344], [-122.22617, 37.34379], [-122.22553, 37.34334], [-122.22507, 37.34306], [-122.2247, 37.34286], [-122.2242, 37.34263], [-122.22021, 37.34108], [-122.22031, 37.34095], [-122.22084, 37.3407], [-122.22131, 37.34038], [-122.22208, 37.33983], [-122.22255, 37.33933], [-122.22275, 37.33916], [-122.22312, 37.33907], [-122.22346, 37.33901], [-122.22384, 37.33882], [-122.2241, 37.33836], [-122.22439, 37.33817], [-122.23254, 37.34142], [-122.23255, 37.34136], [-122.23257, 37.33717], [-122.23272, 37.33733], [-122.23292, 37.33764], [-122.23299, 37.33771], [-122.23315, 37.33784], [-122.23331, 37.33794], [-122.23378, 37.33815], [-122.2345, 37.33833], [-122.23478, 37.33847], [-122.23506, 37.33859], [-122.23528, 37.33862], [-122.23581, 37.33858], [-122.23624, 37.33858], [-122.2369, 37.3385], [-122.23723, 37.33848], [-122.23756, 37.3385], [-122.23787, 37.33858], [-122.23834, 37.3388], [-122.23871, 37.339], [-122.23895, 37.33917], [-122.23925, 37.33942], [-122.23995, 37.33994], [-122.24023, 37.34007], [-122.24044, 37.34011], [-122.24066, 37.34013], [-122.24098, 37.34011], [-122.24151, 37.34004], [-122.24163, 37.34006], [-122.24165, 37.34002], [-122.2423, 37.33997], [-122.24265, 37.33987], [-122.24311, 37.34], [-122.24378, 37.3401], [-122.24469, 37.34028], [-122.24808, 37.34109], [-122.24816, 37.34127], [-122.24853, 37.34139], [-122.24874, 37.34137], [-122.24906, 37.34148], [-122.24942, 37.3415], [-122.24971, 37.34147], [-122.24999, 37.34154], [-122.25041, 37.34133], [-122.25051, 37.34144], [-122.25065, 37.34142], [-122.25067, 37.34157], [-122.2594, 37.34161], [-122.25934, 37.34519], [-122.25864, 37.34713], [-122.25656, 37.34655], [-122.25414, 37.3493], [-122.25066, 37.35068], [-122.25064, 37.35264], [-122.25062, 37.35989], [-122.25309, 37.35989], [-122.25303, 37.35994], [-122.25305, 37.36007], [-122.25364, 37.36022], [-122.25401, 37.36053], [-122.25434, 37.36088], [-122.25431, 37.36107], [-122.25349, 37.36171], [-122.25318, 37.36187], [-122.25304, 37.36212], [-122.25312, 37.36237], [-122.25301, 37.3625], [-122.25264, 37.36259], [-122.25201, 37.36294], [-122.25208, 37.36308], [-122.25254, 37.36305], [-122.25296, 37.36313], [-122.25341, 37.36297], [-122.25397, 37.36309], [-122.2542, 37.36333], [-122.25428, 37.36359], [-122.25452, 37.36351], [-122.25467, 37.36309], [-122.25502, 37.36297], [-122.25569, 37.36291], [-122.25656, 37.363], [-122.25673, 37.36349], [-122.25668, 37.36381], [-122.25697, 37.36403], [-122.25706, 37.36388], [-122.25925, 37.36259], [-122.25961, 37.36297], [-122.25971, 37.36311], [-122.25991, 37.36308], [-122.26002, 37.36302], [-122.26008, 37.36294], [-122.26015, 37.36277], [-122.26028, 37.36266], [-122.26044, 37.3626], [-122.26061, 37.36259], [-122.26043, 37.36268], [-122.26031, 37.36277], [-122.26021, 37.36289], [-122.26015, 37.36301], [-122.26012, 37.36314], [-122.26012, 37.36329], [-122.26016, 37.36344], [-122.26024, 37.36357], [-122.26034, 37.36367], [-122.26046, 37.36376], [-122.26112, 37.36408], [-122.26114, 37.36413], [-122.26126, 37.3642], [-122.2616, 37.36431], [-122.26212, 37.3644], [-122.26225, 37.36445], [-122.26238, 37.36453], [-122.26252, 37.36467], [-122.26294, 37.3656], [-122.2629, 37.36562], [-122.26297, 37.36581]]]} No Public Access 3 Audubon Society   15704 3075 Sequoia Audubon Society 821 Non Profit 6 Non Profit - Conservation 12 http://www.sequoia-audubon.org/ Non Governmental Organization 10 1126.938 Audubon Society 2001

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