Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 5612 | 5612 | 35700 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 7342 | 7342 | 35697 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 8272 | 8272 | 35698 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10284 | 10284 | 35699 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11246 | 11246 | 35705 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11435 | 11435 | 35694 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11560 | 11560 | 35695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11610 | 11610 | 35704 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 12226 | 12226 | 35696 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14850 | 14850 | 35701 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15690 | 15690 | 35690 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15799 | 15799 | 35703 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15958 | 15958 | 35692 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 16152 | 16152 | 35693 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 181097 | 181097 | 208169 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991440.6028 | 2097828.1323700002 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | |||
| 72713 | 72713 | 208168 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991441.450619999 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | |||
| 169758 | 169758 | 208167 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991441.567009999 | 2097783.56953 | 37.7396218639513 | -122.47215777968201 | (37.7396218639513, -122.472157779682) | |||
| 178649 | 178649 | 122998 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 42 07th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5993660.47545 | 2115225.1028 | 37.7876399054327 | -122.465752700208 | (37.7876399054327, -122.465752700208) | |||
| 24184 | 24184 | 208171 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.46205892188401 | (37.744077400365, -122.462058921884) | |||
| 53935 | 53935 | 208172 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994418.094740001 | 2099364.4172099996 | 37.7441342815725 | -122.46198091018499 | (37.7441342815725, -122.461980910185) | |||
| 136849 | 136849 | 208174 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | |||
| 78762 | 78762 | 85037 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 90885 | 90885 | 85038 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 43828 | 43828 | 208173 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.744339434016794 | -122.460502016448 | (37.7443394340168, -122.460502016448) | |||
| 134069 | 134069 | 124474 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.45627485050899 | (37.7748806555631, -122.456274850509) | |||
| 154064 | 154064 | 208170 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | |||
| 146744 | 146744 | 140288 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | |||
| 30478 | 30478 | 140287 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998483.9171 | 2110037.6666 | 37.7736736024147 | -122.448690838206 | (37.7736736024147, -122.448690838206) | |||
| 185507 | 185507 | 140286 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998499.0219 | 2110040.6876 | 37.773682761016104 | -122.44863880622101 | (37.7736827610161, -122.448638806221) | |||
| 166496 | 166496 | 51593 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.773689232881395 | -122.44856674553301 | (37.7736892328814, -122.448566745533) | |
| 67057 | 67057 | 66847 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 45 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 2 | Permit Number 30151 | 5998689.6182 | 2110496.1606 | 37.7749442695784 | -122.448012307244 | (37.7749442695784, -122.448012307244) | |
| 41186 | 41186 | 228842 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999127.094409999 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | |||
| 164671 | 164671 | 64662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2786 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 14 | 6x4 | Permit Number 26052 | 5999613.31909 | 2118454.39818 | 37.796848274496206 | -122.445389381638 | (37.7968482744962, -122.445389381638) | |
| 460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 168945 | 168945 | 39385 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.7395900004 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | ||
| 62368 | 62368 | 39387 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.44195652817899 | (37.7934637371134, -122.441956528179) | ||
| 134375 | 134375 | 39384 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.1206900002 | 37.793465453027395 | -122.441926131987 | (37.7934654530274, -122.441926131987) | ||
| 36450 | 36450 | 39386 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | ||
| 152581 | 152581 | 129751 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000742.15542 | 2119656.12238 | 37.8002122659526 | -122.44156963624201 | (37.8002122659526, -122.441569636242) | |||
| 168272 | 168272 | 129750 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.800217563850296 | -122.44150624394301 | (37.8002175638503, -122.441506243943) | |||
| 167501 | 167501 | 129749 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000782.42382 | 2119661.2506 | 37.8002286408033 | -122.44143066041599 | (37.8002286408033, -122.441430660416) | |||
| 187663 | 187663 | 129748 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.800238273442396 | -122.441353858292 | (37.8002382734424, -122.441353858292) | |||
| 46581 | 46581 | 228841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.749798521207204 | -122.439364559745 | (37.7497985212072, -122.439364559745) | |||
| 151478 | 151478 | 228845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001290.00365 | 2104097.6707200003 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | |||
| 5413 | 5413 | 14844 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649174999 | (37.7782909152526, -122.43388649175) | ||
| 65786 | 65786 | 129752 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003040.06059 | 2116163.9449299998 | 37.790754298317204 | -122.43336831020201 | (37.7907542983172, -122.433368310202) | |||
| 120380 | 120380 | 64146 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | ||
| 131468 | 131468 | 129753 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003149.59406 | 2116175.6254 | 37.790792583373104 | -122.43299016506901 | (37.7907925833731, -122.432990165069) | |||
| 152362 | 152362 | 129754 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003179.18897 | 2116177.33789 | 37.7907989640458 | -122.43288789058902 | (37.7907989640458, -122.432887890589) | |||
| 149570 | 149570 | 129755 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003208.43493 | 2116180.994 | 37.7908106615232 | -122.432786962347 | (37.7908106615232, -122.432786962347) | |||
| 118847 | 118847 | 108695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 511 Alvarado St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | |
| 32287 | 32287 | 227937 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002968.42227 | 2098587.5279900003 | 37.7424896769594 | -122.43236030960699 | (37.7424896769594, -122.432360309607) | |||
| 70036 | 70036 | 129756 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2315 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6003701.89513 | 2116476.8237099997 | 37.7916509089176 | -122.43110073801 | (37.7916509089176, -122.43110073801) | |||
| 55636 | 55636 | 129757 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2315 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6003704.65718 | 2116456.32668 | 37.7915947858084 | -122.431089717742 | (37.7915947858084, -122.431089717742) | |||
| 168339 | 168339 | 49588 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.2146400004 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | ||
| 65614 | 65614 | 228852 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004131.71858 | 2104545.14122 | 37.7589137859482 | -122.428762589748 | (37.7589137859482, -122.428762589748) | |||
| 88634 | 88634 | 100146 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |||||
| 122054 | 122054 | 100145 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |||||
| 129389 | 129389 | 97178 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |
| 151732 | 151732 | 228851 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004146.65332 | 2104546.1831400003 | 37.7589174920696 | -122.42871101271002 | (37.7589174920696, -122.42871101271) | |||
| 146016 | 146016 | 108433 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222x Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004156.2455400005 | 2104544.03717 | 37.758912142621206 | -122.428677685352 | (37.7589121426212, -122.428677685352) | |
| 68851 | 68851 | 228850 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.42863130311501 | (37.7589211990752, -122.428631303115) | |||
| 75033 | 75033 | 228849 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.75892367042171 | -122.42857972608499 | (37.7589236704217, -122.428579726085) | |||
| 75521 | 75521 | 228848 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004199.57922 | 2104548.6925 | 37.7589273774242 | -122.42852814905599 | (37.7589273774242, -122.428528149056) | |||
| 170579 | 170579 | 228847 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004213.13115 | 2104548.41319 | 37.758927377407 | -122.42848126022699 | (37.758927377407, -122.428481260227) | |||
| 40130 | 40130 | 228846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | |||
| 98558 | 98558 | 50617 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | ||
| 121680 | 121680 | 50616 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
| 142828 | 142828 | 50615 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
| 129842 | 129842 | 228840 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 104 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004701.59069 | 2103023.11733 | 37.754766903184 | -122.426683319388 | (37.754766903184, -122.426683319388) | |||
| 33596 | 33596 | 227938 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.756022715594604 | -122.426674645426 | (37.7560227155946, -122.426674645426) | |||
| 84551 | 84551 | 45668 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 46(REVISED) Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 44364 | 6004865.19751473 | 2101080.41704042 | 37.7494419484142 | -122.425979237767 | (37.7494419484142, -122.425979237767) | ||
| 46833 | 46833 | 227936 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 167 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6004844.7517 | 2099277.52267 | 37.7444904598682 | -122.42592162061001 | (37.7444904598682, -122.42592162061) | |||
| 160462 | 160462 | 177154 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.725615388036104 | -122.42363641630301 | (37.7256153880361, -122.423636416303) | |||
| 62252 | 62252 | 227934 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005814.854180001 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | |||
| 37396 | 37396 | 7768 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 66199 | 66199 | 7767 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 120148 | 120148 | 7766 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 35845 | 35845 | 129762 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006368.54903 | 2118610.8656 | 37.797661199562995 | -122.422025790757 | (37.797661199563, -122.422025790757) | |||
| 58412 | 58412 | 129758 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 311 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006236.20671 | 2111756.75185 | 37.778834036391395 | -122.42199657448201 | (37.7788340363914, -122.421996574482) | |||
| 36798 | 36798 | 129763 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006382.65003 | 2118656.3506099996 | 37.7977868852004 | -122.421980230217 | (37.7977868852004, -122.421980230217) | |||
| 173134 | 173134 | 129761 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006380.65068 | 2118525.27839 | 37.797426881191896 | -122.421977832627 | (37.7974268811919, -122.421977832627) | |||
| 69311 | 69311 | 129760 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | |||
| 50680 | 50680 | 129764 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.42190349824101 | (37.7977976222176, -122.421903498241) | |||
| 176983 | 176983 | 129765 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006424.31939 | 2118660.7850599997 | 37.797801411063396 | -122.421836357588 | (37.7978014110634, -122.421836357588) | |||
| 157370 | 157370 | 129766 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6006461.42741 | 2118668.07402 | 37.797823517302206 | -122.42170847129199 | (37.7978235173022, -122.421708471292) | |||
| 55664 | 55664 | 129767 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006477.1660400005 | 2118669.59087 | 37.7978285696796 | -122.421654118939 | (37.7978285696796, -122.421654118939) | |||
| 61384 | 61384 | 63581 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1360 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 13 | Permit Number 24204 | 6006506.63769 | 2118721.20057 | 37.7979719387185 | -122.421555805959 | (37.7979719387185, -122.421555805959) | |
| 133858 | 133858 | 38495 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.2473299997 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) |
| 94681 | 94681 | 63072 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23550 | 6007407.20126882 | 2097784.26133742 | 37.740534778558605 | -122.416955389518 | (37.7405347785586, -122.416955389518) | ||
| 73201 | 73201 | 228843 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 707 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007452.7290199995 | 2097768.34677 | 37.7404936415683 | -122.416796844595 | (37.7404936415683, -122.416796844595) | |||
| 155277 | 155277 | 228844 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007473.725769999 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | |||
| 51118 | 51118 | 62971 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | |
| 176440 | 176440 | 62970 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 10 | Permit Number 23357 | 6008241.174219999 | 2118766.33453 | 37.7981935154844 | -122.41555699245701 | (37.7981935154844, -122.415556992457) | |
| 113875 | 113875 | 129759 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.72856 | 2118745.4751 | 37.7981362718366 | -122.415553596641 | (37.7981362718366, -122.415553596641) | |||
| 173137 | 173137 | 227935 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6008535.61915 | 2104408.30699 | 37.7587863358342 | -122.413522114462 | (37.7587863358342, -122.413522114462) | |||
| 16571 | 16571 | 97169 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 290 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009519.6482 | 2110372.42586 | 37.7752176376301 | -122.410540028225 | (37.7752176376301, -122.410540028225) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");