superunits_with_maps

Table actions

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

7 rows where MNG_AGENCY = 609

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mendocino, County of · 7 ✖

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
955 955 954 {"type": "Polygon", "coordinates": [[[-123.20724, 39.27079], [-123.2067, 39.27099], [-123.20634, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20623, 39.27012], [-123.20624, 39.2701], [-123.20614, 39.26984], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20724, 39.27079]]]} Open Access 1 Redwood Valley Lions Club Park https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park 33588 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 4.167 Redwood Valley Lions Club Park  
2178 2178 2177 {"type": "Polygon", "coordinates": [[[-123.5325, 38.79904], [-123.53139, 38.79955], [-123.5307, 38.799], [-123.53039, 38.79909], [-123.52955, 38.7979], [-123.52979, 38.79762], [-123.53088, 38.79674], [-123.5325, 38.79904]]]} Open Access 1 Bower Park   16307 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 9.996 Bower Park  
6440 6440 6439 {"type": "Polygon", "coordinates": [[[-123.23328, 39.16378], [-123.23272, 39.16366], [-123.23249, 39.16358], [-123.23241, 39.16352], [-123.23233, 39.16328], [-123.2323, 39.16324], [-123.23211, 39.16311], [-123.23206, 39.16309], [-123.23199, 39.1631], [-123.23188, 39.16317], [-123.23166, 39.16327], [-123.23156, 39.1633], [-123.23146, 39.16329], [-123.2313, 39.16323], [-123.23112, 39.16307], [-123.2309, 39.16296], [-123.23075, 39.16294], [-123.23045, 39.16293], [-123.22986, 39.16285], [-123.22964, 39.16284], [-123.22955, 39.16285], [-123.2295, 39.16289], [-123.22933, 39.16306], [-123.22915, 39.16322], [-123.22906, 39.16326], [-123.22883, 39.16333], [-123.22863, 39.16335], [-123.22853, 39.16334], [-123.22842, 39.1633], [-123.22832, 39.16323], [-123.22782, 39.16311], [-123.2276, 39.16289], [-123.22709, 39.16268], [-123.22695, 39.1624], [-123.22694, 39.16232], [-123.22659, 39.16202], [-123.22625, 39.16195], [-123.22552, 39.16209], [-123.22492, 39.16238], [-123.22307, 39.16188], [-123.22317, 39.1616], [-123.22241, 39.16113], [-123.22206, 39.16105], [-123.22201, 39.16068], [-123.22692, 39.16069], [-123.22694, 39.16039], [-123.22886, 39.16039], [-123.23313, 39.16044], [-123.23328, 39.16378]]]} Open Access 1 Low Gap Regional Park https://www.mendocinocounty.org/government/cultural-services-agency/parks/low-gap-park 21551 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 54.98 Low Gap RP  
9615 9615 9614 {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} Open Access 1 Faulkner Park https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park 33709 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 40.359 Faulkner Park 1930
10328 10328 10327 {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44048, 39.05966], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.43951, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} Open Access 1 Indian Creek County Park https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek 33715 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 17.437 Indian Creek County Park 1973
11801 11801 11800 {"type": "Polygon", "coordinates": [[[-123.135, 39.12443], [-123.13499, 39.13171], [-123.12626, 39.13116], [-123.12633, 39.12775], [-123.12597, 39.1242], [-123.135, 39.12443]]]} Open Access 1 Mill Creek Park http://www.co.mendocino.ca.us/gs/parks/millcreek.htm 28437 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 148.087 Mill Creek Park  
12995 12995 12994 {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77186, 39.56918], [-123.7721, 39.56968]]]} Open Access 1 Coastal View Point   30237 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 1.452 Coastal View Point  

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