superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and PARK_NAME = "Otay Mesa Open Space"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
6603 6603 6602 {"type": "MultiPolygon", "coordinates": [[[[-116.99614, 32.55382], [-116.99272, 32.55373], [-116.9927, 32.55115], [-116.99317, 32.55135], [-116.99337, 32.55162], [-116.99346, 32.55187], [-116.99337, 32.55212], [-116.99284, 32.55268], [-116.99288, 32.55314], [-116.993, 32.55322], [-116.99356, 32.55323], [-116.99449, 32.55257], [-116.99481, 32.55243], [-116.99513, 32.55248], [-116.99536, 32.55264], [-116.99588, 32.55353], [-116.99614, 32.55382]]], [[[-116.99975, 32.55984], [-116.99974, 32.56101], [-116.9991, 32.561], [-116.99909, 32.56041], [-116.99846, 32.56039], [-116.99846, 32.55982], [-116.9991, 32.55982], [-116.99911, 32.55925], [-116.99975, 32.55927], [-116.99975, 32.55984]]], [[[-117.0072, 32.58335], [-117.00152, 32.58305], [-117.00113, 32.58209], [-117.00111, 32.58168], [-117.00104, 32.58123], [-117.00082, 32.58039], [-117.00078, 32.58018], [-117.00063, 32.57963], [-117.00064, 32.5796], [-117.00069, 32.57957], [-117.00099, 32.57955], [-117.00123, 32.57957], [-117.00146, 32.57962], [-117.00175, 32.57971], [-117.00249, 32.58005], [-117.00282, 32.58016], [-117.0028, 32.58045], [-117.00282, 32.58056], [-117.00279, 32.58072], [-117.00256, 32.58103], [-117.00259, 32.58116], [-117.00277, 32.58158], [-117.003, 32.58199], [-117.00306, 32.58232], [-117.00312, 32.58247], [-117.00322, 32.5829], [-117.00351, 32.58313], [-117.00379, 32.58303], [-117.00401, 32.58283], [-117.00406, 32.58272], [-117.00457, 32.58226], [-117.0046, 32.58233], [-117.00507, 32.5824], [-117.0055, 32.58251], [-117.00631, 32.58265], [-117.00641, 32.58272], [-117.00678, 32.5828], [-117.00708, 32.58309], [-117.00713, 32.58329], [-117.0072, 32.58335]]], [[[-117.01488, 32.5586], [-117.01422, 32.55859], [-117.01422, 32.55805], [-117.01487, 32.55806], [-117.01488, 32.5586]]], [[[-117.01697, 32.55863], [-117.01632, 32.55862], [-117.01631, 32.55809], [-117.01566, 32.55807], [-117.01566, 32.55753], [-117.01631, 32.55753], [-117.01632, 32.55647], [-117.01697, 32.55648], [-117.01697, 32.55863]]], [[[-117.01697, 32.55486], [-117.01631, 32.55485], [-117.01631, 32.55431], [-117.01697, 32.55433], [-117.01697, 32.55486]]], [[[-117.01842, 32.55758], [-117.0171, 32.55756], [-117.0171, 32.55648], [-117.01841, 32.5565], [-117.01842, 32.55758]]], [[[-117.01841, 32.55812], [-117.01841, 32.55865], [-117.0171, 32.55863], [-117.0171, 32.55809], [-117.01841, 32.55812]]], [[[-117.01841, 32.55542], [-117.01776, 32.55541], [-117.01776, 32.55488], [-117.01841, 32.55489], [-117.01841, 32.55542]]]]} Open Access 1 Otay Mesa Open Space   23241 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 47.324 Otay Mesa OS  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);