units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 369

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Healdsburg, City of · 6 ✖

DES_TP 1

  • Local Park · 6 ✖

ACCESS_TYP 1

  • Open Access · 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
1484 1484 1483 {"type": "Polygon", "coordinates": [[[-122.86036, 38.61008], [-122.85942, 38.61009], [-122.85941, 38.61007], [-122.85774, 38.6101], [-122.85704, 38.6104], [-122.85692, 38.6107], [-122.85688, 38.61073], [-122.85683, 38.61063], [-122.8567, 38.61049], [-122.85652, 38.61039], [-122.85642, 38.61036], [-122.8562, 38.61033], [-122.85576, 38.61037], [-122.85577, 38.60824], [-122.85768, 38.60872], [-122.8593, 38.60871], [-122.85939, 38.60868], [-122.8594, 38.60896], [-122.85966, 38.60884], [-122.85986, 38.60872], [-122.86023, 38.60845], [-122.86027, 38.60849], [-122.85995, 38.60877], [-122.85956, 38.60943], [-122.85945, 38.60956], [-122.85946, 38.61], [-122.85952, 38.61004], [-122.85963, 38.61007], [-122.86036, 38.61005], [-122.86036, 38.61008]]]} Open Access 1 10307 Badger Park and Community Garden 15754 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 15.029 Badger Park and Community Garden 0 Local Park 2 4
1485 1485 1484 {"type": "Polygon", "coordinates": [[[-122.87059, 38.61102], [-122.86967, 38.61115], [-122.86952, 38.61059], [-122.87043, 38.61044], [-122.87059, 38.61102]]]} Open Access 1 10319 Plaza Park 23784 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 1.301 Plaza Park 0 Local Park 2 4
3325 3325 3324 {"type": "Polygon", "coordinates": [[[-122.86319, 38.6161], [-122.86119, 38.61612], [-122.86118, 38.61643], [-122.861, 38.61643], [-122.861, 38.61542], [-122.86126, 38.61542], [-122.86152, 38.61515], [-122.86155, 38.61422], [-122.86189, 38.61422], [-122.86181, 38.61542], [-122.86317, 38.61543], [-122.86319, 38.6161]]]} Open Access 1 23632 Giorgi Park 19300 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 4.729 Giorgi Park 0 Local Park 2 4
4320 4320 4319 {"type": "Polygon", "coordinates": [[[-122.86697, 38.63065], [-122.86595, 38.63077], [-122.86592, 38.63004], [-122.86627, 38.63003], [-122.86628, 38.62997], [-122.86694, 38.62996], [-122.86697, 38.63065]]]} Open Access 1 10295 Gibbs Park 19288 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 1.767 Gibbs Park 0 Local Park 2 4
7913 7913 7912 {"type": "Polygon", "coordinates": [[[-122.86127, 38.60529], [-122.86092, 38.60521], [-122.86095, 38.60495], [-122.86095, 38.60476], [-122.86091, 38.60442], [-122.86082, 38.604], [-122.86097, 38.60398], [-122.86127, 38.60529]]]} Open Access 1 10330 Railroad Park 24077 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 0.626 Railroad Park 0 Local Park 2 4
11536 11536 11535 {"type": "Polygon", "coordinates": [[[-122.87222, 38.64282], [-122.87178, 38.64314], [-122.87062, 38.64408], [-122.87, 38.64377], [-122.86856, 38.64383], [-122.86688, 38.64229], [-122.86594, 38.64229], [-122.86592, 38.6421], [-122.86587, 38.64188], [-122.86589, 38.64183], [-122.86593, 38.64181], [-122.86644, 38.6417], [-122.86694, 38.64153], [-122.86732, 38.64133], [-122.86766, 38.64109], [-122.86885, 38.64215], [-122.86908, 38.64199], [-122.8692, 38.64207], [-122.86931, 38.64209], [-122.86942, 38.64206], [-122.86958, 38.64195], [-122.86976, 38.64211], [-122.87056, 38.64211], [-122.87065, 38.64219], [-122.87141, 38.64269], [-122.87155, 38.64277], [-122.87171, 38.64282], [-122.87188, 38.64284], [-122.87206, 38.64284], [-122.87222, 38.64282]]]} Open Access 1 23644 Barbieri Brothers Park 15809 1131 Healdsburg, City of 374 City 2 City Agency 2 http://www.ci.healdsburg.ca.us/index.aspx?page=94 City 2 1131 Healdsburg, City of 369 City 2 City Agency 2   Sonoma 16 19.743 Barbieri Brothers 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]);