units_with_maps

Table actions

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

634 rows where AGNCY_TYP = 3, DES_TP = 2 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • County Agency · 634 ✖

DES_TP 1

  • Local Park · 634 ✖
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
7 7 6 {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} Open Access 1 28 Richard Vessey Park 24328 327 Santa Cruz, County of 5 County 3 County Agency 3 http://www.scparks.com/ County 3 327 Santa Cruz, County of 5 County 3 County Agency 3   Santa Cruz 5 0.46 Richard Vessey Park 0 Local Park 2 4
9 9 8 {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} Open Access 1 36 Rincon Beach Park 24367 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 11.623 Rincon Beach Park 0 Local Park 2 4
24 24 23 {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} Open Access 1 62 Atlantic Avenue Park 15674 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.951 Atlantic Avenue Park 0 Local Park 2 4
31 31 30 {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} Open Access 1 80 River Park 24416 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 123.418 River Park 0 Local Park 2 4
42 42 41 {"type": "Polygon", "coordinates": [[[-121.8696, 36.54123], [-121.86858, 36.54357], [-121.8688, 36.54399], [-121.86843, 36.54483], [-121.86836, 36.54672], [-121.86702, 36.54676], [-121.86669, 36.54657], [-121.86686, 36.54615], [-121.86861, 36.54212], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} Open Access 1 97 Roach Canyon Park 24474 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 15.0 Roach Canyon Park 0 Local Park 2 4
128 128 127 {"type": "Polygon", "coordinates": [[[-120.6997, 35.75055], [-120.69948, 35.75185], [-120.69912, 35.7518], [-120.6989, 35.75166], [-120.69837, 35.75161], [-120.69849, 35.75083], [-120.69876, 35.75085], [-120.69881, 35.7505], [-120.6997, 35.75055]]]} Open Access 1 394 San Miguel Community Park 24955 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 323 San Luis Obispo, County of 8 County 3 County Agency 3   San Luis Obispo 1 3.196 San Miguel Community Park 0 Local Park 2 4
142 142 141 {"type": "MultiPolygon", "coordinates": [[[[-120.6245, 35.11002], [-120.62419, 35.11012], [-120.62312, 35.1078], [-120.62286, 35.1073], [-120.62239, 35.10649], [-120.62277, 35.10634], [-120.6229, 35.10654], [-120.62301, 35.10675], [-120.6245, 35.11002]]], [[[-120.62952, 35.12079], [-120.6292, 35.12089], [-120.62657, 35.11519], [-120.62426, 35.11027], [-120.62457, 35.11017], [-120.62699, 35.11532], [-120.62952, 35.12079]]]]} Open Access 1 446 Sand and Surf County Park 25009 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 323 San Luis Obispo, County of 8 County 3 County Agency 3   San Luis Obispo 1 13.006 Sand and Surf County Park 0 Local Park 2 4
144 144 143 {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} Open Access 1 363 Brommer Park 16416 327 Santa Cruz, County of 5 County 3 County Agency 3 http://www.scparks.com/ County 3 327 Santa Cruz, County of 5 County 3 County Agency 3   Santa Cruz 5 7.663 Brommer Park 0 Local Park 2 4
160 160 159 {"type": "Polygon", "coordinates": [[[-120.6906, 35.75373], [-120.68985, 35.75372], [-120.68986, 35.75288], [-120.69045, 35.75267], [-120.6906, 35.75373]]]} Open Access 1 409 San Miguel Staging Area Park 24961 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 323 San Luis Obispo, County of 8 County 3 County Agency 3   San Luis Obispo 1 1.605 San Miguel Staging Area Park 0 Local Park 2 4
201 201 200 {"type": "Polygon", "coordinates": [[[-121.97829, 37.0053], [-121.97809, 37.00576], [-121.97787, 37.00575], [-121.97787, 37.00548], [-121.97734, 37.00547], [-121.97737, 37.00514], [-121.97736, 37.00494], [-121.97733, 37.00482], [-121.97818, 37.00467], [-121.97826, 37.00495], [-121.97822, 37.00505], [-121.97829, 37.0053]]]} Open Access 1 539 Santa Cruz Gardens Park 25063 327 Santa Cruz, County of 5 County 3 County Agency 3 http://www.scparks.com/ County 3 327 Santa Cruz, County of 5 County 3 County Agency 3   Santa Cruz 5 1.786 Santa Cruz Gardens Park 0 Local Park 2 4
216 216 215 {"type": "Polygon", "coordinates": [[[-121.81987, 36.97069], [-121.81931, 36.97091], [-121.81883, 36.97022], [-121.81864, 36.96998], [-121.81841, 36.96978], [-121.81822, 36.96964], [-121.81752, 36.96928], [-121.81814, 36.96853], [-121.81894, 36.96939], [-121.81987, 36.97069]]]} Open Access 1 691 Scott Park 25203 327 Santa Cruz, County of 5 County 3 County Agency 3 http://www.scparks.com/ County 3 327 Santa Cruz, County of 5 County 3 County Agency 3   Santa Cruz 5 4.268 Scott Park 0 Local Park 2 4
223 223 222 {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30557, 34.6074], [-120.30189, 34.60527], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60466], [-120.30062, 34.60438], [-120.30092, 34.60412], [-120.29991, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30017, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} Open Access 1 610 Santa Rosa Park 25134 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 24.322 Santa Rosa Park 0 Local Park 2 4
234 234 233 {"type": "Polygon", "coordinates": [[[-119.29489, 35.98035], [-119.29292, 35.98036], [-119.2929, 35.97877], [-119.2929, 35.97629], [-119.29461, 35.97627], [-119.29478, 35.9767], [-119.29488, 35.977], [-119.29489, 35.98035]]]} Open Access 1 752 Pixley Park 23756 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 19.73 Pixley Park 0 Local Park 2 4
252 252 251 {"type": "Polygon", "coordinates": [[[-119.48844, 35.88958], [-119.48844, 35.89083], [-119.48736, 35.89082], [-119.48736, 35.88959], [-119.48844, 35.88958]]]} Open Access 1 702 Alpaugh Park 15404 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 3.313 Alpaugh Park 0 Local Park 2 4
254 254 253 {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} Open Access 1 704 Seaside Gardens County Park 25250 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 0.15 Seaside Gardens County Park 0 Local Park 2 4
257 257 256 {"type": "Polygon", "coordinates": [[[-118.93335, 36.05327], [-118.92985, 36.0558], [-118.92813, 36.05675], [-118.9281, 36.05857], [-118.91372, 36.05857], [-118.91457, 36.05771], [-118.9149, 36.05674], [-118.91523, 36.05625], [-118.91535, 36.05652], [-118.91497, 36.05735], [-118.91511, 36.05767], [-118.91585, 36.058], [-118.91877, 36.058], [-118.91947, 36.05711], [-118.92079, 36.05711], [-118.92118, 36.05661], [-118.92136, 36.05655], [-118.92194, 36.0559], [-118.92294, 36.05525], [-118.92319, 36.05498], [-118.92354, 36.05439], [-118.92349, 36.05416], [-118.92339, 36.05408], [-118.92463, 36.05137], [-118.92516, 36.05104], [-118.9256, 36.05079], [-118.92683, 36.05031], [-118.92822, 36.04991], [-118.92816, 36.05452], [-118.93008, 36.05345], [-118.93103, 36.05314], [-118.93183, 36.05315], [-118.9328, 36.05262], [-118.93335, 36.05327]]]} Open Access 1 715 Bartlett Park 15842 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 141.958 Bartlett Park 0 Local Park 2 4
265 265 264 {"type": "Polygon", "coordinates": [[[-119.28968, 36.52836], [-119.28966, 36.53016], [-119.28768, 36.53012], [-119.28767, 36.52949], [-119.28688, 36.52949], [-119.28687, 36.52833], [-119.28968, 36.52836]]]} Open Access 1 743 Ledbetter Park 21129 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 11.05 Ledbetter Park 0 Local Park 2 4
279 279 278 {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} Open Access 1 948 George Lane Park 19270 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 13.666 George Lane Park 0 Local Park 2 4
288 288 287 {"type": "Polygon", "coordinates": [[[-121.1085, 35.56657], [-121.10785, 35.56657], [-121.10746, 35.56522], [-121.10769, 35.56517], [-121.10777, 35.5654], [-121.10792, 35.56539], [-121.10789, 35.56525], [-121.10824, 35.56519], [-121.1085, 35.56657]]]} Open Access 1 772 Shamel Park 25354 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 323 San Luis Obispo, County of 8 County 3 County Agency 3   San Luis Obispo 1 2.347 Shamel Park 0 Local Park 2 4
314 314 313 {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} Open Access 1 847 Skofield Park 25529 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 4.077 Skofield Park 0 Local Park 2 4

Next page

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]);