trees

400 rows where qSpecies_id = 43 sorted by DBH

✎ 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)
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
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
3336 35927 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 22 Appleton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM     Permit Number 39097 6005564.10753047 2097077.73566378 37.738490969573 -122.423277889221 (37.738490969573, -122.423277889221) 2 7 7 28859 2
3588 37560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4645 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 39999 6000466.36495931 2104620.54811441 37.758912703603 -122.44144447135 (37.758912703603, -122.44144447135) 2 4 5 28862 38
3986 116680 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 100 Esmeralda Ave 19 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
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
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
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
10411 47385 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1231 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2002 12:00:00 AM     Permit Number 45301 6001377.58877778 2100188.59270033 37.7467954887327 -122.437975585037 (37.7467954887327, -122.437975585037) 2 4 5 63 22
12226 68412 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 33 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32249 5993232.78328668 2093269.41121212 37.7273306024275 -122.465636703092 (37.7273306024275, -122.465636703092) 9 8 4 59 40
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
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
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
14912 34353 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 11 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38109 6004890.69932117 2098315.24737801 37.7418508681298 -122.425694266568 (37.7418508681298, -122.425694266568) 2 7 5 63 7
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
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
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
19915 37424 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
20022 35741 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 231 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39015 6007788.68777846 2092857.60054619 37.7270286926321 -122.415287680245 (37.7270286926321, -122.415287680245) 9 3 7 309 28
20564 35401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 30th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38856 6003213.78352736 2098311.09733417 37.7417445720019 -122.431492193982 (37.7417445720019, -122.431492193982) 2 7 5 63 7
20587 40463 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 378 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1999 12:00:00 AM     Permit Number 41548 6007684.60346868 2097335.44684482 37.7393180333935 -122.415964462581 (37.7393180333935, -122.415964462581) 2 7 7 28859 2
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
21691 35960 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
22083 36334 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1998 12:00:00 AM     Permit Number 39301 5995656.19844855 2092807.02452797 37.7262004833581 -122.457225579924 (37.7262004833581, -122.457225579924) 9 7 4 28861 40
22221 36454 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
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
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
23544 42023 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 110 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42346 5993552.23919225 2093678.6131862 37.7284725917152 -122.464562053467 (37.7284725917152, -122.464562053467) 9 8 4 59 40
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
25563 36489 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 5 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
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
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
27476 31110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
28494 42555 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 519 Darien Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42646 5993007.97320082 2094936.14188553 37.7318940637686 -122.466534957812 (37.7318940637686, -122.466534957812) 9 8 4 59 40
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
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
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
29470 45414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 845 Head St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2001 12:00:00 AM     Permit Number 44215 5993893.70509068 2091558.26488077 37.7226703098261 -122.463227804134 (37.7226703098261, -122.463227804134) 9 8 4 59 40
30149 34482 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 840 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38209 6008945.03028541 2119415.9766962 37.8000168102383 -122.413167394928 (37.8000168102383, -122.413167394928) 3 1 10 308 32
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
31600 38082 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000645.66901 2113851.82701 37.7842696912791 -122.44148677751 (37.7842696912791, -122.44148677751) 15 6 11 29490 13
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
32857 47691 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2858 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45490 6001036.99468682 2116264.16139907 37.7909156246348 -122.440305990836 (37.7909156246348, -122.440305990836) 13 6 1 29490 27
32928 37704 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
33819 38088 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000614.67901 2114079.17001 37.7848921510189 -122.441610312074 (37.7848921510189, -122.441610312074) 15 6 11 29490 13
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
34181 68180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 75 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31952 5996329.36645327 2111693.70801186 37.7780972208044 -122.456263479509 (37.7780972208044, -122.456263479509) 11 6 2 54 16
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
35658 36470 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 101 San Ramon Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39368 5995817.82622595 2092643.889646 37.7257618354228 -122.456655052435 (37.7257618354228, -122.456655052435) 9 7 4 28861 40
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
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
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
36835 37313 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 485 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39829 6003203.23907746 2103274.86360864 37.7553733132886 -122.431883001431 (37.7553733132886, -122.431883001431) 2 4 5 28862 22
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
37192 35942 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 21 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39105 6007225.31509594 2097693.4445482 37.7402751828319 -122.417577847872 (37.7402751828319, -122.417577847872) 2 7 7 28859 2
39342 37525 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1150 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/22/1998 12:00:00 AM   3x3 Permit Number 52992 6007323.5106073 2115257.61387493 37.7885078148262 -122.418483459105 (37.7885078148262, -122.418483459105) 13 9 10 28858 21
39432 37587 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
41386 121194 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 255x Red Rock Way 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
41684 68560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32450 5981950.36786377 2112213.67297772 37.7786889858471 -122.506043321809 (37.7786889858471, -122.506043321809) 11 6 2 55 26
42365 39173 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 7461 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40835 6007491.70606937 2105311.60400293 37.7612079095392 -122.417196465004 (37.7612079095392, -122.417196465004) 2 4 7 28859 19
42461 35961 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
43841 39675 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
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
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
45134 34388 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 100 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38136 6003730.56187145 2096520.40051304 37.7368570045518 -122.429577666227 (37.7368570045518, -122.429577666227) 2 7 5 63 7
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
46836 37543 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 704 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39985 6008763.04341244 2114941.12322015 37.7877197423167 -122.413480489066 (37.7877197423167, -122.413480489066) 5 1 10 28858 21
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
47043 36453 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
47534 34111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
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
49379 38081 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000619.36701 2114044.53501 37.7847973193303 -122.441591606798 (37.7847973193303, -122.441591606798) 15 6 11 29490 13
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
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
54982 31111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
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
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
59370 68249 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3531 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32050 6001184.87724579 2120700.92595518 37.8031062325164 -122.440112611548 (37.8031062325164, -122.440112611548) 13 9 1 57 17
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
62613 37588 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
63942 31145 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/2006 12:00:00 AM   3x3 Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 9 7 4 28861 40
64036 43694 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 750 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43338 5993218.66242977 2110366.15850001 37.7742730687673 -122.46692789928 (37.7742730687673, -122.46692789928) 11 6 2 54 11
64456 42029 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 65 Upland Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42351 5994340.62872168 2093722.8989966 37.728639607369 -122.461839780515 (37.728639607369, -122.461839780515) 9 8 4 59 40
65609 37589 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
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
67437 36510 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 406 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39387 6007487.22983868 2096928.20854387 37.7381887481689 -122.416618053798 (37.7381887481689, -122.416618053798) 2 7 7 28859 2
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
67646 39064 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
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

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