trees

400 rows where qSpecies_id = 43 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
46004 37213 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 6   Permit Number 39778 5985860.9109 2105407.8744 37.7602315957486 -122.492014212427 (37.7602315957486, -122.492014212427) 1 8 3 56 35
46689 37212 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 5   Permit Number 39778 5985860.9109 2105390.2338 37.760183159546 -122.492012913605 (37.760183159546, -122.492012913605) 1 8 3 56 35
75146 42256 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1451 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42500 6014382.14951701 2101979.25998884 37.7524432441755 -122.39313199334 (37.7524432441755, -122.39313199334) 10 3 8 28856 1
36106 182248 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1454 34th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5985596.8527 2105324.6327 37.7599875985541 -122.492921320569 (37.7599875985541, -122.492921320569) 1 8 3 56 35
36266 41842 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1459 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42231 5992090.13126179 2105515.92983571 37.7608904365533 -122.470478344247 (37.7608904365533, -122.470478344247) 1 8 4 56 12
68189 68517 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32397 5993053.91795071 2101210.30087773 37.7491239746497 -122.466832052807 (37.7491239746497, -122.466832052807) 1 8 4 29491 12
86212 43997 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43554 6008915.83516029 2099075.89728061 37.7441660743482 -122.411830346827 (37.7441660743482, -122.411830346827) 2 7 7 28859 2
74396 121619 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 1465 Rhode Island St 1 Front Yard : Yard Tree Private 2           6012073 2101555 37.7511497699027 -122.401087656443 (37.7511497699027, -122.401087656443) 10 3 8 28856 29
36381 37477 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1466 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39948 5991509.07030691 2105439.09012647 37.7606458402301 -122.472482356472 (37.7606458402301, -122.472482356472) 1 8 4 56 12
119260 38854 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1466 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 3   Permit Number 40681 5989630.3392 2105375.4166 37.7603620895733 -122.478975308071 (37.7603620895733, -122.478975308071) 1 8 3 56 35
168308 37063 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1468 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39664 6003912.84552522 2099719.17052238 37.7456504127787 -122.429175446828 (37.7456504127787, -122.429175446828) 2 7 5 63 22
100442 37225 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1471 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39789 5985552.67131947 2105212.4791892 37.759677072307 -122.493065858593 (37.759677072307, -122.493065858593) 1 8 3 56 35
175884 37069 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1474 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39671 5983120.2149 2105112.095 37.7592588855971 -122.501470953069 (37.7592588855971, -122.501470953069) 1 8 3 56 35
60108 39693 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1475 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41078 6015709.80747314 2094943.53448428 37.7331982540931 -122.388049755187 (37.7331982540931, -122.388049755187) 10 3 8 58 1
86192 37106 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
171637 37105 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
67140 37133 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
99205 37134 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
31634 31124 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
36936 31125 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
3049 43998 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 150 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43555 6008950.71046834 2099077.83692872 37.7441733566649 -122.411709892219 (37.7441733566649, -122.411709892219) 2 7 7 28859 2
139109 38601 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1534 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40552 6015446.13574073 2094163.07491578 37.7310406573671 -122.388906878559 (37.7310406573671, -122.388906878559) 10 3 8 58 1
65067 38860 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1549 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40687 5989292.62615578 2104803.36922141 37.758771784472 -122.480101420695 (37.758771784472, -122.480101420695) 1 8 3 56 35
10370 72596 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1551 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988056.3788 2104735.0481 37.7585122851486 -122.484371869742 (37.7585122851486, -122.484371869742) 1 8 3 56 35
15667 38606 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1558 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40554 6015323.31475554 2094254.15832382 37.7312839455717 -122.389337853373 (37.7312839455717, -122.389337853373) 10 3 8 58 1
50923 34400 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 156 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38147 6002471.83146577 2097061.86671715 37.738272394243 -122.433968340214 (37.738272394243, -122.433968340214) 2 7 5 63 7
178986 38863 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1565 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40690 5989296.21457943 2104699.06297943 37.7584855960627 -122.480081376814 (37.7584855960627, -122.480081376814) 1 8 3 56 35
82029 38347 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1567 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM     Permit Number 40414 5981854.03597748 2104432.31461127 37.757317957298 -122.5057995404 (37.757317957298, -122.5057995404) 1 8 3 56 35
125415 34401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 157 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38148 6002541.2507672 2096900.64630627 37.7378336595187 -122.433716803341 (37.7378336595187, -122.433716803341) 2 7 5 63 7
88126 43999 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 158 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43556 6009020.46100461 2099081.71622052 37.7441879209123 -122.411468983209 (37.7441879209123, -122.411468983209) 2 7 7 28859 2
13763 72614 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1586 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5987797.3449 2104500.8291 37.7578540967372 -122.485250528016 (37.7578540967372, -122.485250528016) 1 8 3 56 35
17683 34648 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1591 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38327 5987753.8097 2104490.816 37.7578240672557 -122.485400354271 (37.7578240672557, -122.485400354271) 1 8 3 56 35
103016 34646 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1596 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38325 5987803.91965419 2104439.10360026 37.7576849982837 -122.48522326103 (37.7576849982837, -122.48522326103) 1 8 3 56 35
111332 32293 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41561 5996702.09015079 2089306.207139 37.7166480756618 -122.453357371649 (37.7166480756618, -122.453357371649) 9 8 6 28861 24
29221 34402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38149 6002458.41825324 2097080.12272084 37.7383217597979 -122.434016021054 (37.7383217597979, -122.434016021054) 2 7 5 63 7
47019 39910 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
77186 39908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
86961 39907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
89820 39905 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
150087 39909 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2001 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
8969 38615 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
21583 38613 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
26720 38614 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
89942 38612 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
183262 38616 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
125189 38617 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1619 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40558 6014993.23240611 2094434.43177017 37.7317606344589 -122.390491609305 (37.7317606344589, -122.390491609305) 10 3 8 58 1
146098 38618 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1648 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40559 6014913.01600852 2094558.97753063 37.7320981616183 -122.390777636678 (37.7320981616183, -122.390777636678) 10 3 8 58 1
18989 37041 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
29030 37044 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
44466 37043 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
127677 37042 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
142418 37039 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
159010 37040 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
63600 34404 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 171 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38152 6002491.04646095 2096956.56807226 37.7379843589135 -122.433894379886 (37.7379843589135, -122.433894379886) 2 7 5 63 7
75263 42277 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1718 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 7   Permit Number 42514 5986906.0637 2103542.512 37.7551708577637 -122.488262487214 (37.7551708577637, -122.488262487214) 1 8 3 56 35
9754 82920 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1734 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5982872.9956 2103302.6049 37.7542760130661 -122.502192036803 (37.7542760130661, -122.502192036803) 1 8 3 56 35
102213 99920 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1740 Jones St 7 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
69553 37195 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1742 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39762 5986908.61171996 2103401.39400305 37.7547835348007 -122.488243305818 (37.7547835348007, -122.488243305818) 1 8 3 56 35
35084 34650 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1743 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38329 5987786.63645622 2103431.59810771 37.7549176542517 -122.485209109036 (37.7549176542517, -122.485209109036) 1 8 3 56 35
140509 34630 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38311 5988776.9552 2103320.2277 37.7546695008183 -122.481776191509 (37.7546695008183, -122.481776191509) 1 8 3 56 35
193773 34629 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 6   Permit Number 38311 5988774.7652 2103307.0873 37.7546332934455 -122.481782802584 (37.7546332934455, -122.481782802584) 1 8 3 56 35
67851 34930 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1790 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/1997 12:00:00 AM     Permit Number 38522 5991259.7839455 2103214.98783119 37.7545246106445 -122.473182309921 (37.7545246106445, -122.473182309921) 1 8 4 56 12
123655 38553 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40521 6014535.26572589 2096873.10267881 37.7384313099375 -122.392245401183 (37.7384313099375, -122.392245401183) 10 3 8 58 1
46799 38320 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1810 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40378 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
178201 68496 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1822 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32372 5993466.35859208 2103074.11595722 37.7542653280544 -122.465541223192 (37.7542653280544, -122.465541223192) 1 8 4 56 12
14374 34363 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1846 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38119 6004556.0268692 2098000.12862747 37.7409667067108 -122.426829018524 (37.7409667067108, -122.426829018524) 2 7 5 63 7
172957 40642 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 185 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41640 6009192.03574967 2099143.33903301 37.7443667457738 -122.410880064189 (37.7443667457738, -122.410880064189) 2 7 7 28859 2
71856 36717 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1999 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
95507 36720 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
151832 36719 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
170901 36718 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
85584 38345 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1859 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 0   Permit Number 40412 5982231.73051381 2102455.52324126 37.7519124687384 -122.504346906094 (37.7519124687384, -122.504346906094) 1 8 3 56 35
13812 34364 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1862 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38120 6004563.40220029 2097868.81083057 37.7406065549579 -122.426794167737 (37.7406065549579, -122.426794167737) 2 7 5 63 7
89415 40641 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 187 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41639 6009210.87994007 2099144.38708889 37.7443706801351 -122.410814978675 (37.7443706801351, -122.410814978675) 2 7 7 28859 2
9023 38354 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1875 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 0   Permit Number 40422 5981305.52143941 2102319.66652747 37.7514849260003 -122.507539731955 (37.7514849260003, -122.507539731955) 1 8 3 56 35
138527 42740 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 188 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42736 6012851.94955825 2087048.25997051 37.7113606761586 -122.397376721388 (37.7113606761586, -122.397376721388) 10 3 8 309 1
100897 68054 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1881 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31791 5993737.20481548 2102706.11474697 37.7532705090115 -122.46457785688 (37.7532705090115, -122.46457785688) 1 8 4 56 12
166774 141601 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1882 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998863.8341 2110436.3604 37.77479003056 -122.447405354515 (37.77479003056, -122.447405354515) 15 5 11 29492 16
107910 51637 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 189 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47927 5996660.05636895 2089154.42395132 37.7162289049692 -122.453491707846 (37.7162289049692, -122.453491707846) 9 8 6 28861 24
126442 35941 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39104 6007226.10455525 2097703.31078326 37.7403023177454 -122.417575817322 (37.7403023177454, -122.417575817322) 2 7 7 28859 2
22627 31126 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34843 5998070.7770048 2093598.16198917 37.7285111411981 -122.448935514449 (37.7285111411981, -122.448935514449) 9 7 4 28861 40
36633 35970 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 190 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39128 6006126.55379065 2096333.04753419 37.7364779485792 -122.421280351482 (37.7364779485792, -122.421280351482) 2 7 7 28859 2
190034 69279 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1935 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33350 5991240.95366227 2102241.42925325 37.7518503834746 -122.473176432428 (37.7518503834746, -122.473176432428) 1 8 4 29491 12
93886 68599 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1939 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32502 5991241.84953509 2102215.30732714 37.7517787113613 -122.473171429533 (37.7517787113613, -122.473171429533) 1 8 4 29491 12
183661 79350 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1946 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 3 3x3 Permit Number 767118 5983237.8759 2101878.6369 37.7503876245198 -122.500824911735 (37.7503876245198, -122.500824911735) 1 8 3 29491 35
161625 126462 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6000762.32542 2120990.48851 37.8038772290062 -122.441595650935 (37.8038772290062, -122.441595650935) 13 9 1 57 17
172638 126461 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6000743.63592 2120987.57838 37.8038681737437 -122.441660117946 (37.8038681737437, -122.441660117946) 13 9 1 57 17
64957 9986 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2007 12:00:00 AM 8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
161440 9987 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
5456 38303 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
34131 38301 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
58172 38315 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
112873 38302 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
147396 38211 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 201 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40334 6011139.75939059 2091047.44760609 37.7222461553598 -122.403575712805 (37.7222461553598, -122.403575712805) 10 3 7 309 28
131078 31826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
172252 31827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
136510 34429 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38173 6002089.34387418 2096139.54747106 37.7357182050796 -122.435224839434 (37.7357182050796, -122.435224839434) 2 7 5 63 7
26194 34414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 205 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38161 6004190.49432582 2097526.98545022 37.7396468892769 -122.428059186764 (37.7396468892769, -122.428059186764) 2 7 5 63 7
28860 36076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2091 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39189 6008123.15826597 2106262.62233667 37.7638546903501 -122.415079851694 (37.7638546903501, -122.415079851694) 8 4 7 28859 19
177763 255250 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 209x Willow St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);