superunits_with_maps

Table actions

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

7 rows where ACCESS_TYP = 1 and MNG_AGENCY = 321

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Shasta Lake, City of · 7 ✖

ACCESS_TYP 1

  • Open Access · 7 ✖
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
850 850 849 {"type": "Polygon", "coordinates": [[[-122.36952, 40.67363], [-122.36948, 40.67469], [-122.36818, 40.67463], [-122.36816, 40.6744], [-122.36828, 40.67405], [-122.36842, 40.67378], [-122.3686, 40.67367], [-122.36884, 40.67359], [-122.36924, 40.67359], [-122.36952, 40.67363]]]} Open Access 1 Wynne Price Park and Baseball Field https://cityofshastalake.org/553/Parks 33567 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 2.931 Wynne Price Park and Baseball Field  
3004 3004 3003 {"type": "Polygon", "coordinates": [[[-122.36347, 40.68196], [-122.36203, 40.68196], [-122.36202, 40.68114], [-122.36346, 40.68114], [-122.36347, 40.68196]]]} Open Access 1 Clair Engle Park   17375 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 2.752 Clair Engle Park  
11798 11798 11797 {"type": "Polygon", "coordinates": [[[-122.40214, 40.68797], [-122.40213, 40.69102], [-122.40084, 40.69077], [-122.40011, 40.69066], [-122.39937, 40.6906], [-122.39804, 40.69057], [-122.39823, 40.68801], [-122.40214, 40.68797]]]} Open Access 1 Margaret Polf Park http://www.ci.shasta-lake.ca.us/index.aspx?NID=553 28432 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 25.305 Margaret Polf Park  
13791 13791 13790 {"type": "Polygon", "coordinates": [[[-122.39795, 40.68894], [-122.39783, 40.69056], [-122.3966, 40.69054], [-122.39628, 40.69051], [-122.39582, 40.69042], [-122.39539, 40.69028], [-122.39545, 40.68923], [-122.39693, 40.68922], [-122.39713, 40.68908], [-122.39766, 40.68891], [-122.39795, 40.68894]]]} Open Access 1 Bizz Johnson Ball Park https://cityofshastalake.org/553/Parks 33124 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 7.801 Bizz Johnson Ball Park  
13795 13795 13794 {"type": "Polygon", "coordinates": [[[-122.35054, 40.66356], [-122.35029, 40.66413], [-122.34893, 40.66376], [-122.34919, 40.66319], [-122.35054, 40.66356]]]} Open Access 1 Akard Park https://cityofshastalake.org/553/Parks 33125 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 2.014 Akard Park  
13796 13796 13795 {"type": "Polygon", "coordinates": [[[-122.38681, 40.68982], [-122.38668, 40.69007], [-122.38662, 40.69033], [-122.38644, 40.69032], [-122.38656, 40.68978], [-122.3866, 40.68974], [-122.38668, 40.68971], [-122.38678, 40.68975], [-122.3868, 40.68977], [-122.38681, 40.68982]]]} Open Access 1 Shasta Park https://cityofshastalake.org/553/Parks 33126 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 0.284 Shasta Park  
13797 13797 13796 {"type": "Polygon", "coordinates": [[[-122.37519, 40.68902], [-122.37481, 40.68902], [-122.37446, 40.68819], [-122.37432, 40.68767], [-122.37432, 40.68736], [-122.37481, 40.68737], [-122.37482, 40.68864], [-122.37489, 40.68876], [-122.37516, 40.68898], [-122.37519, 40.68902]]]} Open Access 1 Blue Canyon Park https://cityofshastalake.org/553/Parks 33127 1438 Shasta Lake, City of 321 City 2 City Agency 2 http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 City 2 1.375 Blue Canyon Park  

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