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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139370 | 139370 | 90440 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.6036549998 | 37.771704095793794 | -122.420389859033 | (37.7717040957938, -122.420389859033) | ||
| 55392 | 55392 | 120822 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5989570.90273 | 2114637.64231 | 37.7857901594541 | -122.47985865853799 | (37.7857901594541, -122.479858658538) | |||
| 178858 | 178858 | 120818 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 20th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5989573.97075 | 2114567.64315 | 37.7855981397202 | -122.479842920071 | (37.7855981397202, -122.479842920071) | |||
| 179277 | 179277 | 43774 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 101 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 7 | Permit Number 43404 | 5989570.39121 | 2114653.79168 | 37.785834471356104 | -122.479861610415 | (37.7858344713561, -122.479861610415) | |
| 62657 | 62657 | 65074 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 101 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1989 12:00:00 AM | 9 | Permit Number 27036 | 5989259.62499 | 2114639.29905 | 37.7857766193958 | -122.480935700826 | (37.7857766193958, -122.480935700826) | |
| 130799 | 130799 | 120780 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5989259.72068 | 2114624.2077099998 | 37.7857351884005 | -122.48093426443998 | (37.7857351884005, -122.48093426444) | |||
| 157105 | 157105 | 120781 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5989260.945069999 | 2114593.7963 | 37.78565175842729 | -122.480927801043 | (37.7856517584273, -122.480927801043) | |||
| 125259 | 125259 | 61961 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 101 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51629 | 6003797.06082137 | 2108782.38494948 | 37.7705292896917 | -122.4302222862 | (37.7705292896917, -122.4302222862) | ||
| 97983 | 97983 | 113876 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 HUGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 140945 | 140945 | 113875 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 HUGO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 32314 | 32314 | 124326 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5996190.9436800005 | 2113761.49313 | 37.7837668634728 | -122.456891927538 | (37.7837668634728, -122.456891927538) | |||
| 182214 | 182214 | 36183 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 101 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 10 | Permit Number 39252 | 5996190.43607 | 2113774.02215 | 37.7838012356732 | -122.45689459016701 | (37.7838012356732, -122.456894590167) | |
| 185582 | 185582 | 124325 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Jordan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5996191.69169 | 2113748.1926700003 | 37.7837303869078 | -122.456888377409 | (37.7837303869078, -122.456888377409) | |||
| 37070 | 37070 | 132603 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Laurel St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997981.421080001 | 2116053.00353 | 37.790161395977 | -122.450862862428 | (37.790161395977, -122.450862862428) | |||
| 160682 | 160682 | 74868 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 6 | 5997976.38081 | 2116093.74449 | 37.7902729712773 | -122.450883240175 | (37.7902729712773, -122.450883240175) | ||
| 168901 | 168901 | 74567 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Laurel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 6 | 5997978.88772 | 2116072.74607 | 37.7902154587146 | -122.450873051754 | (37.7902154587146, -122.450873051754) | ||
| 175075 | 175075 | 132604 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Laurel St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997984.44466 | 2116036.60243 | 37.7901165360059 | -122.45085121803601 | (37.7901165360059, -122.450851218036) | |||
| 180100 | 180100 | 74720 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 5 | 5997978.29115 | 2116084.4881700003 | 37.790247665245296 | -122.450875962856 | (37.7902476652453, -122.450875962856) | ||
| 137130 | 137130 | 211811 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Los Palmos Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998427.90019 | 2096008.55855 | 37.735149937424204 | -122.44787439011299 | (37.7351499374242, -122.447874390113) | |||
| 56059 | 56059 | 137733 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000662.3069 | 2112624.2642 | 37.7809000665618 | -122.441341105044 | (37.7809000665618, -122.441341105044) | |||
| 62004 | 62004 | 137734 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 101 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000664.6758 | 2112602.6052 | 37.780840731432 | -122.441331355327 | (37.780840731432, -122.441331355327) | |||
| 72843 | 72843 | 141824 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1010 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004706.9953 | 2112293.1631 | 37.780220525245205 | -122.42732494386699 | (37.7802205252452, -122.427324943867) | |||
| 109415 | 109415 | 9510 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1010 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004720.82938 | 2112291.0362 | 37.780215467679895 | -122.42727693386298 | (37.7802154676799, -122.427276933863) | |||
| 50871 | 50871 | 200017 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1011 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018377.4011 | 2092259.3357 | 37.7259753973207 | -122.37864074577601 | (37.7259753973207, -122.378640745776) | |||
| 131763 | 131763 | 142096 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1013 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003019.2266 | 2110623.1721 | 37.775539549678896 | -122.43304435676501 | (37.7755395496789, -122.433044356765) | |||
| 44491 | 44491 | 235165 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1014 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001904.70664 | 2101086.8276 | 37.749291791004204 | -122.43621713584 | (37.7492917910042, -122.43621713584) | |||
| 134614 | 134614 | 141825 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1014 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004675.3229 | 2112289.8540000003 | 37.7802096479891 | -122.42743427748002 | (37.7802096479891, -122.42743427748) | |||
| 144997 | 144997 | 9511 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1014 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6004702.17435 | 2112293.48025 | 37.780221123410705 | -122.427341644353 | (37.7802211234107, -122.427341644353) | |||
| 89904 | 89904 | 56995 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1014-1016 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 6x8 | Permit Number 14252 1014-1016 Diamond St | 6001906.09503782 | 2101135.53181665 | 37.7494256001017 | -122.43621581973801 | (37.7494256001017, -122.436215819738) | ||
| 116744 | 116744 | 99763 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1014-1016 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x8 | 1014-1016 Diamond St | 6001909.0 | 2101139.0 | 37.749435287958 | -122.436206022483 | (37.749435287958, -122.436206022483) | ||
| 19188 | 19188 | 10164 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1015 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1990 12:00:00 AM | 12 | 2x2 | 6005761.80004 | 2102937.9632900003 | 37.754592973400605 | -122.42301076784099 | (37.7545929734006, -122.423010767841) | ||
| 146022 | 146022 | 91936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1015 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992649.184657 | 2106593.110978 | 37.7638804015817 | -122.468623221089 | (37.7638804015817, -122.468623221089) | ||
| 75282 | 75282 | 200016 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1015 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018332.7975 | 2092292.5025 | 37.7260640079993 | -122.37879724133002 | (37.7260640079993, -122.37879724133) | |||
| 179198 | 179198 | 235164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1016 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001904.73341 | 2101070.4750599996 | 37.7492468923326 | -122.436215873174 | (37.7492468923326, -122.436215873174) | |||
| 62520 | 62520 | 200020 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1018 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018197.6822 | 2092123.3004 | 37.7255919615614 | -122.379252584385 | (37.7255919615614, -122.379252584385) | |||
| 74829 | 74829 | 141922 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1019 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004717.0734 | 2112242.8308 | 37.7800828951325 | -122.427286492697 | (37.7800828951325, -122.427286492697) | |||
| 5498 | 5498 | 9513 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1019 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004741.0809 | 2112246.9075 | 37.7800954464336 | -122.427203730317 | (37.7800954464336, -122.427203730317) | |||
| 84756 | 84756 | 9512 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1019 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004547.3886400005 | 2112200.85072 | 37.7799580304074 | -122.42787051712901 | (37.7799580304074, -122.427870517129) | |||
| 119110 | 119110 | 42848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1019 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42778 | 6008079.19651 | 2119244.7716 | 37.7994980783306 | -122.41615138680099 | (37.7994980783306, -122.416151386801) | |
| 147488 | 147488 | 141096 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Cook St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997580.9764 | 2112935.9507 | 37.781579862224206 | -122.452023379854 | (37.7815798622242, -122.452023379854) | |||
| 43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
| 53370 | 53370 | 249773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.80487103114871 | -122.40814255972602 | (37.8048710311487, -122.408142559726) | |||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 21594 | 21594 | 4398 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1020 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2003 12:00:00 AM | 6 | 3X3 | 6004373.52059 | 2102912.04366 | 37.754443367585104 | -122.427809962175 | (37.7544433675851, -122.427809962175) | ||
| 18630 | 18630 | 26686 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1020 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1998 12:00:00 AM | 18 | 3X3 | 6008529.14906 | 2097203.56662 | 37.739003365110705 | -122.413035066831 | (37.7390033651107, -122.413035066831) | ||
| 118044 | 118044 | 81849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1020 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | Permit Number 768979 | 6006831.40900854 | 2114324.3112485 | 37.785917479950704 | -122.420119796129 | (37.7859174799507, -122.420119796129) | ||
| 21897 | 21897 | 25613 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1021 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1997 12:00:00 AM | 3 | 3X3 | 6008526.98955 | 2097259.53858 | 37.7391569306435 | -122.41304649002 | (37.7391569306435, -122.41304649002) | ||
| 163304 | 163304 | 245082 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1026 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001617.2651 | 2109431.9701 | 37.7721891838477 | -122.43780873456998 | (37.7721891838477, -122.43780873457) | |||
| 51705 | 51705 | 103503 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1028 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009840.22204 | 2116824.48974 | 37.7929514356157 | -122.40988664105801 | (37.7929514356157, -122.409886641058) | |||
| 88525 | 88525 | 103459 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1028 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2013 12:00:00 AM | 3x3 | Permit Number 770176 | 6009851.0 | 2116823.0 | 37.7929479491773 | -122.40984924338699 | (37.7929479491773, -122.409849243387) | ||
| 67174 | 67174 | 141920 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1029 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004659.092999999 | 2112234.6773 | 37.7800572284455 | -122.427486492199 | (37.7800572284455, -122.427486492199) | |||
| 162293 | 162293 | 141921 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1029 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004684.9124 | 2112239.207 | 37.7800711261894 | -122.427397493977 | (37.7800711261894, -122.427397493977) | |||
| 83378 | 83378 | 9515 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1029 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004645.98735 | 2112245.24744 | 37.780085510179 | -122.427532583836 | (37.780085510179, -122.427532583836) | |||
| 112895 | 112895 | 9516 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1029 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004667.91129 | 2112234.54275 | 37.780057357761 | -122.427455976152 | (37.780057357761, -122.427455976152) | |||
| 144137 | 144137 | 43768 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 43403 | 5989878.8194806995 | 2114684.1730723 | 37.7859358038532 | -122.478796769381 | (37.7859358038532, -122.478796769381) | ||
| 154761 | 154761 | 43772 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43403 | 5989881.82186 | 2114599.7806599997 | 37.785704260345895 | -122.478780207672 | (37.7857042603459, -122.478780207672) | |
| 159959 | 159959 | 43773 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 6 | Permit Number 43403 | 5989881.38316 | 2114589.5828400003 | 37.785676234525205 | -122.47878097932899 | (37.7856762345252, -122.478780979329) | |
| 174431 | 174431 | 43770 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 7 | Permit Number 43403 | 5989880.83254 | 2114637.30143 | 37.785807224389295 | -122.478786375537 | (37.7858072243893, -122.478786375537) | |
| 180975 | 180975 | 43771 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 7 | Permit Number 43403 | 5989881.17945 | 2114611.55453 | 37.785736550782396 | -122.478783291615 | (37.7857365507824, -122.478783291615) | |
| 181700 | 181700 | 43769 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 103 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/2007 12:00:00 AM | 6 | Permit No. 49274 | 5989879.0887 | 2114672.63696 | 37.785904144564704 | -122.47879499394199 | (37.7859041445647, -122.478794993942) | |
| 181238 | 181238 | 235088 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 103 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007969.6144 | 2098093.58768 | 37.7414157407577 | -122.415032666124 | (37.7414157407577, -122.415032666124) | |||
| 73241 | 73241 | 236117 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 103 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003342.25441 | 2108624.99064 | 37.7700713526377 | -122.43178422457198 | (37.7700713526377, -122.431784224572) | |||
| 22537 | 22537 | 7873 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1030 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2000 12:00:00 AM | 8 | 4X4 | 6006079.80081 | 2113710.82064 | 37.7841906089474 | -122.42267654468999 | (37.7841906089474, -122.42267654469) | ||
| 22768 | 22768 | 7874 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1030 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2010 12:00:00 AM | 3 | 4X4 | 6006075.11435 | 2113745.00842 | 37.784284215775706 | -122.42269518854201 | (37.7842842157757, -122.422695188542) | ||
| 99335 | 99335 | 49547 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1030 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | Permit Number 46438 | 6006083.51623948 | 2113685.45839394 | 37.7841211800765 | -122.422661887685 | (37.7841211800765, -122.422661887685) | |||
| 131933 | 131933 | 71448 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1030 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 6011614.732559999 | 2118874.74994 | 37.7986802465545 | -122.40389104892901 | (37.7986802465545, -122.403891048929) | ||
| 75702 | 75702 | 199986 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1036 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018125.6646 | 2092187.1055 | 37.7257631863869 | -122.37950597633899 | (37.7257631863869, -122.379505976339) | |||
| 108879 | 108879 | 108535 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1036X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009831.243980001 | 2112235.16984 | 37.780349758914795 | -122.40959364419399 | (37.7803497589148, -122.409593644194) | ||||
| 17366 | 17366 | 5573 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1037 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2004 12:00:00 AM | 6 | 3x3 | 6005143.66198 | 2102304.68345 | 37.7528192342456 | -122.425103398502 | (37.7528192342456, -122.425103398502) | ||
| 50361 | 50361 | 141919 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1039 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004618.3256 | 2112228.7886 | 37.7800387536502 | -122.42762710542601 | (37.7800387536502, -122.427627105426) | |||
| 7327 | 7327 | 9518 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1039 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004639.6152 | 2112232.8654 | 37.780051151736295 | -122.427553745606 | (37.7800511517363, -122.427553745606) | |||
| 121057 | 121057 | 9517 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1039 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004601.71952 | 2112239.06676 | 37.7800660356205 | -122.427685285871 | (37.7800660356205, -122.427685285871) | |||
| 151756 | 151756 | 234252 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 104 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008654.73875 | 2098016.48348 | 37.7412425061395 | -122.412658285955 | (37.7412425061395, -122.412658285955) | |||
| 138111 | 138111 | 141097 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 104 Cook St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997586.3911 | 2112917.3375 | 37.78152906541371 | -122.45200330437599 | (37.7815290654137, -122.452003304376) | |||
| 20103 | 20103 | 26473 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 104 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2011 12:00:00 AM | 1 | 3x3 | 6001353.2668 | 2098903.24503 | 37.7432648448922 | -122.437967635622 | (37.7432648448922, -122.437967635622) | ||
| 41899 | 41899 | 234030 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 104 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005393.24175 | 2108339.32766 | 37.769403039450204 | -122.42466955566601 | (37.7694030394502, -122.424669555666) | |||
| 137008 | 137008 | 140860 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 104 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996245.3947 | 2113739.5333 | 37.7837096941931 | -122.456701959932 | (37.7837096941931, -122.456701959932) | |||
| 66101 | 66101 | 34931 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 104 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 9 | Permit Number 38523 | 5995929.73689 | 2113710.75193 | 37.7836125390865 | -122.45779192626301 | (37.7836125390865, -122.457791926263) | ||
| 102744 | 102744 | 107234 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1040 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008492.6 | 2115612.4 | 37.7895477163001 | -122.414463692291 | (37.7895477163001, -122.414463692291) | |||
| 52272 | 52272 | 35712 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1040 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | 12 | Permit Number 46007 | 6008511.4116 | 2115600.01808 | 37.7895147753372 | -122.41439772947201 | (37.7895147753372, -122.414397729472) | |
| 49143 | 49143 | 236140 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1044 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002473.38513 | 2102461.32359 | 37.753098124790505 | -122.43434889320801 | (37.7530981247905, -122.434348893208) | |||
| 116297 | 116297 | 108705 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1044 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774628 | 6002474.51663 | 2102543.7681400003 | 37.7533245621187 | -122.43435087414801 | (37.7533245621187, -122.434350874148) | |
| 59817 | 59817 | 66639 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1047 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 8 | Permit Number 29850 | 6008486.6473199995 | 2115539.47023 | 37.7893471345134 | -122.414479125336 | (37.7893471345134, -122.414479125336) | |
| 26880 | 26880 | 45750 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1047 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 4 | Permit Number 44397 | 6014253.80968 | 2102241.0378400004 | 37.7531548998939 | -122.393594137083 | (37.7531548998939, -122.393594137083) | ||
| 91564 | 91564 | 87926 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1047 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50947 | 6014255.0 | 2102190.0 | 37.753014827027705 | -122.393586448918 | (37.7530148270277, -122.393586448918) | ||
| 157368 | 157368 | 45751 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1047 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 1 | 3x3 | Permit Number 44397 | 6014255.13206 | 2102261.71478 | 37.7532117478325 | -122.39359101102801 | (37.7532117478325, -122.393591011028) | |
| 21565 | 21565 | 25614 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1049 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1997 12:00:00 AM | 3 | 3X3 | 6008552.94277 | 2097277.47143 | 37.7392076272162 | -122.412958022793 | (37.7392076272162, -122.412958022793) | ||
| 70005 | 70005 | 199984 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1049 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018239.0156 | 2092359.9798 | 37.7262441168546 | -122.37912612762501 | (37.7262441168546, -122.379126127625) | |||
| 75637 | 75637 | 235107 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 105 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006680.76731 | 2099005.14374 | 37.7438461585902 | -122.41955371902701 | (37.7438461585902, -122.419553719027) | |||
| 177325 | 177325 | 139630 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1050 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000910.7931 | 2112335.8442 | 37.7801222909699 | -122.44046077971599 | (37.7801222909699, -122.440460779716) | |||
| 153766 | 153766 | 141828 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1050 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004502.7789 | 2112265.7452 | 37.780133690888796 | -122.428029467957 | (37.7801336908888, -122.428029467957) | |||
| 19465 | 19465 | 9521 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1050 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004547.486409999 | 2112287.0280400002 | 37.780194657565 | -122.427876321238 | (37.780194657565, -122.427876321238) | |||
| 86759 | 86759 | 6087 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1050X Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | |||
| 94830 | 94830 | 6085 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1050X Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | |||
| 109748 | 109748 | 6086 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1050X Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | |||
| 33667 | 33667 | 37508 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1055 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39967 | 6008450.33204 | 2115534.6033 | 37.789331730921205 | -122.414604427856 | (37.7893317309212, -122.414604427856) | ||
| 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) | |||
| 151238 | 151238 | 122970 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 106 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993368.1329 | 2114750.9068 | 37.7863210259 | -122.466729656683 | (37.7863210259, -122.466729656683) | |||
| 157089 | 157089 | 59629 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 106 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1981 12:00:00 AM | 12 | Permit Number 19037 | 5993368.72663 | 2114731.40885 | 37.786267524134395 | -122.466726184696 | (37.7862675241344, -122.466726184696) | ||
| 167642 | 167642 | 122969 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 106 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993365.06329 | 2114771.9559299997 | 37.786378643894 | -122.466741807319 | (37.786378643894, -122.466741807319) |
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");