400 rows where qSpecies_id = 43 sorted by Fire Prevention Districts

View and edit SQL

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)
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
1543 259573 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 298 Public Park 3 Unaccepted Street : Cutout Tree Private 2       5x10   5994238 2098707 37.7423188086517 -122.462555955845 (37.7423188086517, -122.462555955845) 1 8 4 59 40
3187 70368 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983113.9936 2105313.3819 37.7598111971708 -122.501507359539 (37.7598111971708, -122.501507359539) 1 8 3 56 35
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
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
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
13527 34657 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 4   Permit Number 38334 5988005.8211 2105120.9797 37.7595690044056 -122.48457502698 (37.7595690044056, -122.48457502698) 1 8 3 56 35
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
19177 38121 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1332 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM     Permit Number 40285 5986502.93855263 2106173.76895003 37.7623720383861 -122.489850100877 (37.7623720383861, -122.489850100877) 1 8 3 56 35
29364 183465 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2530 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5988020.0365 2098057.021 37.7401740893942 -122.484007860756 (37.7401740893942, -122.484007860756) 1 8 3 29491 35
29636 69317 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2122 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1994 12:00:00 AM 6   Permit Number 33397 5987643.2305 2104427.6901 37.7576442978234 -122.485778145282 (37.7576442978234, -122.485778145282) 1 8 3 56 35
31546 37131 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 6   Permit Number 39713 5981666.4542 2104905.7911 37.7586069464275 -122.506483373023 (37.7586069464275, -122.506483373023) 1 8 3 56 35
32117 183413 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2350 Wawona St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985629.7915 2097026.6067 37.737205400625 -122.492196390733 (37.737205400625, -122.492196390733) 1 8 3 29491 35
32817 37130 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39713 5981688.5295 2104905.7911 37.758608246146 -122.506407027964 (37.758608246146, -122.506407027964) 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
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
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
39789 34659 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38334 5987972.9693 2105119.7321 37.7595636656584 -122.484688551924 (37.7595636656584, -122.484688551924) 1 8 3 56 35
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
49100 37124 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
59456 44816 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986280.5132 2105006.9468 37.7591552772781 -122.490533528729 (37.7591552772781, -122.490533528729) 1 8 3 56 35
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
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
67615 69146 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2479 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33181 5983616.53937475 2098288.7238606 37.7405529339472 -122.499250248288 (37.7405529339472, -122.499250248288) 1 8 3 29491 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
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
68850 187339 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985079.354 2099690.9452 37.7444887635366 -122.494295807794 (37.7444887635366, -122.494295807794) 1 8 3 29491 35
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
71470 44817 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986315.8836 2105009.2662 37.7591637116246 -122.490411373273 (37.7591637116246, -122.490411373273) 1 8 3 56 35
72686 34658 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 2   Permit Number 38334 5987988.7714 2105120.9797 37.7595680115028 -122.484633992596 (37.7595680115028, -122.484633992596) 1 8 3 56 35
72873 38036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 111 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40238 5993036.05890767 2098279.23820641 37.7410749908436 -122.466680779864 (37.7410749908436, -122.466680779864) 1 8 4 59 40
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
77557 34660 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38334 5987955.9197 2105118.4846 37.759559247409 -122.484747425675 (37.759559247409, -122.484747425675) 1 8 3 56 35
79954 44818 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986255.58 2105005.7872 37.7591506369625 -122.490619673159 (37.7591506369625, -122.490619673159) 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
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
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
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
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
99430 184739 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984690.4501 2106251.0591 37.7624782581791 -122.496124432854 (37.7624782581791, -122.496124432854) 1 8 3 56 35
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
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
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
110316 42870 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2554 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 5   Permit Number 42793 5986474.4308 2097869.1881 37.73956824618 -122.489338060188 (37.73956824618, -122.489338060188) 1 8 3 29491 35
116814 41829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1406 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42215 5991820.03879919 2105845.80564429 37.7617805674142 -122.471436503306 (37.7617805674142, -122.471436503306) 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
126430 37123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
139892 38864 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 4   Permit Number 40691 5989006.457 2105496.048 37.7606570618134 -122.481141834437 (37.7606570618134, -122.481141834437) 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
141950 34656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 2   Permit Number 38334 5988021.6232 2105120.5638 37.7595687826789 -122.484520345625 (37.7595687826789, -122.484520345625) 1 8 3 56 35
143533 38037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40239 5992979.27513605 2098217.94646306 37.7409034220219 -122.466872661258 (37.7409034220219, -122.466872661258) 1 8 4 59 40
146257 37125 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
163727 184740 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 6 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984699.9431 2106237.7689 37.7624423230543 -122.496090619994 (37.7624423230543, -122.496090619994) 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
173565 38123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1200 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 5   Permit Number 40287 5985851.366 2107007.0192 37.7646218448258 -122.492164972302 (37.7646218448258, -122.492164972302) 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
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
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
179725 38035 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 111 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40238 5993036.05890767 2098279.23820641 37.7410749908436 -122.466680779864 (37.7410749908436, -122.466680779864) 1 8 4 59 40
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
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
190933 40610 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1234 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/1999 12:00:00 AM 5   Permit Number 41621 5983375.0645 2106732.8195 37.7637239007009 -122.500709422357 (37.7637239007009, -122.500709422357) 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
4468 40059 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
5387 38597 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
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
9053 38570 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
12770 38626 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
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
16009 38566 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
18513 38167 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 315 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40305 6010555.26362325 2092792.3936381 37.7270047480515 -122.405719032848 (37.7270047480515, -122.405719032848) 10 3 7 309 28
20690 38595 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 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
23158 38196 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40323 6011305.3220934 2091453.71988413 37.7233709423274 -122.403031960796 (37.7233709423274, -122.403031960796) 10 3 7 309 28
23688 68883 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 59 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM     Permit Number 32855 6013060.20442694 2090777.05783105 37.721610806199 -122.396918198144 (37.721610806199, -122.396918198144) 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
30259 36821 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
36083 40050 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
43878 38172 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 433 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40308 6010665.04465284 2092691.20819375 37.7267330524509 -122.405332397121 (37.7267330524509, -122.405332397121) 10 3 7 309 28
44351 37782 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40117 6009320.94225991 2092982.60267054 37.7274579192917 -122.409999500097 (37.7274579192917, -122.409999500097) 10 3 7 309 28
47665 40058 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
49935 40037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
58227 38593 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
58314 38629 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
59390 38622 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
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
67064 40067 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1400 Thomas Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2005 12:00:00 AM     Permit Number 41294 6015817.64770175 2093187.90304466 37.7283836150635 -122.387554479201 (37.7283836150635, -122.387554479201) 10 3 8 58 1
71570 36820 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
72189 38209 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 830 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40332 6010874.68113014 2090828.02861629 37.7216288654759 -122.40447659257 (37.7216288654759, -122.40447659257) 10 3 7 309 28
72685 40051 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
72918 38642 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40567 6015859.80735798 2093156.47365065 37.7282996512663 -122.38740653837 (37.7282996512663, -122.38740653837) 10 3 8 58 1
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
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
82292 38596 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
83598 34569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 212 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38277 6008791.12126389 2097614.61295509 37.7401467112036 -122.41215832665 (37.7401467112036, -122.41215832665) 10 7 7 28859 2
85527 40036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
86025 38199 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 455 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40326 6010407.74547618 2092510.58020697 37.7262226967111 -122.406209156508 (37.7262226967111, -122.406209156508) 10 3 7 309 28

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