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 = 4 and MNG_AGENCY = 335

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Peninsula Open Space Trust · 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
4085 4085 4084 {"type": "Polygon", "coordinates": [[[-122.41578, 37.23817], [-122.41569, 37.23824], [-122.40876, 37.23907], [-122.40848, 37.2366], [-122.40732, 37.23475], [-122.41318, 37.23173], [-122.41374, 37.23239], [-122.41406, 37.23283], [-122.41436, 37.23334], [-122.4146, 37.23387], [-122.41476, 37.23431], [-122.41487, 37.23475], [-122.41517, 37.23665], [-122.41524, 37.23699], [-122.41533, 37.23727], [-122.41546, 37.23759], [-122.41559, 37.23786], [-122.41578, 37.23817]]]} No Public Access 3 47457 Pebble Beach Farm 31170 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 95.575 Pebble Beach Farm 0 Private Agricultural 354 4
4329 4329 4328 {"type": "Polygon", "coordinates": [[[-122.38517, 37.32725], [-122.38494, 37.32739], [-122.38456, 37.32774], [-122.38408, 37.32822], [-122.38366, 37.32869], [-122.38338, 37.32908], [-122.38289, 37.32997], [-122.38272, 37.3302], [-122.38257, 37.33035], [-122.38242, 37.33046], [-122.38208, 37.33065], [-122.38183, 37.33074], [-122.3794, 37.33144], [-122.37913, 37.33149], [-122.37883, 37.33149], [-122.37858, 37.33146], [-122.37838, 37.33141], [-122.37842, 37.33132], [-122.37781, 37.33039], [-122.37792, 37.32985], [-122.3777, 37.32951], [-122.37762, 37.32919], [-122.37805, 37.32924], [-122.37853, 37.32895], [-122.379, 37.32892], [-122.37937, 37.32876], [-122.38008, 37.32805], [-122.38082, 37.3248], [-122.38128, 37.32459], [-122.38265, 37.32446], [-122.3834, 37.32467], [-122.38409, 37.32473], [-122.38471, 37.32495], [-122.38517, 37.32725]]]} No Public Access 3 45471 San Gregorio Farm 33759 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 71.471 San Gregorio Farm 0 Private Agricultural 354 4

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