units_with_maps

Table actions

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

5 rows where AGNCY_NAME = 781 and MNG_AGENCY = 761

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • Point Arena, City of · 5 ✖

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
4788 4788 4787 {"type": "Polygon", "coordinates": [[[-123.69419, 38.90966], [-123.69413, 38.91095], [-123.69408, 38.91142], [-123.69342, 38.91138], [-123.69342, 38.91022], [-123.69387, 38.91002], [-123.69374, 38.90991], [-123.69342, 38.90992], [-123.69342, 38.9096], [-123.69319, 38.9096], [-123.69319, 38.90939], [-123.69351, 38.90939], [-123.69352, 38.90931], [-123.69407, 38.90932], [-123.69406, 38.90939], [-123.69388, 38.90964], [-123.69419, 38.90966]]]} Open Access 1 48100 Unnamed site - Point Arena, City of 32605 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2   Mendocino 24 3.377   0 Local Other or Unknown 14 4
11412 11412 11411 {"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 48101 Fisherman's Playground 32606 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://pointarena.ca.gov/government/departments/parks-streets/ Mendocino 24 0.214 Fisherman's Playground 0 Local Recreation Area 3 4
11413 11413 11412 {"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 48102 Point Arena Community Garden 32607 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://pointarena.ca.gov/government/departments/parks-streets/ Mendocino 24 0.169 Point Arena Community Garden 0 Local Park 2 4
11414 11414 11413 {"type": "Polygon", "coordinates": [[[-123.69313, 38.90955], [-123.69313, 38.90959], [-123.69252, 38.90959], [-123.69252, 38.90945], [-123.69283, 38.90945], [-123.69283, 38.90955], [-123.69313, 38.90955]]]} Open Access 1 48103 Centennial Plaza Memorial Garden 32608 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2   Mendocino 24 0.139 Centennial Plaza Memorial Garden 0 Local Park 2 4
11500 11500 11499 {"type": "Polygon", "coordinates": [[[-123.70998, 38.91406], [-123.71015, 38.91456], [-123.71027, 38.91481], [-123.70981, 38.91483], [-123.7099, 38.91463], [-123.70916, 38.91441], [-123.70848, 38.91412], [-123.70852, 38.91404], [-123.70852, 38.91403], [-123.70629, 38.91322], [-123.70628, 38.91295], [-123.70876, 38.91318], [-123.70976, 38.91348], [-123.70998, 38.91406]]]} Open Access 1 48188 Point Arena Cove & Fishing Pier 32724 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://www.mendocino.com/?id=3423&url= Mendocino 24 6.991 Point Arena Cove & Fishing Pier 0 None 1022  

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