units_with_maps

Table actions

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

380 rows where COUNTY = 12 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST

DES_TP 1

  • Local Park · 380 ✖
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
37 37 36 {"type": "Polygon", "coordinates": [[[-122.32795, 37.91786], [-122.32631, 37.91992], [-122.32264, 37.91975], [-122.32261, 37.91967], [-122.32261, 37.91841], [-122.32258, 37.9183], [-122.32754, 37.91757], [-122.32795, 37.91786]]]} Open Access 1 119 Booker T. Anderson Jr. Park 16269 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1274 Richmond, City of 20 City 2 City Agency 2   Contra Costa 12 21.023 Booker T. Anderson Jr. Park 0 Local Park 2 4
183 183 182 {"type": "Polygon", "coordinates": [[[-121.9589, 37.75072], [-121.95656, 37.75167], [-121.95627, 37.75123], [-121.95597, 37.75097], [-121.95558, 37.75036], [-121.95489, 37.74989], [-121.95534, 37.74942], [-121.95561, 37.74904], [-121.95572, 37.74886], [-121.9561, 37.74807], [-121.95647, 37.74778], [-121.95661, 37.7477], [-121.95692, 37.74756], [-121.95773, 37.74884], [-121.9589, 37.75072]]]} Open Access 1 506 Athan Downs Park 31278 1313 San Ramon, City of 70 City 2 City Agency 2 http://www.ci.san-ramon.ca.us/Parks/default.htm City 2 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 20.518 Athan Downs Park 0 Local Park 2 4
476 476 475 {"type": "Polygon", "coordinates": [[[-122.06976, 37.87928], [-122.06833, 37.8812], [-122.06772, 37.88097], [-122.06649, 37.88015], [-122.06665, 37.87674], [-122.06746, 37.87673], [-122.06699, 37.87773], [-122.06732, 37.87877], [-122.06801, 37.879], [-122.06955, 37.87914], [-122.06976, 37.87928]]]} Open Access 1 1591 Old Oak Park 23095 1371 Walnut Creek, City of 178 City 2 City Agency 2 http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp City 2 1371 Walnut Creek, City of 174 City 2 City Agency 2   Contra Costa 12 15.049 Old Oak Park 0 Local Park 2 4
507 507 506 {"type": "Polygon", "coordinates": [[[-122.3113, 37.95195], [-122.31115, 37.95198], [-122.31097, 37.9517], [-122.31046, 37.95149], [-122.31045, 37.95104], [-122.30995, 37.95105], [-122.30989, 37.95092], [-122.30964, 37.95091], [-122.30966, 37.95076], [-122.30979, 37.95074], [-122.31036, 37.95059], [-122.31015, 37.9501], [-122.30955, 37.94944], [-122.30954, 37.94962], [-122.30842, 37.94838], [-122.30754, 37.94769], [-122.30759, 37.94744], [-122.30788, 37.94711], [-122.30746, 37.94655], [-122.30701, 37.94631], [-122.30627, 37.94612], [-122.30617, 37.9458], [-122.3065, 37.94519], [-122.30634, 37.94491], [-122.30587, 37.94479], [-122.3057, 37.94457], [-122.30726, 37.94498], [-122.30729, 37.94514], [-122.30789, 37.94641], [-122.30825, 37.94651], [-122.30849, 37.94698], [-122.30882, 37.94708], [-122.30887, 37.94742], [-122.309, 37.94761], [-122.30975, 37.94822], [-122.30975, 37.94857], [-122.31016, 37.9492], [-122.31052, 37.94925], [-122.31084, 37.94972], [-122.31069, 37.94998], [-122.31109, 37.95054], [-122.31128, 37.95049], [-122.31126, 37.95075], [-122.3113, 37.95195]]]} Open Access 1 2075 Wildcat Canyon Regional Park 27502 1311 San Pablo, City of 192 City 2 City Agency 2 http://www.ci.san-pablo.ca.us/ City 2 1311 San Pablo, City of 188 City 2 City Agency 2 http://www.ebparks.org/parks/wildcat Contra Costa 12 18.143 Wildcat Canyon RP 1936 Local Park 2 4
592 592 591 {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} Open Access 1 2015 Ambrose Park 15445 2001 Ambrose Recreation and Park District 217 Special District 4 Recreation/Parks District 4 http://www.ambroserec.org/ Special District 4 2001 Ambrose Recreation and Park District 213 Special District 4 Recreation/Parks District 4   Contra Costa 12 11.746 Ambrose Park 0 Local Park 2 4
672 672 671 {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} Restricted Access 2 5104 711 St. Mary's Road Park 15210 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 11.502 711 St. Mary's Road Park 1983 Local Park 2 4
780 780 779 {"type": "Polygon", "coordinates": [[[-121.73394, 37.98555], [-121.73394, 37.98694], [-121.73255, 37.98694], [-121.73255, 37.98555], [-121.73394, 37.98555]]]} Open Access 1 5063 Crockett Park 17829 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 4.667 Crockett Park 0 Local Park 2 4
786 786 785 {"type": "Polygon", "coordinates": [[[-122.10174, 37.85993], [-122.10174, 37.86191], [-122.10034, 37.86391], [-122.09999, 37.86392], [-122.09965, 37.86438], [-122.09912, 37.86403], [-122.09873, 37.86468], [-122.09828, 37.8651], [-122.09781, 37.86516], [-122.09794, 37.8657], [-122.09807, 37.86602], [-122.0979, 37.86635], [-122.09797, 37.86662], [-122.09815, 37.8669], [-122.09776, 37.86746], [-122.09806, 37.86777], [-122.09807, 37.86819], [-122.09803, 37.86883], [-122.09759, 37.86962], [-122.09705, 37.86926], [-122.09627, 37.8684], [-122.0955, 37.86773], [-122.09513, 37.86732], [-122.09484, 37.86714], [-122.09459, 37.86673], [-122.0961, 37.86643], [-122.09667, 37.86596], [-122.09734, 37.86507], [-122.09768, 37.86456], [-122.09766, 37.86387], [-122.09799, 37.86358], [-122.09332, 37.86072], [-122.09488, 37.86046], [-122.09586, 37.86008], [-122.09628, 37.86048], [-122.09757, 37.86078], [-122.09879, 37.86062], [-122.10029, 37.86018], [-122.10174, 37.85993]]]} Open Access 1 5101 Lafayette Community Park 20830 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 70.977 Lafayette Community Park 1973 Local Park 2 4
1095 1095 1094 {"type": "Polygon", "coordinates": [[[-121.61579, 37.90931], [-121.61435, 37.90927], [-121.61438, 37.90837], [-121.61578, 37.90838], [-121.61579, 37.90931]]]} Open Access 1 48931 Ravenswood Park 33651 2439 Discovery Bay Community Service District 314 Special District 4 Community Services District 19 https://www.todb.ca.gov/district-services Special District 4 2439 Discovery Bay Community Service District 311 Special District 4 Community Services District 17   Contra Costa 12 3.141 Ravenswood Park 0 Local Park 2 4
1344 1344 1343 {"type": "Polygon", "coordinates": [[[-121.80306, 37.96023], [-121.80282, 37.96064], [-121.80082, 37.96089], [-121.80065, 37.96007], [-121.80169, 37.95988], [-121.80252, 37.95958], [-121.8027, 37.95983], [-121.80296, 37.95969], [-121.80306, 37.96023]]]} Open Access 1 11320 Dallas Ranch Park 17898 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 5.028 Dallas Ranch Park 0 Local Park 2 4
1345 1345 1344 {"type": "Polygon", "coordinates": [[[-121.78833, 37.96151], [-121.78833, 37.96151], [-121.7875, 37.9627], [-121.78747, 37.96115], [-121.78782, 37.96133], [-121.78833, 37.96151]]]} Open Access 1 11331 Diablo West Park 18137 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 1.559 Diablo West Park 0 Local Park 2 4
1351 1351 1350 {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} Open Access 1 11414 McClarren Park 21997 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 3.186 McClarren Park 0 Local Park 2 4
1352 1352 1351 {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} Open Access 1 11501 Glory Park 19349 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.072 Glory Park 0 Local Park 2 4
1370 1370 1369 {"type": "Polygon", "coordinates": [[[-122.2916, 38.01582], [-122.29115, 38.01599], [-122.29085, 38.01572], [-122.2913, 38.01544], [-122.2916, 38.01582]]]} Open Access 1 12052 Waterfront Park 27303 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 0.507 Waterfront Park 0 Local Park 2 4
1371 1371 1370 {"type": "Polygon", "coordinates": [[[-122.12055, 37.88858], [-122.12052, 37.88861], [-122.12045, 37.8887], [-122.1203, 37.88872], [-122.12016, 37.88824], [-122.12045, 37.88819], [-122.12055, 37.88858]]]} Open Access 1 12062 Brook Street Park 30315 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 0.324 Brook Street Park 0 Local Park 2 4
1373 1373 1372 {"type": "Polygon", "coordinates": [[[-122.12277, 37.98731], [-122.12226, 37.98757], [-122.12207, 37.98735], [-122.12185, 37.98743], [-122.12071, 37.98629], [-122.12149, 37.98589], [-122.12277, 37.98731]]]} Open Access 1 12112 Nancy Boyd Park 22623 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 3.529 Nancy Boyd Park 0 Local Park 2 4
1398 1398 1397 {"type": "Polygon", "coordinates": [[[-122.27441, 37.98392], [-122.27416, 37.98446], [-122.27372, 37.98438], [-122.27337, 37.98424], [-122.27285, 37.98397], [-122.27253, 37.98359], [-122.27304, 37.98321], [-122.27328, 37.98347], [-122.27387, 37.98379], [-122.27441, 37.98392]]]} Open Access 1 12285 Amber Swartz Park 15442 1252 Pinole, City of 357 City 2 City Agency 2 http://www.ci.pinole.ca.us/recreation/parks.html City 2 1252 Pinole, City of 354 City 2 City Agency 2   Contra Costa 12 2.612 Amber Swartz Park 0 Local Park 2 4
1517 1517 1516 {"type": "Polygon", "coordinates": [[[-121.7324, 37.92885], [-121.73174, 37.92982], [-121.73166, 37.92985], [-121.72989, 37.92896], [-121.73018, 37.92863], [-121.73051, 37.92855], [-121.73172, 37.92869], [-121.73214, 37.92876], [-121.7324, 37.92885]]]} Open Access 1 11473 Apple Hill Park 15539 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 4.417 Apple Hill Park 0 Local Park 2 4
1534 1534 1533 {"type": "Polygon", "coordinates": [[[-121.83573, 37.9804], [-121.83523, 37.98052], [-121.83511, 37.98023], [-121.83472, 37.98031], [-121.83339, 37.98033], [-121.83331, 37.9803], [-121.83334, 37.98023], [-121.83337, 37.97991], [-121.83317, 37.97954], [-121.833, 37.97944], [-121.8327, 37.97883], [-121.83375, 37.97845], [-121.83397, 37.97838], [-121.83441, 37.97831], [-121.83484, 37.97831], [-121.8348, 37.97862], [-121.83488, 37.97909], [-121.83523, 37.97986], [-121.83547, 37.98011], [-121.83564, 37.98014], [-121.83573, 37.9804]]]} Open Access 1 11151 Mira Vista Hills Park 22277 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 9.21 Mira Vista Hills Park 0 Local Park 2 4
1535 1535 1534 {"type": "Polygon", "coordinates": [[[-121.78224, 38.00152], [-121.78223, 38.00289], [-121.782, 38.0029], [-121.78203, 38.00356], [-121.78215, 38.0037], [-121.782, 38.00378], [-121.78185, 38.00358], [-121.78163, 38.00341], [-121.78158, 38.00331], [-121.78173, 38.00246], [-121.78174, 38.00151], [-121.78224, 38.00152]]]} Open Access 1 11212 Meadow Brook Park 22068 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 2.401 Meadow Brook 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]);