units_with_maps

Table actions

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

1 row where LABEL_NAME = "Irvine holding 34" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
13580 13580 13579 {"type": "Polygon", "coordinates": [[[-117.80396, 33.64107], [-117.80396, 33.64112], [-117.80374, 33.64164], [-117.80314, 33.64277], [-117.80274, 33.64322], [-117.80242, 33.64354], [-117.80194, 33.64391], [-117.80165, 33.6441], [-117.80106, 33.64457], [-117.80096, 33.64445], [-117.80118, 33.64398], [-117.80083, 33.64358], [-117.80062, 33.64323], [-117.80029, 33.64303], [-117.79964, 33.64319], [-117.79923, 33.64338], [-117.79861, 33.64339], [-117.79819, 33.64357], [-117.79816, 33.64384], [-117.79842, 33.6443], [-117.79882, 33.64487], [-117.79941, 33.64501], [-117.79997, 33.64541], [-117.80051, 33.64544], [-117.80045, 33.64562], [-117.79855, 33.64577], [-117.79854, 33.64522], [-117.79733, 33.64384], [-117.79708, 33.64124], [-117.79687, 33.63574], [-117.797, 33.63513], [-117.79746, 33.63464], [-117.79784, 33.63446], [-117.79835, 33.63423], [-117.79904, 33.63419], [-117.79949, 33.6352], [-117.79913, 33.63538], [-117.7986, 33.63499], [-117.79819, 33.63499], [-117.79775, 33.63574], [-117.79766, 33.63616], [-117.7978, 33.63669], [-117.79787, 33.63705], [-117.79733, 33.63747], [-117.79752, 33.63777], [-117.7974, 33.6381], [-117.79773, 33.63832], [-117.79808, 33.63834], [-117.79815, 33.63864], [-117.79798, 33.63865], [-117.79783, 33.63892], [-117.7982, 33.6397], [-117.79843, 33.63997], [-117.79891, 33.64006], [-117.79921, 33.64003], [-117.79918, 33.64027], [-117.79892, 33.64018], [-117.79847, 33.64017], [-117.79785, 33.64092], [-117.79796, 33.64133], [-117.79803, 33.64169], [-117.79838, 33.64186], [-117.79881, 33.64176], [-117.7991, 33.64121], [-117.79939, 33.6412], [-117.7999, 33.64134], [-117.80033, 33.64144], [-117.8006, 33.64133], [-117.80085, 33.64103], [-117.80101, 33.64066], [-117.80106, 33.64024], [-117.80109, 33.63981], [-117.80132, 33.63976], [-117.80168, 33.64014], [-117.80205, 33.64044], [-117.80238, 33.64062], [-117.80272, 33.64077], [-117.80382, 33.64099], [-117.80396, 33.64107]]]} Open Access 1 35911 Irvine holding 34 20265 1148 Irvine, City of 271 City 2 City Agency 2 http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp City 2 1148 Irvine, City of 266 City 2 City Agency 2   Orange 3 63.416 Irvine holding 34 0 Local Other or Unknown 14 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]);