superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 840 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • Fond Land Preservation Foundation · 1 ✖

ACCESS_TYP 1

  • Open 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
547 547 546 {"type": "MultiPolygon", "coordinates": [[[[-118.32813, 34.25287], [-118.32799, 34.2536], [-118.32811, 34.254], [-118.32728, 34.25449], [-118.32714, 34.25435], [-118.32611, 34.25459], [-118.32583, 34.25429], [-118.32522, 34.25334], [-118.32538, 34.2516], [-118.32516, 34.25134], [-118.32518, 34.25131], [-118.32529, 34.25124], [-118.32592, 34.25118], [-118.32619, 34.25128], [-118.32645, 34.25156], [-118.32659, 34.25202], [-118.32678, 34.25225], [-118.32709, 34.25239], [-118.32776, 34.25256], [-118.32813, 34.25287]]], [[[-118.35035, 34.24485], [-118.34989, 34.24486], [-118.34989, 34.2463], [-118.34866, 34.2463], [-118.3484, 34.24562], [-118.34796, 34.24523], [-118.34716, 34.24544], [-118.346, 34.2464], [-118.34557, 34.24817], [-118.34407, 34.24477], [-118.34086, 34.24487], [-118.34106, 34.24552], [-118.33901, 34.24712], [-118.3387, 34.2472], [-118.33869, 34.25012], [-118.33898, 34.25021], [-118.33905, 34.25075], [-118.34034, 34.25092], [-118.34012, 34.25127], [-118.34019, 34.2513], [-118.34073, 34.25205], [-118.34067, 34.25204], [-118.34066, 34.25205], [-118.34077, 34.2522], [-118.34112, 34.25233], [-118.34098, 34.25322], [-118.34001, 34.25301], [-118.33979, 34.25305], [-118.33979, 34.25311], [-118.33919, 34.25323], [-118.33872, 34.25315], [-118.3387, 34.25408], [-118.3348, 34.25297], [-118.32787, 34.25114], [-118.32532, 34.24575], [-118.32614, 34.24568], [-118.32564, 34.24438], [-118.32585, 34.24356], [-118.32828, 34.24373], [-118.32941, 34.24303], [-118.33558, 34.24282], [-118.33558, 34.24462], [-118.33559, 34.24463], [-118.33679, 34.24372], [-118.34114, 34.24136], [-118.34167, 34.24142], [-118.34431, 34.24006], [-118.34432, 34.24256], [-118.35034, 34.24236], [-118.35035, 34.24485]]], [[[-118.33422, 34.25811], [-118.33386, 34.25817], [-118.33304, 34.25842], [-118.33287, 34.25845], [-118.33269, 34.25847], [-118.33263, 34.2585], [-118.3325, 34.25862], [-118.33238, 34.25867], [-118.33187, 34.25871], [-118.33175, 34.2588], [-118.33179, 34.25942], [-118.33099, 34.2595], [-118.33094, 34.2595], [-118.33092, 34.25949], [-118.33073, 34.2595], [-118.32881, 34.25776], [-118.32752, 34.25663], [-118.32832, 34.25596], [-118.32851, 34.25262], [-118.32804, 34.25162], [-118.33174, 34.2526], [-118.33132, 34.25461], [-118.33187, 34.2553], [-118.33162, 34.25606], [-118.33175, 34.25642], [-118.33176, 34.25744], [-118.33282, 34.25776], [-118.33402, 34.25796], [-118.33422, 34.25811]]], [[[-118.35418, 34.24275], [-118.35397, 34.24291], [-118.35393, 34.24341], [-118.35417, 34.24362], [-118.35417, 34.24516], [-118.35385, 34.24535], [-118.35372, 34.24537], [-118.35366, 34.24535], [-118.35357, 34.24544], [-118.35353, 34.24541], [-118.35312, 34.24527], [-118.3527, 34.24541], [-118.35272, 34.24228], [-118.35417, 34.24223], [-118.35418, 34.24275]]]]} Open Access 1 Fond Wilderness Preserve http://flpf.org/index.html 3733 3023 Fond Land Preservation Foundation 840 Non Profit 6 Non Profit - Land Trust 10 http://www.flpf.org/ Non Governmental Organization 10 498.791 Fond Wilderness Preserve  

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