superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, ACRES = "2.623" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 3 ✖
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
2979 2979 2978 {"type": "Polygon", "coordinates": [[[-119.64751, 36.3284], [-119.64751, 36.32857], [-119.6471, 36.32858], [-119.64708, 36.32947], [-119.64617, 36.32947], [-119.64618, 36.32839], [-119.64751, 36.3284]]]} Open Access 1 Civic Center Park   17358 1129 Hanford, City of 346 City 2 City Agency 2 http://www.ci.hanford.ca.us/depts/rec/default.asp City 2 2.623 Civic Ctr. Park  
9942 9942 9941 {"type": "Polygon", "coordinates": [[[-118.21331, 34.05275], [-118.21287, 34.05342], [-118.21238, 34.05314], [-118.21168, 34.05282], [-118.21184, 34.05257], [-118.21177, 34.05252], [-118.21199, 34.05217], [-118.21331, 34.05275]]]} Open Access 1 State Street Recreation Center   25812 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 2.623 State Street Rec. Ctr.  
13662 13662 13661 {"type": "Polygon", "coordinates": [[[-117.83498, 33.59186], [-117.83357, 33.592], [-117.83332, 33.59203], [-117.83324, 33.59168], [-117.83368, 33.59129], [-117.8341, 33.59125], [-117.83427, 33.59117], [-117.83438, 33.59126], [-117.83474, 33.59141], [-117.83496, 33.59132], [-117.83498, 33.59186]]]} Open Access 1 Los Trancos Canyon View Park (Upper)   31132 1224 Newport Beach, City of 52 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 2.623 Los Trancos Canyon View Park (Upper)  

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