Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8760 | 8760 | 12320 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 999 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004798.1051 | 2112124.4849 | 37.7797625287887 | -122.426997735879 | (37.7797625287887, -122.426997735879) | |||
| 97109 | 97109 | 113832 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 998X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007963.0 | 2102149.0 | 37.75255062425121 | -122.415342560511 | (37.7525506242512, -122.415342560511) | |||
| 97536 | 97536 | 96969 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 996X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 17188 | 6009608.0 | 2116096.0 | 37.7909381623214 | -122.410638676365 | (37.7909381623214, -122.410638676365) | ||||
| 80339 | 80339 | 7861 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2014 12:00:00 AM | 6 | 4x4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | ||
| 125384 | 125384 | 7863 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | |||
| 128100 | 128100 | 7862 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | |||
| 165405 | 165405 | 58199 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 994X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1978 12:00:00 AM | 9 | 3x3 | Permit Number 17188 | 6009171.14908 | 2116038.20395 | 37.7907549665223 | -122.412146081588 | (37.7907549665223, -122.412146081588) | |
| 161660 | 161660 | 49773 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 991@ HAWES Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2003 12:00:00 AM | 5 | Permit Number 46560 | 6018765.60896 | 2094758.8067599998 | 37.7328598551943 | -122.377472089671 | (37.7328598551943, -122.377472089671) | ||
| 8094 | 8094 | 8144 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 990 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003074.2562 | 2111370.9925 | 37.7775960000162 | -122.43290743350501 | (37.7775960000162, -122.432907433505) | |||
| 62390 | 62390 | 133156 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | |||
| 150939 | 150939 | 133155 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010424.25918 | 2121988.2428099997 | 37.8071625495686 | -122.408230195965 | (37.8071625495686, -122.408230195965) | |||
| 61028 | 61028 | 234093 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Lapidge St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006030.40587 | 2104961.66349 | 37.760164736632 | -122.42222562462798 | (37.760164736632, -122.422225624628) | |||
| 167522 | 167522 | 234094 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Lapidge St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006027.15545 | 2105008.64737 | 37.76029356002471 | -122.422240204431 | (37.7602935600247, -122.422240204431) | |||
| 129846 | 129846 | 211653 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Agua Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996871.35998 | 2098562.1094 | 37.742072275526795 | -122.453440190824 | (37.7420722755268, -122.453440190824) | |||
| 160438 | 160438 | 211652 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Agua Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996858.64894 | 2098565.73818 | 37.7420815106435 | -122.453484403284 | (37.7420815106435, -122.453484403284) | |||
| 9195 | 9195 | 25208 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 98X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006558.37518 | 2110275.64647 | 37.7747854429547 | -122.420776888181 | (37.7747854429547, -122.420776888181) | |||
| 9294 | 9294 | 25210 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 98X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006558.37518 | 2110275.64647 | 37.7747854429547 | -122.420776888181 | (37.7747854429547, -122.420776888181) | |||
| 114957 | 114957 | 25209 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 98X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2014 12:00:00 AM | 3 | 3x3 | 6006534.0 | 2110441.0 | 37.775238090110996 | -122.420872949151 | (37.775238090111, -122.420872949151) | ||
| 123052 | 123052 | 25207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 98X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006558.37518 | 2110275.64647 | 37.7747854429547 | -122.420776888181 | (37.7747854429547, -122.420776888181) | |||
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 5173 | 5173 | 27601 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003246.4786 | 2111399.6963 | 37.7776845802664 | -122.432313709128 | (37.7776845802664, -122.432313709128) | |
| 5174 | 5174 | 27604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | |
| 5175 | 5175 | 27606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.43266311980801 | (37.7776386560762, -122.432663119808) | |
| 5627 | 5627 | 27603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 6003200.8903 | 2111391.8168 | 37.77766036009189 | -122.43247085155501 | (37.7776603600919, -122.432470851555) | |||
| 8824 | 8824 | 27605 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6003164.87 | 2111386.7515 | 37.7776444094038 | -122.432595096019 | (37.7776444094038, -122.432595096019) | |||
| 78745 | 78745 | 46448 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 79205 | 79205 | 46450 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 83527 | 83527 | 46452 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 97693 | 97693 | 46453 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 101953 | 101953 | 46449 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 141118 | 141118 | 46451 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 11096 | 11096 | 101706 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 987 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009634.1980099995 | 2086638.2413700002 | 37.710055168691 | -122.40846923845899 | (37.710055168691, -122.408469238459) | |||
| 177875 | 177875 | 211761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993022.58565 | 2098456.56211 | 37.7415610999725 | -122.466740251977 | (37.7415610999725, -122.466740251977) | |||
| 53451 | 53451 | 132632 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 Spruce St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5997056.52317 | 2116093.53652 | 37.7902196990203 | -122.45406584826999 | (37.7902196990203, -122.45406584827) | |||
| 28460 | 28460 | 211766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992106.77002 | 2095921.0899200002 | 37.73454643836789 | -122.469722258175 | (37.7345464383679, -122.469722258175) | |||
| 150066 | 150066 | 211767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 San Fernando Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 5992105.74103 | 2095889.53253 | 37.734459730225396 | -122.46972351902001 | (37.7344597302254, -122.46972351902) | |||
| 44199 | 44199 | 247462 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 979 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002745.6993 | 2110233.2519 | 37.7744534065731 | -122.433962674806 | (37.7744534065731, -122.433962674806) | |||
| 87117 | 87117 | 7002 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 979 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002780.8869199995 | 2110207.25037 | 37.774384009647605 | -122.433839095378 | (37.7743840096476, -122.433839095378) | |||
| 19309 | 19309 | 10151 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 970 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 2x2 | 6005670.87032 | 2103329.80739 | 37.7556637547844 | -122.423353081294 | (37.7556637547844, -122.423353081294) | |||
| 1268 | 1268 | 221739 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 960 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 5997261.09109 | 2107110.0824 | 37.7655652095945 | -122.452709425124 | (37.7655652095945, -122.452709425124) | |||
| 52781 | 52781 | 235129 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 960 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007985.55995 | 2102191.01079 | 37.7526672443005 | -122.415267517775 | (37.7526672443005, -122.415267517775) | |||
| 51166 | 51166 | 234269 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 96 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007929.65225 | 2099953.36007 | 37.7465200165945 | -122.415302465436 | (37.7465200165945, -122.415302465436) | |||
| 71435 | 71435 | 60419 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 956 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1982 12:00:00 AM | 11 | Permit Number 20001 | 6012141.0311900005 | 2103925.82718 | 37.7576633380176 | -122.40101895967899 | (37.7576633380176, -122.401018959679) | ||
| 184568 | 184568 | 194665 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 954 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012141.87967 | 2103949.8505599997 | 37.7577293482605 | -122.401017713193 | (37.7577293482605, -122.401017713193) | |||
| 164308 | 164308 | 132985 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 951 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006063.23559 | 2113456.74964 | 37.783492057842395 | -122.422715792914 | (37.7834920578424, -122.422715792914) | |||
| 166768 | 166768 | 132986 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 951 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006064.35653 | 2113430.15952 | 37.7834191111477 | -122.422710024653 | (37.7834191111477, -122.422710024653) | |||
| 178484 | 178484 | 132987 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 951 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006075.7011 | 2113391.25211 | 37.7833129210041 | -122.42266801104401 | (37.7833129210041, -122.422668011044) | |||
| 1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
| 40964 | 40964 | 55479 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 950 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 16 | Permit Number 11431 | 6002457.7556 | 2111793.5064 | 37.778721130856 | -122.43507034036502 | (37.778721130856, -122.435070340365) | |
| 105909 | 105909 | 7859 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 950 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6006124.69338 | 2113429.85689 | 37.7834216841963 | -122.422501260977 | (37.7834216841963, -122.422501260977) | |||
| 122501 | 122501 | 7860 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006140.60429 | 2113414.054 | 37.7833791909161 | -122.42244509214 | (37.7833791909161, -122.42244509214) | |||
| 141351 | 141351 | 7858 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 950 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6006130.89599 | 2113392.48394 | 37.783319417158 | -122.422477145901 | (37.783319417158, -122.422477145901) | |||
| 36205 | 36205 | 44457 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002582.01071 | 2086882.75579 | 37.7103290904997 | -122.432860405496 | (37.7103290904997, -122.432860405496) | |
| 49228 | 49228 | 44454 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 115695 | 115695 | 44453 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 39220 | 39220 | 234038 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Scott St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6002345.035630001 | 2108759.77422 | 37.7703848563176 | -122.43524322850901 | (37.7703848563176, -122.435243228509) | |||
| 73798 | 73798 | 234037 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Scott St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6002343.23108 | 2108773.3042200003 | 37.7704219038818 | -122.435250438364 | (37.7704219038818, -122.435250438364) | |||
| 41941 | 41941 | 236173 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003570.95088 | 2097764.56999 | 37.740264170545395 | -122.430218246779 | (37.7402641705454, -122.430218246779) | |||
| 60150 | 60150 | 236171 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Harper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003599.0149 | 2097799.6745 | 37.7403621489854 | -122.430123716338 | (37.7403621489854, -122.430123716338) | |||
| 133089 | 133089 | 236172 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Harper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003583.54823 | 2097783.3412599997 | 37.74031642565271 | -122.43017602901399 | (37.7403164256527, -122.430176029014) | |||
| 23558 | 23558 | 235256 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003748.878930001 | 2105066.8141900003 | 37.7603245002968 | -122.43012384316002 | (37.7603245002968, -122.43012384316) | |||
| 29251 | 29251 | 235253 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003697.36729 | 2105064.6984200003 | 37.7603157732807 | -122.430301846859 | (37.7603157732807, -122.430301846859) | |||
| 39841 | 39841 | 235257 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Hancock St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003769.2591 | 2105068.3802900002 | 37.7603299546911 | -122.430053469409 | (37.7603299546911, -122.430053469409) | |||
| 51273 | 51273 | 235254 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003711.01688 | 2105068.78709 | 37.7603277729298 | -122.430254931026 | (37.7603277729298, -122.430254931026) | |||
| 157467 | 157467 | 235255 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003731.72204 | 2105066.7708 | 37.760323409422604 | -122.43018317771799 | (37.7603234094226, -122.430183177718) | |||
| 40445 | 40445 | 85307 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2007 12:00:00 AM | 14 | Permit Number 49592 | 5994243.39546 | 2114990.3725400004 | 37.7870290071023 | -122.46371888295499 | (37.7870290071023, -122.463718882955) | ||
| 70700 | 70700 | 85308 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2007 12:00:00 AM | 14 | Permit Number 49592 | 5994244.832880001 | 2114975.13056 | 37.7869872396049 | -122.463712803164 | (37.7869872396049, -122.463712803164) | ||
| 74640 | 74640 | 123553 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994244.71645 | 2114956.69048 | 37.7869366014587 | -122.463711867101 | (37.7869366014587, -122.463711867101) | |||
| 147046 | 147046 | 123554 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 95 05th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5994243.89595 | 2114936.9191 | 37.7868822673544 | -122.46371327027799 | (37.7868822673544, -122.463713270278) | |||
| 44307 | 44307 | 116178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 94X Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2x2 | Permit Number 777858 | 6013051.68778 | 2114735.3522900003 | 37.7873946119181 | -122.39862805626001 | (37.7873946119181, -122.39862805626) | ||
| 69217 | 69217 | 116177 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 94X Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6013088.1413199995 | 2114773.9893400003 | 37.7875027311189 | -122.3985046459 | (37.7875027311189, -122.3985046459) | |||
| 136626 | 136626 | 116180 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 94X Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6013027.60059 | 2114713.51395 | 37.7873333069301 | -122.398709860366 | (37.7873333069301, -122.398709860366) | |||
| 152781 | 152781 | 116179 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 94X Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6013036.36382 | 2114723.48466 | 37.787361172417896 | -122.398680241201 | (37.7873611724179, -122.398680241201) | |||
| 121364 | 121364 | 116181 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 94X NATOMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6013016.0 | 2114722.0 | 37.787355961306 | -122.398750592015 | (37.787355961306, -122.398750592015) | ||||
| 85401 | 85401 | 12307 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 949 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6004806.2528800005 | 2112097.03189 | 37.7796876103034 | -122.426967593325 | (37.7796876103034, -122.426967593325) | |||
| 67027 | 67027 | 111960 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 946x Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008211.98048 | 2115817.44636 | 37.7900949549591 | -122.41544913139299 | (37.7900949549591, -122.415449131393) | |||
| 183527 | 183527 | 111959 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 946x Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6008215.71275 | 2115787.91143 | 37.7900140690411 | -122.415434126181 | (37.7900140690411, -122.415434126181) | |||
| 80141 | 80141 | 12303 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 945X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.42758319096399 | (37.7790930089412, -122.427583190964) | |||
| 59291 | 59291 | 116004 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 945 Front St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012685.456119999 | 2119344.92547 | 37.800030995894105 | -122.40021901989901 | (37.8000309958941, -122.400219019899) | |||
| 150437 | 150437 | 116002 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 945 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012675.6988699995 | 2119422.85071 | 37.8002444157938 | -122.400258260017 | (37.8002444157938, -122.400258260017) | |||
| 89103 | 89103 | 116005 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 945 FRONT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012663.0 | 2119386.0 | 37.8001425245044 | -122.40029961366501 | (37.8001425245044, -122.400299613665) | ||||
| 55415 | 55415 | 133122 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 941 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008869.28255 | 2118668.2564 | 37.797959502879294 | -122.413376604174 | (37.7979595028793, -122.413376604174) | ||||
| 163655 | 163655 | 133121 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 941 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008863.72095 | 2118673.47701 | 37.7979735251223 | -122.41339621836201 | (37.7979735251223, -122.413396218362) | ||||
| 32125 | 32125 | 132982 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 940 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006123.5856099995 | 2113391.3058599997 | 37.783315770038 | -122.422502353216 | (37.783315770038, -122.422502353216) | |||
| 118443 | 118443 | 132984 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 940 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006117.05795 | 2113452.3229099996 | 37.7834829396269 | -122.42252927352502 | (37.7834829396269, -122.422529273525) | |||
| 149882 | 149882 | 132983 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 940 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006120.43545 | 2113427.3470099997 | 37.783414552476394 | -122.422515813365 | (37.7834145524764, -122.422515813365) | |||
| 154358 | 154358 | 132981 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 940 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006127.4732 | 2113364.1057 | 37.783241304386 | -122.422486970301 | (37.783241304386, -122.422486970301) | |||
| 29249 | 29249 | 60892 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/11/1983 12:00:00 AM | 16 | 5x5 | Permit Number 20677 | 6008514.66964 | 2119698.45237 | 37.8007682484075 | -122.414676612845 | (37.8007682484075, -122.414676612845) |
| 29352 | 29352 | 110960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008419.49323 | 2119686.5094 | 37.8007301081687 | -122.415005118088 | (37.8007301081687, -122.415005118088) | ||
| 67897 | 67897 | 110959 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008435.0253800005 | 2119688.1206900002 | 37.800735405160296 | -122.414951484348 | (37.8007354051603, -122.414951484348) | ||
| 72275 | 72275 | 110957 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008462.007069999 | 2119690.6551900003 | 37.800743880377205 | -122.41485829568998 | (37.8007438803772, -122.41485829569) | ||
| 73832 | 73832 | 110956 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 5x5 | 6008474.06115 | 2119692.72385 | 37.800750237701294 | -122.414816729923 | (37.8007502377013, -122.414816729923) | ||
| 152078 | 152078 | 110955 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008486.881990001 | 2119694.39066 | 37.8007555347125 | -122.41477248237699 | (37.8007555347125, -122.414772482377) | ||
| 166820 | 166820 | 110958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | ||
| 69107 | 69107 | 235166 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 936 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001887.8049800005 | 2101292.85102 | 37.7498565220628 | -122.436290324449 | (37.7498565220628, -122.436290324449) | |||
| 85005 | 85005 | 63964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 934 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 934-936 Diamond St | 6001894.63542373 | 2101371.30666035 | 37.7500723306894 | -122.436272318547 | (37.7500723306894, -122.436272318547) | ||
| 161673 | 161673 | 133015 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 933 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007703.09634 | 2115631.13846 | 37.789554783461 | -122.41719662654499 | (37.789554783461, -122.417196626545) | |||
| 63903 | 63903 | 34836 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 930 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 11 | 3x3 | Permit Number 50324 | 6009439.92518 | 2116075.5513400002 | 37.790872590650395 | -122.411218765432 | (37.7908725906504, -122.411218765432) | |
| 100931 | 100931 | 87319 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 930 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50324 | 6009428.0 | 2116071.0 | 37.790859424974606 | -122.41125970453399 | (37.7908594249746, -122.411259704534) | |||
| 29065 | 29065 | 234039 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 93 Scott St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6002347.866230001 | 2108745.44445 | 37.770345671048204 | -122.435232412346 | (37.7703456710482, -122.435232412346) |
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");