units_with_maps

Table actions

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

30 rows where DES_TP = 2 and LABEL_NAME = "Pioneer Park"

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, COUNTY

DES_TP 1

  • Local Park · 30 ✖

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
102 102 101 {"type": "Polygon", "coordinates": [[[-120.94041, 37.73977], [-120.93977, 37.73977], [-120.93976, 37.73954], [-120.93952, 37.73938], [-120.93908, 37.73937], [-120.93907, 37.73903], [-120.94036, 37.73903], [-120.9404, 37.73915], [-120.94041, 37.73977]]]} Open Access 1 282 Pioneer Park 31852 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 1.761 Pioneer Park 0 Local Park 2 4
893 893 892 {"type": "Polygon", "coordinates": [[[-117.90512, 34.14554], [-117.9051, 34.14659], [-117.90507, 34.14664], [-117.90497, 34.14665], [-117.90332, 34.14665], [-117.90332, 34.1466], [-117.90342, 34.14629], [-117.90377, 34.14598], [-117.90382, 34.14597], [-117.90387, 34.14587], [-117.904, 34.14577], [-117.90401, 34.14566], [-117.90398, 34.14557], [-117.904, 34.14553], [-117.90512, 34.14554]]]} Open Access 1 5754 Pioneer Park 23718 1018 Azusa, City of 147 City 2 City Agency 2 http://www.ci.azusa.ca.us/index.aspx?NID=249 City 2 1018 Azusa, City of 143 City 2 City Agency 2   Los Angeles 6 4.093 Pioneer Park 0 Local Park 2 4
1507 1507 1506 {"type": "Polygon", "coordinates": [[[-122.76048, 38.46948], [-122.76047, 38.46866], [-122.76257, 38.46867], [-122.76262, 38.4687], [-122.76263, 38.46944], [-122.76261, 38.46948], [-122.76218, 38.46953], [-122.76187, 38.46955], [-122.76156, 38.46954], [-122.76094, 38.46948], [-122.76048, 38.46948]]]} Open Access 1 10687 Pioneer Park 23734 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 4.352 Pioneer Park 0 Local Park 2 4
1671 1671 1670 {"type": "Polygon", "coordinates": [[[-122.07137, 37.57293], [-122.07053, 37.57389], [-122.07049, 37.57392], [-122.07044, 37.57391], [-122.07015, 37.57378], [-122.06979, 37.57365], [-122.06978, 37.57326], [-122.06972, 37.57298], [-122.06961, 37.5727], [-122.0695, 37.57253], [-122.06937, 37.57236], [-122.06937, 37.57232], [-122.06939, 37.57229], [-122.06982, 37.57208], [-122.07137, 37.57293]]]} Open Access 1 12599 Pioneer Park 23735 1362 Union City, City of 365 City 2 City Agency 2 http://www.ci.union-city.ca.us/ City 2 1362 Union City, City of 361 City 2 City Agency 2   Alameda 17 4.684 Pioneer Park 0 Local Park 2 4
2206 2206 2205 {"type": "Polygon", "coordinates": [[[-118.92977, 35.36702], [-118.92976, 35.3687], [-118.92755, 35.36872], [-118.92755, 35.36704], [-118.92977, 35.36702]]]} Open Access 1 16521 Pioneer Park 23713 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 9.264 Pioneer Park 0 Local Park 2 4
2469 2469 2468 {"type": "Polygon", "coordinates": [[[-121.02666, 37.31484], [-121.0256, 37.31511], [-121.02521, 37.31406], [-121.02625, 37.31381], [-121.02666, 37.31484]]]} Open Access 1 18916 Pioneer Park 23726 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 2.919 Pioneer Park 0 Local Park 2 4
2796 2796 2795 {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} Open Access 1 18575 Pioneer Park 23724 1183 Lompoc, City of 39 City 2 City Agency 2 http://www.cityoflompoc.com/parks_rec/ City 2 1183 Lompoc, City of 38 City 2 City Agency 2   Santa Barbara 7 4.712 Pioneer Park 0 Local Park 2 4
2975 2975 2974 {"type": "Polygon", "coordinates": [[[-117.29626, 34.11007], [-117.29428, 34.11007], [-117.29428, 34.10905], [-117.29576, 34.10905], [-117.29576, 34.10929], [-117.29625, 34.10929], [-117.29626, 34.11007]]]} Open Access 1 20541 Pioneer Park 23730 1293 San Bernardino, City of 167 City 2 City Agency 2 http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp City 2 1293 San Bernardino, City of 163 City 2 City Agency 2   San Bernardino 22 4.828 Pioneer Park 0 Local Park 2 4
3900 3900 3899 {"type": "Polygon", "coordinates": [[[-118.31984, 34.69203], [-118.31779, 34.69204], [-118.31778, 34.69113], [-118.31984, 34.69112], [-118.31984, 34.69203]]]} Open Access 1 45862 Pioneer Park 28909 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 4.685 Pioneer Park 0 Local Park 2 4
6643 6643 6642 {"type": "Polygon", "coordinates": [[[-119.454, 36.59939], [-119.45351, 36.59972], [-119.45266, 36.59905], [-119.45324, 36.5987], [-119.454, 36.59939]]]} Open Access 1 4646 Pioneer Park 23729 1272 Reedley, City of 250 City 2 City Agency 2 http://www.reedley.com/ City 2 1272 Reedley, City of 246 City 2 City Agency 2   Fresno 9 1.568 Pioneer Park 0 Local Park 2 4
6898 6898 6897 {"type": "Polygon", "coordinates": [[[-118.43244, 34.29449], [-118.43147, 34.29521], [-118.43119, 34.29495], [-118.43085, 34.2952], [-118.43044, 34.29481], [-118.43077, 34.29457], [-118.43074, 34.29453], [-118.43088, 34.29442], [-118.43043, 34.29399], [-118.4313, 34.29336], [-118.43175, 34.29379], [-118.43173, 34.29382], [-118.43244, 34.29449]]]} Open Access 1 5756 Pioneer Park 23732 1299 San Fernando, City of 242 City 2 City Agency 2 http://www.sfrcs.com/ City 2 1299 San Fernando, City of 238 City 2 City Agency 2   Los Angeles 6 5.279 Pioneer Park 0 Local Park 2 4
6899 6899 6898 {"type": "Polygon", "coordinates": [[[-116.93928, 34.44363], [-116.93788, 34.44365], [-116.93784, 34.44316], [-116.9372, 34.44312], [-116.93715, 34.44215], [-116.93925, 34.4421], [-116.93928, 34.44363]]]} Open Access 1 5757 Pioneer Park 23739 318 San Bernardino, County of 368 County 3 County Agency 3 http://cms.sbcounty.gov/parks/Home.aspx County 3 2320 Yuima Municipal Water District 675 Special District 4 Water District 13   San Bernardino 22 7.116 Pioneer Park 0 Local Park 2 4
6907 6907 6906 {"type": "Polygon", "coordinates": [[[-117.8803, 33.84433], [-117.88029, 33.84459], [-117.87961, 33.84466], [-117.87825, 33.84498], [-117.87823, 33.84546], [-117.87708, 33.84548], [-117.87706, 33.84556], [-117.87658, 33.84557], [-117.87656, 33.84532], [-117.87648, 33.84473], [-117.87645, 33.84441], [-117.87642, 33.84389], [-117.87648, 33.84387], [-117.87646, 33.84365], [-117.87665, 33.84365], [-117.87666, 33.84368], [-117.8767, 33.84373], [-117.87677, 33.84377], [-117.87683, 33.84377], [-117.87697, 33.84372], [-117.87813, 33.8437], [-117.8789, 33.8437], [-117.87959, 33.84372], [-117.87971, 33.84372], [-117.88014, 33.84366], [-117.88021, 33.84366], [-117.88024, 33.84368], [-117.88026, 33.84382], [-117.88026, 33.84432], [-117.8803, 33.84433]]]} Open Access 1 5759 Pioneer Park 23717 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 13.403 Pioneer Park 0 Local Park 2 4
6908 6908 6907 {"type": "Polygon", "coordinates": [[[-117.91112, 33.78643], [-117.91106, 33.78644], [-117.91109, 33.78871], [-117.90944, 33.78872], [-117.90943, 33.78631], [-117.9105, 33.78629], [-117.9105, 33.78638], [-117.91112, 33.7864], [-117.91112, 33.78643]]]} Open Access 1 5760 Pioneer Park 23721 1116 Garden Grove, City of 62 City 2 City Agency 2 http://www.ci.garden-grove.ca.us/commserv/recreation City 2 1116 Garden Grove, City of 60 City 2 City Agency 2   Orange 3 9.909 Pioneer Park 0 Local Park 2 4
8540 8540 8539 {"type": "Polygon", "coordinates": [[[-122.58135, 38.57783], [-122.58089, 38.57861], [-122.5806, 38.57821], [-122.5803, 38.57785], [-122.58049, 38.57753], [-122.5804, 38.57749], [-122.58057, 38.57718], [-122.58104, 38.57735], [-122.58088, 38.57766], [-122.58135, 38.57783]]]} Open Access 1 13437 Pioneer Park 23714 311 Napa, County of 498 County 3 County Agency 3 http://www.napaoutdoors.org/ County 3 311 Napa, County of 489 County 3 County Agency 3   Napa 11 1.778 Pioneer Park 0 Local Park 2 4
8739 8739 8738 {"type": "Polygon", "coordinates": [[[-122.59108, 38.11488], [-122.59098, 38.11496], [-122.59088, 38.11494], [-122.59064, 38.11491], [-122.59011, 38.11489], [-122.58985, 38.11483], [-122.58959, 38.11473], [-122.5893, 38.11468], [-122.58909, 38.11454], [-122.58898, 38.11431], [-122.58885, 38.11447], [-122.58796, 38.11408], [-122.58806, 38.11394], [-122.58805, 38.11393], [-122.58912, 38.1124], [-122.59071, 38.11312], [-122.59025, 38.11373], [-122.5903, 38.11381], [-122.5903, 38.11383], [-122.59108, 38.11488]]]} Open Access 1 14188 Pioneer Park 23727 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 10.39 Pioneer Park 0 Local Park 2 4
9076 9076 9075 {"type": "Polygon", "coordinates": [[[-122.08409, 37.38923], [-122.0836, 37.38993], [-122.08302, 37.39013], [-122.08252, 37.38994], [-122.08257, 37.38983], [-122.08245, 37.38974], [-122.08255, 37.38954], [-122.08283, 37.38967], [-122.08288, 37.38963], [-122.08286, 37.38956], [-122.0829, 37.38948], [-122.08274, 37.38938], [-122.08275, 37.3893], [-122.0831, 37.38875], [-122.08409, 37.38923]]]} Open Access 1 15023 Pioneer Park 23725 1218 Mountain View, City of 460 City 2 City Agency 2 http://www.ci.mtnview.ca.us/services/parks/default.asp City 2 1218 Mountain View, City of 453 City 2 City Agency 2   Santa Clara 19 3.0 Pioneer Park 1940 Local Park 2 4
9955 9955 9954 {"type": "Polygon", "coordinates": [[[-120.9943, 37.25178], [-120.9936, 37.25177], [-120.99359, 37.25128], [-120.9936, 37.25123], [-120.99429, 37.25124], [-120.9943, 37.25178]]]} Open Access 1 17130 Pioneer Park 23722 1127 Gustine, City of 516 City 2 City Agency 2 http://www.cityofgustine.com/pView.aspx?id=13859&catid=649 City 2 1127 Gustine, City of 509 City 2 City Agency 2   Merced 37 0.931 Pioneer Park 0 Local Park 2 4
10488 10488 10487 {"type": "Polygon", "coordinates": [[[-120.68742, 35.63572], [-120.68742, 35.63573], [-120.68517, 35.63585], [-120.68593, 35.63443], [-120.68731, 35.63436], [-120.68742, 35.63572]]]} Open Access 1 18584 Pioneer Park 23728 1247 Paso Robles, City of 118 City 2 City Agency 2 http://www.prcity.com/government/departments/recreation/facilities/index.asp City 2 1247 Paso Robles, City of 115 City 2 City Agency 2   San Luis Obispo 1 6.223 Pioneer Park 0 Local Park 2 4
10491 10491 10490 {"type": "Polygon", "coordinates": [[[-120.45392, 34.87874], [-120.45391, 34.87958], [-120.45361, 34.87957], [-120.45361, 34.87874], [-120.45392, 34.87874]]]} Open Access 1 18588 Pioneer Park 23733 1322 Santa Maria, City of 36 City 2 City Agency 2 http://www.cityofsantamaria.org/209.shtml City 2 1322 Santa Maria, City of 35 City 2 City Agency 2   Santa Barbara 7 0.643 Pioneer 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]);