trees
8,659 rows where qSpecies_id = 11 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );