units_with_maps

Table actions

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

3 rows where AGNCY_NAME = 128 and DES_TP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 3 ✖

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
2998 2998 2997 {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} Restricted Access 2 20562 Veterans Park Soccer Complex 29804 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2 http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park Los Angeles 6 10.986 Veterans Park Soccer Complex 0 Local Recreation Area 3 4
15711 15711 15710 {"type": "Polygon", "coordinates": [[[-117.77156, 34.04612], [-117.76587, 34.04476], [-117.76552, 34.04462], [-117.76521, 34.04446], [-117.76488, 34.04424], [-117.7645, 34.04391], [-117.76436, 34.04383], [-117.76422, 34.04378], [-117.76445, 34.0437], [-117.76472, 34.04357], [-117.76489, 34.04352], [-117.76514, 34.0435], [-117.76538, 34.04355], [-117.76558, 34.04364], [-117.7658, 34.0438], [-117.76599, 34.04392], [-117.76629, 34.04406], [-117.76668, 34.04416], [-117.76724, 34.04422], [-117.76742, 34.04426], [-117.76758, 34.04433], [-117.76781, 34.04447], [-117.76801, 34.04463], [-117.76823, 34.04472], [-117.76833, 34.04478], [-117.76841, 34.0449], [-117.76844, 34.04503], [-117.76865, 34.04508], [-117.76889, 34.04508], [-117.76912, 34.04501], [-117.76925, 34.04493], [-117.76936, 34.04478], [-117.76944, 34.04474], [-117.76951, 34.04474], [-117.76962, 34.04477], [-117.76971, 34.04478], [-117.76984, 34.04475], [-117.76993, 34.04469], [-117.77001, 34.04466], [-117.77071, 34.04468], [-117.7708, 34.04466], [-117.77091, 34.04461], [-117.771, 34.04453], [-117.77106, 34.04446], [-117.77107, 34.04492], [-117.77111, 34.04498], [-117.77134, 34.04494], [-117.77152, 34.04494], [-117.77156, 34.04612]]]} Restricted Access 2 28355 Palm Lake Golf Course 33090 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2   Los Angeles 6 15.151 Palm Lake GC 0 Local Recreation Area 3 4
17051 17051 17050 {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} Restricted Access 2 46518 Renacimiento Community Center 29805 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2 http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center Los Angeles 6 0.157 Renacimiento Community Ctr. 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]);