trees
8,659 rows where qSpecies_id = 11 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14 | 162252 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 789 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | Width 0ft | 6011428.3902 | 2091205.22693 | 37.7226955033817 | -122.402589068938 | (37.7226955033817, -122.402589068938) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 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 | |||
| 134 | 257900 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5701x 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
| 240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
| 254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
| 418 | 191568 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6015230.3015 | 2097471.78413 | 37.7401137346697 | -122.389884091895 | (37.7401137346697, -122.389884091895) | 10 | 3 | 8 | 58 | 1 | |||
| 441 | 200380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 199x Shipley St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6011866.27149 | 2112076.32254 | 37.7800274232626 | -122.402542323073 | (37.7800274232626, -122.402542323073) | 6 | 2 | 9 | 28856 | 34 | |||
| 490 | 201018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2427 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6015837.6438 | 2104277.44784 | 37.7588343299688 | -122.388258987278 | (37.7588343299688, -122.388258987278) | 10 | 3 | 8 | 28856 | 29 | |||
| 496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
| 516 | 228148 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006164.28194 | 2098136.5344 | 37.7414320472565 | -122.421277938832 | (37.7414320472565, -122.421277938832) | 2 | 7 | 7 | 28859 | 2 | |||
| 546 | 166267 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3574 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006475.94954 | 2104385.51361 | 37.7586078842643 | -122.420643797174 | (37.7586078842643, -122.420643797174) | 2 | 4 | 7 | 28859 | 19 | ||
| 547 | 228103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 572 | 130258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007346.42047 | 2122267.68592 | 37.8077570059352 | -122.418901572974 | (37.8077570059352, -122.418901572974) | 5 | 1 | 10 | 308 | 23 | |||
| 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 | |
| 707 | 27746 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | |||
| 714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
| 769 | 35030 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 403 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1998 12:00:00 AM | 15 | Permit Number 38603 | 6015647.17286 | 2114807.4956 | 37.7877369613497 | -122.389653177477 | (37.7877369613497, -122.389653177477) | 6 | 2 | 9 | 28855 | 6 | ||
| 773 | 229088 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Putnam St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009105.76853 | 2096334.59005 | 37.7366496963122 | -122.410980013421 | (37.7366496963122, -122.410980013421) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |
| 986 | 208414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 37 San Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993601.90689 | 2097555.83156 | 37.7391213363856 | -122.464671780704 | (37.7391213363856, -122.464671780704) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||
| 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 | |||
| 1124 | 11393 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1453 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2002 12:00:00 AM | 12 | 3X4 | 6016297.11363 | 2096598.00075 | 37.7377736069734 | -122.386134557472 | (37.7377736069734, -122.386134557472) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 1160 | 122663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | ||||||||||||
| 1164 | 24021 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 21 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/1995 12:00:00 AM | 3 | 3X4 | 6017459.387304 | 2095522.0819228 | 37.7348836077988 | -122.382041153064 | (37.7348836077988, -122.382041153064) | 10 | 3 | 8 | 58 | 1 | ||
| 1197 | 200396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 2 | Width 8ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | ||
| 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 | |||
| 1263 | 15197 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1110 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/1995 12:00:00 AM | 12 | 3X3 | 6009340.5816959 | 2111773.3907707 | 37.7790543166113 | -122.411258449881 | (37.7790543166113, -122.411258449881) | 8 | 2 | 9 | 28853 | 34 | ||
| 1310 | 173924 | 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 | 3x3 | |||||||||||||
| 1384 | 261534 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 711 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982242 | 2110896 | 37.7750882045317 | -122.504936800561 | (37.7750882045317, -122.504936800561) | 11 | 6 | 2 | 55 | 26 | ||
| 1393 | 255136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | ||
| 1488 | 202330 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013774.7833 | 2115928.84741 | 37.7907119312625 | -122.396209955548 | (37.7907119312625, -122.396209955548) | 12 | 2 | 9 | 28855 | 6 | ||
| 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 | |||
| 1704 | 29288 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998060.68791 | 2099984.96724 | 37.7460471998142 | -122.449430386304 | (37.7460471998142, -122.449430386304) | 2 | 7 | 5 | 63 | 7 | ||
| 1713 | 162247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 51 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011515.69266 | 2091168.60243 | 37.7225998137043 | -122.402284707783 | (37.7225998137043, -122.402284707783) | 10 | 3 | 7 | 309 | 28 | ||
| 1719 | 65271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 642 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | 10 | Permit Number 28073 | 6011614.69631 | 2117224.41681 | 37.7941488271457 | -122.403774986938 | (37.7941488271457, -122.403774986938) | 3 | 1 | 10 | 28860 | 4 | ||
| 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 | ||
| 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 | |||
| 1791 | 202438 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015393.28137 | 2113192.42013 | 37.7832882498865 | -122.390418710082 | (37.7832882498865, -122.390418710082) | 6 | 2 | 9 | 28856 | 6 | |||
| 1804 | 261532 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 623 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | 5982220 | 2111497 | 37.7767370803265 | -122.505057450493 | (37.7767370803265, -122.505057450493) | 11 | 6 | 2 | 55 | 26 | |||
| 1843 | 24515 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2016 07:40:00 AM | 3 | 3X3 | 5997710.2902 | 2109583.0289 | 37.7723810166729 | -122.45133412385 | (37.7723810166729, -122.45133412385) | 15 | 5 | 11 | 29492 | 16 | ||
| 1849 | 208186 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993614.60334 | 2106421.09061 | 37.7634638006461 | -122.465271659973 | (37.7634638006461, -122.465271659973) | 1 | 8 | 11 | 56 | 12 | |||
| 1865 | 250727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | 11 | 6 | 1 | 55 | 33 | |||
| 1876 | 264664 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1091 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014392.13173 | 2090011.55148 | 37.7195829270923 | -122.392260533781 | (37.7195829270923, -122.392260533781) | 10 | 3 | 8 | 58 | 1 | |||
| 1887 | 151814 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 77 Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 3ft | 6006579.67986 | 2106248.76891 | 37.7637297940129 | -122.420417302916 | (37.7637297940129, -122.420417302916) | 8 | 4 | 7 | 28859 | 19 | ||
| 1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
| 1893 | 202466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6015364.08596 | 2113980.86874 | 37.7854515313193 | -122.390574827864 | (37.7854515313193, -122.390574827864) | 6 | 2 | 9 | 28856 | 6 | |||
| 1906 | 208208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5992145.29638 | 2096590.12464 | 37.7363856661623 | -122.469637749802 | (37.7363856661623, -122.469637749802) | 1 | 8 | 4 | 59 | 40 | |||
| 1911 | 22930 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 360 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/1997 12:00:00 AM | 6 | 3X3 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |
| 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 | |||
| 2143 | 35031 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 403 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1998 12:00:00 AM | 16 | Permit Number 38603 | 6015552.5764 | 2114910.07467 | 37.7880133742625 | -122.389987634449 | (37.7880133742625, -122.389987634449) | 6 | 2 | 9 | 28855 | 6 | ||
| 2202 | 29373 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |
| 2207 | 26390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6007069.43005 | 2109322.62762 | 37.7721974718223 | -122.418941432593 | (37.7721974718223, -122.418941432593) | 8 | 2 | 9 | 28853 | 19 | |||
| 2242 | 122950 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |
| 2281 | 202367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015662.52454 | 2115317.40495 | 37.7891379072269 | -122.389635690147 | (37.7891379072269, -122.389635690147) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 2514 | 130116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008620.49903 | 2113131.73284 | 37.782743588087 | -122.413845626693 | (37.782743588087, -122.413845626693) | 7 | 10 | 9 | 28852 | 36 | |||
| 2585 | 29556 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3030 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406 | 37.7201955090298 | -122.392114704117 | (37.7201955090298, -122.392114704117) | 10 | 3 | 8 | 58 | 1 | |||
| 2709 | 140325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.427951167196 | (37.7844794061151, -122.427951167196) | 13 | 9 | 11 | 29490 | 41 | |||
| 2747 | 129970 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 245 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009400.62978 | 2113906.25304 | 37.7849140164063 | -122.411201422913 | (37.7849140164063, -122.411201422913) | 14 | 10 | 9 | 28852 | 36 | |||
| 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 | |
| 2855 | 201591 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.17806 | 37.7283237638216 | -122.37051506831 | (37.7283237638216, -122.37051506831) | 10 | 3 | 8 | 58 | 1 | |
| 2887 | 255158 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3098 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | |||||||||||||
| 2892 | 52020 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50061 | 6009007.02458 | 2115965.45342 | 37.7905460009358 | -122.41270880089 | (37.7905460009358, -122.41270880089) | 5 | 1 | 10 | 28858 | 21 | |
| 2899 | 32085 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3933 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | 14 | Permit Number 35458 | 6003385.91589 | 2105339.01194 | 37.7610513260832 | -122.431398593479 | (37.7610513260832, -122.431398593479) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 2952 | 23021 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 873 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006311.34363 | 2104526.62224 | 37.7589860572745 | -122.42122309997 | (37.7589860572745, -122.42122309997) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 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 | |
| 2995 | 202498 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015682.27104 | 2112499.834 | 37.7814025909853 | -122.389370531319 | (37.7814025909853, -122.389370531319) | 6 | 2 | 9 | 28856 | 20 | |||
| 3004 | 202458 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015309.25216 | 2113889.9179 | 37.7851987588479 | -122.390758179856 | (37.7851987588479, -122.390758179856) | 6 | 2 | 9 | 28856 | 6 | |||
| 3107 | 227314 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4329 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2020 12:00:00 AM | 3 | 3x3 | 6000917.153 | 2102277.61106 | 37.752505237738 | -122.439717467211 | (37.752505237738, -122.439717467211) | 2 | 4 | 5 | 28862 | 22 | ||
| 3146 | 27755 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1299 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2002 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 3261 | 177171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012633.43776 | 2088096.17328 | 37.7142258700001 | -122.398205432431 | (37.7142258700001, -122.398205432431) | 10 | 3 | 8 | 309 | 1 | |||
| 3274 | 23104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1417 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1992 12:00:00 AM | 20 | 3X3 | 6006489.94446 | 2101312.55607 | 37.7501710392837 | -122.420377283985 | (37.7501710392837, -122.420377283985) | 2 | 4 | 7 | 28859 | 19 | ||
| 3397 | 228679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 190 Storrie St | 18 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000815.50706 | 2105314.68104 | 37.7608385069212 | -122.440286756929 | (37.7608385069212, -122.440286756929) | 15 | 4 | 5 | 28862 | 3 | |||
| 3403 | 228171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Powhattan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6008190.97242 | 2098122.00574 | 37.7415062071578 | -122.414269294615 | (37.7415062071578, -122.414269294615) | 2 | 7 | 7 | 28859 | 2 | |||
| 3455 | 122949 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||||||||||||
| 3490 | 128009 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 490 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 02:34:00 PM | 3 | Width 3ft | 6008457.49636 | 2121430.59221 | 37.8055210575117 | -122.414997125824 | (37.8055210575117, -122.414997125824) | 3 | 1 | 10 | 308 | 23 | ||
| 3504 | 202818 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014769.41047 | 2108724.81118 | 37.7709865710896 | -122.392264508307 | (37.7709865710896, -122.392264508307) | 14 | 3 | 9 | 310 | 20 | |||
| 3513 | 117891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982566.38409 | 2112290.68382 | 37.7789366773187 | -122.503918023894 | (37.7789366773187, -122.503918023894) | 11 | 6 | 2 | 55 | 26 | |||
| 3564 | 29260 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999192.47139 | 2100264.06623 | 37.7468782156517 | -122.445536908226 | (37.7468782156517, -122.445536908226) | 2 | 7 | 5 | 63 | 22 |
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) );