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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28295 | 28295 | 178408 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001651.1985599995 | 2094173.31719 | 37.7302944985896 | -122.43659898077699 | (37.7302944985896, -122.436598980777) | ||||
| 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) | ||||
| 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) | ||||
| 34233 | 34233 | 249674 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2400 Baker St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999745.99135 | 2117154.55448 | 37.7932868206909 | -122.444836822859 | (37.7932868206909, -122.444836822859) | ||||
| 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) | ||||
| 41576 | 41576 | 178403 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001622.1469 | 2094146.16948 | 37.7302183062155 | -122.436697473612 | (37.7302183062155, -122.436697473612) | ||||
| 41833 | 41833 | 211469 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5993761.6919599995 | 2096603.4346099999 | 37.7365155021795 | -122.46405020255199 | (37.7365155021795, -122.464050202552) | ||||
| 42414 | 42414 | 178412 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001615.63687 | 2094138.09403 | 37.7301957629086 | -122.43671940177201 | (37.7301957629086, -122.436719401772) | ||||
| 42960 | 42960 | 132421 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 93 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6008147.86247 | 2119098.46526 | 37.7991002182645 | -122.41590341131099 | (37.7991002182645, -122.415903411311) | ||||
| 44694 | 44694 | 132423 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.41355547121401 | (37.7979513838133, -122.413555471214) | ||||
| 45229 | 45229 | 249704 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2400 Baker St | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999690.977469999 | 2117209.86424 | 37.793435546960104 | -122.445031151972 | (37.7934355469601, -122.445031151972) | ||||
| 47612 | 47612 | 132430 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008611.92512 | 2118990.4909900003 | 37.79882982628239 | -122.414289948436 | (37.7988298262824, -122.414289948436) | ||||
| 49671 | 49671 | 132429 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008611.378880001 | 2118984.10383 | 37.79881225804311 | -122.414291386455 | (37.7988122580431, -122.414291386455) | ||||
| 51529 | 51529 | 132427 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008608.8618 | 2118977.06556 | 37.798792791310206 | -122.414299598148 | (37.7987927913102, -122.414299598148) | ||||
| 51885 | 51885 | 178405 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001634.24365 | 2094157.9299599999 | 37.7302512852578 | -122.436656495109 | (37.7302512852578, -122.436656495109) | ||||
| 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) | ||||
| 58074 | 58074 | 211472 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 200x Terrace Dr | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993829.814069999 | 2096532.0459099999 | 37.7363234123842 | -122.463809497222 | (37.7363234123842, -122.463809497222) | ||||
| 58076 | 58076 | 247523 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1101 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000011.18383 | 2108488.88375 | 37.769508249328 | -122.44329653959801 | (37.769508249328, -122.443296539598) | ||||
| 61904 | 61904 | 178404 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001626.60618 | 2094150.6328 | 37.730230814892295 | -122.43668237668301 | (37.7302308148923, -122.436682376683) | ||||
| 62899 | 62899 | 132437 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6008631.997880001 | 2118976.07541 | 37.7987913721926 | -122.414219469452 | (37.7987913721926, -122.414219469452) | ||||
| 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) | |
| 63232 | 63232 | 132435 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6008622.60306 | 2118990.33445 | 37.7988299962621 | -122.414252988079 | (37.7988299962621, -122.414252988079) | ||||
| 63952 | 63952 | 132434 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6008620.992269999 | 2118990.5013599996 | 37.7988303640752 | -122.41425857377199 | (37.7988303640752, -122.414258573772) | ||||
| 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) | ||||
| 64602 | 64602 | 132436 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008624.64494 | 2118991.4983200002 | 37.798833306655105 | -122.414246004875 | (37.7988333066551, -122.414246004875) | ||||
| 69268 | 69268 | 116648 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 71995 | 71995 | 132425 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 941 Vallejo St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008897.86349 | 2118673.3166799997 | 37.797975001809995 | -122.413278063645 | (37.79797500181, -122.413278063645) | ||||
| 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) | |
| 73209 | 73209 | 178418 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6001657.79965 | 2094178.37716 | 37.730308767230795 | -122.43657652198999 | (37.7303087672308, -122.43657652199) | ||||
| 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) | ||||
| 82496 | 82496 | 116652 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 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) | |||
| 85774 | 85774 | 100552 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | |||||
| 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) | |||||
| 111240 | 111240 | 121001 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1992X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | ||||
| 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) | |||||
| 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) | |||
| 118788 | 118788 | 116651 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 6 | 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) | |||||
| 129308 | 129308 | 116650 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 131210 | 131210 | 132426 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008604.37776 | 2118975.38502 | 37.798787925083 | -122.414314995462 | (37.798787925083, -122.414314995462) | ||||
| 133323 | 133323 | 132438 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008636.9513 | 2118981.46679 | 37.798806453817896 | -122.414202710601 | (37.7988064538179, -122.414202710601) | ||||
| 134140 | 134140 | 249702 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2400 Baker St | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999706.07757 | 2117210.8185799997 | 37.7934390291431 | -122.44497897331699 | (37.7934390291431, -122.444978973317) | ||||
| 135061 | 135061 | 178414 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6001625.71874 | 2094150.1248299999 | 37.7302293696897 | -122.436685408329 | (37.7302293696897, -122.436685408329) | ||||
| 137516 | 137516 | 178413 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001621.7877 | 2094145.7694700002 | 37.7302171874661 | -122.43669868679 | (37.7302171874661, -122.43669868679) | ||||
| 142403 | 142403 | 100551 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | |||||
| 145521 | 145521 | 116649 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 147367 | 147367 | 194594 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 22 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | ||||
| 147916 | 147916 | 178401 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001606.4733 | 2094132.41207 | 37.730179640767105 | -122.43675067480301 | (37.7301796407671, -122.436750674803) | ||||
| 149478 | 149478 | 211470 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5993769.41475 | 2096594.44879 | 37.736491274435295 | -122.46402284969801 | (37.7364912744353, -122.464022849698) | ||||
| 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) | ||||
| 154461 | 154461 | 178407 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001645.05047 | 2094167.64617 | 37.730278577884 | -122.436619829756 | (37.730278577884, -122.436619829756) | ||||
| 155242 | 155242 | 132420 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 95 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6008112.06223 | 2119093.98922 | 37.799085915430105 | -122.416026975472 | (37.7990859154301, -122.416026975472) | ||||
| 157349 | 157349 | 233978 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1100 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004853.46612 | 2096726.8825 | 37.7374874741536 | -122.42570998043999 | (37.7374874741536, -122.42570998044) | ||||
| 158728 | 158728 | 194598 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 22nd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6013347.3325 | 2103843.81837 | 37.7575053774884 | -122.39684129758801 | (37.7575053774884, -122.396841297588) | ||||
| 159862 | 159862 | 72314 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3481 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2007 12:00:00 AM | 5 | Permit Number 49483 | 5998140.19653 | 2115811.9929299997 | 37.789508732779005 | -122.450296133986 | (37.789508732779, -122.450296133986) | |
| 160773 | 160773 | 178411 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001607.21703 | 2094132.14841 | 37.730178959084796 | -122.43674808476999 | (37.7301789590848, -122.43674808477) | ||||
| 165069 | 165069 | 194591 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1301 Minnesota St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6015395.46497 | 2102261.8945 | 37.7532755385605 | -122.38964748835501 | (37.7532755385605, -122.389647488355) | ||||
| 165371 | 165371 | 178406 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001639.75964 | 2094163.19973 | 37.7302660683079 | -122.43663780268801 | (37.7302660683079, -122.436637802688) | ||||
| 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) | ||
| 168543 | 168543 | 132444 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 14 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6008522.99961 | 2119161.3261700002 | 37.7992939016597 | -122.414609756357 | (37.7992939016597, -122.414609756357) | ||||
| 169010 | 169010 | 250145 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2550x Lyon St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5999218.1379 | 2117651.88833 | 37.794622229397 | -122.44669902475799 | (37.794622229397, -122.446699024758) | ||||
| 170696 | 170696 | 194597 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 22nd St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6013352.62113 | 2103844.18935 | 37.757506690487105 | -122.396823033261 | (37.7575066904871, -122.396823033261) | ||||
| 171212 | 171212 | 178415 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001633.0697 | 2094156.39849 | 37.730247013477005 | -122.43666044402399 | (37.730247013477, -122.436660444024) | ||||
| 175972 | 175972 | 132431 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008617.41774 | 2118989.2974400003 | 37.7988268576225 | -122.41427085762501 | (37.7988268576225, -122.414270857625) | ||||
| 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) | ||||
| 177645 | 177645 | 132409 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3600 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998888.99949 | 2121205.1052200003 | 37.8043596001851 | -122.448093845382 | (37.8043596001851, -122.448093845382) | ||||
| 177748 | 177748 | 178416 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6001641.53674 | 2094164.63815 | 37.7302701188701 | -122.43663176194599 | (37.7302701188701, -122.436631761946) | ||||
| 178678 | 178678 | 178417 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001651.54923 | 2094173.3046900001 | 37.730294484195205 | -122.43659776757099 | (37.7302944841952, -122.436597767571) | ||||
| 179133 | 179133 | 247531 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1101 Waller St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6000098.46541 | 2108483.59021 | 37.7694986913322 | -122.44299425679199 | (37.7694986913322, -122.442994256792) | ||||
| 179175 | 179175 | 211468 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5993742.38425 | 2096618.3358099998 | 37.7365553043905 | -122.464118038412 | (37.7365553043905, -122.464118038412) | ||||
| 179610 | 179610 | 132424 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008826.962619999 | 2118671.13776 | 37.7979650382118 | -122.41352324761101 | (37.7979650382118, -122.413523247611) | ||||
| 180464 | 180464 | 178402 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001615.13724 | 2094139.0666599998 | 37.7301984051332 | -122.436721198652 | (37.7301984051332, -122.436721198652) | ||||
| 181589 | 181589 | 250137 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2550x Lyon St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5999214.14671 | 2117588.9485299997 | 37.7944491854404 | -122.44670830396002 | (37.7944491854404, -122.44670830396) | ||||
| 182983 | 182983 | 194593 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 21 | : Yard 23 | Tree 1 | Private 1 | 19 | 6014441.963140001 | 2105885.02123 | 37.763170945392496 | -122.393198423694 | (37.7631709453925, -122.393198423694) | ||||
| 183715 | 183715 | 211471 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 200x Terrace Dr | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993818.60983 | 2096510.8522700001 | 37.736264574250995 | -122.463846696775 | (37.736264574251, -122.463846696775) | ||||
| 185980 | 185980 | 132428 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008612.46815 | 2118979.35525 | 37.798799280808204 | -122.414287281056 | (37.7987992808082, -122.414287281056) | ||||
| 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) | ||||
| 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 | ||||||||
| 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) | |||
| 17482 | 17482 | 29621 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 900X Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991159.4977400005 | 2090848.6205 | 37.7205639077711 | -122.47262755402299 | (37.7205639077711, -122.472627554023) | ||
| 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) | |||
| 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) | |||
| 5475 | 5475 | 107944 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 44x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008447.49259 | 2119151.63001 | 37.7992630360091 | -122.414870351108 | (37.7992630360091, -122.414870351108) | |||
| 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) | |||
| 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) | |||
| 21562 | 21562 | 29959 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 300x Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991398.70735 | 2094566.15878 | 37.730785187583606 | -122.472071516681 | (37.7307851875836, -122.472071516681) | ||
| 21874 | 21874 | 29958 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 300X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.2554 | 2094584.59866 | 37.7308359084501 | -122.47206750842501 | (37.7308359084501, -122.472067508425) | ||
| 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) | |
| 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) | ||
| 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) | |
| 77533 | 77533 | 95247 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 4 | 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) | |
| 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) | |
| 118434 | 118434 | 95246 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2626 Larkin St | 3 | 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) | |
| 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) | ||
| 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) | ||
| 125349 | 125349 | 88462 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 815 Buena Vista West Ave | 3 | 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) |
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");