units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 1, COUNTY = 26 and DES_TP = 14

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

DES_TP 1

  • Local Other or Unknown · 5 ✖

ACCESS_TYP 1

  • Open Access · 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
3942 3942 3941 {"type": "Polygon", "coordinates": [[[-121.96018, 38.34251], [-121.95925, 38.34317], [-121.95888, 38.3435], [-121.95879, 38.34331], [-121.95865, 38.34325], [-121.95856, 38.34319], [-121.95843, 38.34306], [-121.95841, 38.3429], [-121.95844, 38.34278], [-121.95839, 38.34272], [-121.95832, 38.34273], [-121.95806, 38.34289], [-121.95744, 38.34313], [-121.95728, 38.34315], [-121.95708, 38.34314], [-121.95687, 38.3431], [-121.95677, 38.34313], [-121.95666, 38.3432], [-121.95654, 38.34332], [-121.95649, 38.34339], [-121.95645, 38.3435], [-121.95622, 38.34364], [-121.95602, 38.3438], [-121.95594, 38.34394], [-121.95593, 38.3442], [-121.9559, 38.34432], [-121.95572, 38.34448], [-121.95548, 38.34459], [-121.95519, 38.34469], [-121.95466, 38.34491], [-121.9543, 38.34514], [-121.95404, 38.34527], [-121.95334, 38.3455], [-121.95335, 38.34531], [-121.95334, 38.34466], [-121.95369, 38.34465], [-121.95405, 38.34447], [-121.9543, 38.34445], [-121.9545, 38.34439], [-121.95493, 38.34439], [-121.95497, 38.34427], [-121.95506, 38.34424], [-121.95534, 38.34422], [-121.95571, 38.34376], [-121.95574, 38.34359], [-121.95582, 38.34356], [-121.95586, 38.3435], [-121.9559, 38.34349], [-121.95614, 38.34326], [-121.95648, 38.34299], [-121.95649, 38.34293], [-121.95655, 38.34289], [-121.95662, 38.3429], [-121.9568, 38.34276], [-121.95782, 38.34275], [-121.95823, 38.34253], [-121.95852, 38.34243], [-121.95867, 38.34241], [-121.96018, 38.34251]]]} Open Access 1 36342 Vacaville holding 1 26753 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 8.609 Vacaville holding 1 0 Local Other or Unknown 14 4
13647 13647 13646 {"type": "Polygon", "coordinates": [[[-122.15828, 38.05398], [-122.15776, 38.05473], [-122.1558, 38.05383], [-122.1562, 38.05302], [-122.15828, 38.05398]]]} Open Access 1 36331 Benicia holding 1 16011 1027 Benicia, City of 347 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1027 Benicia, City of 344 City 2 City Agency 2   Solano 26 4.824 Benicia holding 1 0 Local Other or Unknown 14 4
13793 13793 13792 {"type": "Polygon", "coordinates": [[[-122.27659, 38.12585], [-122.27653, 38.12614], [-122.27436, 38.12596], [-122.27377, 38.12604], [-122.2735, 38.12621], [-122.27296, 38.12726], [-122.27264, 38.127], [-122.27238, 38.12688], [-122.27137, 38.1267], [-122.27073, 38.1267], [-122.26972, 38.12673], [-122.26882, 38.12673], [-122.2686, 38.12664], [-122.26957, 38.12564], [-122.27074, 38.12565], [-122.27154, 38.12519], [-122.27256, 38.12469], [-122.27347, 38.12403], [-122.27385, 38.12357], [-122.27422, 38.12319], [-122.27481, 38.12286], [-122.27546, 38.12227], [-122.27609, 38.12257], [-122.2763, 38.12316], [-122.27645, 38.12379], [-122.27639, 38.12421], [-122.27607, 38.12463], [-122.27575, 38.12484], [-122.27511, 38.12496], [-122.2741, 38.125], [-122.27379, 38.12521], [-122.2742, 38.12542], [-122.27516, 38.12546], [-122.27622, 38.12572], [-122.27659, 38.12585]]]} Open Access 1 36360 Vallejo holding 1 26778 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 35.154 Vallejo holding 1 0 Local Other or Unknown 14 4
13807 13807 13806 {"type": "Polygon", "coordinates": [[[-122.01497, 38.28933], [-122.01455, 38.28938], [-122.01421, 38.28953], [-122.01412, 38.28954], [-122.01398, 38.2895], [-122.01352, 38.28967], [-122.01353, 38.28977], [-122.0136, 38.28997], [-122.01351, 38.29013], [-122.01313, 38.28976], [-122.01302, 38.28933], [-122.01314, 38.2891], [-122.01337, 38.28884], [-122.01336, 38.28882], [-122.0137, 38.28834], [-122.01375, 38.28784], [-122.01373, 38.28782], [-122.01375, 38.28782], [-122.01406, 38.28783], [-122.01457, 38.28804], [-122.01493, 38.28826], [-122.01503, 38.28868], [-122.01495, 38.28906], [-122.01497, 38.28933]]]} Open Access 1 36384 Fairfield holding 1 18795 1105 Fairfield, City of 208 City 2 City Agency 2 http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp City 2 1105 Fairfield, City of 204 City 2 City Agency 2   Solano 26 6.146 Fairfield holding 1 0 Local Other or Unknown 14 4
13982 13982 13981 {"type": "Polygon", "coordinates": [[[-121.82236, 38.44685], [-121.82236, 38.44746], [-121.82165, 38.44744], [-121.82164, 38.44684], [-121.82236, 38.44685]]]} Open Access 1 36652 Dixon holding 1 18172 1087 Dixon, City of 426 City 2 City Agency 2 http://www.ci.dixon.ca.us/ City 2 1087 Dixon, City of 420 City 2 City Agency 2   Solano 26 1.036 Dixon 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]);