superunits_with_maps

Table actions

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

5 rows where MNG_AGENCY = 761 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

  • Point Arena, City of · 5 ✖

ACCESS_TYP 1

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
861 861 860 {"type": "Polygon", "coordinates": [[[-123.71027, 38.91481], [-123.70981, 38.91483], [-123.70989, 38.91463], [-123.70916, 38.91441], [-123.70848, 38.91412], [-123.70852, 38.91404], [-123.70851, 38.91403], [-123.70629, 38.91322], [-123.70628, 38.91295], [-123.70876, 38.91318], [-123.70976, 38.91348], [-123.70998, 38.91406], [-123.71015, 38.91455], [-123.71027, 38.91481]]]} Open Access 1 Point Arena Cove & Fishing Pier https://www.mendocino.com/?id=3423&url= 32724 1697 Point Arena, City of 761 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 6.993 Point Arena Cove & Fishing Pier  
14034 14034 14033 {"type": "Polygon", "coordinates": [[[-123.69388, 38.91003], [-123.69342, 38.91022], [-123.69342, 38.91022], [-123.69342, 38.90992], [-123.69374, 38.90991], [-123.69388, 38.91003]]]} Open Access 1 Fisherman's Playground https://pointarena.ca.gov/government/departments/parks-streets/ 32606 1697 Point Arena, City of 761 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 0.214 Fisherman's Playground  
14035 14035 14034 {"type": "Polygon", "coordinates": [[[-123.6942, 38.90931], [-123.69419, 38.90966], [-123.69387, 38.90965], [-123.69406, 38.9094], [-123.69407, 38.90932], [-123.6942, 38.90931]]]} Open Access 1 Point Arena Community Garden https://pointarena.ca.gov/government/departments/parks-streets/ 32607 1697 Point Arena, City of 761 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 0.169 Point Arena Community Garden  
14036 14036 14035 {"type": "Polygon", "coordinates": [[[-123.69313, 38.90955], [-123.69313, 38.90959], [-123.69252, 38.90959], [-123.69252, 38.90945], [-123.69283, 38.90945], [-123.69284, 38.90955], [-123.69313, 38.90955]]]} Open Access 1 Centennial Plaza Memorial Garden   32608 1697 Point Arena, City of 761 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 0.139 Centennial Plaza Memorial Garden  
14366 14366 14365 {"type": "Polygon", "coordinates": [[[-123.69419, 38.90966], [-123.69413, 38.91095], [-123.69408, 38.91142], [-123.69342, 38.91138], [-123.69342, 38.91022], [-123.69386, 38.91002], [-123.69373, 38.90991], [-123.69342, 38.90992], [-123.69342, 38.90961], [-123.69319, 38.9096], [-123.69319, 38.90939], [-123.6935, 38.90939], [-123.69352, 38.90931], [-123.69407, 38.90932], [-123.69406, 38.90939], [-123.69389, 38.90964], [-123.69419, 38.90966]]]} Open Access 1 Unnamed site - Point Arena, City of   32605 1697 Point Arena, City of 761 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 3.387    

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