trees
207 rows where Supervisor Districts = 1 and qSpecies_id = 95 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77601 | 9924 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x3 | 6005199.42754 | 2116554.24063 | 37.7919482211773 | -122.425924797914 | (37.7919482211773, -122.425924797914) | 13 | 9 | 1 | 28858 | 27 | |||
99910 | 9923 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005200.36117 | 2116532.07759 | 37.791887419813 | -122.425919989211 | (37.791887419813, -122.425919989211) | 13 | 9 | 1 | 28858 | 27 | |||
25409 | 9921 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1950 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005216.73932 | 2116427.47967 | 37.7916011458249 | -122.425855872064 | (37.7916011458249, -122.425855872064) | 13 | 9 | 1 | 28858 | 27 | |||
92769 | 9919 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
67766 | 9918 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
12584 | 9912 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1850 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005256.71716 | 2116118.9463 | 37.7907562498626 | -122.425695579589 | (37.7907562498626, -122.425695579589) | 13 | 9 | 1 | 28858 | 27 | |||
158881 | 9911 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1850 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6005261.31756 | 2116094.86183 | 37.7906903799087 | -122.425677947496 | (37.7906903799087, -122.425677947496) | 13 | 9 | 1 | 28858 | 27 | |||
29243 | 9902 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6005282.34014 | 2115923.27251 | 37.7902204265742 | -122.425592993016 | (37.7902204265742, -122.425592993016) | 13 | 9 | 1 | 28858 | 27 | |||
151448 | 9901 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005290.73846 | 2115881.11756 | 37.7901051541858 | -122.42556093401 | (37.7901051541858, -122.42556093401) | 13 | 9 | 1 | 28858 | 27 | |||
95809 | 9888 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005355.48435 | 2115413.01457 | 37.7888235186322 | -122.425303593892 | (37.7888235186322, -122.425303593892) | 13 | 9 | 1 | 28858 | 41 | |||
163243 | 94977 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
82621 | 94976 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
110925 | 94974 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
34930 | 84726 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 20 Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | 27 | Permit No. 49296 | 5996103.83143 | 2115975.82593 | 37.7898418245875 | -122.457353550252 | (37.7898418245875, -122.457353550252) | 11 | 6 | 1 | 54 | 31 | ||
43358 | 7984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005624.48524 | 2117113.11255 | 37.7935067554767 | -122.424493864894 | (37.7935067554767, -122.424493864894) | 13 | 9 | 1 | 28858 | 27 | |||
133880 | 7983 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005599.00069 | 2117137.84326 | 37.7935732205869 | -122.424583803523 | (37.7935732205869, -122.424583803523) | 13 | 9 | 1 | 28858 | 27 | |||
104123 | 7982 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005602.68214 | 2117114.10003 | 37.7935082355629 | -122.424569375675 | (37.7935082355629, -122.424569375675) | 13 | 9 | 1 | 28858 | 27 | |||
30166 | 7981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005603.29363 | 2117103.29165 | 37.793478593006 | -122.424566490678 | (37.793478593006, -122.424566490678) | 13 | 9 | 1 | 28858 | 27 | |||
30170 | 7980 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005605.28232 | 2117078.33764 | 37.7934101878854 | -122.424557833777 | (37.7934101878854, -122.424557833777) | 13 | 9 | 1 | 28858 | 27 | |||
87887 | 7973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1955 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005592.81541 | 2116805.41322 | 37.7926601020218 | -122.42458154712 | (37.7926601020218, -122.42458154712) | 13 | 9 | 1 | 28858 | 27 | |||
61576 | 7964 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1845 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005641.9445 | 2116491.16052 | 37.7918000174095 | -122.424389196528 | (37.7918000174095, -122.424389196528) | 13 | 9 | 1 | 28858 | 27 | |||
122186 | 7958 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005719.63486 | 2116291.57932 | 37.7912564042045 | -122.424106187976 | (37.7912564042045, -122.424106187976) | 13 | 9 | 1 | 28858 | 27 | |||
88691 | 7956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1755 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005681.33133 | 2116176.18238 | 37.7909373903882 | -122.424230506628 | (37.7909373903882, -122.424230506628) | 13 | 9 | 1 | 28858 | 27 | |||
78067 | 68914 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1535 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32893 | 6005691.62707628 | 2118555.83678979 | 37.7974719031724 | -122.424364211095 | (37.7974719031724, -122.424364211095) | 13 | 9 | 1 | 57 | 17 | ||
96275 | 67696 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1802 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2002 12:00:00 AM | Permit Number 31305 | 6004401.173369 | 2118429.46678994 | 37.7970519696736 | -122.428820506832 | (37.7970519696736, -122.428820506832) | 13 | 9 | 1 | 57 | 17 | ||
22030 | 66798 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2727 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30077 | 6006105.82573514 | 2120126.22393826 | 37.8018071677784 | -122.423042648938 | (37.8018071677784, -122.423042648938) | 5 | 9 | 1 | 28858 | 32 | ||
54084 | 65542 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | Permit Number 28439 | 6002392.00985574 | 2114400.8403139 | 37.7858764773821 | -122.435484349614 | (37.7858764773821, -122.435484349614) | 13 | 6 | 1 | 29490 | 27 | ||
180393 | 63584 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1992 12:00:00 AM | Permit Number 24210 | 6006688.3941557 | 2119426.77030347 | 37.7999195019292 | -122.420976997553 | (37.7999195019292, -122.420976997553) | 5 | 9 | 1 | 28858 | 32 | ||
176146 | 58320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1978 12:00:00 AM | 5 | Permit Number 17345 | 5999940.39221 | 2115826.68261 | 37.7896519255343 | -122.44406872811 | (37.7896519255343, -122.44406872811) | 13 | 6 | 1 | 29490 | 27 | ||
134609 | 53445 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1136 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 10 | Permit Number 23060 | 6007541.25929 | 2119223.36211 | 37.7994090319514 | -122.418011327765 | (37.7994090319514, -122.418011327765) | 5 | 1 | 1 | 28858 | 32 | |
140970 | 50962 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2544 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47454 | 6007484.88144152 | 2121079.14108349 | 37.8045013596833 | -122.418338067384 | (37.8045013596833, -122.418338067384) | 5 | 1 | 1 | 308 | 32 | ||||
121945 | 49984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3SEA CLIFF 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46731 | 5988218.33044294 | 2115911.3812309 | 37.7892088105604 | -122.484631586183 | (37.7892088105604, -122.484631586183) | 11 | 6 | 1 | 61 | 33 | |||
105629 | 47188 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 107 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45148 | 5987375.30823388 | 2115250.42635367 | 37.7873448881099 | -122.487499729264 | (37.7873448881099, -122.487499729264) | 11 | 6 | 1 | 55 | 33 | ||
177076 | 42697 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2502 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42714 | 6007504.11437077 | 2120942.44037002 | 37.8041270967963 | -122.41826181189 | (37.8041270967963, -122.41826181189) | 5 | 1 | 1 | 308 | 32 | ||
67832 | 26156 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005669.63899 | 2116283.45257 | 37.7912312672666 | -122.424278594289 | (37.7912312672666, -122.424278594289) | 13 | 9 | 1 | 28858 | 27 | |||
101422 | 2576 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005527.92113 | 2115186.27455 | 37.7882106874937 | -122.424690849945 | (37.7882106874937, -122.424690849945) | 13 | 9 | 1 | 28858 | 41 | |||
168319 | 250759 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 220 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985901.18912 | 2114438.7345 | 37.785030135971 | -122.492540001016 | (37.785030135971, -122.492540001016) | 11 | 6 | 1 | 55 | 33 | |||
96051 | 250646 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 7 | : | Tree | Private 2 | 8 | Width 3ft | 5987286.31285 | 2114656.02961 | 37.7857076546263 | -122.487763944473 | (37.7857076546263, -122.487763944473) | 11 | 6 | 1 | 55 | 33 | |||
141728 | 250643 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 5987323.66461 | 2114657.3301 | 37.7857134039901 | -122.4876348153 | (37.7857134039901, -122.4876348153) | 11 | 6 | 1 | 55 | 33 | |||
20689 | 250642 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 5987348.36119 | 2114656.80551 | 37.7857134039994 | -122.487549334736 | (37.7857134039994, -122.487549334736) | 11 | 6 | 1 | 55 | 33 | |||
172800 | 250641 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5987362.06762 | 2114658.60831 | 37.7857191533476 | -122.487502047492 | (37.7857191533476, -122.487502047492) | 11 | 6 | 1 | 55 | 33 | |||
94944 | 250531 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 76 26th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987723.3107 | 2115526.92779 | 37.7881243712837 | -122.486316035971 | (37.7881243712837, -122.486316035971) | 11 | 6 | 1 | 55 | 33 | |||
128092 | 250530 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 76 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987723.77819 | 2115515.65584 | 37.7880934489912 | -122.486313590702 | (37.7880934489912, -122.486313590702) | 11 | 6 | 1 | 55 | 33 | |||
33400 | 250529 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 76 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5987724.25315 | 2115504.73584 | 37.7880634934877 | -122.486311145439 | (37.7880634934877, -122.486311145439) | 11 | 6 | 1 | 55 | 33 | |||
107324 | 250528 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 76 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5987723.67603 | 2115494.19027 | 37.7880345047402 | -122.486312367641 | (37.7880345047402, -122.486312367641) | 11 | 6 | 1 | 55 | 33 | |||
76267 | 250365 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 55 Scenic Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5987678.19296 | 2115537.88004 | 37.7881518131952 | -122.486472938002 | (37.7881518131952, -122.486472938002) | 11 | 6 | 1 | 55 | 33 | ||||
9049 | 250364 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 55 Scenic Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5987674.80834 | 2115555.75614 | 37.788200698543 | -122.486485961061 | (37.788200698543, -122.486485961061) | 11 | 6 | 1 | 55 | 33 | ||||
73837 | 250363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 55 Scenic Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5987666.7108 | 2115573.26392 | 37.7882482978655 | -122.486515262791 | (37.7882482978655, -122.486515262791) | 11 | 6 | 1 | 55 | 33 | ||||
169172 | 250362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 55 Scenic Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5987656.19233 | 2115587.54347 | 37.7882868922657 | -122.486552703348 | (37.7882868922657, -122.486552703348) | 11 | 6 | 1 | 55 | 33 | ||||
85105 | 250361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 45 Scenic Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5987641.56048 | 2115607.53253 | 37.788340923543 | -122.486604794775 | (37.788340923543, -122.486604794775) | 11 | 6 | 1 | 55 | 33 | ||||
148026 | 250360 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 45 Scenic Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5987630.02194 | 2115618.08542 | 37.7883692261109 | -122.486645490911 | (37.7883692261109, -122.486645490911) | 11 | 6 | 1 | 55 | 33 | ||||
154305 | 250359 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 33 Scenic Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5987617.21703 | 2115632.85047 | 37.7884090202207 | -122.486690877876 | (37.7884090202207, -122.486690877876) | 11 | 6 | 1 | 55 | 33 | ||||
45999 | 250358 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 33 Scenic Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5987605.71758 | 2115644.43526 | 37.7884401583384 | -122.486731514642 | (37.7884401583384, -122.486731514642) | 11 | 6 | 1 | 55 | 33 | ||||
113001 | 250357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 25 Scenic Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5987594.0285 | 2115656.94381 | 37.7884738217661 | -122.486772875384 | (37.7884738217661, -122.486772875384) | 11 | 6 | 1 | 55 | 33 | ||||
124085 | 250356 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 25 Scenic Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987583.59597 | 2115669.67297 | 37.7885081641679 | -122.486809904957 | (37.7885081641679, -122.486809904957) | 11 | 6 | 1 | 55 | 33 | ||||
11371 | 250355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 15 Scenic Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987577.66093 | 2115678.23241 | 37.7885313199138 | -122.486831067817 | (37.7885313199138, -122.486831067817) | 11 | 6 | 1 | 55 | 33 | ||||
62266 | 250345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5987496.56366 | 2115739.63958 | 37.7886951979656 | -122.487116160096 | (37.7886951979656, -122.487116160096) | 11 | 6 | 1 | 55 | 33 | ||||
137973 | 250344 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987477.27987 | 2115739.44054 | 37.7886935270181 | -122.487182863703 | (37.7886935270181, -122.487182863703) | 11 | 6 | 1 | 55 | 33 | ||||
192569 | 250336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 27th Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5987380.06723 | 2115230.15893 | 37.7872895171323 | -122.48748177497 | (37.7872895171323, -122.48748177497) | 11 | 6 | 1 | 55 | 33 | |||
1925 | 250092 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1698 Gough St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005353.59952 | 2115427.24795 | 37.7888624934521 | -122.425311128409 | (37.7888624934521, -122.425311128409) | 13 | 9 | 1 | 28858 | 41 | |||
69096 | 250044 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 50 Daniel Burnham Ct | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6006103.91102 | 2114728.75615 | 37.7869869690171 | -122.422665493826 | (37.7869869690171, -122.422665493826) | 13 | 9 | 1 | 28858 | 41 | |||
39422 | 23695 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2010X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005631.74009 | 2116915.10044 | 37.7929634737292 | -122.424454671565 | (37.7929634737292, -122.424454671565) | 13 | 9 | 1 | 28858 | 27 | |||
168334 | 22790 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1002X BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6000899 | 2112257 | 37.7799051333688 | -122.440495920848 | (37.7799051333688, -122.440495920848) | 15 | 5 | 1 | 29490 | 41 | |||
124165 | 22789 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1002X BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000899 | 2112257 | 37.7799051333688 | -122.440495920848 | (37.7799051333688, -122.440495920848) | 15 | 5 | 1 | 29490 | 41 | |||
49588 | 2239 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1261 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6000775.2551 | 2113005.0733 | 37.7819521045655 | -122.440977689967 | (37.7819521045655, -122.440977689967) | 15 | 5 | 1 | 29490 | 41 | |||
78095 | 2238 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1261 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6000774.2399 | 2113020.3023 | 37.7819938616798 | -122.440982294946 | (37.7819938616798, -122.440982294946) | 15 | 5 | 1 | 29490 | 41 | |||
107207 | 2237 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1261 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6000769.8404 | 2113063.6203 | 37.7821125512395 | -122.441000623777 | (37.7821125512395, -122.441000623777) | 15 | 5 | 1 | 29490 | 41 | |||
37394 | 2232 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1209 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3PL | 6000801.92517 | 2112828.28731 | 37.78146821443 | -122.440872738238 | (37.78146821443, -122.440872738238) | 15 | 5 | 1 | 29490 | 41 | |||
78876 | 2231 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1211 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3PL | 6000797.591 | 2112847.3688 | 37.7815203604798 | -122.440889101586 | (37.7815203604798, -122.440889101586) | 15 | 5 | 1 | 29490 | 41 | |||
185922 | 2189 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1049 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000869.1672 | 2112323.3226 | 37.7800855395625 | -122.440603883886 | (37.7800855395625, -122.440603883886) | 15 | 5 | 1 | 29490 | 41 | |||
33542 | 2188 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1045 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000871.5361 | 2112304.371 | 37.7800336381937 | -122.440594329111 | (37.7800336381937, -122.440594329111) | 15 | 5 | 1 | 29490 | 41 | |||
165644 | 2186 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1039 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6000872.8898 | 2112278.9894 | 37.779964023872 | -122.440587825047 | (37.779964023872, -122.440587825047) | 15 | 5 | 1 | 29490 | 41 | |||
111980 | 2183 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1023 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6000853.50725 | 2112210.1965 | 37.779774032351 | -122.440649942048 | (37.779774032351, -122.440649942048) | 15 | 5 | 1 | 29490 | 41 | |||
38587 | 18832 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2001 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005164.85417 | 2116130.93612 | 37.7907839795542 | -122.426014275038 | (37.7907839795542, -122.426014275038) | 13 | 9 | 1 | 28858 | 27 | |||
55900 | 17783 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1670X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3X3 | 6005360.49348 | 2115382.69892 | 37.7887405624242 | -122.425284104871 | (37.7887405624242, -122.425284104871) | 13 | 9 | 1 | 28858 | 41 | ||
152998 | 17370 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2225X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005023.6203 | 2117335.73677 | 37.7940840749616 | -122.426588765666 | (37.7940840749616, -122.426588765666) | 13 | 9 | 1 | 28858 | 27 | |||
135650 | 17369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2225X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6005023.6203 | 2117335.73677 | 37.7940840749616 | -122.426588765666 | (37.7940840749616, -122.426588765666) | 13 | 9 | 1 | 28858 | 27 | |||
19207 | 17363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
115342 | 17362 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
1045 | 17359 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2221X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | 13 | 9 | 1 | 28858 | 27 | |||
157877 | 143507 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1952 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003639.8096 | 2118677.2493 | 37.7976891948936 | -122.431472707222 | (37.7976891948936, -122.431472707222) | 13 | 9 | 1 | 57 | 17 | |||
177644 | 139554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1207 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000799.9599 | 2112832.4782 | 37.7814796096152 | -122.440879837834 | (37.7814796096152, -122.440879837834) | 15 | 5 | 1 | 29490 | 41 | |||
52152 | 132336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 603 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007097.46754 | 2122233.18776 | 37.8076482617315 | -122.419760687214 | (37.8076482617315, -122.419760687214) | 5 | 1 | 1 | 308 | 32 | |||
190307 | 132335 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 603 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007080.77462 | 2122230.42424 | 37.80763973344 | -122.419818260919 | (37.80763973344, -122.419818260919) | 5 | 1 | 1 | 308 | 32 | |||
140520 | 132334 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2550 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007468.27941 | 2121161.99604 | 37.8047279238135 | -122.41840139881 | (37.8047279238135, -122.41840139881) | 5 | 1 | 1 | 308 | 32 | |||
147575 | 132333 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2540 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007480.55356 | 2121102.67484 | 37.8045657337878 | -122.418354714096 | (37.8045657337878, -122.418354714096) | 5 | 1 | 1 | 308 | 32 | |||
156254 | 132332 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2504 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007487.69217 | 2121044.44677 | 37.8044062561144 | -122.418325879158 | (37.8044062561144, -122.418325879158) | 5 | 1 | 1 | 308 | 32 | |||
39811 | 132331 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2504 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007490.25356 | 2121024.24346 | 37.8043509271294 | -122.418315581892 | (37.8043509271294, -122.418315581892) | 5 | 1 | 1 | 308 | 32 | |||
153083 | 132330 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007494.25982 | 2120977.73519 | 37.8042234527215 | -122.418298418341 | (37.8042234527215, -122.418298418341) | 5 | 1 | 1 | 308 | 32 | |||
55776 | 132321 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007427.51407 | 2121099.77816 | 37.804554794419 | -122.418538057104 | (37.804554794419, -122.418538057104) | 5 | 1 | 1 | 28858 | 32 | |||
98017 | 132320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007424.3414 | 2121124.31025 | 37.8046219747004 | -122.418550777108 | (37.8046219747004, -122.418550777108) | 5 | 1 | 1 | 28858 | 32 | |||
161997 | 132319 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007420.89623 | 2121144.99449 | 37.804678574419 | -122.418564167126 | (37.804678574419, -122.418564167126) | 5 | 1 | 1 | 28858 | 32 | |||
31854 | 132318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007420.0401 | 2121169.28616 | 37.8047452249804 | -122.418568853475 | (37.8047452249804, -122.418568853475) | 5 | 1 | 1 | 28858 | 32 | |||
25348 | 132317 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007415.32813 | 2121203.67481 | 37.8048393822071 | -122.418587599842 | (37.8048393822071, -122.418587599842) | 5 | 1 | 1 | 28858 | 32 | |||
188883 | 132316 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1275 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6006816.19203 | 2119756.21492 | 37.800831276511 | -122.420558166429 | (37.800831276511, -122.420558166429) | 5 | 1 | 1 | 28858 | 32 | |||
137485 | 132315 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1100 Filbert St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007556.34095 | 2119577.0298 | 37.8003809634556 | -122.417984224885 | (37.8003809634556, -122.417984224885) | 5 | 1 | 1 | 28858 | 32 | |||
153522 | 132314 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1100 Filbert St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6007558.42483 | 2119577.92187 | 37.8003835301378 | -122.417977077086 | (37.8003835301378, -122.417977077086) | 5 | 1 | 1 | 28858 | 32 | |||
63877 | 132313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1100 Filbert St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6007559.94961 | 2119579.01274 | 37.8003866112081 | -122.417971878101 | (37.8003866112081, -122.417971878101) | 5 | 1 | 1 | 28858 | 32 | |||
169114 | 132312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1100 Filbert St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6007562.76127 | 2119578.76809 | 37.8003860977016 | -122.41796213126 | (37.8003860977016, -122.41796213126) | 5 | 1 | 1 | 28858 | 32 | |||
118004 | 132311 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1100 Filbert St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6007565.3892 | 2119578.71422 | 37.800386097688 | -122.417953033731 | (37.800386097688, -122.417953033731) | 5 | 1 | 1 | 28858 | 32 |
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) );