units_with_maps

Table actions

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

4 rows where LABEL_NAME = "Vintage Park"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP

DES_TP 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
2784 2784 2783 {"type": "Polygon", "coordinates": [[[-121.23513, 36.32734], [-121.23453, 36.32767], [-121.23445, 36.32757], [-121.23443, 36.32747], [-121.23439, 36.32741], [-121.23433, 36.32738], [-121.23426, 36.32737], [-121.23419, 36.32738], [-121.23414, 36.32741], [-121.23399, 36.32723], [-121.23469, 36.32683], [-121.23513, 36.32734]]]} Open Access 1 18554 Vintage Park 30768 1124 Greenfield, City of 176 City 2 City Agency 2 http://www.ci.greenfield.ca.us/index.aspx?page=179 City 2 1124 Greenfield, City of 172 City 2 City Agency 2   Monterey 14 1.141 Vintage Park 0 Local Park 2 4
9100 9100 9099 {"type": "Polygon", "coordinates": [[[-117.54994, 34.12662], [-117.54984, 34.12663], [-117.54975, 34.12668], [-117.54969, 34.12674], [-117.54964, 34.12685], [-117.54958, 34.12688], [-117.54963, 34.12708], [-117.54962, 34.12726], [-117.54957, 34.12741], [-117.54945, 34.12762], [-117.54942, 34.12774], [-117.54943, 34.12786], [-117.54947, 34.12797], [-117.54954, 34.12806], [-117.54973, 34.12825], [-117.54977, 34.12834], [-117.5498, 34.12844], [-117.54927, 34.1285], [-117.54833, 34.12851], [-117.54828, 34.12814], [-117.5481, 34.12757], [-117.54808, 34.12755], [-117.54788, 34.12758], [-117.5478, 34.12752], [-117.54792, 34.12745], [-117.54792, 34.12725], [-117.54819, 34.12682], [-117.54824, 34.12664], [-117.54834, 34.12661], [-117.54994, 34.12662]]]} Open Access 1 15084 Vintage Park 27149 1263 Rancho Cucamonga, City of 196 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2   San Bernardino 22 6.946 Vintage Park 0 Local Park 2 4
11742 11742 11741 {"type": "Polygon", "coordinates": [[[-121.38097, 38.46416], [-121.38097, 38.46466], [-121.38093, 38.46494], [-121.38088, 38.46509], [-121.38078, 38.46526], [-121.38066, 38.46542], [-121.38057, 38.46551], [-121.38045, 38.46561], [-121.38027, 38.46573], [-121.38009, 38.46581], [-121.37988, 38.46589], [-121.37948, 38.46596], [-121.37922, 38.46597], [-121.37909, 38.46595], [-121.37907, 38.46592], [-121.37907, 38.46456], [-121.37911, 38.46445], [-121.37909, 38.46439], [-121.3792, 38.46433], [-121.37929, 38.46416], [-121.38097, 38.46416]]]} Open Access 1 24034 Vintage Park 27150 2160 Southgate Recreation and Park District 502 Special District 4 Recreation/Parks District 4 http://www.southgaterecandpark.net/ Special District 4 2160 Southgate Recreation and Park District 494 Special District 4 Recreation/Parks District 4   Sacramento 41 6.991 Vintage Park 0 Local Park 2 4
12806 12806 12805 {"type": "Polygon", "coordinates": [[[-117.65823, 33.6523], [-117.65805, 33.65271], [-117.65789, 33.65323], [-117.65753, 33.65399], [-117.65755, 33.6541], [-117.65746, 33.65409], [-117.65687, 33.65388], [-117.65667, 33.65369], [-117.65668, 33.65365], [-117.65697, 33.65334], [-117.65721, 33.65313], [-117.65773, 33.65215], [-117.65823, 33.6523]]]} Open Access 1 30249 Vintage Park 27148 1167 Lake Forest, City of 235 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1167 Lake Forest, City of 231 City 2 City Agency 2   Orange 3 3.326 Vintage Park 0 Local Park 2 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]);