trees
331 rows where qSpecies_id = 166
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );