units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 3, AGNCY_TYP = 10 and DES_TP = 354

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, LABEL_NAME

MNG_AG_TYP 1

DES_TP 1

  • Private Agricultural · 5 ✖

ACCESS_TYP 1

  • No Public Access · 5 ✖
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
10341 10341 10340 {"type": "Polygon", "coordinates": [[[-121.80063, 36.71388], [-121.80041, 36.71423], [-121.7996, 36.71582], [-121.79919, 36.71731], [-121.79904, 36.71798], [-121.7999, 36.72298], [-121.79929, 36.72379], [-121.79896, 36.72387], [-121.79857, 36.72412], [-121.7987, 36.72467], [-121.79841, 36.72503], [-121.78914, 36.72115], [-121.78929, 36.72074], [-121.78951, 36.72025], [-121.78977, 36.71978], [-121.79008, 36.71932], [-121.79048, 36.71881], [-121.79226, 36.7168], [-121.79248, 36.71652], [-121.79262, 36.71625], [-121.79275, 36.7159], [-121.7928, 36.71561], [-121.7928, 36.71522], [-121.79283, 36.71498], [-121.79292, 36.71464], [-121.79304, 36.71435], [-121.79323, 36.71404], [-121.7935, 36.7137], [-121.79382, 36.71339], [-121.79419, 36.71313], [-121.79445, 36.71299], [-121.79473, 36.71286], [-121.79768, 36.71187], [-121.79791, 36.71182], [-121.79815, 36.71178], [-121.79842, 36.71177], [-121.79863, 36.71178], [-121.79889, 36.71183], [-121.79883, 36.712], [-121.79968, 36.71227], [-121.79995, 36.71261], [-121.80063, 36.71388]]]} No Public Access 3 18242 Ocean Mist Farm 23054 3042 Ag Land Trust 947 Non Profit 6 Non Profit - Land Trust 10 http://aglandtrust.org/ Non Governmental Organization 10 3042 Ag Land Trust 919 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 222.013 Ocean Mist Farm 0 Private Agricultural 354 4
14592 14592 14591 {"type": "Polygon", "coordinates": [[[-121.50388, 36.97423], [-121.49381, 36.97987], [-121.49263, 36.98059], [-121.49332, 36.98142], [-121.4935, 36.98161], [-121.49377, 36.98195], [-121.48591, 36.98642], [-121.48466, 36.98592], [-121.48745, 36.98306], [-121.48758, 36.9831], [-121.48771, 36.98296], [-121.48839, 36.98317], [-121.49944, 36.9734], [-121.50077, 36.97148], [-121.50388, 36.97423]]]} No Public Access 3 44803 Gonzales Farm 28146 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   Santa Clara 19 111.334 Gonzales Farm 0 Private Agricultural 354 4
14593 14593 14592 {"type": "Polygon", "coordinates": [[[-121.50077, 36.97148], [-121.49944, 36.9734], [-121.48839, 36.98317], [-121.48771, 36.98296], [-121.48823, 36.98239], [-121.49949, 36.97035], [-121.50077, 36.97148]]]} No Public Access 3 44804 Gonzales Farm 28146 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   San Benito 38 59.149 Gonzales 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]);