units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, LAYER = 10 and MNG_AGENCY = 730

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Friends of the Enchanted Meadow · 2 ✖

ACCESS_TYP 1

  • Open 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
4321 4321 4320 {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72539, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24933], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} Open Access 1 45423 Raven's Call 28205 3353 Friends of the Enchanted Meadow 744 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/ Non Governmental Organization 10 3353 Friends of the Enchanted Meadow 730 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/raven.html Mendocino 24 23.564 Raven's Call 0 Private Conservation 16 2
4322 4322 4321 {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} Open Access 1 45424 Albert Cattalini Conservancy 28204 3353 Friends of the Enchanted Meadow 744 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/ Non Governmental Organization 10 3353 Friends of the Enchanted Meadow 730 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/acc.html Mendocino 24 9.326 Albert Cattalini Conservancy 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]);