units_with_maps

Table actions

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

7 rows where ACCESS_TYP = 1, AGNCY_LEV = 3 and MNG_AGENCY = 609

This data as json, copyable, CSV (advanced)

DES_TP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mendocino, County of · 7 ✖

ACCESS_TYP 1

  • Open Access · 7 ✖
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
3331 3331 3330 {"type": "Polygon", "coordinates": [[[-123.5325, 38.79904], [-123.53139, 38.79955], [-123.53069, 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 29749 Bower Park 16307 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3   Mendocino 24 9.995 Bower Park 0 Local Park 2 4
4186 4186 4185 {"type": "Polygon", "coordinates": [[[-123.20725, 39.27079], [-123.2067, 39.27099], [-123.20635, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20624, 39.27012], [-123.20625, 39.2701], [-123.20614, 39.26983], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20725, 39.27079]]]} Open Access 1 48864 Redwood Valley Lions Club Park 33588 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3 https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park Mendocino 24 4.164 Redwood Valley Lions Club Park 0 Local Park 2 4
5212 5212 5211 {"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.77185, 39.56918], [-123.7721, 39.56968]]]} Open Access 1 46783 Coastal View Point 30237 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3   Mendocino 24 1.451 Coastal View Point   None 422  
9402 9402 9401 {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 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 49017 Indian Creek County Park 33715 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3 https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek Mendocino 24 17.437 Indian Creek County Park 1973 Local Park 2 4
14982 14982 14981 {"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 45610 Mill Creek Park 28437 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/millcreek.htm Mendocino 24 148.09 Mill Creek Park 0 Local Park 2 4
15380 15380 15379 {"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 49011 Faulkner Park 33709 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3 https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park Mendocino 24 40.36 Faulkner Park 1930 Local Park 2 4
16421 16421 16420 {"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.16309], [-123.23188, 39.16317], [-123.23167, 39.16327], [-123.23156, 39.1633], [-123.23146, 39.16329], [-123.2313, 39.16323], [-123.23112, 39.16307], [-123.2309, 39.16297], [-123.23075, 39.16294], [-123.23045, 39.16293], [-123.22986, 39.16285], [-123.22963, 39.16284], [-123.22955, 39.16285], [-123.2295, 39.16289], [-123.22933, 39.16306], [-123.22914, 39.16322], [-123.22907, 39.16326], [-123.22883, 39.16333], [-123.22863, 39.16335], [-123.22854, 39.16334], [-123.22842, 39.1633], [-123.22833, 39.16323], [-123.22782, 39.16311], [-123.2276, 39.16289], [-123.22709, 39.16268], [-123.22695, 39.1624], [-123.22695, 39.16232], [-123.22659, 39.16202], [-123.22625, 39.16195], [-123.22552, 39.16209], [-123.22492, 39.16238], [-123.22307, 39.16188], [-123.22318, 39.1616], [-123.22241, 39.16113], [-123.22206, 39.16105], [-123.22201, 39.16068], [-123.22693, 39.16069], [-123.22694, 39.16039], [-123.22886, 39.16039], [-123.23313, 39.16044], [-123.23328, 39.16378]]]} Open Access 1 44977 Low Gap Regional Park 21551 352 Mendocino, County of 620 County 3 County Agency 3 http://www.co.mendocino.ca.us/gs/parks/ County 3 352 Mendocino, County of 609 County 3 County Agency 3 https://www.mendocinocounty.org/government/cultural-services-agency/parks/low-gap-park Mendocino 24 54.974 Low Gap RP 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]);