Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2834 | 2834 | 18980 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2918 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6000663.1774699995 | 2115553.99763 | 37.788944409101 | -122.441548395156 | (37.788944409101, -122.441548395156) | |||
| 3645 | 3645 | 237733 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4084 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001754.97283 | 2105879.14802 | 37.7624418398492 | -122.437077981268 | (37.7624418398492, -122.437077981268) | |||
| 19823 | 19823 | 28241 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3849 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X6 | 6004869.33528 | 2100447.6674099998 | 37.74770479785771 | -122.42591989391501 | (37.7477047978577, -122.425919893915) | |||
| 23733 | 23733 | 142705 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 550 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008670.6587 | 2121106.7911 | 37.804643957021604 | -122.41423652198 | (37.8046439570216, -122.41423652198) | |||
| 23997 | 23997 | 211515 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 42 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6001141.02777 | 2095226.0889599998 | 37.7331561620146 | -122.43843810425301 | (37.7331561620146, -122.438438104253) | |||
| 29212 | 29212 | 67866 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 525 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51918 | 6011810.47286 | 2105913.7518 | 37.763103292118004 | -122.402301941482 | (37.763103292118, -122.402301941482) | |
| 29518 | 29518 | 233985 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 524 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5998610.0170599995 | 2106121.66353 | 37.762928461205505 | -122.447972640126 | (37.7629284612055, -122.447972640126) | |||
| 30339 | 30339 | 211462 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 20 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5993868.16001 | 2100935.65838 | 37.7484168360728 | -122.463996482471 | (37.7484168360728, -122.463996482471) | |||
| 32731 | 32731 | 132443 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 45 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6008455.947000001 | 2119141.60156 | 37.7992359754255 | -122.414840385693 | (37.7992359754255, -122.414840385693) | ||||
| 34211 | 34211 | 211475 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 370 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997994.43141 | 2098177.8593599997 | 37.7410815301989 | -122.449529301835 | (37.7410815301989, -122.449529301835) | |||
| 39614 | 39614 | 137943 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1934 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003936.5354 | 2115120.5913 | 37.787940331576294 | -122.430192087218 | (37.7879403315763, -122.430192087218) | |||
| 39714 | 39714 | 233979 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 984 Valencia St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6006291.32527 | 2103870.13031 | 37.7571823544938 | -122.421245715219 | (37.7571823544938, -122.421245715219) | |||
| 41205 | 41205 | 234007 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3978 22nd St | 1 | : 4 | Tree 1 | Private 1 | 12 | 6001985.80169 | 2102958.64311 | 37.7544359571599 | -122.43607063447399 | (37.7544359571599, -122.436070634474) | ||||
| 45715 | 45715 | 234010 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 10 Museum Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000617.506990001 | 2106869.9600299997 | 37.765097643976205 | -122.44108313359301 | (37.7650976439762, -122.441083133593) | |||
| 47448 | 47448 | 211458 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 627 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992320.27215 | 2103852.77916 | 37.7563371653349 | -122.46956132179501 | (37.7563371653349, -122.469561321795) | |||
| 51628 | 51628 | 211457 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1612 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993723.499 | 2104492.49464 | 37.758174657459996 | -122.464754967966 | (37.75817465746, -122.464754967966) | |||
| 53864 | 53864 | 88779 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 52 MacOndray Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 51696 | 6008424.66952 | 2119147.16935 | 37.7992495057053 | -122.414949011194 | (37.7992495057053, -122.414949011194) | ||
| 54393 | 54393 | 211454 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1478 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5991840.401000001 | 2105371.22942 | 37.7604786845549 | -122.471331499675 | (37.7604786845549, -122.471331499675) | |||
| 55591 | 55591 | 120237 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 374 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988416.64547 | 2113494.9813 | 37.782585610484 | -122.483768203906 | (37.782585610484, -122.483768203906) | |||
| 55617 | 55617 | 233991 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 252 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5999009.85314 | 2106698.21052 | 37.764534361698 | -122.44663123474 | (37.764534361698, -122.44663123474) | |||
| 56453 | 56453 | 233981 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3846 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6004869.8512 | 2100493.03902 | 37.7478294069984 | -122.425921339098 | (37.7478294069984, -122.425921339098) | |||
| 59662 | 59662 | 194599 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 2ft | 6013504.76514 | 2104470.26142 | 37.7592342153007 | -122.396340734951 | (37.7592342153007, -122.396340734951) | |||
| 63099 | 63099 | 43765 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 342 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43400 | 5990296.824030001 | 2113068.04534 | 37.781522630876495 | -122.47723245536999 | (37.7815226308765, -122.47723245537) | |
| 64201 | 64201 | 211476 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 374 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998007.0333 | 2098161.22384 | 37.7410365739886 | -122.44948453090001 | (37.7410365739886, -122.4494845309) | |||
| 66769 | 66769 | 211455 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1380 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992429.4104 | 2106070.41105 | 37.7624325075809 | -122.469345298373 | (37.7624325075809, -122.469345298373) | |||
| 68502 | 68502 | 248505 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 130 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999316.1058 | 2107725.6935 | 37.767373060939896 | -122.445645887747 | (37.7673730609399, -122.445645887747) | |||
| 69995 | 69995 | 211511 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 340 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992962.16125 | 2099691.47205 | 37.7449483622804 | -122.46703893750299 | (37.7449483622804, -122.467038937503) | |||
| 72226 | 72226 | 73741 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3481 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | Permit Number 49483 | 5998156.63107 | 2115814.91133 | 37.789517686447894 | -122.450239482971 | (37.7895176864479, -122.450239482971) | |
| 75069 | 75069 | 234001 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4472 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000174.51508 | 2101698.13826 | 37.750871847669 | -122.442244032449 | (37.750871847669, -122.442244032449) | |||
| 75457 | 75457 | 123385 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 721 03rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5995022.52144 | 2110636.2099599997 | 37.775118506904796 | -122.460707640307 | (37.7751185069048, -122.460707640307) | |||
| 75693 | 75693 | 84706 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1314 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51012 | 6001521.7618 | 2110464.8497 | 37.775019781788004 | -122.438213093993 | (37.775019781788, -122.438213093993) | |
| 76994 | 76994 | 132433 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008619.19252 | 2118974.8638 | 37.79878732612271 | -122.41426369452499 | (37.7987873261227, -122.414263694525) | ||||
| 79334 | 79334 | 116646 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | ||||
| 81326 | 81326 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | ||||
| 83703 | 83703 | 104370 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3196 Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/25/2013 12:00:00 AM | Permit Number 770075 | 5999036.6 | 2116652.0 | 37.7918664297274 | -122.447255168871 | (37.7918664297274, -122.447255168871) | |||
| 99127 | 99127 | 20590 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
| 115180 | 115180 | 114801 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2147 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 776071 | 5990655.8 | 2100775.7 | 37.7477919761741 | -122.475092965537 | (37.7477919761741, -122.475092965537) | |||
| 117672 | 117672 | 233976 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 85 Scott St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6002352.16344 | 2108701.24422 | 37.7702245521494 | -122.435214386342 | (37.7702245521494, -122.435214386342) | |||
| 121323 | 121323 | 83224 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 26 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50883 | 5994497.41095107 | 2106022.9855068 | 37.762421578125604 | -122.462189460567 | (37.7624215781256, -122.462189460567) | ||
| 123980 | 123980 | 211479 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 490 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5994798.99094 | 2091823.24095 | 37.723449981517504 | -122.46011763813699 | (37.7234499815175, -122.460117638137) | |||
| 131244 | 131244 | 103146 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2400 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x7 | 6001529.82493 | 2118035.8425 | 37.795808247211 | -122.43872782983499 | (37.795808247211, -122.438727829835) | |||
| 136954 | 136954 | 132410 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 745 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5999410.35977 | 2121494.73276 | 37.8051846283209 | -122.446310488859 | (37.8051846283209, -122.446310488859) | |||
| 137674 | 137674 | 211483 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 240 Summit St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996392.86792 | 2089617.979 | 37.717486398958705 | -122.454448701352 | (37.7174863989587, -122.454448701352) | |||
| 151488 | 151488 | 211513 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 85 Linares Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994187.9170699995 | 2102046.5502299997 | 37.7514854856778 | -122.462971364138 | (37.7514854856778, -122.462971364138) | |||
| 152274 | 152274 | 234009 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008979.2712199995 | 2097211.07769 | 37.7390492467314 | -122.411479275665 | (37.7390492467314, -122.411479275665) | |||
| 153202 | 153202 | 132422 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6008806.4990300005 | 2118647.23011 | 37.7978982446696 | -122.413592365905 | (37.7978982446696, -122.413592365905) | ||||
| 155168 | 155168 | 117852 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 646 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5983837.36901 | 2111411.05025 | 37.7765961134807 | -122.499456225742 | (37.7765961134807, -122.499456225742) | |||
| 155513 | 155513 | 233989 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 577 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998615.03299 | 2105838.59692 | 37.7621515180031 | -122.447934910876 | (37.7621515180031, -122.447934910876) | |||
| 155671 | 155671 | 234006 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4249 21st St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6001270.65442 | 2103323.8239 | 37.755398000620296 | -122.43856995745399 | (37.7553980006203, -122.438569957454) | |||
| 156312 | 156312 | 233992 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 26 Aztec St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007767.83381 | 2099565.6382400002 | 37.7454463231873 | -122.415834567334 | (37.7454463231873, -122.415834567334) | |||
| 159016 | 159016 | 211473 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5993901.96581 | 2094475.8287900002 | 37.730681705290706 | -122.46341086912399 | (37.7306817052907, -122.463410869124) | |||
| 161222 | 161222 | 233987 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 516 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5998601.660759999 | 2106187.3875599997 | 37.763108445232604 | -122.448006273897 | (37.7631084452326, -122.448006273897) | |||
| 161551 | 161551 | 211459 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 268 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5994445.84522 | 2100625.23796 | 37.7475977758138 | -122.46197636681002 | (37.7475977758138, -122.46197636681) | |||
| 162329 | 162329 | 234008 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 49 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997051.85672 | 2106264.04005 | 37.7632302017241 | -122.453372028518 | (37.7632302017241, -122.453372028518) | |||
| 167789 | 167789 | 61065 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2941 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1983 12:00:00 AM | 14 | Permit Number 20897 | 5999977.57302 | 2118701.67418 | 37.797548015389104 | -122.44414675956399 | (37.7975480153891, -122.444146759564) | ||
| 170831 | 170831 | 234005 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 423 Eureka St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6001525.86915 | 2103357.05408 | 37.7555037573171 | -122.43768972889299 | (37.7555037573171, -122.437689728893) | |||
| 172718 | 172718 | 87875 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3600 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 28 | 3x3 | Permit Number 50847 | 5998892.13962 | 2121169.8311400004 | 37.804262926641705 | -122.448080437384 | (37.8042629266417, -122.448080437384) | |
| 172880 | 172880 | 211510 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2147 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990673.7374 | 2100765.68933 | 37.747765529061205 | -122.475030208899 | (37.7477655290612, -122.475030208899) | |||
| 173564 | 173564 | 211512 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 160 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994897.8322 | 2099478.1104 | 37.7444740625255 | -122.460330331374 | (37.7444740625255, -122.460330331374) | |||
| 175555 | 175555 | 233994 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006556.895380001 | 2097283.64243 | 37.7391123233744 | -122.419859908531 | (37.7391123233744, -122.419859908531) | |||
| 175632 | 175632 | 211464 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 28 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993948.4771 | 2101040.96262 | 37.7487106032283 | -122.463726391756 | (37.7487106032283, -122.463726391756) | |||
| 177481 | 177481 | 233998 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 642 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6001746.28209 | 2099445.10181 | 37.744774998168396 | -122.43664747132 | (37.7447749981684, -122.43664747132) | ||||
| 177700 | 177700 | 233977 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 79 Scott St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6002355.60896 | 2108678.85755 | 37.770163279535495 | -122.435200866851 | (37.7701632795355, -122.435200866851) | |||
| 179449 | 179449 | 211466 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 5 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5995817.16924 | 2100181.82044 | 37.7464591163017 | -122.457202367915 | (37.7464591163017, -122.457202367915) | |||
| 183907 | 183907 | 233988 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 575 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5998611.18796 | 2105870.9202400004 | 37.7622400499559 | -122.44795053660201 | (37.7622400499559, -122.447950536602) | |||
| 187391 | 187391 | 233999 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 744 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6001714.36393 | 2099737.9136 | 37.745577176359504 | -122.436778794807 | (37.7455771763595, -122.436778794807) | ||||
| 187569 | 187569 | 233990 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 36 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998337.94426 | 2106576.71217 | 37.764162354442604 | -122.44894642245501 | (37.7641623544426, -122.448946422455) | |||
| 188876 | 188876 | 211485 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 284 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993784.87083 | 2089111.53675 | 37.7159459124541 | -122.463426547006 | (37.7159459124541, -122.463426547006) | |||
| 6542 | 6542 | 19818 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 STAIRWAY25 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 6594 | 6594 | 29762 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 530 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008749.3255 | 2121116.482 | 37.8046749842608 | -122.413964972943 | (37.8046749842608, -122.413964972943) | |||
| 10535 | 10535 | 114182 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 126 Chester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x6 | Permit Number 776810 | 5991719.57231 | 2088350.33 | 37.713736615419606 | -122.470509712677 | (37.7137366154196, -122.470509712677) | ||
| 12291 | 12291 | 97765 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 400X Amazon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001461.36757 | 2088928.6001 | 37.7158829014541 | -122.436879936162 | (37.7158829014541, -122.436879936162) | |||
| 24930 | 24930 | 233980 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1609 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | Width 3ft | 6005332.72592 | 2098929.24645 | 37.7435617380791 | -122.424209538959 | (37.7435617380791, -122.424209538959) | |||
| 30308 | 30308 | 234002 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4472 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000158.92491 | 2101697.14224 | 37.750868224295395 | -122.442297873053 | (37.7508682242954, -122.442297873053) | |||
| 31160 | 31160 | 132445 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 44 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008457.55549 | 2119152.19379 | 37.7992651494321 | -122.414835569802 | (37.7992651494321, -122.414835569802) | ||||
| 44063 | 44063 | 211456 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1380 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992429.060880001 | 2106083.47981 | 37.7624683707489 | -122.46934745851699 | (37.7624683707489, -122.469347458517) | |||
| 44921 | 44921 | 233986 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 524 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 5998609.24404 | 2106138.43946 | 37.7629744795115 | -122.44797652162599 | (37.7629744795115, -122.447976521626) | |||
| 54641 | 54641 | 178419 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 164 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000583.99969 | 2092347.99835 | 37.7252218887704 | -122.44015758103201 | (37.7252218887704, -122.440157581032) | |||
| 55110 | 55110 | 132432 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008616.66785 | 2118981.63248 | 37.7988057694225 | -122.41427290988999 | (37.7988057694225, -122.41427290989) | ||||
| 55137 | 55137 | 211463 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 28 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993946.4146 | 2101049.73072 | 37.748734559355604 | -122.463734160116 | (37.7487345593556, -122.463734160116) | |||
| 55865 | 55865 | 211453 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1419 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991125.878830001 | 2105721.1672 | 37.761398162224296 | -122.473828208309 | (37.7613981622243, -122.473828208309) | |||
| 57447 | 57447 | 123386 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 721 03rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995023.17687 | 2110618.9944 | 37.7750712752433 | -122.460704125187 | (37.7750712752433, -122.460704125187) | |||
| 61817 | 61817 | 211480 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 5994051.74701 | 2089492.86038 | 37.71700830855371 | -122.462531748549 | (37.7170083085537, -122.462531748549) | |||
| 63972 | 63972 | 132442 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 71 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6008356.32962 | 2119132.5530000003 | 37.799205532473394 | -122.415184456397 | (37.7992055324734, -122.415184456397) | ||||
| 68219 | 68219 | 250767 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 233 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5985862.448919999 | 2114296.67471 | 37.784637815729106 | -122.492663561601 | (37.7846378157291, -122.492663561601) | |||
| 86550 | 86550 | 26088 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 113 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5995784.15621 | 2088035.19399 | 37.7131055131157 | -122.45643833605101 | (37.7131055131157, -122.456438336051) | |||
| 88813 | 88813 | 4115 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3405 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006973.82506 | 2100523.56194 | 37.748031895810705 | -122.41864804742599 | (37.7480318958107, -122.418648047426) | |||
| 89387 | 89387 | 95245 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 105316 | 105316 | 20591 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
| 105419 | 105419 | 100550 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | |||||
| 112164 | 112164 | 116647 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 119511 | 119511 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 314 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 122695 | 122695 | 83413 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50776 | 5993906.073517201 | 2094457.35212766 | 37.7306312095738 | -122.463395327953 | (37.7306312095738, -122.463395327953) | ||
| 132047 | 132047 | 87876 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3600 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50847 | 5998889.14339 | 2121177.12812 | 37.8042827908914 | -122.448091331753 | (37.8042827908914, -122.448091331753) | |
| 135753 | 135753 | 234000 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 749 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 10ft | 6001659.60779 | 2099970.43439 | 37.7462125114091 | -122.43698477644699 | (37.7462125114091, -122.436984776447) | |||
| 142670 | 142670 | 88461 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 815 Buena Vista West Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2008 12:00:00 AM | 3x3 | Permit Number 51420 | 5999858.0 | 2108239.0 | 37.76881339508 | -122.44380843942301 | (37.76881339508, -122.443808439423) | ||
| 148229 | 148229 | 211474 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 5993912.048780001 | 2094465.3579400002 | 37.730653535825 | -122.463375251462 | (37.730653535825, -122.463375251462) | |||
| 149515 | 149515 | 248506 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 130 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999287.9427 | 2107719.9397 | 37.767355654506204 | -122.445742885801 | (37.7673556545062, -122.445742885801) | |||
| 154006 | 154006 | 211484 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 240 Summit St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996386.966019999 | 2089628.8560799998 | 37.717515926389 | -122.454469886693 | (37.717515926389, -122.454469886693) | |||
| 154086 | 154086 | 194600 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 2ft | 6013514.76966 | 2104470.05867 | 37.7592342153015 | -122.396306120039 | (37.7592342153015, -122.396306120039) |
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");