trees
8,659 rows where qSpecies_id = 11 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192303 | 97456 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2833 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015982.07607 | 2102420.27087 | 37.7537429168085 | -122.387629897505 | (37.7537429168085, -122.387629897505) | 10 | 3 | 8 | 28856 | 29 | |||||
151591 | 97455 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2833 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015982.07607 | 2102420.27087 | 37.7537429168085 | -122.387629897505 | (37.7537429168085, -122.387629897505) | 10 | 3 | 8 | 28856 | 29 | |||||
78841 | 97453 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2890 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015889.88576 | 2102187.78517 | 37.7530994530807 | -122.387932493788 | (37.7530994530807, -122.387932493788) | 10 | 3 | 8 | 28856 | 29 | ||||
128453 | 97452 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6015884.28159 | 2102342.06388 | 37.7535227594935 | -122.387962639067 | (37.7535227594935, -122.387962639067) | 10 | 3 | 8 | 28856 | 29 | ||||
151567 | 97451 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6015865.4173 | 2102637.8152 | 37.7543337851952 | -122.388048513524 | (37.7543337851952, -122.388048513524) | 10 | 3 | 8 | 28856 | 29 | ||||
53894 | 97450 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6015863.68696 | 2102656.78776 | 37.7543857839773 | -122.388055821428 | (37.7543857839773, -122.388055821428) | 10 | 3 | 8 | 28856 | 29 | ||||
119062 | 97449 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6015860.67722 | 2102672.17908 | 37.7544278785458 | -122.38806730398 | (37.7544278785458, -122.38806730398) | 10 | 3 | 8 | 28856 | 29 | ||||
44429 | 97448 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 6015860.44953 | 2102690.82066 | 37.7544790517769 | -122.38806939221 | (37.7544790517769, -122.38806939221) | 10 | 3 | 8 | 28856 | 29 | ||||
172488 | 9742 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 715 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/1990 12:00:00 AM | 16 | 4x4 | 6005732.15596 | 2112245.14755 | 37.7801466109528 | -122.423775023123 | (37.7801466109528, -122.423775023123) | 7 | 9 | 11 | 28852 | 41 | ||
53798 | 97417 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1980X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | Permit Number 768802 | 6006505.8 | 2117586.8 | 37.7948571127085 | -122.421478098294 | (37.7948571127085, -122.421478098294) | 13 | 9 | 10 | 28858 | 32 | |||
172465 | 97416 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1980X Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | Permit Number 768802 | 6006505.8 | 2117586.8 | 37.7948571127085 | -122.421478098294 | (37.7948571127085, -122.421478098294) | 13 | 9 | 10 | 28858 | 32 | |||
146206 | 97415 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1595 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | Permit Number 768802 | 6006511.6 | 2117639.1 | 37.7950010424229 | -122.4214617455 | (37.7950010424229, -122.4214617455) | 13 | 9 | 10 | 28858 | 32 | |||
160641 | 97414 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1595 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | Permit Number 768802 | 6006511.6 | 2117639.1 | 37.7950010424229 | -122.4214617455 | (37.7950010424229, -122.4214617455) | 13 | 9 | 10 | 28858 | 32 | |||
149322 | 9741 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 715 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1990 12:00:00 AM | 10 | 4x4 | 6005762.05796 | 2112160.93191 | 37.7799170633479 | -122.423665588926 | (37.7799170633479, -122.423665588926) | 7 | 9 | 11 | 28852 | 41 | ||
156539 | 9740 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | 3 | 3x3 | 6005803.72445 | 2112207.34656 | 37.7800468585202 | -122.423524746578 | (37.7800468585202, -122.423524746578) | 7 | 9 | 11 | 28852 | 41 | ||
133319 | 9739 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/1997 12:00:00 AM | 10 | 3x3 | 6005806.11727 | 2112180.16431 | 37.7799723577649 | -122.423514535673 | (37.7799723577649, -122.423514535673) | 7 | 9 | 11 | 28852 | 41 | ||
126253 | 9738 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1997 12:00:00 AM | 12 | 3x3 | 6005814.26595 | 2112123.69574 | 37.7798177688046 | -122.423482330047 | (37.7798177688046, -122.423482330047) | 7 | 9 | 11 | 28852 | 41 | ||
113613 | 9737 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6005833.65201 | 2111959.09447 | 37.7793669080814 | -122.423403560226 | (37.7793669080814, -122.423403560226) | 7 | 9 | 11 | 28852 | 10 | |||
177685 | 97359 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 355X 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011968 | 2112002 | 37.7798290295468 | -122.402185169477 | (37.7798290295468, -122.402185169477) | 6 | 2 | 9 | 28856 | 34 | |||
30530 | 97350 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2632 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015823.12948 | 2103390.32283 | 37.7563976690426 | -122.38824727179 | (37.7563976690426, -122.38824727179) | 10 | 3 | 8 | 28856 | 29 | |||
163955 | 97330 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2542 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015793.82304 | 2103742.3022 | 37.7573625057971 | -122.388373190379 | (37.7573625057971, -122.388373190379) | 10 | 3 | 8 | 28856 | 29 | |||
146662 | 97329 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2504 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6015728.85283 | 2103889.92541 | 37.7577642473544 | -122.388608189519 | (37.7577642473544, -122.388608189519) | 10 | 3 | 8 | 28856 | 29 | |||
118902 | 97239 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 03:49:00 PM | 3 | 3x3 | Permit Number 767495 | 6003412.15812 | 2092196.84002 | 37.7249674489828 | -122.430370144078 | (37.7249674489828, -122.430370144078) | 9 | 7 | 6 | 28861 | 5 |
96271 | 97201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1545 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 770119 | 6006293.45154 | 2117933.09937 | 37.7957959885584 | -122.422237470476 | (37.7957959885584, -122.422237470476) | 13 | 9 | 10 | 28858 | 32 | |||
24555 | 97200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1545 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2013 12:00:00 AM | 1 | Permit Number 770119 | 6006267.9333 | 2117930.06594 | 37.7957862201178 | -122.422325552801 | (37.7957862201178, -122.422325552801) | 13 | 9 | 10 | 28858 | 32 | ||
93598 | 9720 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 555 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4X4 | 6005813.17876 | 2111664.22482 | 37.7785561124058 | -122.423453417243 | (37.7785561124058, -122.423453417243) | 7 | 9 | 11 | 28852 | 10 | |||
147142 | 97199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1545 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770119 | 6006248.03632 | 2117928.91827 | 37.7957819465319 | -122.422394318536 | (37.7957819465319, -122.422394318536) | 13 | 9 | 10 | 28858 | 32 | |
181029 | 97198 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1545 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2013 12:00:00 AM | 2 | Permit Number 770119 | 6006218.00833 | 2117923.75359 | 37.7957660716894 | -122.422497853895 | (37.7957660716894, -122.422497853895) | 13 | 9 | 10 | 28858 | 32 | ||
97476 | 97197 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1545 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 770119 | 6006194.96799 | 2117921.7813 | 37.7957593564702 | -122.422577437592 | (37.7957593564702, -122.422577437592) | 13 | 9 | 10 | 28858 | 32 | |||
62366 | 97194 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 390X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | |||
92496 | 9719 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 555 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4X4 | 6005813.17876 | 2111664.22482 | 37.7785561124058 | -122.423453417243 | (37.7785561124058, -122.423453417243) | 7 | 9 | 11 | 28852 | 10 | |||
33510 | 97172 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008094.3658 | 2110608.12589 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | 8 | 2 | 9 | 28853 | 34 | ||||||
76156 | 97171 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008094.3658 | 2110608.12589 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | 8 | 2 | 9 | 28853 | 34 | ||||||
1150 | 97170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 289 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | |||
41021 | 9717 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2009 12:00:00 AM | 3 | 3X3 | 6005862.79801 | 2111412.68335 | 37.7778682412134 | -122.423263879555 | (37.7778682412134, -122.423263879555) | 7 | 9 | 11 | 28852 | 10 | ||
72107 | 9716 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 3 | 4X4 | 6005852.40351 | 2111462.81888 | 37.778005314553 | -122.423303402675 | (37.778005314553, -122.423303402675) | 7 | 9 | 11 | 28852 | 10 | ||
62218 | 97151 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2601x 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
163644 | 97150 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2601X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
165080 | 9715 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/1996 12:00:00 AM | 3 | 4X4 | 6005862.79801 | 2111412.68335 | 37.7778682412134 | -122.423263879555 | (37.7778682412134, -122.423263879555) | 7 | 9 | 11 | 28852 | 10 | ||
115634 | 97149 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
121964 | 97147 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
183227 | 97146 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
2944 | 97145 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
54814 | 97144 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2051X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
164646 | 97143 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2051X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
157442 | 97142 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2051X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
22600 | 97141 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2051X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
180492 | 97140 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2051X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008691 | 2106521 | 37.7645960298802 | -122.413134123465 | (37.7645960298802, -122.413134123465) | 8 | 4 | 7 | 28859 | 19 | |||
118599 | 9714 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2016 12:00:00 AM | 3 | 4X4 | 6005851.03176 | 2111482.4519 | 37.7780591446309 | -122.423309544057 | (37.7780591446309, -122.423309544057) | 7 | 9 | 11 | 28852 | 10 | ||
18865 | 9713 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 3 | 4X4 | 6005848.49792 | 2111505.90882 | 37.7781234086211 | -122.423319977441 | (37.7781234086211, -122.423319977441) | 7 | 9 | 11 | 28852 | 10 | ||
77838 | 9712 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1996 12:00:00 AM | 24 | 4x4 | 6005803.66828 | 2111461.12582 | 37.7779979152285 | -122.423471875003 | (37.7779979152285, -122.423471875003) | 7 | 9 | 11 | 28852 | 10 | ||
175824 | 9711 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1996 12:00:00 AM | 12 | 4x4 | 6005803.66828 | 2111461.12582 | 37.7779979152285 | -122.423471875003 | (37.7779979152285, -122.423471875003) | 7 | 9 | 11 | 28852 | 10 | ||
148385 | 9709 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2010 12:00:00 AM | 12 | 4x4 | 6005803.66828 | 2111461.12582 | 37.7779979152285 | -122.423471875003 | (37.7779979152285, -122.423471875003) | 7 | 9 | 11 | 28852 | 10 | ||
102937 | 9708 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53020 | 6005803.66828 | 2111461.12582 | 37.7779979152285 | -122.423471875003 | (37.7779979152285, -122.423471875003) | 7 | 9 | 11 | 28852 | 10 | |
83901 | 97074 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1551 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/20/2015 05:52:00 PM | 3 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | |
72415 | 9707 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2009 12:00:00 AM | 38 | 3x3 | Permit Number 53020 | 6005902.44069 | 2111502.11522 | 37.7781160365685 | -122.423133099932 | (37.7781160365685, -122.423133099932) | 7 | 9 | 11 | 28852 | 10 | |
135797 | 97066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
95158 | 97065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
92010 | 97064 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
54757 | 97063 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
170813 | 97062 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
115524 | 97061 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
131032 | 97060 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
7107 | 9706 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6005904.98118 | 2111477.12508 | 37.7780475630877 | -122.423122534696 | (37.7780475630877, -122.423122534696) | 7 | 9 | 11 | 28852 | 10 | |||
157893 | 9705 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2014 12:00:00 AM | 3 | 3X3 | Permit Number 772945 | 6005884.40627 | 2111264.73577 | 37.7774632325803 | -122.423178609866 | (37.7774632325803, -122.423178609866) | 7 | 9 | 11 | 28852 | 10 | |
13704 | 9704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6005878.26798 | 2111295.24256 | 37.7775466504055 | -122.423202013315 | (37.7775466504055, -122.423202013315) | 7 | 9 | 11 | 28852 | 10 | ||
31375 | 9703 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 475 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/1999 12:00:00 AM | 2 | 3X3 | 6005887 | 2111305 | 37.7775739347442 | -122.423172500044 | (37.7775739347442, -122.423172500044) | 7 | 9 | 11 | 28852 | 10 | ||
24337 | 9702 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006005.25154 | 2111313.57789 | 37.777604160154 | -122.42276403742 | (37.777604160154, -122.42276403742) | 7 | 9 | 11 | 28852 | 10 | ||
147939 | 9701 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 450 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006005.25154 | 2111313.57789 | 37.777604160154 | -122.42276403742 | (37.777604160154, -122.42276403742) | 7 | 9 | 11 | 28852 | 10 | ||
176187 | 9700 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 450 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006005.25154 | 2111313.57789 | 37.777604160154 | -122.42276403742 | (37.777604160154, -122.42276403742) | 7 | 9 | 11 | 28852 | 10 | ||
145889 | 97 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1997 12:00:00 AM | 12 | 3X3 | 6002378.86758 | 2107679.69737 | 37.7674211521886 | -122.435048944375 | (37.7674211521886, -122.435048944375) | 15 | 5 | 5 | 28862 | 3 | ||
161426 | 9699 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006005.25154 | 2111313.57789 | 37.777604160154 | -122.42276403742 | (37.777604160154, -122.42276403742) | 7 | 9 | 11 | 28852 | 10 | ||
7025 | 96977 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2220 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2005 12:00:00 AM | 3x3 | 6015794 | 2092051 | 37.7252605945934 | -122.387556947253 | (37.7252605945934, -122.387556947253) | 10 | 3 | 8 | 58 | 1 | |||
33915 | 9690 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 3 | 3x3 | 6005924.40984 | 2110798.16094 | 37.776184388733 | -122.423007053797 | (37.776184388733, -122.423007053797) | 7 | 9 | 11 | 28852 | 10 | ||
12085 | 9686 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.422761599875 | (37.7762854431535, -122.422761599875) | 7 | 9 | 11 | 28852 | 10 | |||
140250 | 9685 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | 12 | 3x3 | 6005998.02804 | 2110813.59633 | 37.7762309244582 | -122.422753485305 | (37.7762309244582, -122.422753485305) | 7 | 9 | 11 | 28852 | 10 | ||
170542 | 9684 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | 12 | 3x3 | 6006000.35956 | 2110784.34866 | 37.7761507489834 | -122.422743340937 | (37.7761507489834, -122.422743340937) | 7 | 9 | 11 | 28852 | 10 | ||
42726 | 96806 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 471 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 3x3 | Permit Number 771933 | 6011260.5 | 2118966.4 | 37.7989120989831 | -122.405123270049 | (37.7989120989831, -122.405123270049) | 3 | 1 | 10 | 308 | 23 | ||
148954 | 9680 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 295X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1994 12:00:00 AM | 18 | 3X3 | 6005963.87904 | 2110689.70526 | 37.7758888227966 | -122.422862809189 | (37.7758888227966, -122.422862809189) | 7 | 9 | 11 | 28852 | 10 | ||
36399 | 9679 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 295X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005963.87904 | 2110689.70526 | 37.7758888227966 | -122.422862809189 | (37.7758888227966, -122.422862809189) | 7 | 9 | 11 | 28852 | 10 | ||
46507 | 9678 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 295X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1994 12:00:00 AM | 18 | 3X3 | 6005963.87904 | 2110689.70526 | 37.7758888227966 | -122.422862809189 | (37.7758888227966, -122.422862809189) | 7 | 9 | 11 | 28852 | 10 | ||
107480 | 9677 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 295X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1994 12:00:00 AM | 18 | 3X3 | 6005963.87904 | 2110689.70526 | 37.7758888227966 | -122.422862809189 | (37.7758888227966, -122.422862809189) | 7 | 9 | 11 | 28852 | 10 | ||
163237 | 9673 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 225 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 24 | 3X3 | 6005924.48398 | 2110513.42627 | 37.7754025804342 | -122.422986555189 | (37.7754025804342, -122.422986555189) | 7 | 9 | 11 | 28852 | 10 | ||
58318 | 96725 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2011 12:00:00 AM | Permit Number 767228 | 6015269.4 | 2113570.5 | 37.7843194987226 | -122.390873725806 | (37.7843194987226, -122.390873725806) | 6 | 2 | 9 | 28856 | 6 | |||
185226 | 96723 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2014 12:00:00 AM | 3 | 3x3 | 6007175.58441 | 2119442.18182 | 37.799989268248 | -122.419292225858 | (37.799989268248, -122.419292225858) | 5 | 1 | 1 | 28858 | 32 | ||
90141 | 9672 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 211 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6005993.9451 | 2110479.2475 | 37.7753126530855 | -122.422743843047 | (37.7753126530855, -122.422743843047) | 7 | 9 | 11 | 28852 | 10 | ||
39041 | 96625 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6014746.7 | 2098348.9 | 37.7424952824301 | -122.391617510821 | (37.7424952824301, -122.391617510821) | 10 | 3 | 8 | 58 | 1 | |||
109898 | 96619 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 2x2 | 6014746.7 | 2098348.9 | 37.7424952824301 | -122.391617510821 | (37.7424952824301, -122.391617510821) | 10 | 3 | 8 | 58 | 1 | |||
170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
144623 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
148306 | 96613 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2018 12:00:00 AM | 3 | Permit Number 780998 | 5997328.97921 | 2115415.06267 | 37.7883724097142 | -122.453074178449 | (37.7883724097142, -122.453074178449) | 11 | 6 | 1 | 54 | 31 | ||
191632 | 96612 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2011 12:00:00 AM | 4 | Permit Number 767972 | 5997357.22496 | 2115417.4717 | 37.788380643004 | -122.45297662718 | (37.788380643004, -122.45297662718) | 11 | 6 | 1 | 54 | 31 | ||
50981 | 96611 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2011 12:00:00 AM | 5 | Permit Number 767972 | 5997367.41166 | 2115420.25767 | 37.7883888763049 | -122.452941584197 | (37.7883888763049, -122.452941584197) | 11 | 6 | 1 | 54 | 31 | ||
58556 | 9659 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 111X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/1997 12:00:00 AM | 12 | 3X3 | 6006046.32863 | 2110104.72222 | 37.774287252415 | -122.42253601716 | (37.774287252415, -122.42253601716) | 7 | 9 | 11 | 28852 | 10 | ||
159723 | 9658 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 110 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/2012 12:00:00 AM | 5 | 3x3 | 6006100.97978 | 2110078.42261 | 37.7742181229923 | -122.422345099554 | (37.7742181229923, -122.422345099554) | 7 | 9 | 11 | 28852 | 10 | ||
159107 | 96575 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2013 04:48:00 PM | 10 | 4x4 | Permit Number 56732 | 6011658.85172 | 2113490.94843 | 37.7839000739713 | -122.403359431819 | (37.7839000739713, -122.403359431819) | 12 | 2 | 9 | 28853 | 6 | |
35210 | 96574 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 56732 | 6011674.17261 | 2113474.4463 | 37.7838556186756 | -122.403305265628 | (37.7838556186756, -122.403305265628) | 12 | 2 | 9 | 28853 | 6 | ||
32008 | 96370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001150.89126 | 2121288.6307 | 37.8047179782121 | -122.440272392077 | (37.8047179782121, -122.440272392077) | 13 | 9 | 1 | 57 | 17 | |
178026 | 96369 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.440231537678 | (37.8046852096195, -122.440231537678) | 13 | 9 | 1 | 57 | 17 | |
47717 | 9634 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1455 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2015 12:00:00 AM | 3 | 3X3 | 6002662.6335 | 2111953.9352 | 37.7791732594644 | -122.434373061746 | (37.7791732594644, -122.434373061746) | 15 | 5 | 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) );