superunits_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1, MNG_AGENCY = 776 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 10 ✖
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
938 938 937 {"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 Hudson-Carpenter Park https://www.cityofukiah.com/parks-facilities/ 33573 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1.057 Hudson-Carpenter Park  
941 941 940 {"type": "Polygon", "coordinates": [[[-123.18507, 39.14617], [-123.18356, 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.14439], [-123.18482, 39.14492], [-123.18507, 39.14617]]]} Open Access 1 Riverside Park https://www.cityofukiah.com/parks-facilities/ 33574 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 10.577 Riverside Park  
4570 4570 4569 {"type": "Polygon", "coordinates": [[[-123.22308, 39.15217], [-123.22221, 39.15218], [-123.22213, 39.15121], [-123.2218, 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.15085], [-123.22109, 39.15083], [-123.22067, 39.15069], [-123.22112, 39.15002], [-123.22207, 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.14997], [-123.22307, 39.14999], [-123.22312, 39.15119], [-123.22308, 39.15217]]]} Open Access 1 Giorno Park/Anton Stadium   19301 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 10.216 Giorno Park/Anton Stadium  
6832 6832 6831 {"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 McGarvey Park   22032 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 0.926 McGarvey Park  
7568 7568 7567 {"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 Oak Manor Park   22986 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 4.526 Oak Manor Park  
7614 7614 7613 {"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 Observatory Park Trail   23046 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 2.559 Observatory Park Trail  
10377 10377 10376 {"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 Todd Grove Park   26383 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 9.419 Todd Grove Park  
10546 10546 10545 {"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.19306, 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.19777, 39.15951], [-123.19776, 39.15952], [-123.19793, 39.16065], [-123.198, 39.16129], [-123.19803, 39.16147]]]} Open Access 1 Ukiah Softball Complex   26646 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 20.166 Ukiah Softball Complex  
10910 10910 10909 {"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 Vinewood Park   27133 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 4.763 Vinewood Park  
11814 11814 11813 {"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 Orchard Park http://www.cityofukiah.com/parks-facilities/ 28451 1413 Ukiah, City of 776 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 0.77 Orchard 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]);