superunits_with_maps

Table actions

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

1 row where ACRES = "188.843" and MNG_AGENCY = 593

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • American River Conservancy · 1 ✖

ACCESS_TYP 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
2305 2305 2304 {"type": "Polygon", "coordinates": [[[-121.03542, 38.78141], [-121.03507, 38.78183], [-121.0346, 38.78212], [-121.03407, 38.78232], [-121.03329, 38.78251], [-121.03295, 38.78277], [-121.03281, 38.78309], [-121.03251, 38.78343], [-121.03212, 38.78352], [-121.03173, 38.78352], [-121.03122, 38.78337], [-121.0308, 38.78336], [-121.03049, 38.78342], [-121.03022, 38.78367], [-121.02605, 38.7837], [-121.02584, 38.77615], [-121.02577, 38.77476], [-121.02639, 38.77374], [-121.02717, 38.77352], [-121.03036, 38.77412], [-121.0309, 38.77359], [-121.03129, 38.77362], [-121.03139, 38.7737], [-121.03083, 38.77451], [-121.03091, 38.7753], [-121.03245, 38.77575], [-121.03465, 38.7743], [-121.03466, 38.77614], [-121.02818, 38.77614], [-121.02817, 38.77615], [-121.03315, 38.77619], [-121.03315, 38.77636], [-121.03329, 38.77676], [-121.03362, 38.77707], [-121.03421, 38.77714], [-121.03468, 38.77725], [-121.03503, 38.77769], [-121.03515, 38.77801], [-121.03499, 38.77838], [-121.03517, 38.77907], [-121.03541, 38.77968], [-121.03542, 38.78141]]]} No Public Access 3 Brush Creek Ranch   16454 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 188.843 Brush Creek Ranch  

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