superunits_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, MNG_AGENCY = 50, MNG_AG_ID = 3074 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 4 ✖

MNG_AGENCY 1

  • Save the Redwoods League · 4 ✖

ACCESS_TYP 1

  • Open Access · 4 ✖
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
1101 1101 1100 {"type": "Polygon", "coordinates": [[[-123.84998, 39.82879], [-123.84743, 39.82888], [-123.84723, 39.82902], [-123.84606, 39.82912], [-123.84512, 39.82986], [-123.8439, 39.82982], [-123.84342, 39.83063], [-123.84468, 39.832], [-123.8437, 39.83385], [-123.84267, 39.83451], [-123.8423, 39.8347], [-123.84174, 39.83484], [-123.84164, 39.83488], [-123.84048, 39.83364], [-123.84022, 39.83228], [-123.84092, 39.83265], [-123.84166, 39.83204], [-123.8409, 39.83138], [-123.83928, 39.83063], [-123.83855, 39.83078], [-123.8378, 39.83039], [-123.83609, 39.82986], [-123.83499, 39.82912], [-123.83365, 39.82914], [-123.83284, 39.8296], [-123.83171, 39.82996], [-123.83053, 39.83054], [-123.82851, 39.8297], [-123.8269, 39.82887], [-123.82652, 39.8282], [-123.82603, 39.8281], [-123.82494, 39.82707], [-123.82412, 39.82717], [-123.82356, 39.82668], [-123.82286, 39.82556], [-123.82225, 39.82506], [-123.8219, 39.82385], [-123.82061, 39.82348], [-123.81982, 39.82279], [-123.81968, 39.82278], [-123.8189, 39.82265], [-123.81814, 39.82257], [-123.81738, 39.8221], [-123.81669, 39.8222], [-123.81582, 39.82008], [-123.81601, 39.81927], [-123.81574, 39.81862], [-123.81664, 39.81784], [-123.81724, 39.81709], [-123.81572, 39.81621], [-123.82022, 39.81587], [-123.83988, 39.81637], [-123.84643, 39.81657], [-123.84664, 39.81772], [-123.8469, 39.81806], [-123.84715, 39.81865], [-123.84717, 39.81884], [-123.84711, 39.81894], [-123.84703, 39.81899], [-123.84689, 39.81899], [-123.84684, 39.81901], [-123.8468, 39.81914], [-123.84684, 39.81937], [-123.84695, 39.81981], [-123.84712, 39.82005], [-123.84721, 39.82012], [-123.84758, 39.82025], [-123.84788, 39.82024], [-123.84802, 39.82028], [-123.84808, 39.82035], [-123.84808, 39.82061], [-123.84814, 39.82079], [-123.84813, 39.8209], [-123.84824, 39.82138], [-123.84823, 39.82153], [-123.84816, 39.82163], [-123.84808, 39.8217], [-123.84799, 39.82187], [-123.84799, 39.82206], [-123.84811, 39.82324], [-123.84828, 39.82379], [-123.84852, 39.82438], [-123.84882, 39.82518], [-123.84895, 39.82547], [-123.84919, 39.82612], [-123.84921, 39.82628], [-123.84945, 39.82705], [-123.84953, 39.82724], [-123.84967, 39.82793], [-123.84981, 39.82833], [-123.84998, 39.82879]]]} Open Access 1 Shady Dell   12383 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 927.577 Shady Dell  
14105 14105 14104 {"type": "Polygon", "coordinates": [[[-124.12175, 41.85473], [-124.12022, 41.8547], [-124.12029, 41.85451], [-124.12039, 41.85336], [-124.12051, 41.85288], [-124.12085, 41.85203], [-124.12082, 41.85183], [-124.1206, 41.85116], [-124.12052, 41.85102], [-124.11957, 41.84978], [-124.11897, 41.84931], [-124.11887, 41.84921], [-124.11873, 41.84903], [-124.11853, 41.84866], [-124.11837, 41.84841], [-124.11816, 41.84818], [-124.11785, 41.84791], [-124.11786, 41.84746], [-124.11787, 41.84745], [-124.11789, 41.844], [-124.11857, 41.84418], [-124.11872, 41.84427], [-124.11878, 41.84428], [-124.11892, 41.8444], [-124.11931, 41.84468], [-124.11935, 41.84475], [-124.1195, 41.84487], [-124.11963, 41.84504], [-124.11963, 41.84517], [-124.1196, 41.8453], [-124.11931, 41.84591], [-124.1192, 41.84639], [-124.11922, 41.84657], [-124.11919, 41.84694], [-124.11925, 41.8474], [-124.11925, 41.84746], [-124.11923, 41.84747], [-124.11922, 41.84771], [-124.11927, 41.8479], [-124.11933, 41.84838], [-124.11951, 41.8488], [-124.1196, 41.84896], [-124.11967, 41.84915], [-124.11975, 41.84929], [-124.1202, 41.84969], [-124.12029, 41.84987], [-124.12034, 41.85003], [-124.12035, 41.85018], [-124.12044, 41.85039], [-124.12052, 41.85067], [-124.12103, 41.85116], [-124.12122, 41.85138], [-124.12141, 41.85169], [-124.1216, 41.85199], [-124.12187, 41.85262], [-124.12197, 41.85302], [-124.12195, 41.85363], [-124.12196, 41.85398], [-124.12188, 41.85421], [-124.12175, 41.85473]]]} Open Access 1 Ruby Van Deventer County Park https://www.savetheredwoods.org/park/ruby-van-deventer-county-park/ 31536 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 27.241 Ruby Van Deventer County Park  
14628 14628 14627 {"type": "Polygon", "coordinates": [[[-119.79781, 38.30883], [-119.79777, 38.30983], [-119.79674, 38.30981], [-119.79629, 38.30945], [-119.79631, 38.30886], [-119.79781, 38.30883]]]} Open Access 1 Stanislaus National Forest https://www.savetheredwoods.org/ 33338 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 3.299 Stanislaus NF  
14630 14630 14629 {"type": "Polygon", "coordinates": [[[-118.61242, 36.06821], [-118.61238, 36.08273], [-118.60818, 36.08267], [-118.60824, 36.06818], [-118.61242, 36.06821]]]} Open Access 1 Giant Sequoia National Monument https://www.savetheredwoods.org/ 33335 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 149.97 Giant Sequoia NM  

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