8,659 rows where qSpecies_id = 11 sorted by Fire Prevention Districts descending

View and edit SQL

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)
54 216739 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/23/2020 12:00:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491) 9 8 6 28861 24
506 264804 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
1006 258081 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1205 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2019 03:01:00 PM 3 Width 2ft   5995843.60881 2092100.29717 37.7242707405805 -122.456526632611 (37.7242707405805, -122.456526632611) 9 7 4 28861 40
1377 262327 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1472 2091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 943 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 2X2   6001433.65825 2095553.49813 37.7340717929056 -122.437449841319 (37.7340717929056, -122.437449841319) 9 7 5 63 40
1473 170691 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000619.24687 2092677.737 37.7261292822292 -122.440059368765 (37.7261292822292, -122.440059368765) 9 7 6 28861 25
1679 262328 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1731 261128 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 4ft   6003092 2092654 37.7262045674713 -122.431509515778 (37.7262045674713, -122.431509515778) 9 7 6 28861 5
2023 264805 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
2379 27111 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 497 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 8x4   6004667.95957 2093529.09628 37.7286965849625 -122.426123777405 (37.7286965849625, -122.426123777405) 9 7 6 28861 5
2611 52930 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 36 Havelock St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM     Permit Number 48915 5999971.05699015 2092944.44477133 37.7268246780096 -122.442319255194 (37.7268246780096, -122.442319255194) 9 7 6 28861 25
2903 251423 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2162 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/24/2020 12:00:00 AM 3 3x3   5999946 2089791 37.7181646124566 -122.4421796072 (37.7181646124566, -122.4421796072) 9 7 6 28861 25
2919 208356 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4998 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5990631.22914 2093445.14336 37.7276627189546 -122.474642998593 (37.7276627189546, -122.474642998593) 9 8 4 64 40
2975 171289 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 319 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003630.58529 2092759.63292 37.726525123318 -122.429655186657 (37.726525123318, -122.429655186657) 9 7 6 28861 5
3244 208266 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 4 Median : Yard Tree DPW 1     5 Width 8ft   5996189.57852 2098600.11131 37.7421375150253 -122.455800307749 (37.7421375150253, -122.455800307749) 9 7 4 59 40
3256 256623 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 162 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/10/2019 02:37:00 PM 3 3x3   5994333.67195 2093080.20894 37.7268745363156 -122.461817248026 (37.7268745363156, -122.461817248026) 9 8 4 28861 40
3830 91437 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 900X Portola Dr 2 Median : Cutout Tree DPW 1   02/22/2012 12:00:00 AM   4x4   5996336.043197 2098916.600218 37.7430149203693 -122.455316749086 (37.7430149203693, -122.455316749086) 9 7 4 59 40
3958 29691 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 235X Hahn St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM 3 3X3   6007408.6946 2087074.91278 37.7111292927788 -122.416191939068 (37.7111292927788, -122.416191939068) 9 7 8 309 39
4425 262436 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X San Juan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000647.76831 2092657.8797 37.7260763822942 -122.439959348864 (37.7260763822942, -122.439959348864) 9 7 6 28861 25
4525 162657 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 187 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 09:54:00 AM 3 Width 0ft   5996501.58023 2091123.57415 37.7216266438259 -122.454181619811 (37.7216266438259, -122.454181619811) 9 8 6 28861 24
4628 6858 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2865X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/17/1992 12:00:00 AM 15 3X3   5997253 2087738 37.7123737035526 -122.451340121886 (37.7123737035526, -122.451340121886) 9 7 6 28861 25
4691 179399 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 218 Congdon St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2018 11:42:00 AM 3 Width 3ft   6004674.78225 2093970.68086 37.7299094637318 -122.426131615003 (37.7299094637318, -122.426131615003) 9 7 6 28861 5
5131 172199 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 399 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6003534.5249 2091291.61932 37.7224888445726 -122.429882596429 (37.7224888445726, -122.429882596429) 9 7 6 28861 5
5378 76652 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 148X Paris St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6002965.38435 2092499.73249 37.7257738062998 -122.43193620819 (37.7257738062998, -122.43193620819) 9 7 6 28861 5
5749 214100 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 225 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:56:00 PM 3 Width 3ft   5996085.5249 2091194.13993 37.7217965338776 -122.455624901296 (37.7217965338776, -122.455624901296) 9 8 6 28861 24
6372 160064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Cayuga Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2020 12:44:00 PM 3 Width 0ft   6000438.16193 2090795.67407 37.7209512565735 -122.440550438153 (37.7209512565735, -122.440550438153) 9 7 6 28861 25
7044 70398 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 153 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3 Permit Number 775403 6006428.67416 2093189.72166 37.7278640951339 -122.420012793267 (37.7278640951339, -122.420012793267) 9 7 7 309 5
7353 16291 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 710 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/31/2001 12:00:00 AM 3 3x3   5997353.28432 2094748.65298 37.7316290565338 -122.451498861191 (37.7316290565338, -122.451498861191) 9 7 4 59 40
7582 170693 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X San Juan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2020 12:00:00 AM 3 Width 3ft   6000671.26628 2092639.51564 37.726027296415 -122.4398768019 (37.726027296415, -122.4398768019) 9 7 6 28861 25
7678 171106 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1830 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 4ft   6001167.19025 2091451.63812 37.7227938721177 -122.438077374487 (37.7227938721177, -122.438077374487) 9 7 6 28861 25
8669 262474 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
8998 208278 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 20 Median : Cutout Tree DPW 1     1 Width 3ft   5995821.66146 2098283.49942 37.7412470549149 -122.457049545217 (37.7412470549149, -122.457049545217) 9 7 4 59 40
9536 1292 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3990 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   5992119.08452 2087279.95314 37.710820711192 -122.469051013205 (37.710820711192, -122.469051013205) 9 8 4 64 24
9693 177161 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 221 Hahn St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007505.03845 2087315.42394 37.7117951032216 -122.415875970325 (37.7117951032216, -122.415875970325) 9 7 8 309 39
10195 16208 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 520 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/03/1990 12:00:00 AM 12 3X3   5998621.53802 2094731.71409 37.7316550910103 -122.447113056433 (37.7316550910103, -122.447113056433) 9 7 4 59 40
10239 117493 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 156 DORADO TER 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5994380 2093088 37.7268985955584 -122.461657658843 (37.7268985955584, -122.461657658843) 9 8 4 28861 40
11356 208342 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3600 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5990572.11827 2092496.71048 37.7250551346827 -122.474778147818 (37.7250551346827, -122.474778147818) 9 8 4 64 40
12402 67521 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 424 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31057 5997342.043029 2093839.69948247 37.7291326429008 -122.451472187982 (37.7291326429008, -122.451472187982) 9 7 4 28861 40
12508 62227 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 228 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM     Permit Number 22352 6001110.06412505 2093217.52334826 37.7276393417973 -122.438401301148 (37.7276393417973, -122.438401301148) 9 7 6 28861 25
12740 170692 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000647.76831 2092657.8797 37.7260763822942 -122.439959348864 (37.7260763822942, -122.439959348864) 9 7 6 28861 25
12913 253113 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Cayuga Ave 23 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:52:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
13151 68243 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 493 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/1993 12:00:00 AM 10   Permit Number 32043 6007581.69224 2091476.68313 37.7232253533521 -122.415905517524 (37.7232253533521, -122.415905517524) 9 3 7 309 28
13227 70595 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 330 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/2019 12:00:00 AM 9     6004399.02118 2091228.09004 37.7223633261893 -122.426889705722 (37.7223633261893, -122.426889705722) 9 7 6 28861 5
14188 172200 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 399 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6003544.90457 2091306.45225 37.7225301603163 -122.429847773766 (37.7225301603163, -122.429847773766) 9 7 6 28861 5
14329 208448 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 79 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   5994592.56957 2093111.81863 37.7269762295662 -122.46092454135 (37.7269762295662, -122.46092454135) 9 8 4 28861 40
14402 208305 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600x Bosworth St 6 Median : Yard Tree DPW 1     1 Width 10ft   6002233.89157 2095386.08451 37.7336575763338 -122.434671221913 (37.7336575763338, -122.434671221913) 9 7 5 63 40
14409 177162 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 221 Hahn St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 780274 6007512.10716 2087312.1903 37.7117866217183 -122.415851310014 (37.7117866217183, -122.415851310014) 9 7 8 309 39
14511 208454 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 314 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5994351.80863 2093010.71485 37.7266847664821 -122.461749513755 (37.7266847664821, -122.461749513755) 9 8 4 28861 40
14723 256851 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1777 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001446 2091921 37.7240984859228 -122.437147179411 (37.7240984859228, -122.437147179411) 9 7 6 28861 25
14772 208283 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 26 Median : Cutout Tree DPW 1     6 Width 3ft   5995702.36182 2098208.09954 37.7410331736343 -122.457456584654 (37.7410331736343, -122.457456584654) 9 7 4 59 40
14780 262330 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
16732 262211 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2162 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5999946 2089791 37.7181646124566 -122.4421796072 (37.7181646124566, -122.4421796072) 9 7 6 28861 25
17005 101474 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2016 12:00:00 AM     Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
17325 208354 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 5000 19th Ave 6 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5990627.1725 2093396.83669 37.7275298459097 -122.474653498173 (37.7275298459097, -122.474653498173) 9 8 4 64 40
17562 160058 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 10:47:00 AM 3 Width 0ft   6000597.86618 2091098.27715 37.7217912287713 -122.440020076466 (37.7217912287713, -122.440020076466) 9 7 6 28861 25
18100 94592 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2428 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2016 10:36:00 AM 3 3x3   6010911.88561 2086922.4145 37.7109069219836 -122.404073263263 (37.7109069219836, -122.404073263263) 9 7 8 309 39
18240 208338 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3660 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5990543.735 2092084.7933 37.7239224682242 -122.474846212085 (37.7239224682242, -122.474846212085) 9 8 4 64 40
18601 262329 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18755 16138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 370 Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   5999754.91061 2094714.13801 37.7316715225246 -122.443193512388 (37.7316715225246, -122.443193512388) 9 7 4 63 40
19589 208385 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 180 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992853.23651 2095546.10769 37.733559947723 -122.467114242228 (37.733559947723, -122.467114242228) 9 8 4 59 40
19611 171230 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 95 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003563.26251 2092861.65993 37.7268014543988 -122.429895193205 (37.7268014543988, -122.429895193205) 9 7 6 28861 5
20464 208353 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 5000 19th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5990626.63647 2093347.44726 37.727394203873 -122.474651748098 (37.727394203873, -122.474651748098) 9 8 4 64 40
20473 208314 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 931 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001504.4065 2095542.47222 37.7340455402682 -122.437204453845 (37.7340455402682, -122.437204453845) 9 7 5 63 40
20582 16190 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 463 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/1998 12:00:00 AM 3 3X3   5999017.68694 2094650.2633 37.7314540727285 -122.445737640473 (37.7314540727285, -122.445737640473) 9 7 4 59 40
21376 418 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3870 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2008 12:00:00 AM 3 2X4   5990907.498 2090050.47073 37.7183577952661 -122.473440442237 (37.7183577952661, -122.473440442237) 9 8 4 64 40
21804 16274 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 675 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   5997598.29075 2094676.61172 37.7314452755764 -122.450646637547 (37.7314452755764, -122.450646637547) 9 7 4 59 40
21894 208286 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 215 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5994478.59231 2092821.26982 37.7261718938956 -122.461297502801 (37.7261718938956, -122.461297502801) 9 8 4 28861 40
22430 16257 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 625 Monterey Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5997866.75715 2094667.34056 37.7314351824697 -122.449717834828 (37.7314351824697, -122.449717834828) 9 7 4 59 40
22518 177228 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 134 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6000372.02782 2092644.30994 37.7260234221226 -122.440911591502 (37.7260234221226, -122.440911591502) 9 7 6 28861 25
23257 177158 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 221 Hahn St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007422.75752 2087173.92491 37.7114019502079 -122.416150341778 (37.7114019502079, -122.416150341778) 9 7 8 309 39
23295 2152 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1109 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6000977.95547 2095707.30973 37.734468205445 -122.439036363859 (37.734468205445, -122.439036363859) 9 7 5 63 40
23498 76685 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
23573 60472 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99x Majestic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1982 12:00:00 AM   3x3 Permit Number 20066 5997184 2089426 37.7170046100656 -122.451700294591 (37.7170046100656, -122.451700294591) 9 8 6 28861 24
24208 76687 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
24317 216490 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800x Bosworth St 3 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 3ft   6001788.93125 2095501.57158 37.7339494063362 -122.436217839104 (37.7339494063362, -122.436217839104) 9 7 5 63 40
24399 62832 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2017 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/2005 12:00:00 AM     Permit Number 23197 5999678.92885006 2092144.34740146 37.7246111411292 -122.443271689799 (37.7246111411292, -122.443271689799) 9 7 6 28861 25
24807 208317 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 295 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995337.94079 2092045.98107 37.7240925570223 -122.458270713016 (37.7240925570223, -122.458270713016) 9 8 4 28861 24
25190 208460 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 545 Teresita Blvd 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5998994.59253 2097295.1297 37.7387149309567 -122.446007644855 (37.7387149309567, -122.446007644855) 9 7 4 59 40
25288 208320 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 590 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5994793.28143 2092164.99071 37.724388015769 -122.46016212219 (37.724388015769, -122.46016212219) 9 8 4 28861 24
25324 29368 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3802X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/06/2006 12:00:00 AM 10 3X3   5992911.10359 2087617.08951 37.7117921381675 -122.466338121928 (37.7117921381675, -122.466338121928) 9 8 4 64 24
25361 113722 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 57 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 779057 5994581 2092950 37.7265312490745 -122.460952813642 (37.7265312490745, -122.460952813642) 9 8 4 28861 40
25575 334 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3590X 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/2008 12:00:00 AM 3 2   5990580.28082 2092709.64357 37.7256402686825 -122.474765465576 (37.7256402686825, -122.474765465576) 9 8 4 64 40
25996 208315 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 691 Monterey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5997570.14701 2094675.72422 37.7314412277316 -122.450743871345 (37.7314412277316, -122.450743871345) 9 7 4 59 40
26154 160072 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Cayuga Ave 15 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:34:00 AM 3 Width 0ft   6000153.57644 2090420.29754 37.7199043485999 -122.441507239468 (37.7199043485999, -122.441507239468) 9 7 6 28861 25
26197 177217 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3602 Alemany Blvd 6 : Tree Private 2     8 Width 3ft   5993336.53195 2087626.25376 37.7118418391946 -122.464868401251 (37.7118418391946, -122.464868401251) 9 8 4 64 24
26857 161557 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 15 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 11:09:00 AM 3 Width 0ft   6001350.49803 2088073.55411 37.7135288333539 -122.437201966314 (37.7135288333539, -122.437201966314) 9 7 6 28861 5
26969 87572 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3250 19th Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/2008 12:00:00 AM 3     5990676.28121 2094101.04473 37.7294662695904 -122.474535101923 (37.7294662695904, -122.474535101923) 9 8 4 64 40
27569 86819 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1010 Capitol Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49755 5995086.4 2090661.6 37.7202769199461 -122.45904005327 (37.7202769199461, -122.45904005327) 9 8 6 28861 24
27629 208201 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 109 San Benito Way 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   5992876.13857 2095935.50628 37.7346304611167 -122.467063364902 (37.7346304611167, -122.467063364902) 9 8 4 59 40
27875 56612 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 139 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31089 5996720.86601097 2098424.62291363 37.7416861435861 -122.453950621575 (37.7416861435861, -122.453950621575) 9 7 4 59 40
28095 29690 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 235X Hahn St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM 3 3X3   6007408.6946 2087074.91278 37.7111292927788 -122.416191939068 (37.7111292927788, -122.416191939068) 9 7 8 309 39
28984 253115 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Cayuga Ave 25 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:57:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
29350 25362 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 974 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2017 12:00:00 AM 3 3X3 Permit Number 780532 6000558.35356 2088917.09573 37.7157999479938 -122.440000340863 (37.7157999479938, -122.440000340863) 9 7 6 28861 5
29940 67983 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 90 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1993 12:00:00 AM     Permit Number 31707 5996243.31807004 2090478.67458978 37.7198410887436 -122.455027781571 (37.7198410887436, -122.455027781571) 9 8 6 28861 24
30036 1873 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2566 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/2016 12:00:00 AM 3 3X3   6010639.8141 2086443.56694 37.7095768975302 -122.404979917507 (37.7095768975302, -122.404979917507) 9 7 8 309 39
30073 113257 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 45 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994580 2092875 37.7263252596904 -122.46095083712 (37.7263252596904, -122.46095083712) 9 8 4 28861 40
30221 95757 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.16774 37.7250685138993 -122.430292354528 (37.7250685138993, -122.430292354528) 9 7 6 28861 5
31222 2032 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 645 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002168.04388 2095363.4286 37.7335916299421 -122.434897256628 (37.7335916299421, -122.434897256628) 9 7 5 63 40
31792 87688 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2610 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010514.44412 2086115.57881 37.7086692990048 -122.40539013695 (37.7086692990048, -122.40539013695) 9 7 8 309 39
32107 16122 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 313 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/05/2012 12:00:00 AM 3 3X3   5999967.48728 2094632.53487 37.7314595783841 -122.442452738108 (37.7314595783841, -122.442452738108) 9 7 4 63 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);