superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, MNG_AGENCY = 128 and MNG_AG_LEV = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Other State · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
3218 3218 3217 {"type": "MultiPolygon", "coordinates": [[[[-121.47063, 38.2699], [-121.4706, 38.27064], [-121.45934, 38.27057], [-121.45744, 38.27053], [-121.45774, 38.26731], [-121.45767, 38.2673], [-121.45787, 38.26586], [-121.45678, 38.26697], [-121.4556, 38.26691], [-121.45491, 38.26671], [-121.45329, 38.26679], [-121.45334, 38.26641], [-121.45342, 38.26639], [-121.45386, 38.26294], [-121.45446, 38.25887], [-121.45447, 38.25847], [-121.45468, 38.2569], [-121.45524, 38.25732], [-121.45554, 38.2575], [-121.45556, 38.25748], [-121.45578, 38.25759], [-121.45787, 38.25723], [-121.45864, 38.25732], [-121.45909, 38.25763], [-121.45934, 38.25812], [-121.45982, 38.25857], [-121.46072, 38.25902], [-121.46149, 38.25921], [-121.46136, 38.26017], [-121.46129, 38.2603], [-121.46105, 38.26171], [-121.46263, 38.26384], [-121.46222, 38.26635], [-121.46232, 38.26641], [-121.46232, 38.26645], [-121.46266, 38.26659], [-121.46431, 38.26748], [-121.46447, 38.26828], [-121.46366, 38.26984], [-121.47063, 38.2699]]], [[[-121.50963, 38.2458], [-121.50927, 38.24638], [-121.5092, 38.24637], [-121.50864, 38.24741], [-121.50384, 38.24617], [-121.5037, 38.24612], [-121.50353, 38.24609], [-121.50271, 38.24589], [-121.50332, 38.25019], [-121.50249, 38.25022], [-121.50189, 38.25041], [-121.50176, 38.25041], [-121.50146, 38.25033], [-121.50137, 38.25027], [-121.50135, 38.2503], [-121.5013, 38.25028], [-121.50021, 38.25049], [-121.50021, 38.25051], [-121.5007, 38.25092], [-121.50104, 38.25101], [-121.50058, 38.25107], [-121.50044, 38.25101], [-121.50033, 38.25084], [-121.50004, 38.2507], [-121.49991, 38.25044], [-121.49966, 38.25014], [-121.49947, 38.24987], [-121.49933, 38.24952], [-121.49916, 38.24938], [-121.49894, 38.24893], [-121.4988, 38.24871], [-121.49867, 38.24842], [-121.49845, 38.24755], [-121.49846, 38.24721], [-121.4984, 38.24683], [-121.49827, 38.24643], [-121.49813, 38.2461], [-121.49781, 38.24554], [-121.49768, 38.24512], [-121.49757, 38.24494], [-121.49745, 38.24449], [-121.49737, 38.24423], [-121.49733, 38.24387], [-121.49726, 38.24348], [-121.49726, 38.24268], [-121.49731, 38.24198], [-121.49738, 38.24147], [-121.49733, 38.24066], [-121.49736, 38.24046], [-121.49739, 38.2404], [-121.49744, 38.24035], [-121.49751, 38.24033], [-121.49764, 38.24033], [-121.49767, 38.2403], [-121.49771, 38.24021], [-121.49806, 38.24029], [-121.498, 38.24057], [-121.49802, 38.2411], [-121.49806, 38.24127], [-121.49818, 38.24151], [-121.49846, 38.24191], [-121.49871, 38.24222], [-121.49906, 38.24253], [-121.49937, 38.24273], [-121.49966, 38.24285], [-121.50023, 38.24302], [-121.5084, 38.24517], [-121.50877, 38.24532], [-121.50886, 38.24538], [-121.50905, 38.24565], [-121.50963, 38.2458]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68419, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} Restricted Access 2 Cosumnes River Preserve   17678 299 Other State 128 State 5 State Agency 5   Other State 5 364.737 Cosumnes River Preserve  
14266 14266 14265 {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} Restricted Access 2 Stone Lakes   25872 299 Other State 128 State 5 State Agency 5   Other State 5 41.202 Stone Lakes  

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