trees

400 rows where qSpecies_id = 43 sorted by SiteOrder

✎ 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)
179341 38180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 42 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40313 6011447.25206772 2091677.58315317 37.7239935496068 -122.402557066965 (37.7239935496068, -122.402557066965) 10 3 7 309 28
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
180479 35494 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3763 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38905 6005241.37948762 2104264.99377415 37.758207308358 -122.424904929122 (37.758207308358, -122.424904929122) 2 4 5 28859 19
180644 248448 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 136 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998284.3672 2107976.1331 37.768001745714 -122.449232557107 (37.768001745714, -122.449232557107) 15 5 11 29492 9
181109 38195 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 1 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
182131 40049 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1435 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41286 6015948.92421606 2093724.14562026 37.7298633009427 -122.38713803352 (37.7298633009427, -122.38713803352) 10 3 8 58 1
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
183856 35549 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
184586 37749 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1271 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1999 12:00:00 AM     Permit Number 40096 6009537.93489258 2101780.18844977 37.7516263413346 -122.409870111191 (37.7516263413346, -122.409870111191) 2 4 7 28859 19
184921 38197 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 731 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40324 6011355.00492598 2091469.0696772 37.7234158640083 -122.402861294571 (37.7234158640083, -122.402861294571) 10 3 7 309 28
189659 34528 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
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
191442 38168 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 349 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40306 6010462.31979056 2092763.8646761 37.7269212154772 -122.40603833072 (37.7269212154772, -122.40603833072) 10 3 7 309 28
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
49210 114656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001274.7016 2113900.9823 37.78444047533 -122.439314075739 (37.78444047533, -122.439314075739) 15 6 11 29490 13
177223 38077 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000633.42901 2113935.94101 37.7844999493368 -122.441535161579 (37.7844999493368, -122.441535161579) 15 6 11 29490 13
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
109355 38078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000636.81501 2113914.58701 37.7844415096587 -122.441521914323 (37.7844415096587, -122.441521914323) 15 6 11 29490 13
73346 38079 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000639.41901 2113899.22301 37.7843994724246 -122.441511802515 (37.7843994724246, -122.441511802515) 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
190764 38080 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000641.24201 2113883.59801 37.7843566740562 -122.441504373964 (37.7843566740562, -122.441504373964) 15 6 11 29490 13
88322 38072 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000643.06501 2113866.93101 37.7843110146233 -122.441496870623 (37.7843110146233, -122.441496870623) 15 6 11 29490 13
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
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
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
136957 38083 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
127672 38084 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
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
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
65565 246392 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1310 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999402.5635 2108427.4999 37.7693049801732 -122.445397311319 (37.7693049801732, -122.445397311319) 15 5 11 29492 9
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
70992 38813 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
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
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
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
79486 37707 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 720 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
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
93563 38619 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 2 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
96443 37870 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
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
100219 39676 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 2 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
100434 37455 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39928 6008336.46582591 2098008.78903327 37.7412035106459 -122.413758220259 (37.7412035106459, -122.413758220259) 2 7 7 28859 2
106945 140845 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 527 EUCLID AVE 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996698.8799 2113809.925 37.7839289983891 -122.455138170133 (37.7839289983891, -122.455138170133) 11 6 1 54 31
116835 43746 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 253 Summit St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43378 5996396.86656602 2089502.57565196 37.7171697577055 -122.454426548253 (37.7171697577055, -122.454426548253) 9 8 6 28861 24
118676 38594 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 2 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
124314 246395 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999349.2656 2108419.0206 37.7692786554823 -122.445581055639 (37.7692786554823, -122.445581055639) 15 5 11 29492 9
128913 43106 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 405 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42935 6009343.77596633 2114320.93489173 37.786049444672 -122.411427426058 (37.786049444672, -122.411427426058) 5 10 9 28852 36
129068 36828 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39535 6015154.00494247 2091194.79088837 37.7228741446414 -122.38970959128 (37.7228741446414, -122.38970959128) 10 3 8 58 1
129093 40069 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1410 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41295 6015766.58727052 2093225.96783558 37.7284853051097 -122.387733653848 (37.7284853051097, -122.387733653848) 10 3 8 58 1
135659 36831 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39536 6015108.90537025 2091047.28537032 37.7224666226612 -122.389855194073 (37.7224666226612, -122.389855194073) 10 3 8 58 1
140389 36187 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 8   Permit Number 39256 5996805.8212 2114349.7078 37.7854172332631 -122.45480720749 (37.7854172332631, -122.45480720749) 11 6 1 54 31
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
144944 36488 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 2 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
147085 40061 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 2 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
148447 35550 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
148461 43110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42936 6009339.17842867 2114353.98733566 37.7861399408742 -122.411445668311 (37.7861399408742, -122.411445668311) 5 10 9 28852 36
149710 40034 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 2 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
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
156451 31830 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
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
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
165109 39139 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1081 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40817 6007463.5839422 2101024.83737451 37.7494358467299 -122.416989987658 (37.7494358467299, -122.416989987658) 2 4 7 28859 19
169593 43744 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 240 Summit St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43377 5996455.89048278 2089497.50907915 37.7171592309734 -122.454222165987 (37.7171592309734, -122.454222165987) 9 8 6 28861 24
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
178631 38169 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 349 Bacon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40306 6010462.31979056 2092763.8646761 37.7269212154772 -122.40603833072 (37.7269212154772, -122.40603833072) 10 3 7 309 28
180904 34527 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
183814 37700 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 2 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
187515 37783 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 2 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
193933 40300 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2155 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM     Permit Number 41445 6006883.99939755 2105792.08668164 37.7624929958367 -122.419332354319 (37.7624929958367, -122.419332354319) 8 4 7 28859 19
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
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
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
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
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
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

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