units_with_maps

Table actions

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

7 rows where AGNCY_NAME = 796, DES_TP = 2 and MNG_AGENCY = 776

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • Ukiah, City of · 7 ✖

DES_TP 1

  • Local Park · 7 ✖

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
11933 11933 11932 {"type": "Polygon", "coordinates": [[[-123.21197, 39.1479], [-123.21127, 39.14804], [-123.21114, 39.1475], [-123.21183, 39.14738], [-123.21197, 39.1479]]]} Open Access 1 24547 McGarvey Park 22032 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 0.926 McGarvey Park 0 Local Park 2 4
11934 11934 11933 {"type": "Polygon", "coordinates": [[[-123.19386, 39.14724], [-123.19337, 39.14723], [-123.19227, 39.14734], [-123.19201, 39.14546], [-123.19224, 39.14543], [-123.19277, 39.14585], [-123.19307, 39.14606], [-123.19316, 39.14619], [-123.19357, 39.14691], [-123.19386, 39.14724]]]} Open Access 1 24548 Oak Manor Park 22986 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 4.526 Oak Manor Park 0 Local Park 2 4
11935 11935 11934 {"type": "Polygon", "coordinates": [[[-123.22136, 39.15252], [-123.22095, 39.15405], [-123.22088, 39.15409], [-123.22035, 39.15418], [-123.21818, 39.15212], [-123.21982, 39.15189], [-123.22136, 39.15252]]]} Open Access 1 24549 Todd Grove Park 26383 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 9.42 Todd Grove Park 0 Local Park 2 4
11937 11937 11936 {"type": "Polygon", "coordinates": [[[-123.21346, 39.16223], [-123.21127, 39.16243], [-123.21123, 39.16233], [-123.21122, 39.1622], [-123.21148, 39.16163], [-123.21151, 39.16146], [-123.21148, 39.16135], [-123.21291, 39.16125], [-123.21309, 39.16122], [-123.21346, 39.16223]]]} Open Access 1 24551 Vinewood Park 27133 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 4.763 Vinewood Park 0 Local Park 2 4
14231 14231 14230 {"type": "Polygon", "coordinates": [[[-123.20606, 39.14817], [-123.20523, 39.14828], [-123.20523, 39.14823], [-123.20524, 39.14815], [-123.20521, 39.14809], [-123.20506, 39.14793], [-123.20522, 39.1479], [-123.20523, 39.14774], [-123.20532, 39.14765], [-123.20544, 39.14767], [-123.20548, 39.14771], [-123.20592, 39.14763], [-123.20606, 39.14817]]]} Open Access 1 48853 Hudson-Carpenter Park 33573 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2 https://www.cityofukiah.com/parks-facilities/ Mendocino 24 1.056 Hudson-Carpenter Park 0 Local Park 2 4
14250 14250 14249 {"type": "Polygon", "coordinates": [[[-123.18507, 39.14617], [-123.18355, 39.14629], [-123.18334, 39.14633], [-123.18285, 39.14639], [-123.18261, 39.1464], [-123.18255, 39.14638], [-123.18247, 39.14631], [-123.18244, 39.14618], [-123.18243, 39.14541], [-123.18235, 39.14482], [-123.18242, 39.14451], [-123.1826, 39.14446], [-123.18327, 39.14459], [-123.18469, 39.14438], [-123.18482, 39.14492], [-123.18507, 39.14617]]]} Open Access 1 48854 Riverside Park 33574 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2 https://www.cityofukiah.com/parks-facilities/ Mendocino 24 10.577 Riverside Park 0 Local Park 2 4
14988 14988 14987 {"type": "Polygon", "coordinates": [[[-123.19726, 39.14138], [-123.19722, 39.14143], [-123.19694, 39.14157], [-123.19683, 39.14169], [-123.1965, 39.14159], [-123.19646, 39.14116], [-123.19716, 39.14113], [-123.19726, 39.14138]]]} Open Access 1 45628 Orchard Park 28451 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/parks-facilities/ Mendocino 24 0.77 Orchard 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]);