155 rows where qSpecies_id = 68 sorted by rowid 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)
193280 196534 DPW Maintained 1 Prunus spp :: Cherry 68 2221 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011830.1521 2101342.38489 37.7505524246675 -122.401912510764 (37.7505524246675, -122.401912510764) 10 3 8 28856 1
193278 50442 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
191979 196066 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 29 Front Yard : Yard Tree Private 2     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437159 (37.7467079937826, -122.38832437159)   3 8 58 1
191781 196068 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 9 Side Yard : Yard Tree Private 2     3     6013885.20395 2092887.61216 37.7274518522042 -122.394214063144 (37.7274518522042, -122.394214063144) 10 3 8 58 1
191512 40428 Permitted Site 7 Prunus spp :: Cherry 68 29 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1999 12:00:00 AM     Permit Number 41523 6007969.10251409 2094049.49213596 37.7303115087504 -122.414748301777 (37.7303115087504, -122.414748301777) 9 3 7 309 28
191467 20855 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
190691 196373 DPW Maintained 1 Prunus spp :: Cherry 68 1900 19th St 2 Front Yard : Yard Tree Private 2     1     6012066.64129 2105141.25616 37.760996487211 -122.401361645431 (37.760996487211, -122.401361645431) 10 3 8 28856 29
190581 234912 DPW Maintained 1 Prunus spp :: Cherry 68 266 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006193.38743 2096072.09961 37.7357652112859 -122.421030756557 (37.7357652112859, -122.421030756557) 2 7 7 28859 2
190293 136023 DPW Maintained 1 Prunus spp :: Cherry 68 60 MacOndray Ln 3 Sidewalk: Property side : Yard Tree Private 2     3     6008389.23117 2119145.89275 37.7992440090735 -122.415071550105 (37.7992440090735, -122.415071550105) 5 1 10 308 32
189823 19024 DPW Maintained 1 Prunus spp :: Cherry 68 3170 Sacramento St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372) 13 6 1 29490 27
189473 121317 DPW Maintained 1 Prunus spp :: Cherry 68 1270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6007670 2102262 37.7528444245459 -122.416363810551 (37.7528444245459, -122.416363810551) 2 4 7 28859 19
189054 19028 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     7 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 13 6 1 29490 27
188790 93987 Permitted Site 7 Prunus spp :: Cherry 68 200 Belgrave Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 53411 5997460.5 2104904 37.759519290122 -122.451860552802 (37.759519290122, -122.451860552802) 15 5 11 29492 12
186812 234918 DPW Maintained 1 Prunus spp :: Cherry 68 1319 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011166.83162 2102201.8831 37.7528753762183 -122.404266824377 (37.7528753762183, -122.404266824377) 10 4 8 28859 19
186129 19033 Permitted Site 7 Prunus spp :: Cherry 68 3192 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   5999542.70067 2115392.3027 37.7884365373764 -122.445413449171 (37.7884365373764, -122.445413449171) 13 6 1 29490 27
185049 185048 DPW Maintained 1 Prunus spp :: Cherry 68 2767 34th Ave 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.491467390698 (37.7360613326903, -122.491467390698) 1 8 3 29491 35
181735 237947 DPW Maintained 1 Prunus spp :: Cherry 68 923 Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6008000.76687 2102633.77568 37.7538838309939 -122.415246269499 (37.7538838309939, -122.415246269499) 2 4 7 28859 19
178755 141006 DPW Maintained 1 Prunus spp :: Cherry 68 269 COLLINS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998171.184 2112777.5693 37.7811787774786 -122.449970134459 (37.7811787774786, -122.449970134459) 15 6 2 54 16
177866 53304 Permitted Site 7 Prunus spp :: Cherry 68 47 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/1969 12:00:00 AM 2 4x4 Permit Number 6194 6004117.25840717 2102785.08371789 37.7540802654829 -122.42868713344 (37.7540802654829, -122.42868713344) 2 4 5 28862 22
175309 88559 Permitted Site 7 Prunus spp :: Cherry 68 2901 Pierce St   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501 2118350 37.7966692015857 -122.438850093229 (37.7966692015857, -122.438850093229) 13 9 1 57 17
174947 50443 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
174316 50441 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
174186 105781 DPW Maintained 1 Prunus spp :: Cherry 68 1631 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2014 12:00:00 AM     Permit Number 772613 6001347.6 2111440.1 37.7776876665107 -122.43888545994 (37.7776876665107, -122.43888545994) 15 5 11 29492 41
173631 96998 Significant Tree 6 Prunus spp :: Cherry 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
173341 51063 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
172948 51060 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
172665 179165 DPW Maintained 1 Prunus spp :: Cherry 68 671 London St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6001067.99101 2089902.67343 37.7185351226768 -122.438309369006 (37.7185351226768, -122.438309369006) 9 7 6 28861 5
168750 116071 DPW Maintained 1 Prunus spp :: Cherry 68 4150X CLEMENT ST 1 Front Yard : Yard Tree DPW 1     8 3x3   5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
167001 11193 DPW Maintained 1 Prunus spp :: Cherry 68 162 Idora Ave 1 Median : Cutout Tree DPW 1     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957) 1 8 4 59 40
166835 196065 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 28 Front Yard : Yard Tree Private 2     3     6015745.27894 2099859.59173 37.7466987082831 -122.388270101098 (37.7466987082831, -122.388270101098)   3 8 58 1
164673 122230 DPW Maintained 1 Prunus spp :: Cherry 68 700 14th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5991662.29598 2110580.87973 37.7747726831994 -122.472327258665 (37.7747726831994, -122.472327258665) 11 6 2 54 26
164522 199890 DPW Maintained 1 Prunus spp :: Cherry 68 1200x Quesada Ave 1 Median : Cutout Tree DPW 1     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943) 10 3 8 58 1
163327 181930 DPW Maintained 1 Prunus spp :: Cherry 68 2431 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5986090.3717 2098682.4704 37.7417788753673 -122.49072577603 (37.7417788753673, -122.49072577603) 1 8 3 29491 35
163037 136022 DPW Maintained 1 Prunus spp :: Cherry 68 60 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     6     6008402.81482 2119144.69077 37.7992414720639 -122.415024460715 (37.7992414720639, -122.415024460715) 5 1 10 308 32
159933 183196 Undocumented 4 Prunus spp :: Cherry 68 2479 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976 -122.498162805629 (37.740580843976, -122.498162805629) 1 8 3 29491 35
154760 4161 DPW Maintained 1 Prunus spp :: Cherry 68 3747 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/26/2001 12:00:00 AM 3 3X3   6005530.36537 2100484.52073 37.7478433240046 -122.423636704969 (37.7478433240046, -122.423636704969) 2 4 5 28859 22
154514 109243 Permitted Site 7 Prunus spp :: Cherry 68 755 Buena Vista Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4     5999798.5 2108081.7 37.7683780948237 -122.444002941237 (37.7683780948237, -122.444002941237) 15 5 11 29492 9
154500 213704 DPW Maintained 1 Prunus spp :: Cherry 68 635 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     15     5997206.92035 2095245.84356 37.7329858403205 -122.452040726125 (37.7329858403205, -122.452040726125) 9 7 4 59 40
153560 20857 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
151735 102286 Undocumented 4 Prunus spp :: Cherry 68 122 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2014 12:00:00 AM 26 4x4 Permit Number 772865 6000574.8 2102350.7 37.7526864299915 -122.440906621345 (37.7526864299915, -122.440906621345) 2 4 5 28862 22
151548 179164 DPW Maintained 1 Prunus spp :: Cherry 68 906 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001361.98728 2088931.83355 37.7158861309088 -122.43722367146 (37.7158861309088, -122.43722367146) 9 7 6 28861 5
151000 51061 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
149775 196062 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 8 Side Yard : Yard Tree Private 2     5 Width 5ft   6012859.76673 2103766.08005 37.7572647746544 -122.398522052264 (37.7572647746544, -122.398522052264) 10 3 8 28856 29
145574 19031 Permitted Site 7 Prunus spp :: Cherry 68 3190 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 2X2   5999568.09479 2115476.97835 37.7886704841429 -122.445331680485 (37.7886704841429, -122.445331680485) 13 6 1 29490 27
142169 82056 Permitted Site 7 Prunus spp :: Cherry 68 447 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2011 12:00:00 AM   3x3 Permit Number 767285 5993745.17939928 2090171.13367763 37.7188530246919 -122.463640596127 (37.7188530246919, -122.463640596127) 9 8 6 64 24
140897 19022 Permitted Site 7 Prunus spp :: Cherry 68 3170 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372) 13 6 1 29490 27
139368 50308 Permitted Site 7 Prunus spp :: Cherry 68 701 (REVISED) Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.7199495485694 -122.460248307265 (37.7199495485694, -122.460248307265) 9 8 6 28861 24
139351 96677 Permitted Site 7 Prunus spp :: Cherry 68 1701 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
138611 237972 DPW Maintained 1 Prunus spp :: Cherry 68 400 Prospect Ave 14 Sidewalk: Property side : Yard Tree Private 2     11     6006214.1673 2097605.70169 37.7399773120135 -122.421067769962 (37.7399773120135, -122.421067769962) 2 7 7 28859 2
133845 49367 Permitted Site 7 Prunus spp :: Cherry 68 1328@ 4th & 5t Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2005 12:00:00 AM     Permit Number 47977 5994585.78557071 2112147.74022661 37.7792436288989 -122.462328048371 (37.7792436288989, -122.462328048371) 11 6 2 54 11
133197 51064 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
130764 249657 DPW Maintained 1 Prunus spp :: Cherry 68 2401 Lyon St 9 Front Yard : Yard Tree Private 2     5 Width 10ft   5999220.85646 2117228.07126 37.7934586955217 -122.446659110123 (37.7934586955217, -122.446659110123) 11   1 57 30
129805 142312 DPW Maintained 1 Prunus spp :: Cherry 68 1691 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5999733.1826 2110513.1611 37.7750505456338 -122.444403629404 (37.7750505456338, -122.444403629404) 15 5 11 29492 16
129139 196536 DPW Maintained 1 Prunus spp :: Cherry 68 1422 Rhode Island St 1 : Tree Private 2     10 Width 3ft   6011983.19537 2101729.68858 37.7516244165498 -122.401410487604 (37.7516244165498, -122.401410487604) 10 3 8 28856 29
128650 179166 DPW Maintained 1 Prunus spp :: Cherry 68 137 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007974.04708 2093261.84981 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606) 9 3 7 309 28
127650 43350 DPW Maintained 1 Prunus spp :: Cherry 68 651 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2000 12:00:00 AM 8   Permit Number 43102 6007249.15746 2091540.31674 37.7233813767346 -122.417059535679 (37.7233813767346, -122.417059535679) 9 3 7 309 28
125827 56999 Permitted Site 7 Prunus spp :: Cherry 68 4206 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 14257 6001838.61131344 2101787.92307498 37.7512130767933 -122.436495868054 (37.7512130767933, -122.436495868054) 2 4 5 28862 22
122322 136024 DPW Maintained 1 Prunus spp :: Cherry 68 66 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024) 5 1 10 308 32
121838 53181 Permitted Site 7 Prunus spp :: Cherry 68 2784 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2006 12:00:00 AM   3x3 Permit Number 49099 6010077.71172244 2102830.43618978 37.7545403242811 -122.408077545352 (37.7545403242811, -122.408077545352) 2 4 7 28859 19
121716 51062 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
121576 142162 DPW Maintained 1 Prunus spp :: Cherry 68 490X Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000657 2110488 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609) 15 5 11 29492 16
118419 43986 Permitted Site 7 Prunus spp :: Cherry 68 2200 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2000 12:00:00 AM     Permit Number 43550 6005547.87197183 2117529.65351428 37.7946461451301 -122.424788600108 (37.7946461451301, -122.424788600108) 13 9 1 28858 27
117684 117739 DPW Maintained 1 Prunus spp :: Cherry 68 475 39th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243) 11 6 2 55 26
115685 234917 DPW Maintained 1 Prunus spp :: Cherry 68 1341 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011175.62775 2102086.99041 37.7525603976539 -122.404228319896 (37.7525603976539, -122.404228319896) 10 4 8 28859 19
115596 39201 Permitted Site 7 Prunus spp :: Cherry 68 36 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/1998 12:00:00 AM   3x3 Permit Number 40852 5996541.64157093 2114326.11365116 37.7853372927938 -122.455719478601 (37.7853372927938, -122.455719478601) 11 6 1 54 31
112884 19029 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 13 6 1 29490 27
112015 120699 DPW Maintained 1 Prunus spp :: Cherry 68 82 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5988985.45615 2114833.30825 37.7862933730561 -122.481898453185 (37.7862933730561, -122.481898453185) 11 6 1 55 33
110871 52194 Permitted Site 7 Prunus spp :: Cherry 68 415 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
107251 238534 DPW Maintained 1 Prunus spp :: Cherry 68 671 Church St 39 Front Yard : Yard Tree Private 2     12 Width 3ft   6004315.93981 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928) 2 4 5 28862 3
106492 20856 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
100657 237946 DPW Maintained 1 Prunus spp :: Cherry 68 923 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008002.82503 2102600.12508 37.7537915497511 -122.415236769973 (37.7537915497511, -122.415236769973) 2 4 7 28859 19
100372 40636 Permitted Site 7 Prunus spp :: Cherry 68 142 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41636 6010372.94752615 2111469.26002805 37.7782770896065 -122.407665612051 (37.7782770896065, -122.407665612051) 14 2 9 28853 34
99909 96676 Property Tree 8 Prunus spp :: Cherry 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
97628 234922 DPW Maintained 1 Prunus spp :: Cherry 68 818 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010155.119 2104325.0374 37.758648498551 -122.407915239024 (37.758648498551, -122.407915239024) 2 4 7 28859 19
93588 136021 DPW Maintained 1 Prunus spp :: Cherry 68 1010 Lombard St 1 Sidewalk: Curb side : Yard Tree Private 2     12     6007482.49892 2120248.47345 37.8022204224067 -122.418287380977 (37.8022204224067, -122.418287380977) 5 1 1 28858 32
92263 196371 DPW Maintained 1 Prunus spp :: Cherry 68 1797 Bancroft Ave 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 1ft   6013429.50102 2092789.94242 37.7271583305791 -122.395782600389 (37.7271583305791, -122.395782600389) 10 3 8 58 1
91846 19030 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     7 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 13 6 1 29490 27
91325 84725 Permitted Site 7 Prunus spp :: Cherry 68 20 Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49296 5996092 2115960 37.7897976912986 -122.457393340224 (37.7897976912986, -122.457393340224) 11 6 1 54 31
89476 49741 Permitted Site 7 Prunus spp :: Cherry 68 646@ 18th Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2003 12:00:00 AM     Permit Number 46540 6010086.91434322 2105281.03537103 37.7612696346383 -122.408218548113 (37.7612696346383, -122.408218548113) 2 4 8 28859 19
88482 56560 Permitted Site 7 Prunus spp :: Cherry 68 298X SAN FERNANDO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   5992129 2095185 37.7325266047982 -122.469591834842 (37.7325266047982, -122.469591834842) 9 8 4 59 40
88402 96987 Permitted Site 7 Prunus spp :: Cherry 68 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
85722 237945 DPW Maintained 1 Prunus spp :: Cherry 68 99 Aztec St 2 Side Yard : Yard Tree Private 2     14     6007968.29609 2099608.22097 37.7455745134701 -122.415144412305 (37.7455745134701, -122.415144412305) 2 7 7 28859 2
85690 196063 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 9 Side Yard : Yard Tree Private 2     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.398493171445 (37.757265535503, -122.398493171445) 10 3 8 28856 29
85686 17372 Permitted Site 7 Prunus spp :: Cherry 68 1050X Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2012 12:00:00 AM 6 3X3 Permit Number 769300 5999379.15193 2109268.47217 37.7716127406754 -122.445538771694 (37.7716127406754, -122.445538771694) 15 5 11 29492 9
85355 58408 Permitted Site 7 Prunus spp :: Cherry 68 755 Buena Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1979 12:00:00 AM 5   Permit Number 17543 5999798.5 2108081.7 37.7683780948237 -122.444002941237 (37.7683780948237, -122.444002941237) 15 5 11 29492 9
84619 51065 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
83211 93959 Permitted Site 7 Prunus spp :: Cherry 68 419 Elizabeth St   Front Yard : Cutout Tree Private 2       3x3 Permit Number 53399 6003681 2102149 37.7523090296265 -122.430150445418 (37.7523090296265, -122.430150445418) 2 4 5 28862 22
82413 29657 DPW Maintained 1 Prunus spp :: Cherry 68 299X Cashmere St 1 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3x3   6016930.34883 2095863.99444 37.7357931999838 -122.383894041377 (37.7357931999838, -122.383894041377) 10 3 8 58 1
80855 237971 DPW Maintained 1 Prunus spp :: Cherry 68 3178 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008600.41483 2100617.45628 37.7483811527764 -122.413029982045 (37.7483811527764, -122.413029982045) 2 4 7 28859 19
79051 237948 DPW Maintained 1 Prunus spp :: Cherry 68 3387 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6007155.62665 2101453.96351 37.7505968017181 -122.418085332981 (37.7505968017181, -122.418085332981) 2 4 7 28859 19
76705 196372 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 7 Side Yard : Yard Tree Private 2     1     6013890.96771 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931) 10 3 8 58 1
75737 50440 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
75245 234921 DPW Maintained 1 Prunus spp :: Cherry 68 1062 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936) 2 4 5 28859 19
73071 196064 DPW Maintained 1 Prunus spp :: Cherry 68 1800 Illinois St 10 Sidewalk: Curb side : Yard Tree Private 2     2 Width 5ft   6016257.27394 2100629.71457 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372) 10 3 8 58 1
70311 50019 Permitted Site 7 Prunus spp :: Cherry 68 1363 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46753 6009308.17778689 2101227.80950502 37.7500967527825 -122.410625639874 (37.7500967527825, -122.410625639874) 2 4 7 28859 19
70091 237950 DPW Maintained 1 Prunus spp :: Cherry 68 3145 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008062.3853 2102670.45818 37.7539880156382 -122.415035774193 (37.7539880156382, -122.415035774193) 2 4 7 28859 19
65912 196067 DPW Maintained 1 Prunus spp :: Cherry 68 2338 Lane St 2 Front Yard : Yard Tree Private 2     2 Width 5ft   6013920.54146 2092873.26714 37.7274144278184 -122.394090896496 (37.7274144278184, -122.394090896496) 10 3 8 58 1
65616 86757 Permitted Site 7 Prunus spp :: Cherry 68 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
64777 234916 DPW Maintained 1 Prunus spp :: Cherry 68 1 Albion St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6005792.88209 2107221.84485 37.766357260514 -122.423207770616 (37.766357260514, -122.423207770616) 8 4 5 28853 19
62546 19034 Permitted Site 7 Prunus spp :: Cherry 68 3192 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2     12 2X2   5999529.89099 2115397.322 37.7884495878023 -122.445458129536 (37.7884495878023, -122.445458129536) 13 6 1 29490 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)
);