units_with_maps

Table actions

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

1 row where DES_TP = 3, MNG_AG_TYP = 2 and SUID_NMA = 23241

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 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
16160 16160 16159 {"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.99287, 32.55313], [-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.58122], [-117.00082, 32.58039], [-117.00078, 32.58019], [-117.00063, 32.57963], [-117.00064, 32.5796], [-117.00069, 32.57957], [-117.00099, 32.57955], [-117.00123, 32.57957], [-117.00147, 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.00459, 32.58233], [-117.00507, 32.5824], [-117.0055, 32.58251], [-117.00631, 32.58265], [-117.00641, 32.58271], [-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.55808], [-117.01566, 32.55807], [-117.01566, 32.55753], [-117.01632, 32.55754], [-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.01842, 32.55542], [-117.01776, 32.55541], [-117.01776, 32.55488], [-117.01841, 32.55489], [-117.01842, 32.55542]]]]} Open Access 1 19940 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 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 47.301 Otay Mesa OS 0 Local Recreation Area 3 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]);