331 rows where qSpecies_id = 166

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)
65858 234454 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 281 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001786.69063 2104222.73922 37.7578955465505 -122.43684969828 (37.7578955465505, -122.43684969828) 2 4 5 28862 3
66012 234448 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 671 Church St 47 Front Yard : Yard Tree Private 2     15 Width 3ft   6004302.05711 2105157.91964 37.7606059692151 -122.428217150911 (37.7606059692151, -122.428217150911) 2 4 5 28862 3
66133 210980 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 332 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994137.14757 2099857.70125 37.7454725366457 -122.462988138299 (37.7454725366457, -122.462988138299) 1 8 4 29491 40
66282 31859 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 603 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42495 6009703.09193941 2111483.74896598 37.7782793527016 -122.409983922333 (37.7782793527016, -122.409983922333) 8 2 9 28853 34
66706 43053 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
68153 103229 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 18 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
68758 9383 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 343 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/10/1997 12:00:00 AM 3 3X3   6001126.8594841 2097771.388653 37.7401441558955 -122.438669406094 (37.7401441558955, -122.438669406094) 2 7 5 63 7
68775 234433 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Kingston St 18 Front Yard : Yard Tree Private 2     14     6006187.51948 2098069.90486 37.7412504075673 -122.421192861183 (37.7412504075673, -122.421192861183) 2 7 7 28859 2
69418 139015 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000259.188 2114052.0744 37.7847974932802 -122.442838245979 (37.7847974932802, -122.442838245979) 15 6 11 29490 13
69616 178117 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     2     5988789.57342 2089765.12974 37.7174514468002 -122.480740256365 (37.7174514468002, -122.480740256365) 1 8 4 64 14
70555 210942 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 901 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995890.68132 2090003.12019 37.7185150920717 -122.456212350116 (37.7185150920717, -122.456212350116) 9 8 6 28861 24
71777 218210 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 51 Taraval St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993519.34586 2099173.99103 37.7435596354643 -122.465074732739 (37.7435596354643, -122.465074732739) 1 8 4 59 40
73285 45158 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 101 Bradford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2001 12:00:00 AM     Permit Number 44011 6009592.49240283 2098004.38500436 37.7412618732658 -122.409414999284 (37.7412618732658, -122.409414999284) 10 7 7 28859 2
74422 139017 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000294.6805 2114054.8581 37.7848071599694 -122.442715653875 (37.7848071599694, -122.442715653875) 15 6 11 29490 13
74929 138930 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 666 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004176.0708 2110989.9993 37.7766123186068 -122.429068714009 (37.7766123186068, -122.429068714009) 7 9 11 28852 10
76407 87294 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2087 28th Ave   Front Yard : Yard Tree Private 2   03/20/2008 12:00:00 AM     Permit Number 50307 5987541.6 2101099.3 37.7484995140672 -122.485885323793 (37.7484995140672, -122.485885323793) 1 8 3 29491 35
76620 234422 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 370 Church St 1 : Tree Private 2     10 Width 3ft   6004156.87328 2106762.65224 37.7650039651812 -122.428833681136 (37.7650039651812, -122.428833681136) 8 4 5 28862 3
77609 178103 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 450 Holyoke St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009835.80068 2092308.97785 37.7256371300447 -122.408172135737 (37.7256371300447, -122.408172135737) 10 3 7 309 28
77974 139825 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 900 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6004831 2112025 37.7794912277556 -122.426876850808 (37.7794912277556, -122.426876850808) 7 9 11 28852 41
78037 103221 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 6 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM 11 3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
78409 210953 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 82 Vernon St 5 : Tree Private 2     5 Width 2ft   5992464.38924 2088481.68139 37.7141403138917 -122.467944923523 (37.7141403138917, -122.467944923523) 9 8 6 64 24
78794 140010 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 820 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004913.6029 2111647.1443 37.7784583990483 -122.426564178697 (37.7784583990483, -122.426564178697) 7 9 11 28852 41
79059 182437 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1551 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5989914.2293 2104805.4779 37.7588136721701 -122.477951808318 (37.7588136721701, -122.477951808318) 1 8 3 56 35
79338 43402 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 224 Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43145 6000589.19693618 2103093.40902085 37.754726548938 -122.440910109621 (37.754726548938, -122.440910109621) 2 4 5 63 38
79361 132152 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004681.57966 2111062.06426 37.7768387933051 -122.427325145748 (37.7768387933051, -122.427325145748) 7 9 11 28852 10
79405 178104 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 450 Holyoke St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009831.59561 2092324.84748 37.725680469262 -122.408187791139 (37.725680469262, -122.408187791139) 10 3 7 309 28
80373 194419 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1548 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015902.62004 2095929.89737 37.7359172884615 -122.387451930266 (37.7359172884615, -122.387451930266) 10 3 8 58 1
80504 45316 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 739 Garfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44153 5992112.57362646 2090471.95346901 37.719584794705 -122.46930570018 (37.719584794705, -122.46930570018) 9 8 6 64 24
80891 101310 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 250 Napoleon St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012064.79616 2099822.57577 37.7463924495572 -122.400994315548 (37.7463924495572, -122.400994315548) 10 3 8 58 1
83338 194408 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 670 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014377.03674 2104046.75926 37.7581198698487 -122.393294339956 (37.7581198698487, -122.393294339956) 10 3 8 28856 29
83945 103226 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 12 Sidewalk: Property side : Cutout Tree Rec/Park 5       3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
84112 210986 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1 Pizarro Way 5 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5995099.57616 2093947.59024 37.7293002171239 -122.45923233653 (37.7293002171239, -122.45923233653) 9 7 4 28861 40
84578 140233 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1 SHRADER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997236.5638 2110458.2831 37.7747571011004 -122.453035971219 (37.7747571011004, -122.453035971219) 15 5 2 29492 16
85510 210936 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 147 Edna St 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   5998728.75297 2093448.46825 37.7281377246652 -122.446650099831 (37.7281377246652, -122.446650099831) 9 7 4 28861 40
85578 42212 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 963 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42480 6011658.35372103 2111289.20991303 37.7778545845813 -122.403206224165 (37.7778545845813, -122.403206224165) 14 2 9 28856 34
85868 234432 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Kingston St 17 Front Yard : Yard Tree Private 2     8     6006208.4441 2098088.09071 37.7413015214408 -122.421121802138 (37.7413015214408, -122.421121802138) 2 7 7 28859 2
86593 101730 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 90 Rotteck St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6003358.27479 2094550.48416 37.7314269752556 -122.430724293513 (37.7314269752556, -122.430724293513) 9 7 5 28861 25
87283 40750 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 50 Cerritos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/13/1999 12:00:00 AM     Permit Number 41721 5992599.375194 2093012.15972087 37.7265876981878 -122.467807672314 (37.7265876981878, -122.467807672314) 9 8 4 59 40
88220 234431 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Kingston St 15 Front Yard : Yard Tree Private 2     5     6006215.94221 2098085.47113 37.7412947513536 -122.421095690312 (37.7412947513536, -122.421095690312) 2 7 7 28859 2
88382 210963 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 88 Forest Side Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992505.49172 2098536.05346 37.7417495070478 -122.468533953373 (37.7417495070478, -122.468533953373) 1 8 4 29491 40
88385 210955 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 222 Monterey Blvd 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   6000597.13244 2094707.94452 37.7317025050644 -122.440281346627 (37.7317025050644, -122.440281346627) 9 7 4 63 40
89335 234459 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 218 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007099.90307 2097707.68115 37.7403072157133 -122.418012482517 (37.7403072157133, -122.418012482517) 2 7 7 28859 2
89377 9362 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 253 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/1999 12:00:00 AM 8 2X2   6001087.5285041 2098351.9099154 37.7417358932247 -122.438846986479 (37.7417358932247, -122.438846986479) 2 7 5 63 7
89460 194407 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1301 Minnesota St 75 Front Yard : Yard Tree Private 2     15     6015362.28462 2102262.66677 37.7532758191494 -122.38976228772 (37.7532758191494, -122.38976228772) 10 3 8 28856 29
90116 178121 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1186 Munich St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6001045.2474 2087209.5115 37.7111390073292 -122.438195159605 (37.7111390073292, -122.438195159605) 9 7 6 28861 5
90470 23459 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2290X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4 Permit Number 769634 6005952.25741 2118257.88317 37.7966685117079 -122.423441167528 (37.7966685117079, -122.423441167528) 13 9 10 28858 32
90723 112348 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 50 Perine Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6002110.93793 2115571.44216 37.7890746830929 -122.436540595874 (37.7890746830929, -122.436540595874) 13 6 1 29490 27
91008 132141 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2200 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000126.69281 2120608.21837 37.8027913830869 -122.443767809531 (37.8027913830869, -122.443767809531) 13 9 1 57 17
91100 31367 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 300 Taraval St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4 3x3 Permit Number 34972 5992232.45976 2099147.6054 37.7434128975899 -122.469522506162 (37.7434128975899, -122.469522506162) 1 8 4 29491 40
91582 178125 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 753 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6001422.11728 2092653.05494 37.7261071849737 -122.437282130958 (37.7261071849737, -122.437282130958) 9 7 6 28861 25
91663 140232 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2217 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997153.7791 2110495.4596 37.7748544334109 -122.453325023475 (37.7748544334109, -122.453325023475) 15 5 2 29492 16
91888 65834 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2222 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM 6   Permit Number 28824 6000082.60671 2120602.00378 37.8027718048421 -122.443919922685 (37.8027718048421, -122.443919922685) 13 9 1 57 17
91892 49566 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 156 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2003 12:00:00 AM     Permit Number 46451 6005497.65497222 2099068.87265965 37.7439544310926 -122.423649179655 (37.7439544310926, -122.423649179655) 2 7 5 28859 22
92940 132150 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6004720.2552 2111067.25332 37.7768552284141 -122.427191725035 (37.7768552284141, -122.427191725035) 7 9 11 28852 10
93010 186335 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1801 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984801.9017 2102876.5819 37.7532194095825 -122.495490075013 (37.7532194095825, -122.495490075013) 1 8 3 56 35
94633 132153 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 11 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004662.5128 2111060.462 37.776833315546 -122.427390989626 (37.776833315546, -122.427390989626) 7 9 11 28852 10
95142 234458 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 478 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5998572.14145 2106426.12515 37.7637622712248 -122.448125561761 (37.7637622712248, -122.448125561761) 15 5 11 29492 9
95296 178123 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 7 Still St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6003166.62203 2094649.98003 37.7316893083954 -122.431393972765 (37.7316893083954, -122.431393972765) 9 7 5 28861 25
95413 106022 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 181 Buena Vista Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 771765 6001436.7 2108377.5 37.7692836023561 -122.438357764726 (37.7692836023561, -122.438357764726) 15 5 5 29492 9
95498 210958 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2470 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992377.13613 2098506.21795 37.7416601710863 -122.468975589747 (37.7416601710863, -122.468975589747) 1 8 4 29491 40
95894 210970 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1901 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991556.76068 2102423.86372 37.7523695813055 -122.472097634818 (37.7523695813055, -122.472097634818) 1 8 4 29491 12
96238 194413 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 98 Ceres St 3 : Tree Private 2     5 Width 1ft   6013801.43313 2093700.7478 37.7296799009949 -122.394560576406 (37.7296799009949, -122.394560576406) 10 3 8 58 1
97220 178108 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000658.1626 2087895.78339 37.7130013342097 -122.439582182182 (37.7130013342097, -122.439582182182) 9 7 6 28861 5
97287 234453 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 439 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003529.16507 2102129.83652 37.7522478103946 -122.430674147321 (37.7522478103946, -122.430674147321) 2 4 5 28862 22
98597 24851 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2380 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/29/1996 12:00:00 AM 3     6010563.145169 2094856.3578366 37.7326724006804 -122.405837111499 (37.7326724006804, -122.405837111499) 10 3 7 309 28
98895 234442 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 4545 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000779.85677 2101100.46263 37.7492652556087 -122.440107856608 (37.7492652556087, -122.440107856608) 2 4 5 28862 22
99203 178101 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 450 Holyoke St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009849.55094 2092272.62028 37.7255380696985 -122.408122039001 (37.7255380696985, -122.408122039001) 10 3 7 309 28
100098 30932 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 507 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 4   Permit Number 34745 5995284.50806 2091206.784 37.7217852518603 -122.458394705264 (37.7217852518603, -122.458394705264) 9 8 6 28861 24
100534 37781 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 274 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 6   Permit Number 40116 6009257.34688 2093021.85403 37.7275621306623 -122.410222120555 (37.7275621306623, -122.410222120555) 9 3 7 309 28
101821 178105 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 450 Holyoke St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009827.37216 2092339.81548 37.7257213317608 -122.408203446535 (37.7257213317608, -122.408203446535) 10 3 7 309 28
102113 234449 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 322 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001539.15917 2096239.21679 37.7359606150995 -122.437134171803 (37.7359606150995, -122.437134171803) 2 7 5 63 7
102866 210973 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1252 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992165.38565 2098459.60758 37.7415199541938 -122.469704352692 (37.7415199541938, -122.469704352692) 1 8 4 29491 40
102948 43054 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
104964 138961 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 659 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004210.501 2110971.7814 37.7765642456394 -122.428948310762 (37.7765642456394, -122.428948310762) 7 9 11 28852 10
106424 182203 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1659 21st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5989632.7475 2104072.0115 37.7567834283184 -122.478871646143 (37.7567834283184, -122.478871646143) 1 8 3 56 35
106904 210975 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 260 Dorantes Ave 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5993308.24189 2099718.06264 37.7450413431967 -122.465844195348 (37.7450413431967, -122.465844195348) 1 8 4 29491 40
107067 45330 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 471 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44163 5993999.8706027 2089674.33515151 37.7175036072534 -122.462724216271 (37.7175036072534, -122.462724216271) 9 8 6 64 24
107110 178115 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 47 Payson St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5991818.21291 2087759.03799 37.7121187737221 -122.470125748026 (37.7121187737221, -122.470125748026) 9 8 4 64 24
107291 194406 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1301 Minnesota St 74 Front Yard : Yard Tree Private 2     12     6015366.03061 2102265.75372 37.753284502988 -122.389749548804 (37.753284502988, -122.389749548804) 10 3 8 28856 29
107659 101308 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 250 Napoleon St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012186.42356 2099869.94046 37.746529286798 -122.400577066077 (37.746529286798, -122.400577066077) 10 3 8 58 1
108156 37796 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 407 Somerset St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 7   Permit Number 40124 6010061.01823 2092600.5122 37.7264502304769 -122.407414116969 (37.7264502304769, -122.407414116969) 10 3 7 309 28
108176 31383 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1200 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4   Permit Number 34979 5992400.98606 2098463.33859 37.7415438132084 -122.468890005775 (37.7415438132084, -122.468890005775) 1 8 4 29491 40
108352 234462 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 4089 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002433.81124 2104701.21769 37.7592460908663 -122.43464589971 (37.7592460908663, -122.43464589971) 2 4 5 28862 3
108792 101309 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 250 Napoleon St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012087.5096 2099832.08135 37.7464198168313 -122.400916442354 (37.7464198168313, -122.400916442354) 10 3 8 58 1
108938 194417 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 352 Tehama St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011498.49075 2112641.6467 37.7815591323857 -122.403854441123 (37.7815591323857, -122.403854441123) 6 2 9 28853 34
109791 210944 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 471 Orizaba Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5994007.18286 2089638.21665 37.7174048556293 -122.462696322689 (37.7174048556293, -122.462696322689) 9 8 6 64 24
109846 246514 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 73 Waller St 1 : Tree Private 2     4 Width 3ft   6005362.30932 2109213.80064 37.7718023848053 -122.424838771211 (37.7718023848053, -122.424838771211) 7 9 5 28852 10
110491 12292 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 830 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/1997 12:00:00 AM 3 4X4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
111196 26894 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1245X Lane St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4   6015870.9547371 2095407.1210845 37.7344800964063 -122.387524951 (37.7344800964063, -122.387524951) 10 3 8 58 1
111444 210937 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996251.40401 2091280.47926 37.7220431189884 -122.455057739344 (37.7220431189884, -122.455057739344) 9 8 4 28861 24
111872 210940 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 71 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994126.22956 2090303.05992 37.7192372117057 -122.462333029842 (37.7192372117057, -122.462333029842) 9 8 6 28861 24
113105 234438 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 786 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5998023.26528 2107589.70092 37.7669257633449 -122.450107819521 (37.7669257633449, -122.450107819521) 15 5 11 29492 9
114145 183496 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2546 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5989574.0258 2098014.7611 37.7401484030768 -122.478631764598 (37.7401484030768, -122.478631764598) 1 8 3 29491 35
114291 210941 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 901 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995891.34278 2090020.28633 37.718562264216 -122.456211304216 (37.718562264216, -122.456211304216) 9 8 6 28861 24
114640 194418 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1548 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015914.23421 2095920.15434 37.7358911793201 -122.38741109564 (37.7358911793201, -122.38741109564) 10 3 8 58 1
116119 103194 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1601X 28th Ave 13 Sidewalk: Property side : Cutout Tree Rec/Park 5       3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
118488 141413 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 530 IVY ST 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004701.4857 2111062.9803 37.7768424342938 -122.427256349988 (37.7768424342938, -122.427256349988) 7 9 11 28852 10
119179 40793 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 456 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1999 12:00:00 AM     Permit Number 41742 5992180.76921934 2091949.45696534 37.7236455979149 -122.469177453156 (37.7236455979149, -122.469177453156) 9 8 4 59 40
119305 139020 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2557 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000390.0231 2114072.2564 37.7848603658988 -122.442387050125 (37.7848603658988, -122.442387050125) 15 6 11 29490 13
119345 210965 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1405 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993935.40946 2105897.25233 37.7620439725694 -122.464124072887 (37.7620439725694, -122.464124072887) 1 5 11 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)
);