superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, LAYER = 10 and MNG_AGENCY = 137

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Land Trust of Napa County · 2 ✖

ACCESS_TYP 1

  • No Public 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
13136 13136 13135 {"type": "Polygon", "coordinates": [[[-122.61347, 38.57103], [-122.60977, 38.57104], [-122.60939, 38.57019], [-122.60879, 38.56687], [-122.61337, 38.56677], [-122.61347, 38.57103]]]} No Public Access 3 Willer Donation   31822 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 42.634 Willer Donation 2010
13868 13868 13867 {"type": "Polygon", "coordinates": [[[-122.40763, 38.56593], [-122.40662, 38.56777], [-122.39871, 38.56771], [-122.39845, 38.56769], [-122.39832, 38.56763], [-122.39815, 38.56748], [-122.39786, 38.56727], [-122.39744, 38.56723], [-122.39806, 38.56708], [-122.3984, 38.5669], [-122.39855, 38.56672], [-122.3986, 38.56653], [-122.39852, 38.56635], [-122.39829, 38.56621], [-122.39817, 38.5661], [-122.39812, 38.566], [-122.39819, 38.56588], [-122.39834, 38.56571], [-122.39836, 38.56558], [-122.39834, 38.56548], [-122.39823, 38.56528], [-122.39821, 38.56511], [-122.39512, 38.56389], [-122.39492, 38.56386], [-122.39459, 38.56008], [-122.39764, 38.56007], [-122.39939, 38.56002], [-122.39966, 38.56387], [-122.40438, 38.56388], [-122.40442, 38.56433], [-122.40763, 38.56593]]]} No Public Access 3 Okin Preserve   31422 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 122.868 Okin 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]);