units_with_maps

Table actions

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

2 rows where COUNTY = 40, MNG_AGENCY = 551 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 2 ✖

MNG_AGENCY 1

  • Tuleyome · 2 ✖

ACCESS_TYP 1

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
2820 2820 2819 {"type": "Polygon", "coordinates": [[[-122.5547, 39.07288], [-122.54077, 39.07244], [-122.52192, 39.07296], [-122.51717, 39.07356], [-122.51634, 39.05553], [-122.52099, 39.05524], [-122.52083, 39.05168], [-122.53935, 39.05086], [-122.54017, 39.06525], [-122.54047, 39.06885], [-122.55439, 39.06917], [-122.5547, 39.07288]]]} Open Access 1 48614 Silver Spur Ranch 33328 3095 Tuleyome 558 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://tuleyome.org/properties/ Lake 40 1270.865 Silver Spur Ranch 2016 Private Conservation 16 2
10539 10539 10538 {"type": "MultiPolygon", "coordinates": [[[[-122.70762, 39.22992], [-122.70761, 39.23359], [-122.70258, 39.23362], [-122.69033, 39.23329], [-122.6873, 39.23318], [-122.68712, 39.22951], [-122.68979, 39.22966], [-122.70275, 39.23006], [-122.70762, 39.22992]]], [[[-122.72176, 39.22676], [-122.71711, 39.22651], [-122.71709, 39.23007], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22983], [-122.70762, 39.22992], [-122.70772, 39.22628], [-122.71247, 39.22625], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409]]]]} Open Access 1 48615 Goat Mountain Property 33329 3095 Tuleyome 558 Non Profit 6 Non Profit - Land Trust 10 http://www.tuleyome.org/ Non Governmental Organization 10 3095 Tuleyome 551 Non Profit 6 Non Profit - Land Trust 10 http://tuleyome.org/properties/ Lake 40 663.188 Goat Mtn. Property 2011 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]);