units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 776

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 10 ✖
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
5143 5143 5142 {"type": "Polygon", "coordinates": [[[-123.21229, 39.1384], [-123.21159, 39.13851], [-123.21138, 39.13701], [-123.21209, 39.1369], [-123.21229, 39.1384]]]} Open Access 1 44983 Observatory Park Trail 23046 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 2.559 Observatory Park Trail 0 Local Recreation Area 3 4
11932 11932 11931 {"type": "Polygon", "coordinates": [[[-123.22308, 39.15217], [-123.22221, 39.15218], [-123.22214, 39.15121], [-123.22179, 39.15122], [-123.22179, 39.1513], [-123.2213, 39.15129], [-123.22064, 39.15207], [-123.22029, 39.15192], [-123.22076, 39.15107], [-123.22095, 39.15112], [-123.2211, 39.15084], [-123.2211, 39.15083], [-123.22067, 39.15069], [-123.22112, 39.15002], [-123.22208, 39.14999], [-123.22215, 39.14955], [-123.22223, 39.14958], [-123.22224, 39.14953], [-123.22226, 39.14954], [-123.22231, 39.1496], [-123.22235, 39.1496], [-123.22236, 39.14972], [-123.22272, 39.14973], [-123.22283, 39.14978], [-123.22302, 39.14976], [-123.22298, 39.14998], [-123.22307, 39.14999], [-123.22312, 39.15119], [-123.22308, 39.15217]]]} Open Access 1 24546 Giorno Park/Anton Stadium 19301 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 10.198 Giorno Park/Anton Stadium   None 1049  
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
11936 11936 11935 {"type": "Polygon", "coordinates": [[[-123.19803, 39.16147], [-123.19777, 39.16132], [-123.19706, 39.16098], [-123.19584, 39.16063], [-123.19504, 39.16045], [-123.19363, 39.1604], [-123.19299, 39.15994], [-123.19205, 39.15918], [-123.19305, 39.15931], [-123.19354, 39.15926], [-123.19472, 39.15902], [-123.19543, 39.15884], [-123.19602, 39.15882], [-123.19676, 39.15886], [-123.1977, 39.15864], [-123.19794, 39.1595], [-123.19776, 39.15951], [-123.19793, 39.16065], [-123.198, 39.16129], [-123.19803, 39.16147]]]} Open Access 1 24550 Ukiah Softball Complex 26646 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 20.165 Ukiah Softball Complex 0 Local Recreation Area 3 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]);