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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54 | 54 | 121137 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 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) | |||
| 60 | 60 | 121139 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 70 | 70 | 121138 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 97 | 97 | 5266 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.43918115910401 | (37.781343716873, -122.439181159104) | |||
| 98 | 98 | 142074 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1384X GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001183.1648 | 2110763.0502 | 37.7758193019084 | -122.439405751925 | (37.7758193019084, -122.439405751925) | |||
| 102 | 102 | 98037 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1384X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2017 12:00:00 AM | 3 | Permit Number 767782 | 6001197.2582 | 2110764.9293 | 37.775825263482105 | -122.439357134105 | (37.7758252634821, -122.439357134105) | ||
| 107 | 107 | 142075 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1384X GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001166.7226 | 2110758.8221 | 37.775806756879895 | -122.439462326391 | (37.7758067568799, -122.439462326391) | |||
| 115 | 115 | 6964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003997.6735 | 2110460.7643 | 37.7751490695403 | -122.42964808764499 | (37.7751490695403, -122.429648087645) | |||
| 153 | 153 | 5972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.43311045884899 | (37.7813844410266, -122.433110458849) | ||
| 234 | 234 | 26932 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1570 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2000 12:00:00 AM | 3 | 3X3 | 6002097.1307 | 2111930.5841 | 37.7790770280177 | -122.43632769328998 | (37.7790770280177, -122.43632769329) | ||
| 264 | 264 | 20199 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | ||
| 309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
| 322 | 322 | 7968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3 | 3X3 | 6005627.24821 | 2116610.0246200003 | 37.7921255585096 | -122.42444850412 | (37.7921255585096, -122.42444850412) | ||
| 329 | 329 | 5267 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6001292.1098 | 2112753.8798 | 37.7812918154006 | -122.43917160516001 | (37.7812918154006, -122.43917160516) | |||
| 337 | 337 | 14819 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | |||
| 347 | 347 | 250073 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 373 | 373 | 250075 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 377 | 377 | 250072 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 386 | 386 | 2602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005112.3923 | 2115130.7833 | 37.7880348455319 | -122.42612455857201 | (37.7880348455319, -122.426124558572) | |||
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 415 | 415 | 250074 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
| 452 | 452 | 221749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | |||
| 458 | 458 | 221750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.45214620578699 | (37.7636633116224, -122.452146205787) | |||
| 463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
| 472 | 472 | 236059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004719.95486 | 2107769.51353 | 37.7678004187701 | -122.42695783742799 | (37.7678004187701, -122.426957837428) | |||
| 483 | 483 | 236058 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004683.7857099995 | 2107762.8709299997 | 37.767780134560205 | -122.427082469082 | (37.7677801345602, -122.427082469082) | |||
| 491 | 491 | 236057 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004642.9908 | 2107763.18347 | 37.767778685763 | -122.427223596101 | (37.767778685763, -122.427223596101) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 510 | 510 | 7848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006120.7355 | 2113033.04101 | 37.7823319018231 | -122.422486748168 | (37.7823319018231, -122.422486748168) | |||
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 590 | 590 | 98625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002285.2374 | 2120040.8430000003 | 37.8013564005351 | -122.43625752618999 | (37.8013564005351, -122.43625752619) | ||
| 615 | 615 | 2703 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 12 | 3X3 | 6003147.2203 | 2114799.0941 | 37.7870128441602 | -122.432899995096 | (37.7870128441602, -122.432899995096) | ||
| 616 | 616 | 8142 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.777707304798206 | -122.432059137251 | (37.7777073047982, -122.432059137251) | |||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 653 | 653 | 144739 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | |||
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 658 | 658 | 147406 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 515 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 6x10 | 5989054.53583 | 2111789.60329 | 37.7779402316839 | -122.48143647103201 | (37.7779402316839, -122.481436471032) | |||
| 871 | 871 | 20198 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002788.752 | 2112893.404 | 37.7817599629104 | -122.43400393984501 | (37.7817599629104, -122.434003939845) | ||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 957 | 957 | 141829 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1058 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | 6004468.2701 | 2112261.9634 | 37.780121354581105 | -122.42814858004101 | (37.7801213545811, -122.428148580041) | |||
| 992 | 992 | 7205 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 926 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | 3 | 4X4 | 6003464.8493 | 2111545.8007 | 37.778098126187295 | -122.431568724094 | (37.7780981261873, -122.431568724094) | ||
| 1000 | 1000 | 133103 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006658.0 | 2119469.0 | 37.8000337406718 | -122.42108517312599 | (37.8000337406718, -122.421085173126) | |||
| 1019 | 1019 | 5195 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 625 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001591.0229 | 2110593.2492 | 37.7753762735578 | -122.437982704394 | (37.7753762735578, -122.437982704394) | ||
| 1089 | 1089 | 9603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003102.1679 | 2112019.7759 | 37.7793789805584 | -122.43285723801 | (37.7793789805584, -122.43285723801) | |||
| 1096 | 1096 | 211742 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Junipero Serra Blvd | 88 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5991230.19236 | 2092152.91218 | 37.724149261961706 | -122.472478226094 | (37.7241492619617, -122.472478226094) | |||
| 1110 | 1110 | 14853 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1351 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6002697.0103 | 2111613.4514 | 37.778240327396105 | -122.434229790526 | (37.7782403273961, -122.434229790526) | ||
| 1142 | 1142 | 20178 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002826.2747 | 2112615.9016 | 37.781000140452704 | -122.433854288088 | (37.7810001404527, -122.433854288088) | ||
| 1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
| 1229 | 1229 | 235065 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2400 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 6 | Width 2ft | Permit Number 38465 | 6001951.69941 | 2097144.86437 | 37.7384707551305 | -122.43577263420299 | (37.7384707551305, -122.435772634203) | |
| 1236 | 1236 | 9417 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 4X4 | 6006077.70084 | 2112484.44584 | 37.7808231658948 | -122.422596633642 | (37.7808231658948, -122.422596633642) | ||
| 1255 | 1255 | 65778 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3101 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1990 12:00:00 AM | 5 | Permit Number 28743 | 6000913.14979 | 2119077.92932 | 37.7986344413927 | -122.440936428972 | (37.7986344413927, -122.440936428972) | |
| 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) | |||
| 1300 | 1300 | 14826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | |||
| 1314 | 1314 | 92967 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3022 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779165 | 6000091.47375 | 2115801.73595 | 37.7895920459934 | -122.443544210206 | (37.7895920459934, -122.443544210206) | |
| 1328 | 1328 | 236115 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | Width 3ft | Permit Number 780066 | 6003708.0 | 2109045.0 | 37.771245321662896 | -122.4305490898 | (37.7712453216629, -122.4305490898) | |
| 1331 | 1331 | 14830 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1284 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003046.0718 | 2111709.6378 | 37.778524236985895 | -122.433029133637 | (37.7785242369859, -122.433029133637) | |||
| 1339 | 1339 | 66377 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 621 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29502 | 6003558.1677 | 2110522.6128 | 37.775293994216 | -122.431172851087 | (37.775293994216, -122.431172851087) | |
| 1351 | 1351 | 5208 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001567.0603 | 2111230.6559 | 37.777125069374705 | -122.438111266341 | (37.7771250693747, -122.438111266341) | |||
| 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) | |||
| 1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
| 1446 | 1446 | 139885 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1575 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 6 | Width 0ft | 6002581.4123 | 2112293.0339 | 37.7800997287845 | -122.434678293337 | (37.7800997287845, -122.434678293337) | ||
| 1449 | 1449 | 234076 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12 | Width 4ft | 6011147.1312 | 2101589.6307 | 37.751193164657 | -122.40429186329901 | (37.751193164657, -122.404291863299) | |||
| 1454 | 1454 | 234074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.8522900003 | 37.751468148541996 | -122.40431145682301 | (37.751468148542, -122.404311456823) | |||
| 1456 | 1456 | 139884 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 4 | Width 0ft | 6002525.5727 | 2112285.5886 | 37.7800761156462 | -122.43487093500299 | (37.7800761156462, -122.434870935003) | ||
| 1461 | 1461 | 234073 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | |||
| 1464 | 1464 | 234075 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.75130354562771 | -122.404297986789 | (37.7513035456277, -122.404297986789) | |||
| 1474 | 1474 | 139883 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002506.9595 | 2112283.5581 | 37.780069483595 | -122.434935181147 | (37.780069483595, -122.434935181147) | |||
| 1476 | 1476 | 139882 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 14 | Width 0ft | 6002483.27 | 2112280.1738 | 37.780058846079605 | -122.435016891621 | (37.7800588460796, -122.435016891621) | ||
| 1481 | 1481 | 51149 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47562 | 6003023.69355 | 2121013.0550700002 | 37.804067769267704 | -122.433771669621 | (37.8040677692677, -122.433771669621) | |
| 1572 | 1572 | 9622 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1404 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002793.2644 | 2112026.6959 | 37.7793804561129 | -122.433926358604 | (37.7793804561129, -122.433926358604) | |||
| 1589 | 1589 | 45715 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 475 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2017 12:00:00 AM | 3 | Permit Number 44386 | 6010097.78481 | 2106045.52558 | 37.7633693601423 | -122.40823487245301 | (37.7633693601423, -122.408234872453) | ||
| 1667 | 1667 | 251648 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2649 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007031.0 | 2102934.0 | 37.7546536287073 | -122.41862124555 | (37.7546536287073, -122.41862124555) | ||||
| 1672 | 1672 | 251649 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2649 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007031.0 | 2102934.0 | 37.7546536287073 | -122.41862124555 | (37.7546536287073, -122.41862124555) | ||||
| 1704 | 1704 | 251429 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779991 | 6003307.0 | 2100429.0 | 37.7475651236724 | -122.43132102920099 | (37.7475651236724, -122.431321029201) | |
| 1714 | 1714 | 115408 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 889 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6006526.39743 | 2121457.3012099997 | 37.8054856898732 | -122.42168186931801 | (37.8054856898732, -122.421681869318) | |||
| 1724 | 1724 | 14824 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003110.3265 | 2111720.6082 | 37.7785580034409 | -122.43280763628599 | (37.7785580034409, -122.432807636286) | |||
| 1744 | 1744 | 9601 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6003062.4207 | 2112013.0769 | 37.7793583323419 | -122.432994261414 | (37.7793583323419, -122.432994261414) | |||
| 1816 | 1816 | 20201 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002775.658 | 2112980.5073 | 37.7819983835402 | -122.43405546728 | (37.7819983835402, -122.43405546728) | ||
| 1821 | 1821 | 21741 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002908.4575 | 2114420.548 | 37.7859599074732 | -122.433698994827 | (37.7859599074732, -122.433698994827) | |||
| 1845 | 1845 | 98642 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002233.86885 | 2120387.2869599997 | 37.8023047257379 | -122.436460093962 | (37.8023047257379, -122.436460093962) | ||
| 1887 | 1887 | 20008 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
| 1910 | 1910 | 18873 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2299 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003870.98343 | 2115955.49438 | 37.790229051088 | -122.430478480014 | (37.790229051088, -122.430478480014) | |||
| 1922 | 1922 | 14822 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003155.2525 | 2111726.3545 | 37.778576329265 | -122.432652630798 | (37.778576329265, -122.432652630798) | |||
| 1931 | 1931 | 135812 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1147 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779607 | 6007418.27175 | 2119501.50723 | 37.800165825864205 | -122.418456642358 | (37.8001658258642, -122.418456642358) | |
| 1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 1986 | 1986 | 251131 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 2036 | 2036 | 11448 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:09:00 PM | 3 | 3 | 5995519.82754 | 2115841.84115 | 37.789440378559796 | -122.45936442896799 | (37.7894403785598, -122.459364428968) | ||
| 2044 | 2044 | 20173 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002849.1714 | 2112441.6535 | 37.780522998189795 | -122.43376261941201 | (37.7805229981898, -122.433762619412) | ||
| 2129 | 2129 | 156905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 3201x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417.0 | 2106083.0 | 37.763321780718705 | -122.417509514421 | (37.7633217807187, -122.417509514421) | |
| 2130 | 2130 | 18891 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2513 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1990 12:00:00 AM | 8 | 3X3 | 6002620.56709 | 2115777.954 | 37.7896706584215 | -122.434792120457 | (37.7896706584215, -122.434792120457) | ||
| 2133 | 2133 | 252909 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417.0 | 2106083.0 | 37.763321780718705 | -122.417509514421 | (37.7633217807187, -122.417509514421) | |
| 2142 | 2142 | 252906 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2143 | 2143 | 252905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2147 | 2147 | 252908 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2181 | 2181 | 98628 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x4 | 6002274.71062 | 2120096.76485 | 37.801509349129795 | -122.43629795788999 | (37.8015093491298, -122.43629795789) | ||
| 2243 | 2243 | 20174 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002845.6787 | 2112476.9688 | 37.7806197669525 | -122.433777227143 | (37.7806197669525, -122.433777227143) | ||
| 2368 | 2368 | 68207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.80491086613029 | -122.41001577934601 | (37.8049108661303, -122.410015779346) | |
| 2375 | 2375 | 14825 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003082.6395 | 2111715.9066 | 37.7785435236875 | -122.432903080133 | (37.7785435236875, -122.432903080133) |
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");