Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 188289 | 188289 | 178905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999575.27021 | 2086527.1037599999 | 37.7091815546459 | -122.443226763913 | (37.7091815546459, -122.443226763913) | |||
| 172601 | 172601 | 117182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000152.35367 | 2086600.7137400003 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) | |||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 117477 | 117477 | 37344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | ||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 155848 | 155848 | 178895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 240 Concord St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.44207374220801 | (37.7105103506437, -122.442073742208) | |||
| 11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
| 12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
| 11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
| 11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
| 12814 | 12814 | 95025 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.40450209567699 | (37.7114343969477, -122.404502095677) | |||
| 12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
| 11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
| 11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
| 12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
| 10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
| 11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) | |||
| 175027 | 175027 | 51531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.4993200002 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | ||
| 85059 | 85059 | 51530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 169 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47832 | 5997730.87276608 | 2087189.13752554 | 37.710894004264205 | -122.449648930425 | (37.7108940042642, -122.449648930425) | |||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 143612 | 143612 | 94987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.711692402207106 | -122.40438551024401 | (37.7116924022071, -122.404385510244) | ||
| 11845 | 11845 | 95018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.40521408790899 | (37.7117099327517, -122.405214087909) | |||
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 11612 | 11612 | 95017 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.40530753468501 | (37.7117488165229, -122.405307534685) | |||
| 11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
| 10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) | ||||
| 10592 | 10592 | 26788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.40518761518801 | (37.711819305554, -122.405187615188) | ||
| 10400 | 10400 | 94994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 82 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010574.5301 | 2087274.9346 | 37.7118560160688 | -122.405264057289 | (37.7118560160688, -122.405264057289) | |||
| 10788 | 10788 | 94995 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.711892427555796 | -122.40535898167299 | (37.7118924275558, -122.405358981673) | |||
| 12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
| 37685 | 37685 | 178897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.39803135517599 | (37.7120669530014, -122.398031355176) | |||
| 10354 | 10354 | 95012 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.40584279071301 | (37.7119519253908, -122.405842790713) | ||
| 11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
| 11078 | 11078 | 94996 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | |||
| 13045 | 13045 | 26792 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.40608116557199 | (37.7121745258223, -122.406081165572) | ||
| 12999 | 12999 | 94997 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010302.5304 | 2087413.7951 | 37.7122220880479 | -122.40621394582399 | (37.7122220880479, -122.406213945824) | |||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 12910 | 12910 | 26795 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.712320301990204 | -122.40679292443501 | (37.7123203019902, -122.406792924435) | ||
| 12621 | 12621 | 95008 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.712393072261705 | -122.40698585693501 | (37.7123930722617, -122.406985856935) | |||
| 10735 | 10735 | 95001 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 166 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010153.2106 | 2087493.0431 | 37.712431333442 | -122.40673562308099 | (37.712431333442, -122.406735623081) | |||
| 11134 | 11134 | 95007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 185 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010037.7782 | 2087495.7404 | 37.712432280377705 | -122.40713478458 | (37.7124322803777, -122.40713478458) | |||
| 11856 | 11856 | 95002 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.712462163614795 | -122.406812851088 | (37.7124621636148, -122.406812851088) | |||
| 12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
| 10559 | 10559 | 26794 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | ||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 12738 | 12738 | 95005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201X Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009777.312000001 | 2087590.4351 | 37.71267771272821 | -122.40804171326799 | (37.7126777127282, -122.408041713268) | ||||
| 44585 | 44585 | 37353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.3710199995 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | |
| 108171 | 108171 | 51590 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | Permit Number 47881 | 5994487.68194175 | 2087789.14028904 | 37.7123553921006 | -122.46090153342199 | (37.7123553921006, -122.460901533422) | |||
| 89705 | 89705 | 109182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998040.0 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | |||
| 68678 | 68678 | 217554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 258 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5994397.0077 | 2088113.6647 | 37.7132412415717 | -122.461238438183 | (37.7132412415717, -122.461238438183) | |||
| 18656 | 18656 | 25472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1999 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.714208763487896 | -122.46459914058599 | (37.7142087634879, -122.464599140586) | ||
| 22231 | 22231 | 25471 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | ||
| 20466 | 20466 | 18597 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | ||
| 46224 | 46224 | 91571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.730359999 | 2088527.6355299999 | 37.71527728989071 | -122.40648870199 | (37.7152772898907, -122.40648870199) | |
| 144119 | 144119 | 50873 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47383 | 5995201.42685987 | 2088679.26823835 | 37.714840517964 | -122.45849902539601 | (37.714840517964, -122.458499025396) | |||
| 154579 | 154579 | 214418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995206.37473 | 2088687.6179099998 | 37.714863728550604 | -122.458482527651 | (37.7148637285506, -122.458482527651) | |||
| 72387 | 72387 | 178871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998313.518130001 | 2088706.56781 | 37.7150938380738 | -122.44774434904801 | (37.7150938380738, -122.447744349048) | |||
| 112903 | 112903 | 84224 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
| 63894 | 63894 | 178877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 812 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002023.11476 | 2088969.20619 | 37.71602630823671 | -122.434941181287 | (37.7160263082367, -122.434941181287) | |||
| 27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
| 108190 | 108190 | 40474 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 103053 | 103053 | 40468 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.71633447730439 | -122.45122371003599 | (37.7163344773044, -122.451223710036) | ||
| 101489 | 101489 | 34809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 55 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38444 | 5999172.71597008 | 2089296.17855447 | 37.716761844805795 | -122.444816960418 | (37.7167618448058, -122.444816960418) | ||
| 32627 | 32627 | 78659 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | 5998369.991909999 | 2089313.5256400001 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | ||
| 132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
| 86444 | 86444 | 50722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
| 72768 | 72768 | 178878 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 754 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001997.79635 | 2089434.8838799999 | 37.717303518220206 | -122.435061980046 | (37.7173035182202, -122.435061980046) | |||
| 165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
| 110971 | 110971 | 38915 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 147 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40726 | 5991915.47880902 | 2089512.34448242 | 37.7169385510534 | -122.469917148086 | (37.7169385510534, -122.469917148086) | ||
| 128630 | 128630 | 38916 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.46991790012301 | (37.7170074074891, -122.469917900123) | ||
| 113456 | 113456 | 51244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47619 | 5997384.45837141 | 2089741.12682177 | 37.7178813535714 | -122.451030121405 | (37.7178813535714, -122.451030121405) | ||
| 48414 | 48414 | 40566 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 687 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 41611 | 6000998.28566 | 2089807.27388 | 37.7182692120226 | -122.43854347959801 | (37.7182692120226, -122.438543479598) | |||
| 146368 | 146368 | 178879 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 683 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002292.149780001 | 2089824.9266099997 | 37.718391198782 | -122.434072405644 | (37.718391198782, -122.434072405644) | |||
| 80652 | 80652 | 33821 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.40598618211901 | (37.7189040522027, -122.405986182119) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 145664 | 145664 | 50427 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 575 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47080 | 5996062.43497228 | 2089871.90840865 | 37.718164673097 | -122.45560919316799 | (37.718164673097, -122.455609193168) | ||
| 66194 | 66194 | 43721 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.718160841718394 | -122.45775999315399 | (37.7181608417184, -122.457759993154) | ||
| 114939 | 114939 | 43722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 663 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43362 | 5995378.9819826 | 2089884.66693766 | 37.7181604610324 | -122.457972504918 | (37.7181604610324, -122.457972504918) | ||
| 118465 | 118465 | 66236 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29334 | 5994760.98118392 | 2089897.08979712 | 37.7181590447559 | -122.460109553503 | (37.7181590447559, -122.460109553503) | ||
| 87285 | 87285 | 50652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.718286082953604 | -122.452817003739 | (37.7182860829536, -122.452817003739) | |||
| 104618 | 104618 | 65461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 745 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49756 | 5994584.49670969 | 2089901.01202032 | 37.7181596617168 | -122.46071986445101 | (37.7181596617168, -122.460719864451) | ||
| 51523 | 51523 | 43732 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | ||
| 152248 | 152248 | 178929 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 236 Niagara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999086.8403199995 | 2089914.7209 | 37.7184553195406 | -122.445158233389 | (37.7184553195406, -122.445158233389) | ||||
| 98315 | 98315 | 38920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 748 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40730 | 5994545.96417904 | 2089953.8830186 | 37.718302615811794 | -122.460856883631 | (37.7183026158118, -122.460856883631) | ||
| 78236 | 78236 | 43735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711003 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | ||
| 92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 166733 | 166733 | 178880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 641 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002434.092619999 | 2090051.35285 | 37.71902096971979 | -122.433597942217 | (37.7190209697198, -122.433597942217) | |||
| 108465 | 108465 | 45358 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 434 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44766 | 5993275.26942875 | 2090069.89309509 | 37.7185479545501 | -122.465257525662 | (37.7185479545501, -122.465257525662) | ||
| 55665 | 55665 | 178881 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | |||
| 146227 | 146227 | 45359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.718615761020004 | -122.46525810245701 | (37.71861576102, -122.465258102457) | ||
| 93255 | 93255 | 66254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 930 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29355 | 5995057.552477599 | 2090124.39622258 | 37.7188002278135 | -122.45910089062099 | (37.7188002278135, -122.459100890621) | ||
| 68245 | 68245 | 214423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 447 Bright St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993753.592209999 | 2090152.37899 | 37.718802013579705 | -122.463610156194 | (37.7188020135797, -122.463610156194) | |||
| 76820 | 76820 | 66242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | ||
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) |
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");