superunits_with_maps

Table actions

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

2 rows where LAYER = 5, MNG_AGENCY = 378 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

MNG_AGENCY 1

  • San Diego State University · 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
13006 13006 13005 {"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15547, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14836, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14522, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]} No Public Access 3 Santa Margarita Ecological Reserve https://fsp.sdsu.edu/about-us/ 33343 221 San Diego State University 378 State 5 State Agency 5 http://www.sdsu.edu/ Other State 5 243.201 Santa Margarita ER 1962
14536 14536 14535 {"type": "MultiPolygon", "coordinates": [[[[-117.20651, 33.43216], [-117.20644, 33.44303], [-117.19757, 33.44297], [-117.1975, 33.44656], [-117.19751, 33.44657], [-117.20642, 33.44665], [-117.20637, 33.45054], [-117.16741, 33.4645], [-117.16732, 33.46177], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.15938, 33.4648], [-117.15931, 33.46482], [-117.15421, 33.46507], [-117.14525, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46152], [-117.14069, 33.45435], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15378, 33.43266], [-117.15812, 33.43261], [-117.15812, 33.43977], [-117.15813, 33.43978], [-117.16663, 33.43969], [-117.16672, 33.43254], [-117.17132, 33.43242], [-117.17338, 33.43238], [-117.17327, 33.42847], [-117.1779, 33.42839], [-117.1779, 33.43232], [-117.18245, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42931], [-117.19526, 33.42932], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19589, 33.43216], [-117.20651, 33.43216]], [[-117.17573, 33.43756], [-117.17571, 33.43677], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17359, 33.44318], [-117.17439, 33.44316], [-117.17551, 33.43984], [-117.17588, 33.43855], [-117.17623, 33.43758], [-117.17573, 33.43756]]], [[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]]]} Restricted Access 2 Santa Margarita Ecological Reserve https://fsp.sdsu.edu/about-us/ 33342 221 San Diego State University 378 State 5 State Agency 5 http://www.sdsu.edu/ Other State 5 4355.304 Santa Margarita ER 1962

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