3,965 rows where qSpecies_id = 70 sorted by PermitNotes descending

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)
23222 53937 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 174 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM 12 3x4 Permit Number 9651 5993070.40109 2114326.65829 37.7851389689099 -122.467728857293 (37.7851389689099, -122.467728857293) 11 6 2 54 11
1631 30310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
14545 30309 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
194294 111846 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2720 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2020 12:00:00 AM 3 3x3 Permit Number 785307 6000128.0406 2117924.83666 37.7954236080649 -122.443570269862 (37.7954236080649, -122.443570269862) 13 9 1 57 17
194295 111848 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2720 Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 785307 6000127.46619 2117938.95057 37.7954623283723 -122.443573271789 (37.7954623283723, -122.443573271789) 13 9 1 57 17
194303 111847 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2720 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 785307 6000127.3505 2117932.29224 37.7954440397598 -122.443573193555 (37.7954440397598, -122.443573193555) 13 9 1 57 17
194313 111849 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2720 Broderick St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 785307 6000127.71624 2117950.98913 37.7954953973371 -122.443573271798 (37.7954953973371, -122.443573271798) 13 9 1 57 17
194273 263629 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1985X Alemany Blvd 1 Side Yard : Yard Tree Private 2       10x10 Permit Number 785142 6000955 2090559 37.7203308201534 -122.438746936552 (37.7203308201534, -122.438746936552) 9 7 6 28861 25
8988 125125 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2921 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft Permit Number 784827 5999533.93344 2117358.43143 37.7938345087112 -122.445585222496 (37.7938345087112, -122.445585222496) 13 9 1 57 27
12411 260714 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2290 Lyon St 1 Back Yard : Cutout Tree Private 2       3x3 Permit Number 784756 5999390 2116615 37.7917850243096 -122.446029746387 (37.7917850243096, -122.446029746387) 13 6 1 29490 27
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
183780 218318 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 407 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2   03/07/2019 12:00:00 AM 3 Width 0ft Permit Number 782718 5993261.50766 2099931.86652 37.7456256983858 -122.466021325821 (37.7456256983858, -122.466021325821) 1 8 4 29491 40
99095 125118 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3170 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft Permit Number 782127 5999016.80534 2116307.34293 37.7909189615014 -122.447298841085 (37.7909189615014, -122.447298841085) 13 6 1 29490 31
165444 120228 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 172 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2018 12:00:00 AM 3 Width 4ft Permit Number 781953 5988061.30942 2114851.82661 37.7862904310499 -122.485097081718 (37.7862904310499, -122.485097081718) 11 6 1 55 33
31117 204006 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1347 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft Permit Number 781782 5993496.82475 2097739.91918 37.7396207362118 -122.465048470705 (37.7396207362118, -122.465048470705) 1 8 4 59 40
173722 250672 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 726 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2018 12:00:00 AM 3 Width 4ft Permit Number 781557 5986349.68151 2114864.86182 37.7862263710027 -122.491019750162 (37.7862263710027, -122.491019750162) 11 6 1 55 33
31720 254395 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1286 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 781556 5988061 2106558 37.7635178832746 -122.484489596097 (37.7635178832746, -122.484489596097) 1 8 3 56 35
68079 203280 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 59 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     14 Width 10ft Permit Number 781025 5999721.17343 2095479.15955 37.7337701687542 -122.443365077855 (37.7337701687542, -122.443365077855) 9 7 4 63 40
182107 251542 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 50 Vista Ln   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 780127 5999350 2102347 37.7526064375926 -122.445141915929 (37.7526064375926, -122.445141915929) 2 5 5 63 38
65102 124801 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2898 Union St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft Permit Number 780062 5999229.08983 2118053.40815 37.7957253216105 -122.446690033314 (37.7957253216105, -122.446690033314) 13 9 1 57 17
34056 64237 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 557 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2017 12:00:00 AM 3 3x3 Permit Number 779942 5987180.23832 2112140.30179 37.7787939955639 -122.487946016766 (37.7787939955639, -122.487946016766) 11 6 2 55 26
140302 124755 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2040 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft Permit Number 779873 6003722.50351 2117641.05418 37.794848756005 -122.431112566798 (37.794848756005, -122.431112566798) 13 9 1 29490 27
143678 68937 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 518 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/06/2017 12:00:00 AM 3   Permit Number 779489 5992539.41235 2111890.04765 37.7784180283155 -122.46938847409 (37.7784180283155, -122.46938847409) 11 6 2 54 11
69249 121575 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 57-59 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2017 12:00:00 AM 3 6x8 Permit Number 779439 5991428 2114866 37.786524881607 -122.473450350287 (37.786524881607, -122.473450350287) 11 6 1 54 33
53811 121152 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 4300 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2017 12:00:00 AM 3 3x3 Permit Number 779217 6001168 2102360 37.7527457326892 -122.438855901364 (37.7527457326892, -122.438855901364) 2 4 5 28862 22
87130 122739 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 4300 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2017 12:00:00 AM 3 5x5 Permit Number 779217 6001168 2102360 37.7527457326892 -122.438855901364 (37.7527457326892, -122.438855901364) 2 4 5 28862 22
146860 122740 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 4300 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2017 12:00:00 AM 3 3x3 Permit Number 779217 6001168 2102360 37.7527457326892 -122.438855901364 (37.7527457326892, -122.438855901364) 2 4 5 28862 22
153666 122576 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1910 30th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 779012 5986951.5849 2102234.0134 37.7515807312502 -122.488008923136 (37.7515807312502, -122.488008923136) 1 8 3 29491 35
132464 121203 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3041 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4 Permit Number 778902 5999408.34577 2119299.99025 37.7991583414361 -122.446159489987 (37.7991583414361, -122.446159489987) 13 9 1 57 17
43680 203910 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 544 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2017 12:00:00 AM 24 Width 4ft Permit Number 778778 5992548.72144 2104598.67457 37.7583983997918 -122.468825547757 (37.7583983997918, -122.468825547757) 1 8 4 56 12
57608 110848 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2668 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778643 6000804.34505 2117582.1485 37.7945212238167 -122.441205550194 (37.7945212238167, -122.441205550194) 13 9 1 57 27
73770 110847 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2668 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2016 12:00:00 AM 3 3x3 Permit Number 778643 6000834.0024 2117585.61695 37.7945324365719 -122.441103181276 (37.7945324365719, -122.441103181276) 13 9 1 57 27
172734 115358 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 353 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2016 12:00:00 AM 3 6x6 Permit Number 778572 6001795.91538 2087927.53278 37.7131532009313 -122.435652007258 (37.7131532009313, -122.435652007258) 9 7 6 28861 5
101045 116781 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2016 12:00:00 AM 3 3x3 Permit Number 778230 5997601.12717 2115625.0178 37.7889644837841 -122.452147749912 (37.7889644837841, -122.452147749912) 11 6 1 54 31
112086 95360 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 3 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   12 3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
141758 95359 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   12 3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
142765 95361 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 4 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   10 3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
148170 95362 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency     3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
157769 95358 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 1 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   25 3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
73787 116455 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2728 GREEN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 4x4 Permit Number 778010 5999979 2117809 37.7950970500966 -122.444077646155 (37.7950970500966, -122.444077646155) 13 9 1 57 17
83887 110557 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 600 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777830 5987235.91404 2111803.79765 37.7778732980336 -122.487728686455 (37.7778732980336, -122.487728686455) 11 6 2 55 26
73455 51704 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 171 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2016 12:00:00 AM 3   Permit Number 777735 6001742.29918465 2107821.21142041 37.7677735488102 -122.437260877297 (37.7677735488102, -122.437260877297) 15 5 5 29492 3
176729 15277 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1563X Mission St 2 Median : Cutout Tree DPW 1   10/28/2016 12:00:00 AM 3 4X4 Permit Number 777705 6007250.56082 2109703.40074 37.7732531819334 -122.418341887077 (37.7732531819334, -122.418341887077) 8 2 9 28853 19
2457 115561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 44 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 4x10 Permit Number 777606 5989293.97789 2114922.2794 37.7865556002814 -122.480837576069 (37.7865556002814, -122.480837576069) 11 6 1 55 33
184376 46251 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2683 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2016 12:00:00 AM 7   Permit Number 777339 6000247.41446 2117804.02133 37.7950986884031 -122.443148536401 (37.7950986884031, -122.443148536401) 13 9 1 57 27
69992 112618 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3 3x3 Permit Number 777210 6002384.2725 2115806.13213 37.7897346101096 -122.435611691534 (37.7897346101096, -122.435611691534) 13 9 1 29490 27
130936 114571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3633 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777013 5997417 2115685 37.7891186297883 -122.452789133032 (37.7891186297883, -122.452789133032) 11 6 1 54 31
78793 115073 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2263 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM 24 3x3 Permit Number 777001 6003883.69661 2116609.10432 37.7920244180358 -122.430481149195 (37.7920244180358, -122.430481149195) 13 9 1 29490 27
120624 113660 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3060 JACKSON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Permit Number 776720 5999534 2116404 37.7912138957856 -122.445516329339 (37.7912138957856, -122.445516329339) 13 6 1 29490 27
68058 112042 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2418 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM 17 3x3 Permit Number 776583 6002409.60423 2117108.01013 37.7933106707057 -122.435617223266 (37.7933106707057, -122.435617223266) 13 9 1 29490 27
42888 113973 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 11 Hiliritas Ave 1 Front Yard : Yard Tree Private 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
122110 113061 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2775 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 776016 6000301.4 2117440.5 37.7941036326689 -122.442935620895 (37.7941036326689, -122.442935620895) 13 9 1 57 27
13976 1368 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 33 Amethyst Way 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 1X1 Permit Number 776000 5999092.87122 2100014.72745 37.7461879050589 -122.445863385507 (37.7461879050589, -122.445863385507) 2 7 5 63 22
169502 1367 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 33 Amethyst Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 1X1 Permit Number 776000 5999068.70954 2100015.22991 37.7461879050483 -122.445946969396 (37.7461879050483, -122.445946969396) 2 7 5 63 22
99826 67295 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2021 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2015 12:00:00 AM 3   Permit Number 775844 5999878.81667 2115908.61359 37.7898733737087 -122.444287662668 (37.7898733737087, -122.444287662668) 13 6 1 29490 27
192441 98513 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100 De Montfort Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3 Permit Number 775766 5995016.6 2091971.4 37.7238693046984 -122.459376132933 (37.7238693046984, -122.459376132933) 9 8 4 28861 24
114168 115175 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1899X 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x20 Permit Number 775764 5993756.36006 2102907.65397 37.7538249882276 -122.464526247261 (37.7538249882276, -122.464526247261) 1 8 4 56 12
153919 111044 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1635 Plymouth Ave 1 Sidewalk: Property side : Yard Tree Private 2       6x10 Permit Number 775721 5995557 2094802 37.7316725070779 -122.457712790279 (37.7316725070779, -122.457712790279) 9 7 4 59 40
140352 111337 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2178 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2015 12:00:00 AM 3 3x10 Permit Number 775561 5991058.1 2100603.7 37.7473430166558 -122.473689301 (37.7473430166558, -122.473689301) 1 8 4 29491 40
162685 103476 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 147 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2013 12:00:00 AM     Permit Number 775299 6001179.7 2121217.2 37.8045234887457 -122.440167571349 (37.8045234887457, -122.440167571349) 13 9 1 57 17
171881 55211 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 101X Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/1972 12:00:00 AM     Permit Number 775231 5999977.22784047 2112772.7148777 37.7812686237346 -122.443721790146 (37.7812686237346, -122.443721790146) 15 5 1 29490 16
168909 112367 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2770 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.43478 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617) 13 9 1 57 27
34135 106832 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 138 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 774880 5997571.74884 2115814.60363 37.7894833530272 -122.452263079899 (37.7894833530272, -122.452263079899) 11 6 1 54 31
131261 104547 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 MADRONE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2015 12:00:00 AM 3 3x6 Permit Number 774728 5992588 2098182 37.7407821316344 -122.468222919411 (37.7407821316344, -122.468222919411) 1 8 4 59 40
166824 104548 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 MADRONE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3x10 Permit Number 774728 5992588 2098182 37.7407821316344 -122.468222919411 (37.7407821316344, -122.468222919411) 1 8 4 59 40
180863 109131 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 Madrone Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2015 12:00:00 AM 3 3x3 Permit Number 774728 5992631.8 2098170.8 37.740753908855 -122.468070662321 (37.740753908855, -122.468070662321) 1 8 4 59 40
107957 94851 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1107 Bowdoin St 2 Front Yard : Yard Tree Private 2   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
151507 112490 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3 Permit Number 774532 6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
67303 109049 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2146 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 774033 6000515.3 2120331 37.8020523729009 -122.442403120222 (37.8020523729009, -122.442403120222) 13 9 1 57 17
119649 109048 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2146 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 774033 6000515.3 2120331 37.8020523729009 -122.442403120222 (37.8020523729009, -122.442403120222) 13 9 1 57 17
164247 105787 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 67- 69 CASA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 9x3 Permit Number 773990 6001454.5 2121609.5 37.8056162809509 -122.439244738513 (37.8056162809509, -122.439244738513) 13 9 1 57 17
145350 107354 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 34 Princeton St   Sidewalk: Curb side : Cutout Tree Private 2   08/25/2014 12:00:00 AM     Permit Number 773911 6007504.47131 2093847.45075 37.7297306299075 -122.41634029479 (37.7297306299075, -122.41634029479) 9 3 7 309 28
130547 98318 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1811 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2015 12:00:00 AM 3 3x3 Permit Number 773893 6001987.8 2114705.4 37.786689755292 -122.436904612265 (37.786689755292, -122.436904612265) 13 6 11 29490 27
134464 98317 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1811 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2015 12:00:00 AM 3 3x3 Permit Number 773893 6001987.8 2114705.4 37.786689755292 -122.436904612265 (37.786689755292, -122.436904612265) 13 6 11 29490 27
34078 106506 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3975 22nd St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
131481 106505 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3975 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
112586 106503 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
130598 106504 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
117611 104976 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 348 STRATFORD DR 1 Sidewalk: Property side : Yard Tree Private 2     14   Permit Number 771068 5990941.2 2090341.4 37.7191585669518 -122.473345157269 (37.7191585669518, -122.473345157269) 9 8 4 64 40
153430 104809 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 685 Marina Blvd   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 770974 5999736.8 2121509.8 37.8052446370698 -122.445181890463 (37.8052446370698, -122.445181890463) 13 9 1 57 17
31746 104753 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2328 12TH AVE   Front Yard : Cutout Tree Private 2     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356) 1 8 4 29491 40
155560 203734 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2328 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft Permit Number 770921 5992653.8964 2099572.36715 37.7446035325326 -122.468096189498 (37.7446035325326, -122.468096189498) 1 8 4 29491 40
32089 106242 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 5 Sidewalk: Property side : Yard Tree Private 2     6   Permit Number 770844 6012041.04445 2105749.16688 37.7626642466674 -122.401492899679 (37.7626642466674, -122.401492899679) 8 3 8 28856 29
70795 106249 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 10 Sidewalk: Curb side : Cutout Tree Private 2     12   Permit Number 770844 6012059.45728 2105702.6288 37.7625374908356 -122.401425945147 (37.7625374908356, -122.401425945147) 8 3 8 28856 29
157924 106248 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 9 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770844 6012033.91664 2105711.77198 37.7625611708892 -122.401514924078 (37.7625611708892, -122.401514924078) 8 3 8 28856 29
163150 106241 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     10   Permit Number 770844 6012039.11056 2105754.27928 37.7626781762725 -122.401499947673 (37.7626781762725, -122.401499947673) 8 3 8 28856 29
61043 68013 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2245 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1993 12:00:00 AM 21   Permit Number 770742 5999478.95817 2120820.40604 37.8033370269329 -122.446024564694 (37.8033370269329, -122.446024564694) 13 9 1 57 17
58489 104690 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1435X La Salle Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
87061 104723 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 133X Juan Bautista Cir 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770293 5989605.82194 2089746.43988 37.7174475379801 -122.477917527277 (37.7174475379801, -122.477917527277) 1 8 4 64 14
193946 102631 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 175 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769999 5987997.5 2114816.6 37.7861899917282 -122.485315257259 (37.7861899917282, -122.485315257259) 11 6 1 55 33
48043 102629 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 168 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15   Permit Number 769953 5988063.8153 2114882.99878 37.7863761669029 -122.485090700066 (37.7863761669029, -122.485090700066) 11 6 1 55 33
125951 59324 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1370 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/2012 12:00:00 AM 1   Permit Number 769281 5983406.5406 2105829.5951 37.761245750287 -122.500533768842 (37.761245750287, -122.500533768842) 1 8 3 56 35
178622 100392 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1800X Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769124 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
104052 99855 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2900 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768992 5999541.6 2118827.3 37.7978680691774 -122.445664375651 (37.7978680691774, -122.445664375651) 13 9 1 57 17
162549 99856 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2900 Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768992 5999541.6 2118827.3 37.7978680691774 -122.445664375651 (37.7978680691774, -122.445664375651) 13 9 1 57 17
14158 99903 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
22295 99908 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
23492 99901 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
53086 99902 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
80066 99897 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2101X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     21   Permit Number 768908 6004409.82631 2116680.57597 37.7922504509529 -122.428665832574 (37.7922504509529, -122.428665832574) 13 9 1 28858 27

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