units_with_maps

Table actions

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

1 row where ACRES = "8195.668", MNG_AGENCY = 335 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • Peninsula Open Space Trust · 1 ✖

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
14133 14133 14132 {"type": "MultiPolygon", "coordinates": [[[[-122.20849, 37.03895], [-122.20774, 37.04537], [-122.20299, 37.06543], [-122.19842, 37.08504], [-122.18438, 37.08286], [-122.18407, 37.08499], [-122.18456, 37.08659], [-122.18512, 37.08703], [-122.18582, 37.08725], [-122.18595, 37.08895], [-122.18438, 37.08984], [-122.18419, 37.09107], [-122.18314, 37.09157], [-122.18216, 37.09181], [-122.18187, 37.09228], [-122.1819, 37.09257], [-122.1816, 37.09318], [-122.1813, 37.09353], [-122.18131, 37.09355], [-122.19588, 37.09597], [-122.19473, 37.10089], [-122.1884, 37.12545], [-122.18624, 37.13506], [-122.1861, 37.13497], [-122.18557, 37.13479], [-122.18461, 37.13435], [-122.18395, 37.13375], [-122.18343, 37.13349], [-122.18229, 37.13277], [-122.18236, 37.1309], [-122.1819, 37.13049], [-122.18223, 37.13005], [-122.18227, 37.12981], [-122.18261, 37.1298], [-122.18278, 37.13035], [-122.18335, 37.13025], [-122.18308, 37.12927], [-122.18249, 37.12937], [-122.18258, 37.1297], [-122.17618, 37.12994], [-122.17542, 37.12787], [-122.17376, 37.12442], [-122.16521, 37.12842], [-122.1644, 37.12829], [-122.16424, 37.12807], [-122.16405, 37.12776], [-122.1632, 37.12631], [-122.16293, 37.12597], [-122.16275, 37.1258], [-122.16245, 37.12559], [-122.16152, 37.1252], [-122.16122, 37.12444], [-122.16116, 37.12436], [-122.16006, 37.12376], [-122.15975, 37.12338], [-122.15883, 37.12287], [-122.1587, 37.1226], [-122.15861, 37.12227], [-122.15884, 37.12155], [-122.15884, 37.12139], [-122.15869, 37.12093], [-122.15726, 37.11922], [-122.15619, 37.11778], [-122.15531, 37.11642], [-122.15489, 37.11582], [-122.15374, 37.11427], [-122.15329, 37.1139], [-122.15189, 37.1132], [-122.1516, 37.11304], [-122.15133, 37.11285], [-122.15108, 37.11265], [-122.15064, 37.11224], [-122.14951, 37.11109], [-122.14858, 37.11051], [-122.14695, 37.11007], [-122.14663, 37.10979], [-122.1459, 37.10868], [-122.14507, 37.10836], [-122.1451, 37.10768], [-122.14323, 37.10677], [-122.14216, 37.10396], [-122.14289, 37.10266], [-122.14355, 37.10188], [-122.14419, 37.10142], [-122.14459, 37.10103], [-122.145, 37.10046], [-122.14599, 37.09888], [-122.14813, 37.09608], [-122.1526, 37.09031], [-122.15435, 37.08702], [-122.15368, 37.08583], [-122.15319, 37.08545], [-122.1535, 37.08473], [-122.15315, 37.08383], [-122.15361, 37.08288], [-122.15423, 37.08234], [-122.15509, 37.08177], [-122.15449, 37.07867], [-122.15532, 37.07661], [-122.15469, 37.07477], [-122.16265, 37.06826], [-122.16347, 37.06734], [-122.16394, 37.06713], [-122.16448, 37.06601], [-122.16446, 37.0658], [-122.16456, 37.06463], [-122.16383, 37.06289], [-122.16492, 37.06221], [-122.16664, 37.06137], [-122.16756, 37.06135], [-122.16806, 37.06095], [-122.16785, 37.06029], [-122.16833, 37.06012], [-122.16848, 37.06056], [-122.1689, 37.06068], [-122.16921, 37.06037], [-122.16966, 37.06046], [-122.16983, 37.06047], [-122.17014, 37.06047], [-122.17061, 37.06042], [-122.17084, 37.06043], [-122.17118, 37.0605], [-122.17141, 37.06058], [-122.17177, 37.06075], [-122.17206, 37.06094], [-122.17214, 37.06098], [-122.17231, 37.06101], [-122.17245, 37.06102], [-122.17261, 37.06101], [-122.17299, 37.06092], [-122.17325, 37.06089], [-122.17343, 37.06089], [-122.17379, 37.06095], [-122.174, 37.06103], [-122.17398, 37.05437], [-122.17845, 37.05438], [-122.17844, 37.05084], [-122.17396, 37.05083], [-122.17396, 37.04733], [-122.16939, 37.0473], [-122.16065, 37.04754], [-122.1608, 37.04027], [-122.17396, 37.04019], [-122.17451, 37.0396], [-122.17648, 37.03937], [-122.17738, 37.03965], [-122.17719, 37.03971], [-122.17661, 37.03985], [-122.17629, 37.03999], [-122.1761, 37.04011], [-122.17593, 37.04026], [-122.17573, 37.0405], [-122.17563, 37.04068], [-122.17554, 37.04096], [-122.17549, 37.04159], [-122.17546, 37.04175], [-122.17537, 37.04196], [-122.17521, 37.0422], [-122.17511, 37.04246], [-122.17509, 37.04264], [-122.1751, 37.04282], [-122.17514, 37.043], [-122.17518, 37.04309], [-122.17556, 37.04313], [-122.17548, 37.04298], [-122.17544, 37.04282], [-122.17544, 37.04257], [-122.17551, 37.04233], [-122.17571, 37.04202], [-122.17578, 37.04186], [-122.17582, 37.04169], [-122.17587, 37.04107], [-122.1759, 37.04094], [-122.17598, 37.04072], [-122.1761, 37.04054], [-122.1763, 37.04034], [-122.17656, 37.04018], [-122.17685, 37.04007], [-122.17739, 37.03995], [-122.17758, 37.03987], [-122.17777, 37.03977], [-122.18066, 37.04065], [-122.18094, 37.04163], [-122.18109, 37.04201], [-122.18147, 37.04244], [-122.18205, 37.04278], [-122.18244, 37.04391], [-122.20017, 37.04577], [-122.20022, 37.04569], [-122.20041, 37.04519], [-122.2004, 37.04498], [-122.20136, 37.04424], [-122.20252, 37.04371], [-122.20661, 37.04251], [-122.20646, 37.04228], [-122.20681, 37.0422], [-122.20708, 37.04229], [-122.20729, 37.04229], [-122.20786, 37.04143], [-122.20802, 37.04078], [-122.20811, 37.04063], [-122.20796, 37.04005], [-122.20816, 37.03988], [-122.20837, 37.03901], [-122.20849, 37.03895]], [[-122.19563, 37.05623], [-122.19595, 37.05595], [-122.19627, 37.05545], [-122.19701, 37.05489], [-122.19743, 37.05451], [-122.19149, 37.04872], [-122.18633, 37.05292], [-122.18883, 37.05685], [-122.19538, 37.05764], [-122.19545, 37.05742], [-122.19554, 37.05726], [-122.19557, 37.05714], [-122.19548, 37.05701], [-122.19556, 37.05644], [-122.19563, 37.05623]]], [[[-122.18623, 37.13512], [-122.18531, 37.13922], [-122.17559, 37.13654], [-122.17015, 37.13295], [-122.17627, 37.13022], [-122.17622, 37.13003], [-122.1822, 37.12981], [-122.18216, 37.13004], [-122.1818, 37.1305], [-122.18232, 37.13093], [-122.18225, 37.13281], [-122.18339, 37.13353], [-122.18391, 37.13379], [-122.18456, 37.13439], [-122.18556, 37.13484], [-122.18606, 37.13501], [-122.18623, 37.13512]]]]} No Public Access 3 42002 San Vicente Redwoods (CEMEX) 30543 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   Santa Cruz 5 8195.668 San Vicente Redwoods (CEMEX) 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]);