superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2 and PARK_NAME = "Semitropic Ridge Preserve"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

ACCESS_TYP 1

  • Restricted 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
9497 9497 9496 {"type": "MultiPolygon", "coordinates": [[[[-119.57997, 35.64111], [-119.57117, 35.64112], [-119.57115, 35.64445], [-119.56897, 35.64444], [-119.56895, 35.64466], [-119.56222, 35.64465], [-119.5622, 35.64444], [-119.53554, 35.64451], [-119.53554, 35.63747], [-119.5445, 35.63746], [-119.54453, 35.63473], [-119.56227, 35.63466], [-119.56228, 35.63556], [-119.5667, 35.63557], [-119.56672, 35.63466], [-119.56672, 35.63375], [-119.56894, 35.63374], [-119.56894, 35.63556], [-119.56673, 35.63557], [-119.56671, 35.63648], [-119.5656, 35.63647], [-119.56228, 35.63647], [-119.56226, 35.63737], [-119.57996, 35.63738], [-119.57997, 35.64111]], [[-119.5445, 35.63926], [-119.54451, 35.63927], [-119.54892, 35.63924], [-119.54894, 35.63744], [-119.54452, 35.63746], [-119.5445, 35.63926]]], [[[-119.57113, 35.64487], [-119.571, 35.64832], [-119.57096, 35.65194], [-119.56622, 35.65193], [-119.56626, 35.64877], [-119.56624, 35.64836], [-119.54891, 35.64846], [-119.54898, 35.64468], [-119.56038, 35.64466], [-119.56041, 35.64486], [-119.57113, 35.64487]]], [[[-119.5624, 35.61941], [-119.5623, 35.63012], [-119.55342, 35.63014], [-119.55351, 35.6229], [-119.55793, 35.6229], [-119.55797, 35.61939], [-119.5624, 35.61941]]], [[[-119.57117, 35.63011], [-119.57116, 35.63193], [-119.56895, 35.63193], [-119.56894, 35.63284], [-119.56673, 35.63284], [-119.56673, 35.63193], [-119.56894, 35.63192], [-119.56895, 35.63011], [-119.57117, 35.63011]]], [[[-119.57999, 35.64466], [-119.57999, 35.64522], [-119.57705, 35.64523], [-119.57707, 35.64466], [-119.57999, 35.64466]]], [[[-119.59769, 35.67028], [-119.59764, 35.6761], [-119.59324, 35.67615], [-119.59325, 35.67793], [-119.59762, 35.67791], [-119.59761, 35.67928], [-119.59322, 35.67928], [-119.59317, 35.68115], [-119.58869, 35.68114], [-119.58877, 35.67389], [-119.57999, 35.67388], [-119.58005, 35.67027], [-119.59769, 35.67028]]], [[[-119.61603, 35.6738], [-119.61597, 35.67618], [-119.61571, 35.67622], [-119.61129, 35.67624], [-119.61127, 35.67386], [-119.60655, 35.67391], [-119.60662, 35.65931], [-119.59777, 35.65929], [-119.59771, 35.66659], [-119.58004, 35.66658], [-119.58008, 35.66298], [-119.58008, 35.65926], [-119.58018, 35.65192], [-119.58019, 35.64466], [-119.58436, 35.64466], [-119.58439, 35.64373], [-119.58552, 35.64323], [-119.58553, 35.64466], [-119.58937, 35.64466], [-119.58938, 35.64299], [-119.58883, 35.64298], [-119.58884, 35.64179], [-119.59048, 35.64108], [-119.5978, 35.64104], [-119.60681, 35.64109], [-119.60691, 35.64469], [-119.6067, 35.64471], [-119.60664, 35.65929], [-119.61136, 35.65928], [-119.61129, 35.67385], [-119.61603, 35.6738]], [[-119.59342, 35.6483], [-119.5934, 35.64828], [-119.58895, 35.64829], [-119.58892, 35.65193], [-119.59338, 35.65195], [-119.59342, 35.6483]]], [[[-119.58551, 35.64111], [-119.58551, 35.64274], [-119.58439, 35.64323], [-119.5844, 35.64111], [-119.58551, 35.64111]]]]} Restricted Access 2 Semitropic Ridge Preserve   25298 3014 Center for Natural Lands Management 89 Non Profit 6 Non Profit - Land Trust 10 http://cnlm.org/ Non Governmental Organization 10 3174.959 Semitropic Ridge 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]);