Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4360 | 4360 | 8196 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1310X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001489.6126 | 2111152.0859 | 37.7769049310776 | -122.438373551392 | (37.7769049310776, -122.438373551392) | |||
| 4387 | 4387 | 175897 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:28:00 AM | 3 | Width 4ft | 6004496.9517 | 2090791.26121 | 37.721169426695795 | -122.426520093344 | (37.7211694266958, -122.426520093344) | ||
| 4415 | 4415 | 216758 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Bruce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 10:35:00 AM | 3 | Width 3ft | 5997172.50242 | 2091270.81822 | 37.7220693917577 | -122.45187305021099 | (37.7220693917577, -122.451873050211) | ||
| 4544 | 4544 | 253638 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 859 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2017 12:00:00 AM | 3 | 3x3 | 6009440.103999999 | 2118743.01656 | 37.7981968084542 | -122.411406675592 | (37.7981968084542, -122.411406675592) | ||
| 4550 | 4550 | 236150 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 78 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1980 12:00:00 AM | 12 | Width 3ft | Permit Number 18226 | 6003583.9574 | 2097837.09588 | 37.7404640466695 | -122.430178448188 | (37.7404640466695, -122.430178448188) | |
| 4625 | 4625 | 19259 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1320 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6001796.9506 | 2113006.0886 | 37.782013030605995 | -122.437443172865 | (37.782013030606, -122.437443172865) | |||
| 4633 | 4633 | 160570 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 795 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:41:00 AM | 3 | Width 0ft | 6002146.9194 | 2089087.66438 | 37.716358596934796 | -122.43452171951598 | (37.7163585969348, -122.434521719516) | |
| 4656 | 4656 | 160582 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 725 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:12:00 PM | 3 | Width 0ft | 6002352.537690001 | 2089413.73171 | 37.7172655758154 | -122.433834295726 | (37.7172655758154, -122.433834295726) | |
| 4660 | 4660 | 49888 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1400 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52632 | 6006190.8899300005 | 2119372.26772 | 37.7997417954962 | -122.422694676831 | (37.7997417954962, -122.422694676831) | |
| 4676 | 4676 | 160569 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 797 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:33:00 AM | 3 | Width 0ft | 6002135.10796 | 2089068.7183299998 | 37.7163059047739 | -122.434561191648 | (37.7163059047739, -122.434561191648) | |
| 4688 | 4688 | 160571 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 793 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:54:00 AM | 3 | Width 0ft | 6002167.83829 | 2089121.34733 | 37.716452270331295 | -122.43445182061899 | (37.7164522703313, -122.434451820619) | |
| 4727 | 4727 | 253673 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 600 x Sanchez St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
| 4746 | 4746 | 206086 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1337 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 5 | Width 3ft | 5991588.39226 | 2106545.66282 | 37.7636887858255 | -122.472288687689 | (37.7636887858255, -122.472288687689) | ||
| 4860 | 4860 | 14685 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 772 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005444.6106 | 2112052.626 | 37.779601757581396 | -122.42475607462099 | (37.7796017575814, -122.424756074621) | |||
| 4883 | 4883 | 206248 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5994216.193940001 | 2106696.29316 | 37.7642541095667 | -122.46321093723301 | (37.7642541095667, -122.463210937233) | |||
| 4927 | 4927 | 5213 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 824 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2006 12:00:00 AM | 5 | 3x3 | 6001558.6916 | 2111280.8681 | 37.77726246348279 | -122.438143814078 | (37.7772624634828, -122.438143814078) | ||
| 5087 | 5087 | 150676 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 548 Rhode Island St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.983990001 | 2105812.52377 | 37.762822244976505 | -122.402486741392 | (37.7628222449765, -122.402486741392) | |
| 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) | |
| 5244 | 5244 | 235111 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006667.0 | 2098452.0 | 37.7423265745703 | -122.41956208669599 | (37.7423265745703, -122.419562086696) | |||
| 5295 | 5295 | 6028 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1800 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001799.5064 | 2112579.1081 | 37.780840795713395 | -122.437403746471 | (37.7808407957134, -122.437403746471) | |||
| 5316 | 5316 | 20193 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002809.8162 | 2112741.4002 | 37.7813437940939 | -122.433920199287 | (37.7813437940939, -122.433920199287) | ||
| 5337 | 5337 | 14719 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 871 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6005011.2646 | 2111934.1612 | 37.779251997589 | -122.426246769427 | (37.779251997589, -122.426246769427) | |||
| 5338 | 5338 | 2730 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2254 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002720.3576 | 2114799.1787 | 37.7869888561759 | -122.43437684858999 | (37.7869888561759, -122.43437684859) | |||
| 5367 | 5367 | 22746 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1585 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002419.6467 | 2112271.0365 | 37.7800301445704 | -122.43523633930401 | (37.7800301445704, -122.435236339304) | |||
| 5403 | 5403 | 6081 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1973 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 12 | 4x4 | 6000989.2223 | 2112419.519 | 37.780356506143704 | -122.440195460208 | (37.7803565061437, -122.440195460208) | ||
| 5424 | 5424 | 18952 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2848 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001174.38746 | 2115625.67946 | 37.78917034037811 | -122.439784822813 | (37.7891703403781, -122.439784822813) | |||
| 5492 | 5492 | 8001 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 355 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1992 12:00:00 AM | 12 | 3X3 | 6006046.8196 | 2111733.76797 | 37.7787602452394 | -122.422650106445 | (37.7787602452394, -122.422650106445) | ||
| 5496 | 5496 | 99696 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.794393599230204 | -122.41905900288799 | (37.7943935992302, -122.419059002888) | ||
| 5563 | 5563 | 97055 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2209 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 769445 | 6002327.80211 | 2115857.41291 | 37.7898722063959 | -122.43581074387501 | (37.7898722063959, -122.435810743875) | ||
| 5584 | 5584 | 2623 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1810 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 9 | 3X3 | 6004694.7357 | 2115072.9947 | 37.787852557835706 | -122.42756545836599 | (37.7878525578357, -122.427565458366) | ||
| 5611 | 5611 | 22669 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1301 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003694.9541 | 2112452.7229 | 37.780601348717 | -122.43083744803499 | (37.780601348717, -122.430837448035) | |||
| 5620 | 5620 | 2650 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1950 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004171.8211 | 2114999.0511 | 37.7876199363476 | -122.429369370882 | (37.7876199363476, -122.429369370882) | |||
| 5623 | 5623 | 19242 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 707 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/2012 12:00:00 AM | 3 | 3X3 | 6002040.9749 | 2110967.2112 | 37.776428657122395 | -122.43645298909901 | (37.7764286571224, -122.436452989099) | ||
| 5708 | 5708 | 18895 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2540 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2015 12:00:00 AM | 3 | 4X4 | 6002597.10991 | 2115822.79128 | 37.789792438322394 | -122.434876487663 | (37.7897924383224, -122.434876487663) | ||
| 5777 | 5777 | 18935 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2720 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001787.24752 | 2115709.65036 | 37.7894357680807 | -122.437670423159 | (37.7894357680807, -122.437670423159) | ||
| 5821 | 5821 | 13219 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2233 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001704.3053 | 2119361.4174 | 37.7994578530016 | -122.438219104839 | (37.7994578530016, -122.438219104839) | ||
| 5840 | 5840 | 6055 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001309.0309 | 2112458.7759 | 37.7804824979769 | -122.43909191015699 | (37.7804824979769, -122.439091910157) | |||
| 5876 | 5876 | 22641 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1232 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/1991 12:00:00 AM | 6 | 3X3 | 6004096.6073 | 2112557.2154 | 37.780911007880796 | -122.429455392073 | (37.7809110078808, -122.429455392073) | ||
| 5895 | 5895 | 18863 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2224 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003936.17366 | 2116009.64602 | 37.7903814304031 | -122.430256791725 | (37.7903814304031, -122.430256791725) | |||
| 5903 | 5903 | 2675 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2059 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003660.5178 | 2114875.7424 | 37.787252401142794 | -122.43112957460501 | (37.7872524011428, -122.431129574605) | |||
| 5937 | 5937 | 21745 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2053 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002761.9991 | 2114399.8594 | 37.7858947903994 | -122.434204220723 | (37.7858947903994, -122.434204220723) | |||
| 5970 | 5970 | 18896 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2555 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002535.92495 | 2115763.84644 | 37.789627116838005 | -122.435083963947 | (37.789627116838, -122.435083963947) | |||
| 6041 | 6041 | 18960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000879.73218 | 2115589.7344400003 | 37.7890548683423 | -122.440801711449 | (37.7890548683423, -122.440801711449) | |||
| 6109 | 6109 | 18931 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2711 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001680.91742 | 2115644.75135 | 37.789251525792295 | -122.438033662046 | (37.7892515257923, -122.438033662046) | |||
| 6134 | 6134 | 8185 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1231 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 6 | 3X3 | 6001830.167 | 2111146.7455 | 37.7769096322666 | -122.43719508955401 | (37.7769096322666, -122.437195089554) | ||
| 6182 | 6182 | 8032 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 555 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.778311728407104 | -122.426254616894 | (37.7783117284071, -122.426254616894) | |||
| 6194 | 6194 | 18986 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2927 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000773.77883 | 2115525.0246900003 | 37.788871157515004 | -122.44116365078999 | (37.788871157515, -122.44116365079) | |||
| 6195 | 6195 | 5203 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 773 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2011 12:00:00 AM | 3 | 4x4 | 6001531.5367 | 2111004.3927 | 37.7765017872485 | -122.438217940497 | (37.7765017872485, -122.438217940497) | ||
| 6237 | 6237 | 2645 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1922 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6004273.4414 | 2115014.6406 | 37.7876684938964 | -122.42901889648998 | (37.7876684938964, -122.42901889649) | |||
| 6255 | 6255 | 5277 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1343 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001253.1913 | 2113044.9225 | 37.7820887298486 | -122.43932711157301 | (37.7820887298486, -122.439327111573) | |||
| 6325 | 6325 | 18898 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2565 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002517.73823 | 2115762.73588 | 37.789623034819 | -122.43514680858401 | (37.789623034819, -122.435146808584) | |||
| 6349 | 6349 | 8141 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 924 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003343.2834 | 2111409.827 | 37.77771788514671 | -122.43197955209999 | (37.7777178851467, -122.4319795521) | |||
| 6361 | 6361 | 21734 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1971 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003170.7155 | 2114455.7073 | 37.7860713235645 | -122.432794167189 | (37.7860713235645, -122.432794167189) | |||
| 6427 | 6427 | 8025 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 475 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005491.2545 | 2111661.4115 | 37.7785302125817 | -122.424566877082 | (37.7785302125817, -122.424566877082) | |||
| 6430 | 6430 | 19274 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1357 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2x2 | 6001742.1262 | 2113132.6584 | 37.782357442099 | -122.437641907141 | (37.782357442099, -122.437641907141) | |||
| 6453 | 6453 | 1900 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 20 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6001556.2481 | 2112999.4048 | 37.7819809912612 | -122.438275412787 | (37.7819809912612, -122.438275412787) | ||
| 6462 | 6462 | 7852 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006141.267469999 | 2113278.03254 | 37.783005746771 | -122.42243312970899 | (37.783005746771, -122.422433129709) | |||
| 6529 | 6529 | 19276 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1375 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6001733.3273 | 2113193.2359 | 37.782523272226 | -122.437676687178 | (37.782523272226, -122.437676687178) | |||
| 6549 | 6549 | 3021 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2500X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6002331.14616 | 2115451.17215 | 37.7887569634091 | -122.43577009631201 | (37.7887569634091, -122.435770096312) | |||
| 6553 | 6553 | 19247 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2012 12:00:00 AM | 3 | 3X3 | 6002021.1577 | 2111125.9971 | 37.7768635173125 | -122.43653291011299 | (37.7768635173125, -122.436532910113) | ||
| 6558 | 6558 | 2682 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2094 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/1995 12:00:00 AM | 11 | 3X3 | 6003513.5745 | 2114908.5919 | 37.787334269689495 | -122.431640312975 | (37.7873342696895, -122.431640312975) | ||
| 6565 | 6565 | 9626 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1412 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002726.9337 | 2112016.8817 | 37.7793497443727 | -122.434155122321 | (37.7793497443727, -122.434155122321) | |||
| 6608 | 6608 | 18948 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2832 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6001228.58337 | 2115631.47646 | 37.78918934215 | -122.439597727861 | (37.78918934215, -122.439597727861) | |||
| 6614 | 6614 | 102689 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2145 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001361.0184 | 2115839.1531599998 | 37.789767105317395 | -122.43915441067399 | (37.7897671053174, -122.439154410674) | |||
| 6736 | 6736 | 18847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2171 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004409.47419 | 2116033.3162599998 | 37.790473219721704 | -122.428620891643 | (37.7904732197217, -122.428620891643) | |||
| 6747 | 6747 | 27613 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1235 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003138.7984 | 2111681.5354 | 37.7784523340396 | -122.43270634933 | (37.7784523340396, -122.43270634933) | |||
| 6767 | 6767 | 10641 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003718.4017 | 2110767.1906 | 37.7759746233785 | -122.430636021327 | (37.7759746233785, -122.430636021327) | |||
| 6878 | 6878 | 19002 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3055 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000175.03289 | 2115441.15492 | 37.7886067496481 | -122.443229196567 | (37.7886067496481, -122.443229196567) | |||
| 6890 | 6890 | 19261 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1321 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001757.6936 | 2113025.0402 | 37.7820628349745 | -122.437580341502 | (37.7820628349745, -122.437580341502) | |||
| 6897 | 6897 | 54854 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 240 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 10 | 3x3 | Permit Number 10713 | 5998352.4011 | 2109746.0854 | 37.772865474065 | -122.44912476046001 | (37.772865474065, -122.44912476046) | |
| 6905 | 6905 | 18889 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2505 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 14 | 3X3 | 6002719.33455 | 2115789.29201 | 37.789707396626895 | -122.434451206367 | (37.7897073966269, -122.434451206367) | ||
| 6912 | 6912 | 21737 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002817.9196 | 2114405.7997 | 37.785914274666794 | -122.43401117624201 | (37.7859142746668, -122.434011176242) | |||
| 6956 | 6956 | 2655 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1998 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003984.7473 | 2114974.2234 | 37.78754117279421 | -122.43001483766001 | (37.7875411727942, -122.43001483766) | |||
| 7005 | 7005 | 9643 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1495 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1987 12:00:00 AM | 12 | 3x3 | 6002484.9621 | 2111928.892 | 37.77909441056521 | -122.43498590771699 | (37.7790944105652, -122.434985907717) | ||
| 7018 | 7018 | 18846 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2153 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004468.00056 | 2116036.9604599997 | 37.7904865377806 | -122.428418653923 | (37.7904865377806, -122.428418653923) | |||
| 7063 | 7063 | 5960 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1510 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2002 12:00:00 AM | 6 | 3x3 | 6003193.6121 | 2112775.3517 | 37.7814587887796 | -122.432594879838 | (37.7814587887796, -122.432594879838) | ||
| 7074 | 7074 | 102692 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2105 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001375.56268 | 2115723.58488 | 37.789450612297294 | -122.43909580275199 | (37.7894506122973, -122.439095802752) | |||
| 7145 | 7145 | 9444 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 785 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1997 12:00:00 AM | 3 | 3x3 | 6005806.881019999 | 2112394.04649 | 37.780559669032606 | -122.423527103712 | (37.7805596690326, -122.423527103712) | ||
| 7165 | 7165 | 20180 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2008 12:00:00 AM | 3 | 3X3 | 6002788.0753 | 2112583.2115 | 37.7809082138909 | -122.433984101181 | (37.7809082138909, -122.433984101181) | ||
| 7198 | 7198 | 6361 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001087.8723 | 2112779.769 | 37.781351276781 | -122.439880021764 | (37.781351276781, -122.439880021764) | |||
| 7233 | 7233 | 8026 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 479 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005450.8521 | 2111656.1644 | 37.778513523554395 | -122.424706271124 | (37.7785135235544, -122.424706271124) | |||
| 7241 | 7241 | 18843 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2121 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1994 12:00:00 AM | 6 | 3x3 | 6004600.36718 | 2116052.01819 | 37.79053537185071 | -122.427961747031 | (37.7905353718507, -122.427961747031) | ||
| 7254 | 7254 | 59145 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 636 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 18453 | 6001100.9535 | 2110936.3987 | 37.776290594205605 | -122.439702571656 | (37.7762905942056, -122.439702571656) | |
| 7258 | 7258 | 5948 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1445 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1990 12:00:00 AM | 6 | 3x3 | 6003514.9369 | 2112774.3523 | 37.7814742616502 | -122.43148318047399 | (37.7814742616502, -122.431483180474) | ||
| 7355 | 7355 | 9645 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1521 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002120.8202 | 2111880.4977 | 37.7789408493567 | -122.43624215643699 | (37.7789408493567, -122.436242156437) | |||
| 7370 | 7370 | 18933 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2713 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001657.24685 | 2115643.17685 | 37.7892458564681 | -122.43811544637899 | (37.7892458564681, -122.438115446379) | |||
| 7403 | 7403 | 107472 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6007706.0171300005 | 2117181.73808 | 37.793812512193604 | -122.417296448573 | (37.7938125121936, -122.417296448573) | |||
| 7442 | 7442 | 1549 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 521 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 5995574.90365 | 2112668.93283 | 37.780731590921704 | -122.458944048869 | (37.7807315909217, -122.458944048869) | |||
| 7468 | 7468 | 18930 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2709 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001727.72178 | 2115652.0410700003 | 37.789274203096795 | -122.437872247233 | (37.7892742030968, -122.437872247233) | |||
| 7498 | 7498 | 9532 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1089 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6004379.3224 | 2112193.8398 | 37.7799292710395 | -122.428451433608 | (37.7799292710395, -122.428451433608) | |||
| 7552 | 7552 | 2646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1936 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004216.8574 | 2115005.9798 | 37.787641510438704 | -122.42921404836001 | (37.7876415104387, -122.42921404836) | |||
| 7587 | 7587 | 98602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.792731538790704 | -122.433083047059 | (37.7927315387907, -122.433083047059) | ||
| 7614 | 7614 | 20156 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002897.8994 | 2112109.7603 | 37.7796144675148 | -122.43357032043899 | (37.7796144675148, -122.433570320439) | |||
| 7657 | 7657 | 7078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1738 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/2016 07:11:00 AM | 3 | 3X3 | 5999065.402000001 | 2109769.8151 | 37.7729713838489 | -122.446660124374 | (37.7729713838489, -122.446660124374) | ||
| 7659 | 7659 | 9621 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1402 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002809.5086 | 2112030.0801 | 37.779390670103 | -122.43387040511001 | (37.779390670103, -122.43387040511) | |||
| 7693 | 7693 | 102688 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2151 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001355.00146 | 2115873.66297 | 37.7898615179477 | -122.439177703113 | (37.7898615179477, -122.439177703113) | |||
| 7720 | 7720 | 8064 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 624 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004671.4119 | 2111597.7717 | 37.7783091393379 | -122.42739849091002 | (37.7783091393379, -122.42739849091) | |||
| 7727 | 7727 | 22739 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1575 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:58:00 AM | 3 | 3x3 | 6002545.878 | 2112288.296 | 37.7800847023278 | -122.434800883535 | (37.7800847023278, -122.434800883535) | ||
| 7753 | 7753 | 6030 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1802 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001783.7854 | 2112578.1648 | 37.780837311887495 | -122.437458065414 | (37.7808373118875, -122.437458065414) | |||
| 7795 | 7795 | 19003 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3064 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000117.92738 | 2115475.13063 | 37.7886967816762 | -122.443429213889 | (37.7886967816762, -122.443429213889) |
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");