units_with_maps

Table actions

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

9 rows where COUNTY = 49 and MNG_AGENCY = 482

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Colusa, City of · 9 ✖

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
2172 2172 2171 {"type": "Polygon", "coordinates": [[[-122.01257, 39.21619], [-122.01254, 39.21627], [-122.01227, 39.21628], [-122.01234, 39.2164], [-122.01224, 39.21664], [-122.01199, 39.21651], [-122.01098, 39.21614], [-122.01035, 39.21606], [-122.00971, 39.21603], [-122.00915, 39.21603], [-122.0093, 39.21577], [-122.01001, 39.21576], [-122.01008, 39.21561], [-122.01257, 39.21619]]]} Open Access 1 16248 Levee Park 21188 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 2.726 Levee Park 0 Local Park 2 4
2177 2177 2176 {"type": "Polygon", "coordinates": [[[-122.02058, 39.20099], [-122.02056, 39.20198], [-122.02026, 39.20211], [-122.01859, 39.20167], [-122.01703, 39.20212], [-122.01747, 39.20097], [-122.02058, 39.20099]]]} Open Access 1 16325 Lewis Tennant Softball Complex 21198 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 7.164 Lewis Tennant Softball Complex 0 Local Recreation Area 3 4
2189 2189 2188 {"type": "Polygon", "coordinates": [[[-122.01629, 39.21117], [-122.01603, 39.21185], [-122.01494, 39.2116], [-122.01519, 39.21092], [-122.01629, 39.21117]]]} Open Access 1 16422 A.B. Davidson Park 15226 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 1.924 A.B. Davidson Park 0 Local Park 2 4
9645 9645 9644 {"type": "Polygon", "coordinates": [[[-122.01493, 39.21475], [-122.01467, 39.21544], [-122.01359, 39.21519], [-122.01385, 39.2145], [-122.01493, 39.21475]]]} Open Access 1 16268 Memorial Park 22125 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 1.909 Memorial Park 0 Local Park 2 4
9656 9656 9655 {"type": "Polygon", "coordinates": [[[-122.00867, 39.1898], [-122.0086, 39.19018], [-122.00852, 39.19051], [-122.00798, 39.19045], [-122.00785, 39.19001], [-122.00849, 39.18982], [-122.00867, 39.1898]]]} Open Access 1 16312 Leland Taylor Park 21148 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 0.953 Leland Taylor Park 0 Local Park 2 4
9662 9662 9661 {"type": "Polygon", "coordinates": [[[-122.00817, 39.2093], [-122.00791, 39.20998], [-122.00682, 39.20973], [-122.00708, 39.20905], [-122.00817, 39.2093]]]} Open Access 1 16291 Sankey-Elmwood Park 25030 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 1.911 Sankey-Elmwood Park 0 Local Park 2 4
9680 9680 9679 {"type": "Polygon", "coordinates": [[[-122.00933, 39.20285], [-122.0091, 39.20345], [-122.00778, 39.20316], [-122.00786, 39.2029], [-122.00787, 39.20253], [-122.0079, 39.20252], [-122.00933, 39.20285]]]} Open Access 1 16344 C.D. Semple Park 16628 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2   Colusa 49 2.158 C.D. Semple Park 0 Local Park 2 4
14972 14972 14971 {"type": "Polygon", "coordinates": [[[-122.01103, 39.20019], [-122.01091, 39.20049], [-122.0106, 39.20041], [-122.01071, 39.20011], [-122.01103, 39.20019]]]} Open Access 1 45588 King Vale Park 28413 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2 http://www.cityofcolusa.com/recreation__tourism/city_parks Colusa 49 0.252 King Vale Park 0 Local Park 2 4
15036 15036 15035 {"type": "Polygon", "coordinates": [[[-122.01485, 39.21084], [-122.01458, 39.21153], [-122.01358, 39.21131], [-122.01385, 39.21062], [-122.01485, 39.21084]]]} Open Access 1 45689 Will S Green Park 28501 1063 Colusa, City of 491 City 2 City Agency 2 http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ City 2 1063 Colusa, City of 482 City 2 City Agency 2 http://www.cityofcolusa.com/recreation__tourism/city_parks Colusa 49 1.767 Will S Green 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]);