8,659 rows where qSpecies_id = 11 sorted by qCareAssistant 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)
8442 43966 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 627 Turk St 1 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 08/24/2000 12:00:00 AM 9   Permit Number 43534 6006884.39072 2112892.55093 37.7819892007742 -122.419834861512 (37.7819892007742, -122.419834861512) 7 9 9 28852 36
127023 251811 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 4 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
144228 251810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
168582 251809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 2 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
615 262077 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 565 Page St 1 Sidewalk: Curb side : Cutout Tree Port 6 Private 04/16/2020 12:00:00 AM 3 3x3   6003870.34162 2109702.301 37.7730593047529 -122.430034440005 (37.7730593047529, -122.430034440005) 7 9 11 29492 10
5711 253201 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800 Oak St 3 Sidewalk: Property side : Cutout Tree DPW 1 Private 11/02/2019 06:09:00 AM 3 6x6   6003064 2109976 37.77376511482 -122.432843231253 (37.77376511482, -122.432843231253) 15 5 11 29492 10
6078 255898 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 255 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 11/12/2019 06:17:00 AM 3 3x3   6007944 2113354 37.7833158649371 -122.416201780533 (37.7833158649371, -122.416201780533) 7 10 9 28852 36
8266 253200 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800 Oak St 2 Sidewalk: Property side : Cutout Tree DPW 1 Private 11/02/2019 06:07:00 AM 3 6x6   6003064 2109976 37.77376511482 -122.432843231253 (37.77376511482, -122.432843231253) 15 5 11 29492 10
17225 253199 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800 Oak St 1 Sidewalk: Property side : Cutout Tree DPW 1 Private 11/02/2019 06:04:00 AM 3 6x6   6003064 2109976 37.77376511482 -122.432843231253 (37.77376511482, -122.432843231253) 15 5 11 29492 10
19694 91181 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 8 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
33666 201689 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 324 08th St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009821.14 2110064.65257 37.7743894618352 -122.409475369404 (37.7743894618352, -122.409475369404) 8 2 9 28853 34
36901 91180 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 7 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
44511 258444 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 598 Hampshire St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6010091 2105516 37.7619150231034 -122.408220989844 (37.7619150231034, -122.408220989844) 8 4 8 28859 19
49983 110536 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 4 Sidewalk: Curb side : Cutout Tree City College 20 Private 05/29/2015 02:12:00 PM 3 3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
65819 91179 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
72004 87557 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 408X Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/03/2007 12:00:00 AM 3 3x3   5994236.22519 2114896.53302 37.7867709361644 -122.463736876784 (37.7867709361644, -122.463736876784) 11 6 1 54 11
78526 254583 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1439 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 08/02/2016 06:38:00 AM   3x3   6005488 2119883 37.8011044543754 -122.425163298445 (37.8011044543754, -122.425163298445) 13 9 1 57 17
94501 258447 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 598 Hampshire St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6010091 2105516 37.7619150231034 -122.408220989844 (37.7619150231034, -122.408220989844) 8 4 8 28859 19
99706 85477 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1711 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 02/10/2011 12:00:00 AM 18 4x4 Permit Number 56911 6007344.49108 2118216.09025 37.7966322393414 -122.418620748847 (37.7966322393414, -122.418620748847) 5 1 10 28858 32
117347 49668 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.443384720262 (37.8030812490195, -122.443384720262) 13 9 1 57 17
129646 11066 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1711 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 02/10/2011 12:00:00 AM 60 4x4 Permit Number 56911 6007343.19343 2118232.87472 37.7966782522465 -122.418626429868 (37.7966782522465, -122.418626429868) 5 1 10 28858 32
138459 258445 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 598 Hampshire St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6010091 2105516 37.7619150231034 -122.408220989844 (37.7619150231034, -122.408220989844) 8 4 8 28859 19
141293 91178 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
146849 258446 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 598 Hampshire St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6010091 2105516 37.7619150231034 -122.408220989844 (37.7619150231034, -122.408220989844) 8 4 8 28859 19
157938 251285 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1299x Hudson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/11/2006 12:00:00 AM   3x3   6017207 2095414 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346) 10 3 8 58 1
161715 85436 - 12 Lophostemon confertus :: Brisbane Box 11 1397X Buchanan St 7 Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304) 7 9 11 29490 41
166528 258443 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 598 Hampshire St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6010091 2105516 37.7619150231034 -122.408220989844 (37.7619150231034, -122.408220989844) 8 4 8 28859 19
189797 201693 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 342 08th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009930.21878 2109950.89592 37.7740832238052 -122.409090015305 (37.7740832238052, -122.409090015305) 8 2 9 28853 34
83 259099 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
101 255229 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
105 70839 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 939 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6010931.16123 2112337.60471 37.780692593337 -122.405795716794 (37.780692593337, -122.405795716794) 14 2 9 28853 34
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
809 66604 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 795 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM 17 3x3 Permit Number 31919 6008813.15818 2115243.41738 37.7885525825831 -122.413328486829 (37.7885525825831, -122.413328486829) 5 1 10 28858 21
977 37516 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM 11   Permit Number 41076 6007956.90243 2113828.43772 37.7846192815973 -122.416190755523 (37.7846192815973, -122.416190755523) 7 10 9 28858 36
1107 258138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300 Beale St 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6014765.94263 2115143.61778 37.7886109721909 -122.39272561329 (37.7886109721909, -122.39272561329) 6 2 9 28855 6
1205 71779 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1062 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6007509.77749 2115111.57122 37.7881173017281 -122.417828646693 (37.7881173017281, -122.417828646693) 13 1 10 28858 21
1500 65026 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 271 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1989 12:00:00 AM 13   Permit Number 26077 6013497.70585 2105830.92167 37.7629698974541 -122.396460524653 (37.7629698974541, -122.396460524653) 14 3 8 28856 29
1589 33856 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 757 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1997 12:00:00 AM 8   Permit Number 37855 6014472.91099 2103543.47306 37.7567432802823 -122.392927551468 (37.7567432802823, -122.392927551468) 10 3 8 28856 29
1690 52430 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2536 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 12   Permit Number 48545 6002701.73302 2117006.28973 37.7930479607542 -122.434599161948 (37.7930479607542, -122.434599161948) 13 9 1 29490 27
1693 70072 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 460-462 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6014075.24964 2112803.80145 37.7821479895867 -122.394951382198 (37.7821479895867, -122.394951382198) 6 2 9 28856 6
1736 255231 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1754 72457 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6013447.28917 2112118.8251 37.7802322636443 -122.397075813805 (37.7802322636443, -122.397075813805) 6 2 9 28856 34
1953 32433 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 370 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1996 12:00:00 AM 16   Permit Number 36960 6006526.54951 2103941.02007 37.7573902597604 -122.420437248987 (37.7573902597604, -122.420437248987) 2 4 7 28859 19
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
2134 83455 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6015476.55407 2105691.51602 37.7626970431542 -122.389606573684 (37.7626970431542, -122.389606573684) 10 3 8 28856 29
2157 66537 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 17 Hattie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1995 12:00:00 AM     Permit Number 29712 6000633.94026001 2105546.19436908 37.76146384633 -122.440931323073 (37.76146384633, -122.440931323073) 15 5 5 28862 3
2256 34592 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 7   Permit Number 38288 5999079.37666 2116641.84681 37.7918409959053 -122.447106431134 (37.7918409959053, -122.447106431134) 11 6 1 29490 30
2552 42536 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 95 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42642 6006853.97359683 2109407.99798814 37.7724197439799 -122.419692774816 (37.7724197439799, -122.419692774816) 8 2 9 28853 19
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
2831 67412 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 531 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2019 12:00:00 AM 3   Permit Number 30911 5989678.19598 2111713.94895 37.7777687473825 -122.479273498656 (37.7777687473825, -122.479273498656) 11 6 2 55 26
2844 45194 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 434 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/2001 12:00:00 AM 6   Permit Number 44039 6008463.06426 2114024.06162 37.7851848652278 -122.414453446982 (37.7851848652278, -122.414453446982) 7 10 9 28852 36
2980 62421 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 769 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/17/1986 12:00:00 AM 15   Permit Number 22736 5991633.13825 2110183.5333 37.773679990211 -122.472399147235 (37.773679990211, -122.472399147235) 11 6 2 54 26
3059 68742 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3926 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32663 6003444.16925552 2105388.01634751 37.7611891817503 -122.431200618374 (37.7611891817503, -122.431200618374) 15 4 5 28862 3
3477 259101 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
3692 62416 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 677 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/08/1985 12:00:00 AM 12   Permit Number 22573 5991607.27791 2110834.1835 37.7754650021114 -122.472536046895 (37.7754650021114, -122.472536046895) 11 6 2 54 26
3733 60222 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1200 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1982 12:00:00 AM 16   Permit Number 19772 6009437.72242 2117453.02752 37.7946546814167 -122.411323738797 (37.7946546814167, -122.411323738797) 3 1 10 28857 4
4046 43411 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 536 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43154 6002822.07551999 2103890.28570644 37.7570415002259 -122.433245151224 (37.7570415002259, -122.433245151224) 2 4 5 28862 3
4300 72086 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 287 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5988351.63673 2114094.10602 37.7842268528731 -122.484037051708 (37.7842268528731, -122.484037051708) 11 6 2 55 26
4330 68743 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3929 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32664 6003434.71793969 2105335.41306872 37.761044210169 -122.431229551523 (37.761044210169, -122.431229551523) 2 4 5 28862 3
4357 76336 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6015855.31224 2112664.17743 37.7818634332888 -122.388783363957 (37.7818634332888, -122.388783363957) 6 2 9 28856 6
4395 255228 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4406 68340 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 431 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 10   Permit Number 32157 5991217.62534 2112456.91618 37.7798980198622 -122.474002355247 (37.7798980198622, -122.474002355247) 11 6 2 54 26
4482 73980 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3   Permit Number 769778 6007997.42322 2113875.47963 37.7847507256189 -122.416053899389 (37.7847507256189, -122.416053899389) 7 10 9 28858 36
4532 70356 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1912 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6006535.5562 2117410.9094 37.7943758388735 -122.421362640608 (37.7943758388735, -122.421362640608) 13 9 10 28858 32
4667 75958 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2650 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009941.91637 2105516.75655 37.7619087513959 -122.408736667189 (37.7619087513959, -122.408736667189) 8 4 8 28859 19
4682 75924 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     6007948.10688 2114213.26854 37.7856754391124 -122.416248450599 (37.7856754391124, -122.416248450599) 13 10 9 28858 36
4756 80808 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6015600.52909 2102412.11891 37.7536993917283 -122.388948815828 (37.7536993917283, -122.388948815828) 10 3 8 28856 29
4834 255234 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 9 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4960 76355 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6015869.61058 2112665.8481 37.7818688130373 -122.388734014567 (37.7818688130373, -122.388734014567) 6 2 9 28856 6
5184 41797 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 18   Permit Number 42199 6011431.47132 2107642.26388 37.7678282330246 -122.403734417609 (37.7678282330246, -122.403734417609) 8 2 8 28853 20
5214 264633 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1222 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/04/2020 12:00:00 AM   4x6   6015226 2090508 37.7209923441218 -122.389412779223 (37.7209923441218, -122.389412779223) 10 3 8 58 1
5225 76274 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 753 Davis St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6013063.67102 2119100.92888 37.7993821215331 -122.398893108952 (37.7993821215331, -122.398893108952) 3 1 10 28860 6
5405 76328 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 753 Davis St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6013055.77037 2119154.19347 37.7995279331128 -122.398924188599 (37.7995279331128, -122.398924188599) 3 1 10 28860 6
5555 256038 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1563 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6015087 2093984 37.7305290408635 -122.390135976897 (37.7305290408635, -122.390135976897) 10 3 8 58 1
5699 62214 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 266 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM 17   Permit Number 22337 5988393.1262 2114211.29352 37.7845510318996 -122.483902110393 (37.7845510318996, -122.483902110393) 11 6 2 55 26
5709 62987 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 139 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/1986 12:00:00 AM 11   Permit Number 23387 5989577.1157 2114447.52745 37.7852685185368 -122.479823246943 (37.7852685185368, -122.479823246943) 11 6 2 55 26
5838 259349 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 244 Somerset St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6009793.70664 2093331.31107 37.7284418848055 -122.408389730347 (37.7284418848055, -122.408389730347) 10 3 7 309 28
5871 75838 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6011420.31077 2107843.20731 37.7683793546411 -122.403787161967 (37.7683793546411, -122.403787161967) 8 2 8 28853 20
5933 71780 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1080 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3   Permit Number 768726 6007445.70481 2115106.99549 37.7881011319113 -122.418050003112 (37.7881011319113, -122.418050003112) 13 1 10 28858 21
6184 64799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 450 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25798 6003587.23896685 2100132.28558533 37.7467662928737 -122.430330814023 (37.7467662928737, -122.430330814023) 2 7 5 63 22
6520 73325 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 141 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6008557.19392 2112976.99217 37.7823151519537 -122.414053685727 (37.7823151519537, -122.414053685727) 7 10 9 28852 36
6568 62216 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 275 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM 13   Permit Number 22339 5988348.59257 2114168.35653 37.7844305464846 -122.484053030045 (37.7844305464846, -122.484053030045) 11 6 2 55 26
6621 262544 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1146 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/18/2020 12:00:00 AM   3x3   6014979 2090344 37.7205283348361 -122.390255140049 (37.7205283348361, -122.390255140049) 10 3 8 58 1
6648 255227 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6801 41801 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42199 6011430.3722 2107669.42894 37.7679027607219 -122.403740131013 (37.7679027607219, -122.403740131013) 8 2 8 28853 20
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
7221 75198 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 675 17th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5990644.77295 2110703.64966 37.7750508336714 -122.475856010882 (37.7750508336714, -122.475856010882) 11 6 2 55 26
7273 72083 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 258 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5988389.53404 2114272.57287 37.7847190784909 -122.483919032846 (37.7847190784909, -122.483919032846) 11 6 2 55 26
7555 69133 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1624 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM 18   Permit Number 33160 6006948.32504 2116425.19331 37.7916925709073 -122.419864429405 (37.7916925709073, -122.419864429405) 13 9 10 28858 21
7573 64140 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 408 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24912 6003905.86029931 2098394.49493183 37.7420127636574 -122.429105167098 (37.7420127636574, -122.429105167098) 2 7 5 63 22
7699 75956 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2650 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6009924.38993 2105515.09453 37.7619032061973 -122.408797167259 (37.7619032061973, -122.408797167259) 8 4 8 28859 19
7805 75950 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007955.1578 2114181.95625 37.7855898596379 -122.416221837886 (37.7855898596379, -122.416221837886) 13 10 9 28858 36
7977 63890 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 165 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24599 6005777.74997654 2109961.71011831 37.7738794203064 -122.423454911884 (37.7738794203064, -122.423454911884) 7 9 11 28852 10
8336 75176 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 288 Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6009077.63424 2113593.69297 37.7840376819271 -122.412296788176 (37.7840376819271, -122.412296788176) 14 10 9 28852 36
8418 64139 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 523 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24910 6003239.38144538 2098311.93722578 37.7417483289476 -122.431403744863 (37.7417483289476, -122.431403744863) 2 7 5 63 7
8523 75002 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6015627.97358 2112537.98479 37.7815043339974 -122.389561041014 (37.7815043339974, -122.389561041014) 6 2 9 28856 6
8544 256668 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1835 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782601                    
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
9219 74232 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997684.08326 2115006.73382 37.7872715918672 -122.451816113239 (37.7872715918672, -122.451816113239) 11 6 1 54 31
9247 31823 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 201 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM 17   Permit Number 46493 6009289.61762 2110714.55017 37.7761441317862 -122.41135993383 (37.7761441317862, -122.41135993383) 8 2 9 28853 34

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