units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 369

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 10 ✖
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
11252 11252 11251 {"type": "Polygon", "coordinates": [[[-122.86822, 38.62425], [-122.86384, 38.62426], [-122.86382, 38.62265], [-122.86822, 38.62269], [-122.86822, 38.62425]]]} Open Access 1 23635 Healdsburg Municipal Pool 19771 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 16.657 Healdsburg Municipal Pool 0 Local Recreation Area 3 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
16831 16831 16830 {"type": "Polygon", "coordinates": [[[-122.86318, 38.61423], [-122.86317, 38.61543], [-122.86181, 38.61542], [-122.86189, 38.61422], [-122.86318, 38.61423]]]} Open Access 1 47196 Recreation Park 30892 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 http://ci.healdsburg.ca.us/Facilities/Facility/Details/Recreation-Park-14 Sonoma 16 3.816 Rec. Park 0 Local Recreation Area 3 4
16940 16940 16939 {"type": "Polygon", "coordinates": [[[-122.84377, 38.62226], [-122.84368, 38.6223], [-122.84358, 38.62231], [-122.84251, 38.62232], [-122.84195, 38.62227], [-122.84194, 38.62237], [-122.84211, 38.62239], [-122.84209, 38.62266], [-122.84173, 38.62262], [-122.84146, 38.62261], [-122.84145, 38.62289], [-122.84092, 38.62291], [-122.83988, 38.62287], [-122.83935, 38.62288], [-122.83932, 38.62261], [-122.8385, 38.62264], [-122.83877, 38.62224], [-122.83884, 38.62226], [-122.83889, 38.62219], [-122.83906, 38.62227], [-122.83918, 38.62227], [-122.83929, 38.62204], [-122.83907, 38.62196], [-122.83888, 38.62178], [-122.83872, 38.62157], [-122.83862, 38.6215], [-122.83849, 38.62145], [-122.83831, 38.62145], [-122.83813, 38.62151], [-122.83803, 38.62158], [-122.83775, 38.62188], [-122.83708, 38.62147], [-122.83713, 38.62062], [-122.83543, 38.62019], [-122.83495, 38.61921], [-122.83414, 38.61931], [-122.83411, 38.61939], [-122.83377, 38.61963], [-122.83329, 38.61974], [-122.83322, 38.61978], [-122.8331, 38.61987], [-122.83305, 38.61997], [-122.833, 38.62003], [-122.83241, 38.62041], [-122.83109, 38.62042], [-122.83098, 38.62033], [-122.83122, 38.61983], [-122.83154, 38.61989], [-122.83171, 38.61933], [-122.83183, 38.61844], [-122.83043, 38.6186], [-122.82999, 38.61855], [-122.82945, 38.61845], [-122.82937, 38.61872], [-122.8289, 38.61905], [-122.82851, 38.61911], [-122.82849, 38.6189], [-122.82854, 38.61876], [-122.82855, 38.61869], [-122.82859, 38.61857], [-122.82858, 38.61856], [-122.82873, 38.61827], [-122.82913, 38.61772], [-122.82916, 38.61763], [-122.82917, 38.61752], [-122.8292, 38.61746], [-122.82925, 38.61741], [-122.82949, 38.61732], [-122.83004, 38.61777], [-122.83039, 38.61772], [-122.83069, 38.61762], [-122.8307, 38.61761], [-122.83059, 38.61749], [-122.83074, 38.61742], [-122.83076, 38.61743], [-122.83097, 38.6173], [-122.83121, 38.61714], [-122.83145, 38.61694], [-122.83144, 38.61693], [-122.83122, 38.61677], [-122.83151, 38.61647], [-122.83123, 38.61632], [-122.83145, 38.61601], [-122.83254, 38.6164], [-122.83256, 38.61587], [-122.83507, 38.61554], [-122.83573, 38.61541], [-122.83587, 38.61568], [-122.83646, 38.61567], [-122.8367, 38.61612], [-122.83795, 38.61568], [-122.83876, 38.61654], [-122.83923, 38.61678], [-122.84085, 38.61657], [-122.84112, 38.61639], [-122.84178, 38.61646], [-122.8423, 38.61692], [-122.84344, 38.61729], [-122.84328, 38.62056], [-122.8473, 38.62055], [-122.84721, 38.62384], [-122.84713, 38.62377], [-122.84704, 38.62359], [-122.84697, 38.62351], [-122.84687, 38.62346], [-122.84648, 38.62335], [-122.84634, 38.62325], [-122.84626, 38.62314], [-122.84624, 38.62309], [-122.84622, 38.62297], [-122.84623, 38.62286], [-122.84622, 38.6228], [-122.84618, 38.62273], [-122.84611, 38.62269], [-122.84603, 38.62266], [-122.8459, 38.62267], [-122.84547, 38.62287], [-122.84526, 38.62288], [-122.84489, 38.62269], [-122.84456, 38.62257], [-122.84453, 38.62252], [-122.84477, 38.62231], [-122.84469, 38.62216], [-122.84439, 38.62229], [-122.84433, 38.62204], [-122.84427, 38.62197], [-122.84443, 38.62173], [-122.84426, 38.62168], [-122.84407, 38.62168], [-122.84393, 38.62173], [-122.84411, 38.62196], [-122.84386, 38.62221], [-122.84377, 38.62226]]]} Open Access 1 49079 Fitch Mountain Park Open Space Preserve 33780 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 171.489 Fitch Mtn. Park OSP 0 Local Conservation Area 4 2
17033 17033 17032 {"type": "Polygon", "coordinates": [[[-122.85063, 38.62187], [-122.85033, 38.62203], [-122.85026, 38.62196], [-122.85036, 38.62188], [-122.85022, 38.62174], [-122.85, 38.62187], [-122.85036, 38.62223], [-122.84998, 38.62226], [-122.8494, 38.62223], [-122.84941, 38.62281], [-122.84722, 38.62334], [-122.8473, 38.62058], [-122.85008, 38.62055], [-122.85049, 38.62114], [-122.85063, 38.62187]]]} Open Access 1 23634 Villag Chanticleer Conference Center 27108 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 16.784 Villag Chanticleer Conference Ctr. 0 Local Recreation Area 3 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]);