units_with_maps

Table actions

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

6 rows where COUNTY = 16 and DES_TP = 14

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST

DES_TP 1

  • Local Other or Unknown · 6 ✖
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
1216 1216 1215 {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} No Public Access 3 7007 Lafferty Ranch 20837 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 272.49 Lafferty Ranch 0 Local Other or Unknown 14 4
9009 9009 9008 {"type": "Polygon", "coordinates": [[[-122.65202, 38.35073], [-122.64218, 38.35079], [-122.64218, 38.35016], [-122.64159, 38.34812], [-122.64149, 38.34804], [-122.64161, 38.34773], [-122.64163, 38.34714], [-122.64171, 38.34669], [-122.64214, 38.34583], [-122.64266, 38.34517], [-122.64337, 38.34455], [-122.64507, 38.34235], [-122.64514, 38.34205], [-122.64511, 38.34176], [-122.64494, 38.3412], [-122.6448, 38.34093], [-122.64492, 38.34076], [-122.64516, 38.34051], [-122.64545, 38.34014], [-122.64715, 38.34466], [-122.65121, 38.34968], [-122.65166, 38.34996], [-122.65202, 38.35073]]]} Open Access 1 14914 Crane Creek 17756 328 Sonoma County Regional Parks Dept., County of 193 County 3 County Agency - Parks 7 http://parks.sonomacounty.ca.gov/ County 3 328 Sonoma County Regional Parks Dept., County of 189 County 3 County Agency - Parks 7   Sonoma 16 129.999 Crane Creek 1974 Local Other or Unknown 14 4
9081 9081 9080 {"type": "Polygon", "coordinates": [[[-123.07275, 38.37014], [-123.07057, 38.37134], [-123.06942, 38.37164], [-123.0685, 38.37149], [-123.06748, 38.37154], [-123.06637, 38.37194], [-123.06309, 38.3645], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35892], [-123.05851, 38.35864], [-123.05854, 38.35835], [-123.05851, 38.35812], [-123.05851, 38.35799], [-123.05848, 38.35785], [-123.0583, 38.35731], [-123.05826, 38.35714], [-123.05826, 38.35705], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.356], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05838, 38.35543], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05941, 38.35485], [-123.05994, 38.35473], [-123.06015, 38.35469], [-123.06041, 38.35468], [-123.06101, 38.35462], [-123.06128, 38.35457], [-123.06153, 38.35449], [-123.06171, 38.35435], [-123.06179, 38.35419], [-123.06177, 38.3541], [-123.06176, 38.35385], [-123.06179, 38.35378], [-123.06188, 38.35331], [-123.06184, 38.35315], [-123.06172, 38.35292], [-123.06172, 38.35287], [-123.06166, 38.35281], [-123.06163, 38.35274], [-123.06158, 38.35256], [-123.06249, 38.35334], [-123.06313, 38.35379], [-123.06445, 38.35463], [-123.06499, 38.35501], [-123.06561, 38.35547], [-123.0666, 38.35624], [-123.06683, 38.3565], [-123.06689, 38.35665], [-123.06694, 38.35688], [-123.06696, 38.35708], [-123.06696, 38.35747], [-123.06692, 38.3578], [-123.06695, 38.358], [-123.06706, 38.35821], [-123.0675, 38.35885], [-123.06775, 38.35926], [-123.06781, 38.35942], [-123.06797, 38.3601], [-123.06807, 38.36033], [-123.06817, 38.36051], [-123.06855, 38.361], [-123.06867, 38.36122], [-123.06873, 38.36144], [-123.06873, 38.36205], [-123.06878, 38.36226], [-123.06891, 38.36246], [-123.06962, 38.36317], [-123.06968, 38.36328], [-123.0698, 38.36358], [-123.06997, 38.36427], [-123.07005, 38.36441], [-123.07075, 38.36541], [-123.0715, 38.36668], [-123.07159, 38.36688], [-123.0717, 38.36731], [-123.07179, 38.36752], [-123.07194, 38.3677], [-123.07229, 38.36799], [-123.07245, 38.36823], [-123.07281, 38.3691], [-123.07287, 38.36927], [-123.07288, 38.36939], [-123.07287, 38.36952], [-123.07283, 38.3697], [-123.07275, 38.36998], [-123.07275, 38.37014]]]} Restricted Access 2 15036 Carrington Coast Ranch 31268 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 329.459 Carrington Coast Ranch 2003 Local Other or Unknown 14 4
9628 9628 9627 {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} No Public Access 3 47850 Wendle Property 31796 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 50.237 Wendle Property 2018 Local Other or Unknown 14 4
13762 13762 13761 {"type": "Polygon", "coordinates": [[[-122.44326, 38.2855], [-122.44321, 38.28582], [-122.4422, 38.28573], [-122.44253, 38.28549], [-122.44264, 38.28551], [-122.44274, 38.2855], [-122.44281, 38.28545], [-122.44326, 38.2855]]]} Open Access 1 36282 Sonoma holding 2 25613 1338 Sonoma, City of 373 City 2 City Agency 2 http://www.sonomacity.org/ City 2 1338 Sonoma, City of 368 City 2 City Agency 2   Sonoma 16 0.635 Sonoma holding 2 0 Local Other or Unknown 14 4
13805 13805 13804 {"type": "Polygon", "coordinates": [[[-122.44718, 38.28907], [-122.447, 38.29026], [-122.44655, 38.29023], [-122.44662, 38.28979], [-122.44643, 38.28956], [-122.44649, 38.28952], [-122.44655, 38.28942], [-122.4466, 38.2891], [-122.44671, 38.28903], [-122.44718, 38.28907]]]} Open Access 1 36376 Sonoma holding 1 25612 1338 Sonoma, City of 373 City 2 City Agency 2 http://www.sonomacity.org/ City 2 1338 Sonoma, City of 368 City 2 City Agency 2   Sonoma 16 1.524 Sonoma holding 1 0 Local Other or Unknown 14 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]);