Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81242 | 81242 | 39675 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 97619 | 97619 | 39676 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 126984 | 126984 | 68883 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | ||
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 139314 | 139314 | 39490 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | ||
| 41814 | 41814 | 38626 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 88362 | 88362 | 38629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 106275 | 106275 | 38553 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40521 | 6014535.26572589 | 2096873.10267881 | 37.7384313099375 | -122.39224540118299 | (37.7384313099375, -122.392245401183) | ||
| 117173 | 117173 | 38627 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 86280 | 86280 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712.0 | 2113143.0 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | |
| 144295 | 144295 | 64645 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856003 | 37.7288421898975 | -122.46009728755301 | (37.7288421898975, -122.460097287553) | ||
| 83070 | 83070 | 39173 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 7461 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.41719646500401 | (37.7612079095392, -122.417196465004) | ||
| 93272 | 93272 | 39174 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.41719646500401 | (37.7612079095392, -122.417196465004) | ||
| 120111 | 120111 | 39139 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.749435846729895 | -122.416989987658 | (37.7494358467299, -122.416989987658) | ||
| 120722 | 120722 | 39138 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.749435846729895 | -122.416989987658 | (37.7494358467299, -122.416989987658) | ||
| 120616 | 120616 | 33344 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.46400139922599 | (37.730182659203, -122.464001399226) | ||
| 87387 | 87387 | 90956 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.438709999 | 2110931.20899 | 37.775120893377796 | -122.50869800264299 | (37.7751208933778, -122.508698002643) | ||
| 90662 | 90662 | 37286 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | ||
| 71486 | 71486 | 38854 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1466 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40681 | 5989630.3392 | 2105375.4166 | 37.7603620895733 | -122.478975308071 | (37.7603620895733, -122.478975308071) | |
| 113208 | 113208 | 36907 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.753396682452205 | -122.440506941015 | (37.7533966824522, -122.440506941015) | ||
| 159923 | 159923 | 38864 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1442 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40691 | 5989006.457 | 2105496.048 | 37.7606570618134 | -122.48114183443701 | (37.7606570618134, -122.481141834437) | |
| 180381 | 180381 | 38863 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1565 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 0 | Permit Number 40690 | 5989296.21457943 | 2104699.06297943 | 37.758485596062705 | -122.480081376814 | (37.7584855960627, -122.480081376814) | |
| 187149 | 187149 | 38860 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1549 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 0 | Permit Number 40687 | 5989292.62615578 | 2104803.36922141 | 37.758771784471996 | -122.480101420695 | (37.758771784472, -122.480101420695) | |
| 85736 | 85736 | 38813 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | ||
| 102122 | 102122 | 38812 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | ||
| 87203 | 87203 | 38622 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 97472 | 97472 | 38619 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 109923 | 109923 | 38620 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 117991 | 117991 | 38621 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 87435 | 87435 | 31145 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | |
| 91475 | 91475 | 68599 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.47317142953301 | (37.7517787113613, -122.473171429533) | ||
| 78508 | 78508 | 68560 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.778688985847104 | -122.506043321809 | (37.7786889858471, -122.506043321809) | ||
| 89241 | 89241 | 68517 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | ||
| 121863 | 121863 | 68548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.778332244778106 | -122.504940366327 | (37.7783322447781, -122.504940366327) | ||
| 140374 | 140374 | 68496 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | ||
| 117250 | 117250 | 38565 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 127128 | 127128 | 38613 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 113886 | 113886 | 37066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 39668 | 6003784.55345185 | 2099265.25748104 | 37.7443968092105 | -122.42958669484501 | (37.7443968092105, -122.429586694845) | ||
| 88607 | 88607 | 34930 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1790 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/1997 12:00:00 AM | Permit Number 38522 | 5991259.7839455 | 2103214.98783119 | 37.754524610644495 | -122.473182309921 | (37.7545246106445, -122.473182309921) | ||
| 96701 | 96701 | 34355 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.740180967537604 | -122.425706834494 | (37.7401809675376, -122.425706834494) | ||
| 103409 | 103409 | 34672 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3112 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | Permit Number 38340 | 6003381.034936099 | 2119134.6254032 | 37.7989303613953 | -122.43240082161199 | (37.7989303613953, -122.432400821612) | ||
| 118661 | 118661 | 39134 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.753695817901104 | -122.417576944272 | (37.7536958179011, -122.417576944272) | ||
| 17972 | 17972 | 38597 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 18457 | 18457 | 38570 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 27177 | 27177 | 38615 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 88116 | 88116 | 38642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | ||
| 89321 | 89321 | 38593 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 91768 | 91768 | 38596 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 94510 | 94510 | 38612 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 103548 | 103548 | 38571 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 105922 | 105922 | 38617 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1619 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40558 | 6014993.23240611 | 2094434.43177017 | 37.7317606344589 | -122.390491609305 | (37.7317606344589, -122.390491609305) | ||
| 106822 | 106822 | 38594 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 109076 | 109076 | 38569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 112576 | 112576 | 38598 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | ||
| 113802 | 113802 | 38601 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1534 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40552 | 6015446.13574073 | 2094163.07491578 | 37.7310406573671 | -122.388906878559 | (37.7310406573671, -122.388906878559) | ||
| 115620 | 115620 | 38567 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 115662 | 115662 | 38618 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1648 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40559 | 6014913.01600852 | 2094558.97753063 | 37.732098161618296 | -122.39077763667801 | (37.7320981616183, -122.390777636678) | ||
| 119355 | 119355 | 38628 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | |||
| 119849 | 119849 | 38568 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 123886 | 123886 | 38566 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 125105 | 125105 | 38614 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 126038 | 126038 | 38595 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 141770 | 141770 | 38616 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 53182 | 53182 | 43998 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43555 | 6008950.71046834 | 2099077.83692872 | 37.7441733566649 | -122.41170989221901 | (37.7441733566649, -122.411709892219) | |||
| 94380 | 94380 | 43999 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.744187920912296 | -122.411468983209 | (37.7441879209123, -122.411468983209) | |||
| 94422 | 94422 | 43997 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.41183034682699 | (37.7441660743482, -122.411830346827) | |||
| 69521 | 69521 | 73455 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 9 | 6009841.50181 | 2111066.87201 | 37.777142462880995 | -122.409475680552 | (37.777142462881, -122.409475680552) | ||
| 151243 | 151243 | 34648 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1591 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | Permit Number 38327 | 5987753.8097 | 2104490.816 | 37.757824067255704 | -122.485400354271 | (37.7578240672557, -122.485400354271) | |
| 112060 | 112060 | 39909 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | ||
| 91922 | 91922 | 38511 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | |||
| 114806 | 114806 | 34398 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | |
| 101381 | 101381 | 96988 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 106196 | 106196 | 96990 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 114706 | 114706 | 96989 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 98637 | 98637 | 36720 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 111647 | 111647 | 36719 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 139285 | 139285 | 36718 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 96548 | 96548 | 40641 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.744370680135106 | -122.410814978675 | (37.7443706801351, -122.410814978675) | |||
| 143045 | 143045 | 40642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.744366745773796 | -122.410880064189 | (37.7443667457738, -122.410880064189) | |||
| 133985 | 133985 | 38606 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1558 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 40554 | 6015323.31475554 | 2094254.15832382 | 37.731283945571704 | -122.389337853373 | (37.7312839455717, -122.389337853373) | |
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 90711 | 90711 | 68249 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 89732 | 89732 | 43105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444671995 | -122.41142742605801 | (37.786049444672, -122.411427426058) | ||
| 106385 | 106385 | 43109 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.78613994087421 | -122.411445668311 | (37.7861399408742, -122.411445668311) | ||
| 86438 | 86438 | 40067 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 105358 | 105358 | 40066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 91302 | 91302 | 38347 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1567 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | Permit Number 40414 | 5981854.03597748 | 2104432.31461127 | 37.757317957298 | -122.5057995404 | (37.757317957298, -122.5057995404) | ||
| 152505 | 152505 | 38345 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1859 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 0 | Permit Number 40412 | 5982231.73051381 | 2102455.52324126 | 37.7519124687384 | -122.504346906094 | (37.7519124687384, -122.504346906094) | |
| 140714 | 140714 | 34803 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | ||
| 34390 | 34390 | 34657 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38334 | 5988005.8211 | 2105120.9797 | 37.759569004405606 | -122.48457502698 | (37.7595690044056, -122.48457502698) | |
| 35235 | 35235 | 34660 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38334 | 5987955.9197 | 2105118.4846 | 37.759559247409 | -122.484747425675 | (37.759559247409, -122.484747425675) | |
| 36479 | 36479 | 34629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | |
| 37832 | 37832 | 34658 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5987988.7714 | 2105120.9797 | 37.75956801150279 | -122.484633992596 | (37.7595680115028, -122.484633992596) | |
| 44447 | 44447 | 34630 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.754669500818295 | -122.481776191509 | (37.7546695008183, -122.481776191509) | |
| 59206 | 59206 | 34656 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5988021.6232 | 2105120.5638 | 37.7595687826789 | -122.484520345625 | (37.7595687826789, -122.484520345625) | |
| 96015 | 96015 | 34569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665002 | (37.7401467112036, -122.41215832665) | ||
| 98252 | 98252 | 34646 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | |||
| 126783 | 126783 | 34650 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38329 | 5987786.63645622 | 2103431.59810771 | 37.754917654251706 | -122.485209109036 | (37.7549176542517, -122.485209109036) | ||
| 175318 | 175318 | 34659 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38334 | 5987972.9693 | 2105119.7321 | 37.7595636656584 | -122.484688551924 | (37.7595636656584, -122.484688551924) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");