trees
7,157 rows where qSpecies_id = 36 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61602 | 206088 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1005 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992631.31797 | 2106583.46011 | 37.7638528707289 | -122.468684313748 | (37.7638528707289, -122.468684313748) | 1 | 8 | 11 | 56 | 12 | |||
85086 | 91937 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1005 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992678.903537 | 2106594.128971 | 37.7638849134436 | -122.46852050742 | (37.7638849134436, -122.46852050742) | 1 | 8 | 11 | 56 | 12 | ||
131437 | 65090 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 100X 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 10 | 6x6 | Permit Number 27055 | 5995195 | 2114938 | 37.7869399943714 | -122.460422770698 | (37.7869399943714, -122.460422770698) | 11 | 6 | 1 | 54 | 11 |
175087 | 90440 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
45028 | 43774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 7 | Permit Number 43404 | 5989570.39121 | 2114653.79168 | 37.7858344713561 | -122.479861610415 | (37.7858344713561, -122.479861610415) | 11 | 6 | 2 | 55 | 26 | |
46072 | 120822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5989570.90273 | 2114637.64231 | 37.7857901594541 | -122.479858658538 | (37.7857901594541, -122.479858658538) | 11 | 6 | 2 | 55 | 26 | |||
171243 | 120818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 20th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5989573.97075 | 2114567.64315 | 37.7855981397202 | -122.479842920071 | (37.7855981397202, -122.479842920071) | 11 | 6 | 2 | 55 | 26 | |||
926 | 120780 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989259.72068 | 2114624.20771 | 37.7857351884005 | -122.48093426444 | (37.7857351884005, -122.48093426444) | 11 | 6 | 2 | 55 | 26 | |||
47103 | 65074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1989 12:00:00 AM | 9 | Permit Number 27036 | 5989259.62499 | 2114639.29905 | 37.7857766193958 | -122.480935700826 | (37.7857766193958, -122.480935700826) | 11 | 6 | 2 | 55 | 26 | |
86773 | 120781 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5989260.94507 | 2114593.7963 | 37.7856517584273 | -122.480927801043 | (37.7856517584273, -122.480927801043) | 11 | 6 | 2 | 55 | 26 | |||
22394 | 61961 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 101 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51629 | 6003797.06082137 | 2108782.38494948 | 37.7705292896917 | -122.4302222862 | (37.7705292896917, -122.4302222862) | 15 | 9 | 11 | 29492 | 10 | ||
103035 | 113876 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 101 HUGO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
182315 | 113875 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 101 HUGO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
17938 | 124326 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5996190.94368 | 2113761.49313 | 37.7837668634728 | -122.456891927538 | (37.7837668634728, -122.456891927538) | 11 | 6 | 1 | 54 | 31 | |||
156853 | 124325 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Jordan Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5996191.69169 | 2113748.19267 | 37.7837303869078 | -122.456888377409 | (37.7837303869078, -122.456888377409) | 11 | 6 | 1 | 54 | 31 | |||
162572 | 36183 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 10 | Permit Number 39252 | 5996190.43607 | 2113774.02215 | 37.7838012356732 | -122.456894590167 | (37.7838012356732, -122.456894590167) | 11 | 6 | 1 | 54 | 31 | |
3386 | 74868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997976.38081 | 2116093.74449 | 37.7902729712773 | -122.450883240175 | (37.7902729712773, -122.450883240175) | 11 | 6 | 1 | 54 | 31 | |||
6403 | 74567 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997978.88772 | 2116072.74607 | 37.7902154587146 | -122.450873051754 | (37.7902154587146, -122.450873051754) | 11 | 6 | 1 | 54 | 31 | |||
7241 | 74720 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997978.29115 | 2116084.48817 | 37.7902476652453 | -122.450875962856 | (37.7902476652453, -122.450875962856) | 11 | 6 | 1 | 54 | 31 | |||
125908 | 132604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997984.44466 | 2116036.60243 | 37.7901165360059 | -122.450851218036 | (37.7901165360059, -122.450851218036) | 11 | 6 | 1 | 54 | 31 | |||
166880 | 132603 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997981.42108 | 2116053.00353 | 37.790161395977 | -122.450862862428 | (37.790161395977, -122.450862862428) | 11 | 6 | 1 | 54 | 31 | |||
110337 | 211811 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Los Palmos Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998427.90019 | 2096008.55855 | 37.7351499374242 | -122.447874390113 | (37.7351499374242, -122.447874390113) | 9 | 7 | 4 | 59 | 40 | |||
164445 | 137734 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000664.6758 | 2112602.6052 | 37.780840731432 | -122.441331355327 | (37.780840731432, -122.441331355327) | 15 | 5 | 1 | 29490 | 16 | |||
74961 | 141824 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1010 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004706.9953 | 2112293.1631 | 37.7802205252452 | -122.427324943867 | (37.7802205252452, -122.427324943867) | 7 | 9 | 11 | 29490 | 41 | |||
120710 | 9510 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1010 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004720.82938 | 2112291.0362 | 37.7802154676799 | -122.427276933863 | (37.7802154676799, -122.427276933863) | 7 | 9 | 11 | 29490 | 41 | |||
26296 | 200017 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1011 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6018377.4011 | 2092259.3357 | 37.7259753973207 | -122.378640745776 | (37.7259753973207, -122.378640745776) | 10 | 3 | 8 | 58 | 1 | |||
193155 | 142096 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1013 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003019.2266 | 2110623.1721 | 37.7755395496789 | -122.433044356765 | (37.7755395496789, -122.433044356765) | 15 | 5 | 11 | 29492 | 10 | |||
186949 | 235165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1014 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001904.70664 | 2101086.8276 | 37.7492917910042 | -122.43621713584 | (37.7492917910042, -122.43621713584) | 2 | 4 | 5 | 28862 | 22 | |||
61762 | 141825 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1014 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004675.3229 | 2112289.854 | 37.7802096479891 | -122.42743427748 | (37.7802096479891, -122.42743427748) | 7 | 9 | 11 | 29490 | 41 | |||
190867 | 9511 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1014 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6004702.17435 | 2112293.48025 | 37.7802211234107 | -122.427341644353 | (37.7802211234107, -122.427341644353) | 7 | 9 | 11 | 29490 | 41 | |||
71683 | 56995 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1014-1016 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 6x8 | Permit Number 14252 1014-1016 Diamond St | 6001906.09503782 | 2101135.53181665 | 37.7494256001017 | -122.436215819738 | (37.7494256001017, -122.436215819738) | 2 | 4 | 5 | 28862 | 22 | ||
158246 | 99763 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1014-1016 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x8 | 1014-1016 Diamond St | 6001909 | 2101139 | 37.749435287958 | -122.436206022483 | (37.749435287958, -122.436206022483) | 2 | 4 | 5 | 28862 | 22 | ||
153272 | 10164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1015 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1990 12:00:00 AM | 12 | 2x2 | 6005761.80004 | 2102937.96329 | 37.7545929734006 | -122.423010767841 | (37.7545929734006, -122.423010767841) | 2 | 4 | 5 | 28859 | 19 | ||
191166 | 91936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1015 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992649.184657 | 2106593.110978 | 37.7638804015817 | -122.468623221089 | (37.7638804015817, -122.468623221089) | 1 | 8 | 11 | 56 | 12 | ||
147273 | 200016 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1015 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6018332.7975 | 2092292.5025 | 37.7260640079993 | -122.37879724133 | (37.7260640079993, -122.37879724133) | 10 | 3 | 8 | 58 | 1 | |||
79001 | 235164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1016 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001904.73341 | 2101070.47506 | 37.7492468923326 | -122.436215873174 | (37.7492468923326, -122.436215873174) | 2 | 4 | 5 | 28862 | 22 | |||
65456 | 200020 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1018 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018197.6822 | 2092123.3004 | 37.7255919615614 | -122.379252584385 | (37.7255919615614, -122.379252584385) | 10 | 3 | 8 | 58 | 1 | |||
175820 | 141922 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1019 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004717.0734 | 2112242.8308 | 37.7800828951325 | -122.427286492697 | (37.7800828951325, -122.427286492697) | 7 | 9 | 11 | 29490 | 41 | |||
71224 | 9512 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1019 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004547.38864 | 2112200.85072 | 37.7799580304074 | -122.427870517129 | (37.7799580304074, -122.427870517129) | 7 | 9 | 11 | 29490 | 41 | |||
160360 | 9513 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1019 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004741.0809 | 2112246.9075 | 37.7800954464336 | -122.427203730317 | (37.7800954464336, -122.427203730317) | 7 | 9 | 11 | 29490 | 41 | |||
154846 | 42848 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1019 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 7 | Permit Number 42778 | 6008079.19651 | 2119244.7716 | 37.7994980783306 | -122.416151386801 | (37.7994980783306, -122.416151386801) | 5 | 1 | 10 | 308 | 32 | |
183429 | 141096 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Cook St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997580.9764 | 2112935.9507 | 37.7815798622242 | -122.452023379854 | (37.7815798622242, -122.452023379854) | 15 | 6 | 2 | 54 | 16 | |||
97772 | 249771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 2 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | 3 | 1 | 10 | 308 | 23 | |||
136364 | 249772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.408121373518 | (37.8049001107042, -122.408121373518) | 3 | 1 | 10 | 308 | 23 | |||
192800 | 249773 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.8048710311487 | -122.408142559726 | (37.8048710311487, -122.408142559726) | 3 | 1 | 10 | 308 | 23 | |||
13762 | 4398 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1020 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1997 12:00:00 AM | 6 | 3X3 | 6004373.52059 | 2102912.04366 | 37.7544433675851 | -122.427809962175 | (37.7544433675851, -122.427809962175) | 2 | 4 | 5 | 28862 | 22 | ||
92602 | 26686 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1020 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1998 12:00:00 AM | 18 | 3X3 | 6008529.14906 | 2097203.56662 | 37.7390033651107 | -122.413035066831 | (37.7390033651107, -122.413035066831) | 10 | 7 | 7 | 28859 | 2 | ||
165503 | 81849 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1020 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2012 12:00:00 AM | Permit Number 768979 | 6006831.40900854 | 2114324.3112485 | 37.7859174799507 | -122.420119796129 | (37.7859174799507, -122.420119796129) | 13 | 9 | 9 | 28858 | 36 | ||
111259 | 25613 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1021 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1997 12:00:00 AM | 3 | 3X3 | 6008526.98955 | 2097259.53858 | 37.7391569306435 | -122.41304649002 | (37.7391569306435, -122.41304649002) | 10 | 7 | 7 | 28859 | 2 | ||
108323 | 245082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1026 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001617.2651 | 2109431.9701 | 37.7721891838477 | -122.43780873457 | (37.7721891838477, -122.43780873457) | 15 | 5 | 11 | 29492 | 9 | |||
24675 | 103503 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1028 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009840.22204 | 2116824.48974 | 37.7929514356157 | -122.409886641058 | (37.7929514356157, -122.409886641058) | 3 | 1 | 10 | 28857 | 21 | |||
61146 | 103459 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1028 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 3x3 | Permit Number 770176 | 6009851 | 2116823 | 37.7929479491773 | -122.409849243387 | (37.7929479491773, -122.409849243387) | 3 | 1 | 10 | 28857 | 21 | ||
84499 | 141921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1029 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004684.9124 | 2112239.207 | 37.7800711261894 | -122.427397493977 | (37.7800711261894, -122.427397493977) | 7 | 9 | 11 | 29490 | 41 | |||
141215 | 141920 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1029 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004659.093 | 2112234.6773 | 37.7800572284455 | -122.427486492199 | (37.7800572284455, -122.427486492199) | 7 | 9 | 11 | 29490 | 41 | |||
44703 | 9515 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1029 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004645.98735 | 2112245.24744 | 37.780085510179 | -122.427532583836 | (37.780085510179, -122.427532583836) | 7 | 9 | 11 | 29490 | 41 | |||
142963 | 9516 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1029 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004667.91129 | 2112234.54275 | 37.780057357761 | -122.427455976152 | (37.780057357761, -122.427455976152) | 7 | 9 | 11 | 29490 | 41 | |||
29871 | 43770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 7 | Permit Number 43403 | 5989880.83254 | 2114637.30143 | 37.7858072243893 | -122.478786375537 | (37.7858072243893, -122.478786375537) | 11 | 6 | 2 | 55 | 26 | |
42935 | 43769 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/2007 12:00:00 AM | 6 | Permit No. 49274 | 5989879.0887 | 2114672.63696 | 37.7859041445647 | -122.478794993942 | (37.7859041445647, -122.478794993942) | 11 | 6 | 2 | 55 | 26 | |
82940 | 43773 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 6 | Permit Number 43403 | 5989881.38316 | 2114589.58284 | 37.7856762345252 | -122.478780979329 | (37.7856762345252, -122.478780979329) | 11 | 6 | 2 | 55 | 26 | |
154367 | 43771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 7 | Permit Number 43403 | 5989881.17945 | 2114611.55453 | 37.7857365507824 | -122.478783291615 | (37.7857365507824, -122.478783291615) | 11 | 6 | 2 | 55 | 26 | |
181168 | 43768 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | Permit Number 43403 | 5989878.8194807 | 2114684.1730723 | 37.7859358038532 | -122.478796769381 | (37.7859358038532, -122.478796769381) | 11 | 6 | 2 | 55 | 26 | ||
182110 | 43772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43403 | 5989881.82186 | 2114599.78066 | 37.7857042603459 | -122.478780207672 | (37.7857042603459, -122.478780207672) | 11 | 6 | 2 | 55 | 26 | |
59652 | 235088 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007969.6144 | 2098093.58768 | 37.7414157407577 | -122.415032666124 | (37.7414157407577, -122.415032666124) | 2 | 7 | 7 | 28859 | 2 | |||
194110 | 236117 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003342.25441 | 2108624.99064 | 37.7700713526377 | -122.431784224572 | (37.7700713526377, -122.431784224572) | 15 | 9 | 5 | 29492 | 9 | |||
45864 | 7873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1030 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2000 12:00:00 AM | 8 | 4X4 | 6006079.80081 | 2113710.82064 | 37.7841906089474 | -122.42267654469 | (37.7841906089474, -122.42267654469) | 7 | 9 | 11 | 28858 | 41 | ||
98481 | 49547 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1030 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2003 12:00:00 AM | Permit Number 46438 | 6006083.51623948 | 2113685.45839394 | 37.7841211800765 | -122.422661887685 | (37.7841211800765, -122.422661887685) | 7 | 9 | 11 | 28858 | 41 | |||
172113 | 7874 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1030 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2010 12:00:00 AM | 3 | 4X4 | 6006075.11435 | 2113745.00842 | 37.7842842157757 | -122.422695188542 | (37.7842842157757, -122.422695188542) | 7 | 9 | 11 | 28858 | 41 | ||
13807 | 71448 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1030 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011614.73256 | 2118874.74994 | 37.7986802465545 | -122.403891048929 | (37.7986802465545, -122.403891048929) | 3 | 1 | 10 | 308 | 23 | |||
137945 | 199986 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1036 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018125.6646 | 2092187.1055 | 37.7257631863869 | -122.379505976339 | (37.7257631863869, -122.379505976339) | 10 | 3 | 8 | 58 | 1 | |||
126621 | 108535 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1036X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009831.24398 | 2112235.16984 | 37.7803497589148 | -122.409593644194 | (37.7803497589148, -122.409593644194) | 14 | 2 | 9 | 28853 | 34 | ||||
31635 | 5573 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1037 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2004 12:00:00 AM | 6 | 3x3 | 6005143.66198 | 2102304.68345 | 37.7528192342456 | -122.425103398502 | (37.7528192342456, -122.425103398502) | 2 | 4 | 5 | 28859 | 19 | ||
46017 | 141919 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1039 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004618.3256 | 2112228.7886 | 37.7800387536502 | -122.427627105426 | (37.7800387536502, -122.427627105426) | 7 | 9 | 11 | 29490 | 41 | |||
153212 | 9517 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1039 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004601.71952 | 2112239.06676 | 37.7800660356205 | -122.427685285871 | (37.7800660356205, -122.427685285871) | 7 | 9 | 11 | 29490 | 41 | |||
177294 | 9518 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1039 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004639.6152 | 2112232.8654 | 37.7800511517363 | -122.427553745606 | (37.7800511517363, -122.427553745606) | 7 | 9 | 11 | 29490 | 41 | |||
89455 | 234252 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008654.73875 | 2098016.48348 | 37.7412425061395 | -122.412658285955 | (37.7412425061395, -122.412658285955) | 10 | 7 | 7 | 28859 | 2 | |||
165741 | 141097 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997586.3911 | 2112917.3375 | 37.7815290654137 | -122.452003304376 | (37.7815290654137, -122.452003304376) | 15 | 6 | 2 | 54 | 16 | |||
51929 | 26473 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2011 12:00:00 AM | 1 | 3x3 | 6001353.2668 | 2098903.24503 | 37.7432648448922 | -122.437967635622 | (37.7432648448922, -122.437967635622) | 2 | 7 | 5 | 63 | 7 | ||
168280 | 234030 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Guerrero St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6005393.24175 | 2108339.32766 | 37.7694030394502 | -122.424669555666 | (37.7694030394502, -122.424669555666) | 8 | 4 | 5 | 28853 | 19 | |||
30728 | 140860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996245.3947 | 2113739.5333 | 37.7837096941931 | -122.456701959932 | (37.7837096941931, -122.456701959932) | 11 | 6 | 1 | 54 | 31 | |||
124268 | 34931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 104 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 9 | Permit Number 38523 | 5995929.73689 | 2113710.75193 | 37.7836125390865 | -122.457791926263 | (37.7836125390865, -122.457791926263) | 11 | 6 | 1 | 54 | 31 | ||
107623 | 107234 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1040 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008492.6 | 2115612.4 | 37.7895477163001 | -122.414463692291 | (37.7895477163001, -122.414463692291) | 5 | 1 | 10 | 28858 | 21 | |||
123106 | 35712 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1040 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 12 | Permit Number 46007 | 6008511.4116 | 2115600.01808 | 37.7895147753372 | -122.414397729472 | (37.7895147753372, -122.414397729472) | 5 | 1 | 10 | 28858 | 21 | |
57920 | 236140 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1044 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002473.38513 | 2102461.32359 | 37.7530981247905 | -122.434348893208 | (37.7530981247905, -122.434348893208) | 2 | 4 | 5 | 28862 | 22 | |||
147770 | 108705 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1044 Castro St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774628 | 6002474.51663 | 2102543.76814 | 37.7533245621187 | -122.434350874148 | (37.7533245621187, -122.434350874148) | 2 | 4 | 5 | 28862 | 22 | |
3131 | 66639 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1047 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1991 12:00:00 AM | 8 | Permit Number 29850 | 6008486.64732 | 2115539.47023 | 37.7893471345134 | -122.414479125336 | (37.7893471345134, -122.414479125336) | 5 | 1 | 10 | 28858 | 21 | |
87994 | 87926 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1047 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50947 | 6014255 | 2102190 | 37.7530148270277 | -122.393586448918 | (37.7530148270277, -122.393586448918) | 10 | 3 | 8 | 28856 | 29 | ||
107331 | 45750 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1047 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 4 | Permit Number 44397 | 6014253.80968 | 2102241.03784 | 37.7531548998939 | -122.393594137083 | (37.7531548998939, -122.393594137083) | 10 | 3 | 8 | 28856 | 29 | ||
147615 | 45751 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1047 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 1 | 3x3 | Permit Number 44397 | 6014255.13206 | 2102261.71478 | 37.7532117478325 | -122.393591011028 | (37.7532117478325, -122.393591011028) | 10 | 3 | 8 | 28856 | 29 | |
191817 | 25614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1049 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1997 12:00:00 AM | 3 | 3X3 | 6008552.94277 | 2097277.47143 | 37.7392076272162 | -122.412958022793 | (37.7392076272162, -122.412958022793) | 10 | 7 | 7 | 28859 | 2 | ||
171184 | 199984 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1049 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6018239.0156 | 2092359.9798 | 37.7262441168546 | -122.379126127625 | (37.7262441168546, -122.379126127625) | 10 | 3 | 8 | 58 | 1 | |||
26425 | 235107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 105 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006680.76731 | 2099005.14374 | 37.7438461585902 | -122.419553719027 | (37.7438461585902, -122.419553719027) | 2 | 7 | 7 | 28859 | 2 | |||
16094 | 206192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 105 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | Width 3ft | 5991391.3951 | 2104508.95832 | 37.7580851326494 | -122.472821514428 | (37.7580851326494, -122.472821514428) | 1 | 8 | 4 | 56 | 12 | |||
152237 | 139630 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1050 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000910.7931 | 2112335.8442 | 37.7801222909699 | -122.440460779716 | (37.7801222909699, -122.440460779716) | 15 | 5 | 11 | 29490 | 41 | |||
98460 | 141828 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1050 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004502.7789 | 2112265.7452 | 37.7801336908888 | -122.428029467957 | (37.7801336908888, -122.428029467957) | 7 | 9 | 11 | 29490 | 41 | |||
15378 | 9521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1050 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004547.48641 | 2112287.02804 | 37.780194657565 | -122.427876321238 | (37.780194657565, -122.427876321238) | 7 | 9 | 11 | 29490 | 41 | |||
70039 | 6087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1050X Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | 15 | 5 | 11 | 29490 | 41 | |||
94489 | 6085 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1050X Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | 15 | 5 | 11 | 29490 | 41 | |||
124118 | 6086 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1050X Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000924.13119 | 2112263.90827 | 37.779925532694 | -122.440409476699 | (37.779925532694, -122.440409476699) | 15 | 5 | 11 | 29490 | 41 | |||
54247 | 37508 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1055 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39967 | 6008450.33204 | 2115534.6033 | 37.7893317309212 | -122.414604427856 | (37.7893317309212, -122.414604427856) | 5 | 1 | 10 | 28858 | 21 | ||
97964 | 141829 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1058 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6004468.2701 | 2112261.9634 | 37.7801213545811 | -122.428148580041 | (37.7801213545811, -122.428148580041) | 7 | 9 | 11 | 29490 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );