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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | |
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 2650 | 2650 | 253148 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 375 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 3x3 | Permit Number 43092 | 6003622.0 | 2091383.0 | 37.722744709081205 | -122.42958672889 | (37.7227447090812, -122.42958672889) | |||
| 3149 | 3149 | 253338 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 324 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 5996595.0 | 2107026.0 | 37.7652961513923 | -122.455007196131 | (37.7652961513923, -122.455007196131) | ||||
| 3179 | 3179 | 253343 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3189 | 3189 | 253342 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 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) | ||||
| 6932 | 6932 | 36849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7300 | 7300 | 36853 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7845 | 7845 | 36850 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9699 | 9699 | 173641 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 657 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
| 9746 | 9746 | 173680 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1251 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 9747 | 9747 | 173679 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1251 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 10107 | 10107 | 173845 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1339 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003306.0 | 2100451.0 | 37.7476254738591 | -122.43132605732201 | (37.7476254738591, -122.431326057322) | ||||
| 10111 | 10111 | 67877 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1993 12:00:00 AM | Permit Number 31567 | 6003285.36844159 | 2100415.0335047003 | 37.747525548999704 | -122.43139483291999 | (37.7475255489997, -122.43139483292) | |||
| 10591 | 10591 | 36848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12676 | 12676 | 174956 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002808.89406 | 2112441.5792799997 | 37.780520508824296 | -122.433901952341 | (37.7805205088243, -122.433901952341) | ||||
| 13401 | 13401 | 87812 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4850 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50626 | |||||||
| 13714 | 13714 | 36844 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14679 | 14679 | 36852 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14747 | 14747 | 36851 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16842 | 16842 | 36847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 17887 | 17887 | 58111 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 424 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1978 12:00:00 AM | Permit Number 17089 | 5994475.54876777 | 2106701.69853806 | 37.7642838888462 | -122.462314301289 | (37.7642838888462, -122.462314301289) | |||
| 17888 | 17888 | 44169 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2100 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43638 | 6003503.99505303 | 2117958.62597334 | 37.795708342081 | -122.43189132313299 | (37.795708342081, -122.431891323133) | |||
| 18036 | 18036 | 113513 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 352 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008306.0 | 2113136.0 | 37.78273763754461 | -122.41493396572399 | (37.7827376375446, -122.414933965724) | ||||
| 18153 | 18153 | 40872 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | |||
| 18636 | 18636 | 101400 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2101X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002392.4 | 2115430.1 | 37.7887025838749 | -122.435556659004 | (37.7887025838749, -122.435556659004) | ||||
| 18640 | 18640 | 102886 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2940 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007175.0 | 2106758.0 | 37.765161553341606 | -122.41839437881399 | (37.7651615533416, -122.418394378814) | ||||
| 19425 | 19425 | 37331 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | ||
| 19686 | 19686 | 116812 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3660x 23RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005401.0 | 2102665.0 | 37.7538231135776 | -122.42423909941999 | (37.7538231135776, -122.42423909942) | ||||
| 19728 | 19728 | 112894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1x WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 19850 | 19850 | 105855 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4X Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006273.18234 | 2099962.5946400003 | 37.746452135478 | -122.421031022521 | (37.746452135478, -122.421031022521) | ||||
| 20655 | 20655 | 30721 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 273 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1995 12:00:00 AM | Permit Number 34621 | 6005264.06153495 | 2109890.21668057 | 37.7736541098939 | -122.42522675761002 | (37.7736541098939, -122.42522675761) | |||
| 22119 | 22119 | 234249 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 112 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007940.400230001 | 2098071.29786 | 37.741352896112296 | -122.415132101492 | (37.7413528961123, -122.415132101492) | ||||
| 22836 | 22836 | 251133 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | ||||
| 22859 | 22859 | 251138 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 304 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003283.0 | 2109317.0 | 37.7719680815982 | -122.43203860792299 | (37.7719680815982, -122.432038607923) | ||||
| 32408 | 32408 | 49732 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 34302 | 34302 | 30402 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 44085 | 44085 | 37178 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 83 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39751 | 6006286.91240997 | 2099581.31244652 | 37.745405994952705 | -122.420956479029 | (37.7454059949527, -122.420956479029) | ||
| 44182 | 44182 | 116897 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 180 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992666.0 | 2097552.0 | 37.7390568153225 | -122.46790741539499 | (37.7390568153225, -122.467907415395) | ||||
| 44574 | 44574 | 49689 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2235 NOTES) Hayes St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2003 12:00:00 AM | Permit Number 46511 | 5997175.15188937 | 2109805.23760487 | 37.7729604879505 | -122.453201252207 | (37.7729604879505, -122.453201252207) | |||
| 49117 | 49117 | 58287 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 335 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1978 12:00:00 AM | Permit Number 17301 | 6002954.56301529 | 2106290.38431517 | 37.763639108551395 | -122.43295842594499 | (37.7636391085514, -122.432958425945) | |||
| 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) | ||
| 53181 | 53181 | 101200 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994231.2 | 2106687.3 | 37.7642302811549 | -122.463158383346 | (37.7642302811549, -122.463158383346) | |||||
| 53603 | 53603 | 30383 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 54136 | 54136 | 47349 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 247 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45275 | 5994440.83573449 | 2091551.9214492 | 37.7226843967426 | -122.461336047264 | (37.7226843967426, -122.461336047264) | ||
| 54137 | 54137 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 54140 | 54140 | 96417 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2001 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||
| 61690 | 61690 | 115232 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775420 | 5985904.5 | 2112316.6 | 37.7792035589465 | -122.49237222008001 | (37.7792035589465, -122.49237222008) | |||
| 66733 | 66733 | 35711 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 271 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40008 | 6002102.4473232 | 2104292.82421891 | 37.7581059239319 | -122.43576269498399 | (37.7581059239319, -122.435762694984) | ||
| 66744 | 66744 | 32694 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3732 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37102 | 6004840.63533052 | 2102540.6946209 | 37.7534501432299 | -122.426168121736 | (37.7534501432299, -122.426168121736) | |||
| 71515 | 71515 | 41147 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1571 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41880 | 5998098.90766238 | 2108198.23177185 | 37.7686009624438 | -122.449890046711 | (37.7686009624438, -122.449890046711) | ||
| 72153 | 72153 | 49599 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2540 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | 3x3 | Permit Number 46468 | 6000006.86571427 | 2113723.38602572 | 37.7838806119089 | -122.44368757451001 | (37.7838806119089, -122.44368757451) | ||
| 77323 | 77323 | 58949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 91 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1980 12:00:00 AM | 3x3 | Permit Number 50911 | 6003609.463337 | 2097799.84135396 | 37.7403631988963 | -122.43008760168999 | (37.7403631988963, -122.43008760169) | ||
| 77462 | 77462 | 56263 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | Permit Number 12389 | 5997442.16701528 | 2106406.61050088 | 37.7636440286356 | -122.452032368392 | (37.7636440286356, -122.452032368392) | |||
| 77467 | 77467 | 35313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3637 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38780 | 6005411.11195628 | 2104860.60189435 | 37.759852294152005 | -122.42436028242201 | (37.759852294152, -122.424360282422) | ||
| 77476 | 77476 | 93539 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 77565 | 77565 | 92213 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3001 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2009 12:00:00 AM | 3x3 | Permit Number 52643 | 5999733.7 | 2116663.4 | 37.791937538515604 | -122.444844029888 | (37.7919375385156, -122.444844029888) | ||
| 77806 | 77806 | 51596 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 130 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47889 | 5999316.0541876 | 2107729.2257987 | 37.7673827567962 | -122.445646320311 | (37.7673827567962, -122.445646320311) | |||
| 78179 | 78179 | 37162 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3555 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.747982034538296 | -122.420875232711 | (37.7479820345383, -122.420875232711) | |||
| 78350 | 78350 | 37409 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 301 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39889 | 6003208.12169915 | 2100936.51274949 | 37.7489530306424 | -122.431699173329 | (37.7489530306424, -122.431699173329) | ||
| 78365 | 78365 | 57364 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 115 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 7.5x9 | Permit Number 16202 | 6006203.71006943 | 2102364.99346068 | 37.7530446568928 | -122.421441834225 | (37.7530446568928, -122.421441834225) | ||
| 78502 | 78502 | 109491 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1315 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007628.0 | 2115744.0 | 37.789860448493 | -122.41746445445699 | (37.789860448493, -122.417464454457) | ||||
| 78505 | 78505 | 33766 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 310 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37816 | 5994334.89031031 | 2100058.38542597 | 37.7460349532135 | -122.462318932902 | (37.7460349532135, -122.462318932902) | |||
| 78513 | 78513 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 78608 | 78608 | 116420 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 409 Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | ||||
| 78649 | 78649 | 97433 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1696@ Newhall St McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | ||||
| 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) | |||
| 78840 | 78840 | 46889 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1376 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44945 | 5993052.08417282 | 2106111.27690754 | 37.762580677938104 | -122.46719468926099 | (37.7625806779381, -122.467194689261) | ||
| 78977 | 78977 | 92833 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 575X Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007114.0 | 2112879.0 | 37.7819649256319 | -122.41903955544599 | (37.7819649256319, -122.419039555446) | ||||
| 79123 | 79123 | 35405 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 206 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50565 | 6004580.90644064 | 2098724.42919099 | 37.742956877374894 | -122.426794562995 | (37.7429568773749, -122.426794562995) | |
| 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) | |||
| 79240 | 79240 | 98015 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 79254 | 79254 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 79274 | 79274 | 30385 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 79490 | 79490 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 79537 | 79537 | 40871 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | |||
| 79731 | 79731 | 107915 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 40X Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998867.83001 | 2105402.91503 | 37.7609696909735 | -122.447029231618 | (37.7609696909735, -122.447029231618) | ||||
| 79801 | 79801 | 46710 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1302 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44840 | 5996796.89477309 | 2106986.36474823 | 37.7651989032411 | -122.454306030419 | (37.7651989032411, -122.454306030419) | ||
| 79840 | 79840 | 97855 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 79877 | 79877 | 31420 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4052 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35006 | 6001951.47636685 | 2103555.31466959 | 37.7560723237915 | -122.436232037881 | (37.7560723237915, -122.436232037881) | ||
| 79914 | 79914 | 43373 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43122 | 6001780.55436365 | 2103444.50870534 | 37.755758364615296 | -122.436815210583 | (37.7557583646153, -122.436815210583) | ||
| 79928 | 79928 | 110607 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1181 GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6007369.0 | 2118756.0 | 37.798116076291706 | -122.41857424763599 | (37.7981160762917, -122.418574247636) | ||||
| 79936 | 79936 | 122844 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 20x Seymour St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001693.0 | 2112151.0 | 37.77965926371179 | -122.437741533251 | (37.7796592637118, -122.437741533251) | ||||
| 79939 | 79939 | 101199 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994231.2 | 2106687.3 | 37.7642302811549 | -122.463158383346 | (37.7642302811549, -122.463158383346) | |||||
| 80040 | 80040 | 53968 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1354 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773113 | 5988678.33594659 | 2106104.92629407 | 37.762309795805294 | -122.48232125545799 | (37.7623097958053, -122.482321255458) | ||
| 80122 | 80122 | 98749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 80152 | 80152 | 104683 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 80156 | 80156 | 40873 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | |||
| 80276 | 80276 | 93199 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 748 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x9 | 5998625.2 | 2107963.2 | 37.7679857237315 | -122.448052727493 | (37.7679857237315, -122.448052727493) | ||||
| 80294 | 80294 | 98013 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1535 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1987 12:00:00 AM | Permit Number 24638 | 5988477.0 | 2098970.0 | 37.7427074834674 | -122.482494765439 | (37.7427074834674, -122.482494765439) | |||
| 80302 | 80302 | 48515 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1(REVISED) Church St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 80335 | 80335 | 98579 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 80458 | 80458 | 37567 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4406 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40002 | 6001744.86990875 | 2104124.02927541 | 37.7576221359597 | -122.43698726488199 | (37.7576221359597, -122.436987264882) | ||
| 80544 | 80544 | 30393 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) |
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");