units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, GAP_STS = 2 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 UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
2231 2231 2230 {"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 47877 Willer Donation 31822 3035 Land Trust of Napa County 140 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10   Napa 11 42.637 Willer Donation 2010 Private Conservation 16 2
4195 4195 4194 {"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.56634], [-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.39822, 38.56512], [-122.39512, 38.56389], [-122.39492, 38.56386], [-122.39459, 38.56008], [-122.39764, 38.56007], [-122.39939, 38.56002], [-122.39966, 38.56388], [-122.40438, 38.56388], [-122.40441, 38.56433], [-122.40763, 38.56593]]]} No Public Access 3 47684 Okin Preserve 31422 3035 Land Trust of Napa County 140 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10   Napa 11 122.836 Okin Preserve 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);