units_with_maps

Table actions

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

5 rows where DES_TP = 3, LAYER = 2, MNG_AGENCY = 144 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

  • Petaluma, City of · 5 ✖

DES_TP 1

  • Local Recreation Area · 5 ✖
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
1472 1472 1471 {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24562], [-122.62614, 38.24564], [-122.62491, 38.24476], [-122.62415, 38.24407], [-122.6233, 38.24296], [-122.62246, 38.24147], [-122.62271, 38.24132], [-122.62324, 38.24158], [-122.62375, 38.24187], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} Open Access 1 10010 Kenilworth Athletic Fields 20596 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 20.13 Kenilworth Athletic Fields 0 Local Recreation Area 3 4
9576 9576 9575 {"type": "Polygon", "coordinates": [[[-122.61166, 38.265], [-122.61098, 38.26576], [-122.60488, 38.26235], [-122.6057, 38.26144], [-122.60662, 38.26161], [-122.60843, 38.26232], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} Open Access 1 47844 Petaluma Community Sports Fields 31786 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 http://cityofpetaluma.net/parksnrec/parks-pages/petaluma-comm-sport-fields.html Sonoma 16 24.892 Petaluma Community Sports Fields 2015 Local Recreation Area 3 4
11494 11494 11493 {"type": "Polygon", "coordinates": [[[-122.63742, 38.22602], [-122.63723, 38.22633], [-122.63703, 38.22625], [-122.63725, 38.22589], [-122.63737, 38.22594], [-122.63735, 38.22599], [-122.63742, 38.22602]]]} Open Access 1 23637 Cavanaugh Pool 16981 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 0.205 Cavanaugh Pool 0 Local Recreation Area 3 4
13173 13173 13172 {"type": "MultiPolygon", "coordinates": [[[[-122.58307, 38.22933], [-122.58238, 38.23007], [-122.57621, 38.22666], [-122.57633, 38.22647], [-122.57659, 38.22629], [-122.57685, 38.22617], [-122.5772, 38.22588], [-122.57777, 38.22573], [-122.57799, 38.2256], [-122.57872, 38.22483], [-122.57915, 38.22443], [-122.58083, 38.22535], [-122.58089, 38.22576], [-122.5804, 38.22629], [-122.58131, 38.22682], [-122.58105, 38.22709], [-122.58105, 38.22711], [-122.5828, 38.22811], [-122.58307, 38.22933]]], [[[-122.59172, 38.21766], [-122.59033, 38.21764], [-122.58878, 38.21814], [-122.58712, 38.21833], [-122.58596, 38.21827], [-122.58479, 38.21783], [-122.58391, 38.21714], [-122.58327, 38.21602], [-122.58331, 38.21486], [-122.58381, 38.21407], [-122.58571, 38.2127], [-122.58639, 38.21185], [-122.58784, 38.2134], [-122.59172, 38.21766]]]]} No Public Access 3 35157 Petaluma Marsh Acquisition, Enhancement and Access 28158 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 112.939 Petaluma Marsh Acquisition, Enhancement and Access 0 Local Recreation Area 3 4
16201 16201 16200 {"type": "Polygon", "coordinates": [[[-122.63457, 38.21113], [-122.63449, 38.21118], [-122.63444, 38.21125], [-122.63444, 38.21131], [-122.63448, 38.21139], [-122.63438, 38.21156], [-122.63433, 38.2118], [-122.63408, 38.21197], [-122.63407, 38.21196], [-122.63379, 38.21207], [-122.63266, 38.21208], [-122.63256, 38.21216], [-122.63245, 38.21218], [-122.63236, 38.21224], [-122.63233, 38.21234], [-122.63231, 38.21254], [-122.63193, 38.21255], [-122.63201, 38.2123], [-122.63218, 38.21214], [-122.63234, 38.21206], [-122.63231, 38.21177], [-122.63339, 38.21173], [-122.63364, 38.21166], [-122.6338, 38.21155], [-122.6339, 38.21141], [-122.63393, 38.21131], [-122.63393, 38.21051], [-122.63395, 38.21038], [-122.63418, 38.20984], [-122.63431, 38.20957], [-122.63435, 38.20955], [-122.6344, 38.20955], [-122.63532, 38.20982], [-122.63555, 38.20996], [-122.63563, 38.21005], [-122.63562, 38.21013], [-122.63559, 38.21018], [-122.63506, 38.21055], [-122.63479, 38.21079], [-122.63463, 38.211], [-122.63457, 38.21113]]]} Open Access 1 29792 Westridge Open Space 27418 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 6.718 Westridge OS 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]);