Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85875 | 85875 | 3577 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 103993 | 103993 | 3578 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 153213 | 153213 | 83039 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 12 | 6018611.72965 | 2097767.00037 | 37.741111283369705 | -122.378212851336 | (37.7411112833697, -122.378212851336) | |||
| 13482 | 13482 | 3542 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | ||
| 22353 | 22353 | 3591 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018372.01456 | 2097944.0595 | 37.741584237724396 | -122.37905400254499 | (37.7415842377244, -122.379054002545) | ||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 16415 | 16415 | 3521 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | |||
| 72615 | 72615 | 197255 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | |||
| 70243 | 70243 | 197256 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1320 Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6018044.32152 | 2094632.22344 | 37.732472518087 | -122.37995699832899 | (37.732472518087, -122.379956998329) | |||
| 89435 | 89435 | 10777 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 102835 | 102835 | 10749 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 103746 | 103746 | 10775 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 144183 | 144183 | 10760 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 176622 | 176622 | 197254 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1333 Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017901.24331 | 2094608.61235 | 37.7323997926186 | -122.380450018371 | (37.7323997926186, -122.380450018371) | |||
| 108454 | 108454 | 10829 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2006 12:00:00 AM | 3 | 3X4 | 6017900.94101 | 2094609.6380099999 | 37.7324025921986 | -122.380451134764 | (37.7324025921986, -122.380451134764) | ||
| 92367 | 92367 | 98130 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 4 | 3x4 | 6017903.8 | 2094987.0 | 37.733438911814 | -122.38046746904399 | (37.733438911814, -122.380467469044) | ||
| 179230 | 179230 | 197253 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1333 Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017800.41079 | 2094649.2469900001 | 37.7325058028811 | -122.38080144733401 | (37.7325058028811, -122.380801447334) | |||
| 84694 | 84694 | 10824 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X4 | 6017795.47201 | 2094639.5860099997 | 37.732479003154104 | -122.38081785069599 | (37.7324790031541, -122.380817850696) | ||
| 46248 | 46248 | 197252 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1333 Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017782.90663 | 2094656.28102 | 37.7325241508658 | -122.38086245283999 | (37.7325241508658, -122.38086245284) | |||
| 96624 | 96624 | 10823 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.243009999 | 2094650.0030099999 | 37.7325066000949 | -122.38088159725099 | (37.7325066000949, -122.380881597251) | ||
| 174616 | 174616 | 197251 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1333 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017752.42929 | 2094673.2277 | 37.732569000954896 | -122.380968999147 | (37.7325690009549, -122.380968999147) | |||
| 91634 | 91634 | 10820 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017736.87901 | 2094664.32601 | 37.7325437003489 | -122.38102214211901 | (37.7325437003489, -122.381022142119) | ||
| 90100 | 90100 | 10790 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 8 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 108283 | 108283 | 10782 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 09:31:00 AM | 3 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 127727 | 127727 | 26705 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 78265 | 78265 | 10877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 79309 | 79309 | 10879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 140228 | 140228 | 10876 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 75378 | 75378 | 197257 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.38174298627199 | (37.733193723116, -122.381742986272) | |||
| 159917 | 159917 | 197258 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017525.05376 | 2094913.62104 | 37.7332165209287 | -122.38177181313299 | (37.7332165209287, -122.381771813133) | |||
| 170688 | 170688 | 197259 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017468.44354 | 2094985.48685 | 37.73341072412121 | -122.381972529223 | (37.7334107241212, -122.381972529223) | |||
| 75680 | 75680 | 197250 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1337 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017426.32364 | 2094968.1062 | 37.733360674138105 | -122.382116942362 | (37.7333606741381, -122.382116942362) | |||
| 80111 | 80111 | 10795 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017417.868009999 | 2094975.5240099998 | 37.733380574977204 | -122.382146691971 | (37.7333805749772, -122.382146691971) | ||
| 161783 | 161783 | 197260 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017393.357030001 | 2095090.62772 | 37.7336952732179 | -122.38223943901698 | (37.7336952732179, -122.382239439017) | |||
| 59607 | 59607 | 197261 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017380.571719999 | 2095099.80246 | 37.7337197590624 | -122.38228428011499 | (37.7337197590624, -122.382284280115) | |||
| 77356 | 77356 | 10849 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1220X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | ||
| 89270 | 89270 | 10851 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1220X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | ||
| 344 | 344 | 251279 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | |||
| 393 | 393 | 251277 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/26/2011 12:00:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 409 | 409 | 251278 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 01/27/2016 09:31:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 60807 | 60807 | 197262 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017335.88738 | 2095181.6845 | 37.733942122725395 | -122.38244446375201 | (37.7339421227254, -122.382444463752) | |||
| 187937 | 187937 | 197249 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1339 Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017286.5777 | 2095179.92105 | 37.733934556716 | -122.382614821425 | (37.733934556716, -122.382614821425) | |||
| 179697 | 179697 | 197248 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1339 Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017268.43044 | 2095223.8124400002 | 37.7340540712292 | -122.382680615833 | (37.7340540712292, -122.382680615833) | |||
| 184913 | 184913 | 197247 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1339 Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017256.120180001 | 2095247.45205 | 37.7341183008123 | -122.382724821107 | (37.7341183008123, -122.382724821107) | |||
| 36467 | 36467 | 197263 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017252.47245 | 2095336.30143 | 37.7343620620475 | -122.382743613324 | (37.7343620620475, -122.382743613324) | |||
| 96804 | 96804 | 14891 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | ||
| 152349 | 152349 | 197264 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017243.9601 | 2095358.62855 | 37.734422897596005 | -122.382774596779 | (37.734422897596, -122.382774596779) | |||
| 128155 | 128155 | 10791 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3x4 | 6017221.84081 | 2095393.05521 | 37.734516204285605 | -122.382853466196 | (37.7345162042856, -122.382853466196) | ||
| 14802 | 14802 | 24222 | Section 143 8 | Quercus suber :: Cork Oak 76 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.38288292190398 | (37.7334154068844, -122.382882921904) | |
| 42259 | 42259 | 197246 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1339 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017203.85974 | 2095339.7013299998 | 37.7343687116489 | -122.382911921471 | (37.7343687116489, -122.382911921471) | |||
| 22320 | 22320 | 3658 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6017265.726009999 | 2098814.03291 | 37.7439119466908 | -122.382939742901 | (37.7439119466908, -122.382939742901) | |||
| 57512 | 57512 | 197265 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1328 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017187.84442 | 2095472.38417 | 37.734732147456604 | -122.382976523354 | (37.7347321474566, -122.382976523354) | |||
| 16517 | 16517 | 14896 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/2016 12:00:00 AM | 3 | 3x3 | 6017148.9857 | 2098654.5103700003 | 37.743467479245794 | -122.38333230594601 | (37.7434674792458, -122.383332305946) | ||
| 13711 | 13711 | 14895 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 3 | 3x3 | 6017124.7449900005 | 2098611.99106 | 37.743349390171105 | -122.383413165805 | (37.7433493901711, -122.383413165805) | ||
| 15542 | 15542 | 14893 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2008 12:00:00 AM | 3 | 3x3 | 6017107.5762 | 2098575.41356 | 37.7432480069006 | -122.38346998587 | (37.7432480069006, -122.38346998587) | ||
| 52745 | 52745 | 197242 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017080.03361 | 2098493.68243 | 37.7430220675307 | -122.383559533147 | (37.7430220675307, -122.383559533147) | |||
| 23027 | 23027 | 14877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017083.42225 | 2098683.73205 | 37.7435440924819 | -122.383561044027 | (37.7435440924819, -122.383561044027) | |||
| 94700 | 94700 | 14884 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.74349348316439 | -122.383634554347 | (37.7434934831644, -122.383634554347) | ||
| 105309 | 105309 | 14878 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.74349348316439 | -122.383634554347 | (37.7434934831644, -122.383634554347) | ||
| 13627 | 13627 | 14879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.743418358272706 | -122.383649254902 | (37.7434183582727, -122.383649254902) | |||
| 16610 | 16610 | 14901 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 175 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6017044.13522 | 2098333.33165 | 37.7425797926155 | -122.383672499702 | (37.7425797926155, -122.383672499702) | ||
| 16393 | 16393 | 14881 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017041.97386 | 2098599.86831 | 37.743311528701504 | -122.383698526073 | (37.7433115287015, -122.383698526073) | ||
| 16312 | 16312 | 14882 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | |||
| 188304 | 188304 | 197241 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 201 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016985.47526 | 2098058.3462799997 | 37.7418214959701 | -122.383856188014 | (37.7418214959701, -122.383856188014) | |||
| 142275 | 142275 | 14923 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 190 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2015 08:59:00 AM | 3 | 3x3 | 6016976.73758 | 2098306.80908 | 37.7425032414108 | -122.383903696919 | (37.7425032414108, -122.383903696919) | ||
| 107792 | 107792 | 14957 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 275 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2007 12:00:00 AM | 3 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.38392217193301 | (37.7417352694795, -122.383922171933) | ||
| 67475 | 67475 | 197240 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 301 Mendell St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016921.73157 | 2097930.91265 | 37.7414680650873 | -122.384067722948 | (37.7414680650873, -122.384067722948) | |||
| 14574 | 14574 | 14944 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016843.847680001 | 2097941.18235 | 37.7414919573859 | -122.384337736299 | (37.7414919573859, -122.384337736299) | ||
| 88338 | 88338 | 14961 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.741185307463496 | -122.384350479174 | (37.7411853074635, -122.384350479174) | |||
| 13742 | 13742 | 14945 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016835.656690001 | 2097927.0465 | 37.7414526902904 | -122.384365073909 | (37.7414526902904, -122.384365073909) | ||
| 132253 | 132253 | 197245 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016656.39457 | 2097572.2278400003 | 37.7404685163083 | -122.38496019216001 | (37.7404685163083, -122.38496019216) | |||
| 30199 | 30199 | 197244 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016639.49339 | 2097549.35813 | 37.7404047858594 | -122.38501703741699 | (37.7404047858594, -122.385017037417) | |||
| 174606 | 174606 | 197243 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016629.41985 | 2097534.84725 | 37.7403643847096 | -122.38505085732099 | (37.7403643847096, -122.385050857321) | |||
| 16096 | 16096 | 14971 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 400X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016631.74011 | 2097650.02311 | 37.740680762618396 | -122.385050857322 | (37.7406807626184, -122.385050857322) | ||
| 87342 | 87342 | 14977 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 495X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016593.7594099995 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | ||
| 118418 | 118418 | 14981 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 495X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3X3 | 6016593.7594099995 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | ||
| 182869 | 182869 | 197272 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 621 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016550.5665 | 2097428.77687 | 37.740068774853796 | -122.38531611416401 | (37.7400687748538, -122.385316114164) | |||
| 84773 | 84773 | 15001 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | ||
| 104312 | 104312 | 15003 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | ||
| 124664 | 124664 | 15000 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | |||
| 74976 | 74976 | 197271 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016522.123869999 | 2097389.36221 | 37.739958976617295 | -122.385411712102 | (37.7399589766173, -122.385411712102) | |||
| 105453 | 105453 | 197270 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 621 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016507.88272 | 2097368.67206 | 37.739901377747294 | -122.385459511073 | (37.7399013777473, -122.385459511073) | |||
| 14657 | 14657 | 12132 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.995019999 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | ||
| 53585 | 53585 | 197269 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016467.035209999 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | |||
| 65823 | 65823 | 197268 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 623 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016457.45945 | 2097300.20103 | 37.7397105802781 | -122.385629084527 | (37.7397105802781, -122.385629084527) | |||
| 23243 | 23243 | 14987 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | ||
| 14722 | 14722 | 14988 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.38567078067801 | (37.7400006988631, -122.385670780678) | ||
| 138859 | 138859 | 93980 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53404 | 6016373.3 | 2096115.1 | 37.7364518752706 | -122.385837492382 | (37.7364518752706, -122.385837492382) | |
| 126922 | 126922 | 15008 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 600X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 134739 | 134739 | 197273 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.38610360101299 | (37.7394019032644, -122.386103601013) | |||
| 170255 | 170255 | 65579 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 670 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/1990 12:00:00 AM | 4 | Permit Number 28479 | 6016251.26211 | 2097105.4929099998 | 37.739164539819 | -122.386328462099 | (37.739164539819, -122.386328462099) | ||
| 119871 | 119871 | 15016 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 670 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 5 | 3x3 | 6016248.60441 | 2097127.21289 | 37.739224031366795 | -122.386339165233 | (37.7392240313668, -122.386339165233) | ||
| 147369 | 147369 | 197233 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016183.784440001 | 2103092.78575 | 37.7556006718551 | -122.38697923850799 | (37.7556006718551, -122.386979238508) | |||
| 78226 | 78226 | 27556 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 82165 | 82165 | 27558 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 84083 | 84083 | 27571 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 85613 | 85613 | 27570 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 90033 | 90033 | 27553 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 119050 | 119050 | 27573 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) |
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");