superunits_with_maps

Table actions

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

1 row where MNG_AGENCY = 129 and PARK_NAME = "Poway holding 15"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Poway, City of · 1 ✖

ACCESS_TYP 1

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
8349 8349 8348 {"type": "Polygon", "coordinates": [[[-117.03223, 33.02732], [-117.03223, 33.0274], [-117.0322, 33.02753], [-117.03215, 33.02762], [-117.03205, 33.02772], [-117.03127, 33.02818], [-117.03061, 33.02847], [-117.0306, 33.02849], [-117.03032, 33.02863], [-117.03001, 33.0288], [-117.02974, 33.029], [-117.02938, 33.0293], [-117.02869, 33.03006], [-117.02813, 33.0297], [-117.02657, 33.03019], [-117.02603, 33.02982], [-117.0251, 33.03029], [-117.02605, 33.0314], [-117.0269, 33.03161], [-117.02686, 33.03184], [-117.02659, 33.03256], [-117.02724, 33.033], [-117.02797, 33.03252], [-117.02827, 33.03267], [-117.02924, 33.03206], [-117.0295, 33.03206], [-117.02948, 33.03383], [-117.02838, 33.03472], [-117.02818, 33.03446], [-117.0279, 33.03436], [-117.02771, 33.03419], [-117.02742, 33.03411], [-117.02695, 33.0341], [-117.02667, 33.03402], [-117.02625, 33.03381], [-117.0261, 33.03365], [-117.02591, 33.03327], [-117.0258, 33.03295], [-117.02576, 33.03258], [-117.02564, 33.03202], [-117.02522, 33.03132], [-117.025, 33.03105], [-117.02385, 33.03105], [-117.02384, 33.03093], [-117.02385, 33.03065], [-117.02391, 33.03028], [-117.02402, 33.02997], [-117.02464, 33.02858], [-117.0247, 33.0283], [-117.02472, 33.02802], [-117.02485, 33.02804], [-117.02495, 33.02809], [-117.02502, 33.02815], [-117.02554, 33.02893], [-117.02562, 33.029], [-117.0257, 33.02903], [-117.02583, 33.02904], [-117.02616, 33.02969], [-117.02721, 33.02928], [-117.02638, 33.02771], [-117.02468, 33.02715], [-117.02468, 33.02703], [-117.02471, 33.02682], [-117.0248, 33.02653], [-117.02499, 33.02615], [-117.02518, 33.0259], [-117.02544, 33.02565], [-117.02558, 33.02549], [-117.02571, 33.02529], [-117.02582, 33.02506], [-117.02599, 33.02482], [-117.02616, 33.02465], [-117.0263, 33.02454], [-117.02641, 33.02447], [-117.02699, 33.02415], [-117.02723, 33.02395], [-117.02739, 33.02372], [-117.0276, 33.02315], [-117.02778, 33.02287], [-117.02823, 33.02236], [-117.02878, 33.02179], [-117.02904, 33.02156], [-117.0294, 33.02128], [-117.02955, 33.02114], [-117.02965, 33.02101], [-117.02975, 33.02084], [-117.02982, 33.02064], [-117.02983, 33.02055], [-117.03008, 33.02029], [-117.03024, 33.02009], [-117.03044, 33.02005], [-117.03062, 33.02005], [-117.03074, 33.02008], [-117.03085, 33.02012], [-117.03099, 33.02023], [-117.03117, 33.02048], [-117.03075, 33.02071], [-117.0303, 33.02441], [-117.03108, 33.02717], [-117.03195, 33.02699], [-117.03213, 33.02697], [-117.03223, 33.02732]], [[-117.02995, 33.02738], [-117.03026, 33.02759], [-117.03048, 33.02762], [-117.03068, 33.02742], [-117.0306, 33.02717], [-117.03001, 33.0271], [-117.02995, 33.02738]]]} Open Access 1 Poway holding 15   23938 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 119.195 Poway holding 15  

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]);