units_with_maps

Table actions

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

8 rows where COUNTY = 18, MNG_AGENCY = 484 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

MNG_AGENCY 1

  • Red Bluff, City of · 8 ✖

ACCESS_TYP 1

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
2192 2192 2191 {"type": "Polygon", "coordinates": [[[-122.232, 40.17507], [-122.23071, 40.17573], [-122.2307, 40.17574], [-122.23086, 40.17592], [-122.23078, 40.17596], [-122.23066, 40.17592], [-122.23043, 40.17581], [-122.22907, 40.17432], [-122.22898, 40.17436], [-122.22712, 40.17225], [-122.22833, 40.1722], [-122.22829, 40.17165], [-122.22961, 40.17158], [-122.23017, 40.17223], [-122.22995, 40.17234], [-122.23011, 40.17254], [-122.22989, 40.17266], [-122.23005, 40.1729], [-122.22916, 40.17335], [-122.22954, 40.17381], [-122.22921, 40.17398], [-122.22921, 40.174], [-122.22936, 40.17417], [-122.22986, 40.17392], [-122.23045, 40.1746], [-122.23076, 40.17445], [-122.23092, 40.17464], [-122.23078, 40.1747], [-122.23078, 40.17472], [-122.23089, 40.17484], [-122.23098, 40.1748], [-122.23115, 40.17501], [-122.23171, 40.17473], [-122.232, 40.17507]]]} Open Access 1 16429 River Park 24417 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 15.505 River Park 0 Local Park 2 4
2195 2195 2194 {"type": "Polygon", "coordinates": [[[-122.24678, 40.18591], [-122.24675, 40.18628], [-122.24649, 40.18701], [-122.24458, 40.18698], [-122.24438, 40.18668], [-122.24399, 40.18629], [-122.24374, 40.18612], [-122.24361, 40.18592], [-122.24356, 40.1859], [-122.24352, 40.18567], [-122.24373, 40.18547], [-122.24433, 40.18462], [-122.2446, 40.1845], [-122.24487, 40.18458], [-122.24511, 40.18471], [-122.24519, 40.18497], [-122.24547, 40.18541], [-122.24552, 40.18556], [-122.24627, 40.18555], [-122.24655, 40.1858], [-122.24678, 40.18591]]]} Open Access 1 16438 Forward Park 19014 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 11.801 Forward Park 0 Local Park 2 4
5189 5189 5188 {"type": "Polygon", "coordinates": [[[-122.24846, 40.17789], [-122.24809, 40.17808], [-122.24765, 40.17757], [-122.24805, 40.17738], [-122.24846, 40.17789]]]} Open Access 1 16457 Carl Coleman Courts 16850 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 0.645 Carl Coleman Courts 0 Local Recreation Area 3 4
8279 8279 8278 {"type": "Polygon", "coordinates": [[[-122.25409, 40.18034], [-122.25409, 40.18068], [-122.25387, 40.18068], [-122.25387, 40.18033], [-122.25409, 40.18034]]]} Open Access 1 24223 Lots for Tots 21544 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 0.177 Lots for Tots 0 Local Other or Unknown 14 4
9710 9710 9709 {"type": "Polygon", "coordinates": [[[-122.24292, 40.17711], [-122.24251, 40.17733], [-122.24219, 40.17696], [-122.24261, 40.17675], [-122.24292, 40.17711]]]} Open Access 1 16451 Campfire Recreation Area 16782 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 0.516 Campfire Rec. Area 0 Local Recreation Area 3 4
9715 9715 9714 {"type": "Polygon", "coordinates": [[[-122.22673, 40.16205], [-122.22503, 40.16269], [-122.22472, 40.16276], [-122.22457, 40.16276], [-122.22424, 40.16273], [-122.22316, 40.16239], [-122.22322, 40.16234], [-122.22345, 40.16223], [-122.22372, 40.16061], [-122.22414, 40.15986], [-122.22445, 40.16019], [-122.22476, 40.16007], [-122.22538, 40.16082], [-122.22577, 40.16091], [-122.22673, 40.16205]]]} Open Access 1 16443 Diamond Park 18147 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 13.384 Diamond Park 0 Local Park 2 4
9717 9717 9716 {"type": "MultiPolygon", "coordinates": [[[[-122.23764, 40.18392], [-122.23729, 40.18417], [-122.23686, 40.18432], [-122.23672, 40.18432], [-122.23644, 40.18444], [-122.23623, 40.18444], [-122.23553, 40.18459], [-122.23457, 40.18483], [-122.23387, 40.18508], [-122.23361, 40.18513], [-122.23323, 40.18529], [-122.23239, 40.18554], [-122.23227, 40.18552], [-122.23242, 40.18529], [-122.23336, 40.18459], [-122.23362, 40.18454], [-122.23428, 40.18413], [-122.23466, 40.18378], [-122.2348, 40.18358], [-122.23516, 40.18323], [-122.23542, 40.18282], [-122.23556, 40.18273], [-122.23604, 40.18217], [-122.23643, 40.18176], [-122.23656, 40.18171], [-122.23691, 40.18178], [-122.23699, 40.18182], [-122.23737, 40.18213], [-122.2375, 40.18243], [-122.23752, 40.18295], [-122.23759, 40.18308], [-122.23764, 40.18346], [-122.23765, 40.18375], [-122.23764, 40.18392]]], [[[-122.23918, 40.18381], [-122.23913, 40.18382], [-122.23912, 40.18417], [-122.23885, 40.18416], [-122.23884, 40.18429], [-122.23893, 40.1843], [-122.23781, 40.18486], [-122.23797, 40.18457], [-122.23765, 40.18444], [-122.23774, 40.18366], [-122.23761, 40.18291], [-122.23875, 40.18232], [-122.23893, 40.18267], [-122.23907, 40.18308], [-122.23916, 40.18348], [-122.23918, 40.18381]]]]} Open Access 1 16447 Samual Ayer/Dog Island Park 24821 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 23.479 Samual Ayer/Dog Island Park 0 Local Park 2 4
11366 11366 11365 {"type": "Polygon", "coordinates": [[[-122.24404, 40.15549], [-122.2409, 40.15549], [-122.2409, 40.15379], [-122.24403, 40.15378], [-122.24404, 40.15549]]]} Open Access 1 24224 John R. Trainor Park 20464 1267 Red Bluff, City of 493 City 2 City Agency 2 http://www.cityofredbluff.org/citydepartments/parksandrecreation/ City 2 1267 Red Bluff, City of 484 City 2 City Agency 2   Tehama 18 12.548 John R. Trainor 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]);