units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, GAP_STS = 2 and MNG_AGENCY = 498

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
6379 6379 6378 {"type": "MultiPolygon", "coordinates": [[[[-121.16326, 35.63247], [-121.16323, 35.63258], [-121.16325, 35.63272], [-121.16305, 35.63292], [-121.16236, 35.63206], [-121.16176, 35.63122], [-121.16061, 35.62972], [-121.16073, 35.62973], [-121.16074, 35.62971], [-121.15941, 35.62815], [-121.15868, 35.62717], [-121.15815, 35.62658], [-121.15762, 35.62605], [-121.15714, 35.62563], [-121.15655, 35.62497], [-121.15629, 35.6247], [-121.15607, 35.6244], [-121.15505, 35.6228], [-121.15437, 35.62187], [-121.15387, 35.6213], [-121.15318, 35.62058], [-121.15384, 35.62023], [-121.15391, 35.62027], [-121.15402, 35.62038], [-121.15398, 35.62055], [-121.15399, 35.62066], [-121.15404, 35.62072], [-121.15429, 35.62079], [-121.15441, 35.62085], [-121.15443, 35.62094], [-121.15454, 35.62111], [-121.15469, 35.62128], [-121.1548, 35.62133], [-121.15502, 35.62137], [-121.1551, 35.62161], [-121.15516, 35.62169], [-121.15517, 35.62177], [-121.15508, 35.62186], [-121.15512, 35.6219], [-121.15526, 35.62199], [-121.1554, 35.62203], [-121.15558, 35.62224], [-121.15568, 35.62231], [-121.1559, 35.62241], [-121.15592, 35.62246], [-121.1559, 35.62267], [-121.15583, 35.62294], [-121.15583, 35.6231], [-121.15585, 35.62314], [-121.15594, 35.62322], [-121.15593, 35.62328], [-121.15578, 35.6233], [-121.15579, 35.62337], [-121.15584, 35.62345], [-121.15595, 35.62358], [-121.15599, 35.62369], [-121.15618, 35.62392], [-121.15624, 35.62401], [-121.15632, 35.62409], [-121.15646, 35.62417], [-121.15658, 35.62427], [-121.15677, 35.62437], [-121.15691, 35.62448], [-121.15717, 35.62474], [-121.15744, 35.62497], [-121.15772, 35.62509], [-121.15786, 35.62519], [-121.15788, 35.62534], [-121.15787, 35.62554], [-121.15785, 35.62565], [-121.15781, 35.62572], [-121.15781, 35.62578], [-121.158, 35.62588], [-121.158, 35.62594], [-121.15806, 35.62604], [-121.15811, 35.62625], [-121.15833, 35.6264], [-121.15849, 35.62657], [-121.15872, 35.62674], [-121.15897, 35.62689], [-121.15904, 35.62695], [-121.15917, 35.62715], [-121.1592, 35.62725], [-121.15922, 35.6273], [-121.15947, 35.62737], [-121.15951, 35.6274], [-121.15955, 35.62756], [-121.15958, 35.62762], [-121.15964, 35.62763], [-121.15971, 35.62773], [-121.15971, 35.62776], [-121.15969, 35.62784], [-121.15984, 35.62823], [-121.15986, 35.62823], [-121.15987, 35.62816], [-121.15993, 35.62817], [-121.16, 35.62848], [-121.16007, 35.6286], [-121.16015, 35.62864], [-121.16025, 35.62873], [-121.16056, 35.62888], [-121.16073, 35.62901], [-121.16075, 35.62912], [-121.16086, 35.62952], [-121.16088, 35.62952], [-121.16094, 35.62936], [-121.16104, 35.62941], [-121.16109, 35.62953], [-121.16107, 35.62964], [-121.16108, 35.62975], [-121.16116, 35.62984], [-121.16155, 35.62988], [-121.16154, 35.62993], [-121.16134, 35.62996], [-121.16133, 35.62997], [-121.16139, 35.63002], [-121.16146, 35.63006], [-121.16147, 35.63016], [-121.16157, 35.63029], [-121.16159, 35.63045], [-121.1618, 35.63049], [-121.16184, 35.63083], [-121.16253, 35.63147], [-121.16288, 35.63191], [-121.16293, 35.63201], [-121.16295, 35.63215], [-121.16313, 35.63224], [-121.16322, 35.63236], [-121.16326, 35.63247]]], [[[-121.18278, 35.64194], [-121.18244, 35.6425], [-121.18122, 35.64207], [-121.1793, 35.64153], [-121.17573, 35.6407], [-121.17417, 35.6403], [-121.17359, 35.64006], [-121.17292, 35.6397], [-121.16994, 35.6383], [-121.17033, 35.63744], [-121.17046, 35.63743], [-121.17056, 35.63748], [-121.17066, 35.63764], [-121.17077, 35.63773], [-121.17105, 35.63807], [-121.1716, 35.63852], [-121.17194, 35.63866], [-121.17239, 35.63893], [-121.17268, 35.63905], [-121.1731, 35.63927], [-121.17337, 35.63947], [-121.17364, 35.63951], [-121.17383, 35.6395], [-121.17422, 35.63958], [-121.1745, 35.6396], [-121.17488, 35.63968], [-121.17506, 35.63981], [-121.17537, 35.64013], [-121.17565, 35.64029], [-121.17598, 35.64037], [-121.17615, 35.64035], [-121.17632, 35.64039], [-121.17654, 35.64039], [-121.17725, 35.64069], [-121.17768, 35.64079], [-121.17787, 35.64079], [-121.17834, 35.64088], [-121.17865, 35.64097], [-121.17915, 35.64103], [-121.1796, 35.64121], [-121.18023, 35.64138], [-121.18051, 35.64138], [-121.18067, 35.64141], [-121.18084, 35.64139], [-121.18111, 35.64148], [-121.1813, 35.64149], [-121.18179, 35.64159], [-121.18198, 35.64162], [-121.18212, 35.64166], [-121.18231, 35.64163], [-121.18249, 35.6417], [-121.18275, 35.64184], [-121.18278, 35.64194]]]]} Open Access 1 1779 Vista Points 27188 3032 Land Conservancy of San Luis Obispo County 506 Non Profit 6 Non Profit - Land Trust 10 http://lcslo.org/ Non Governmental Organization 10 3032 Land Conservancy of San Luis Obispo County 498 Non Profit 6 Non Profit - Land Trust 10   San Luis Obispo 1 36.668 Vista Points 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]);