trees
8,659 rows where qSpecies_id = 11 sorted by PlantType 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
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 | |||
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 | |
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
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 |
843 | 38804 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
958 | 36868 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
963 | 109935 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011302 | 2112245.5 | 37.7804604268654 | -122.404506314811 | (37.7804604268654, -122.404506314811) | 14 | 2 | 9 | 28853 | 34 | |
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 | ||
1017 | 46142 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
1023 | 228184 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776221 | 6006352.00962 | 2102676.26299 | 37.7539076917969 | -122.420951082919 | (37.7539076917969, -122.420951082919) | 2 | 4 | 5 | 28859 | 19 | ||
1036 | 82363 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1455 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49901 | 6007633.52614619 | 2107338.64546667 | 37.7667816713746 | -122.416849584537 | (37.7667816713746, -122.416849584537) | 8 | 4 | 7 | 28853 | 19 | ||
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 | ||
1183 | 47616 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
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 | |||||||||||||
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 | ||||
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 | |||||||||||||||
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 | ||
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 | |
1602 | 45381 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
1665 | 47611 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | Permit Number 45444 | |||||||||||||
1676 | 84541 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 838 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51852 | 5986369.18358167 | 2110196.92433931 | 37.7734106873115 | -122.49060871536 | (37.7734106873115, -122.49060871536) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||||
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 | |
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 | |||
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 | ||
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 | ||
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 | |||
2283 | 49626 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46481 | |||||||||||||
2296 | 32307 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
2310 | 91800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
2315 | 87492 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2085 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2010 12:00:00 AM | 3 | 3x3 | 6015789.87829 | 2105903.76161 | 37.7632971922443 | -122.388537703233 | (37.7632971922443, -122.388537703233) | 14 | 3 | 8 | 28856 | 29 | ||
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 | |||
2403 | 60302 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1200 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1982 12:00:00 AM | 3x3 | Permit Number 19869 | 5992068.87064248 | 2106619.25975245 | 37.7639186591654 | -122.470632238353 | (37.7639186591654, -122.470632238353) | 11 | 8 | 11 | 56 | 12 | ||
2484 | 20118 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 875X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 12 | 2X2 | 6003233.15229 | 2110304.12624 | 37.774675660821 | -122.432281545934 | (37.774675660821, -122.432281545934) | 15 | 9 | 11 | 29492 | 10 | ||
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 | |||
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 | ||
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 | |||
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 | ||
2630 | 47383 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1515 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | Permit Number 46367 | 6006307.07862293 | 2118296.63950756 | 37.7967949468883 | -122.422216159163 | (37.7967949468883, -122.422216159163) | 13 | 9 | 10 | 28858 | 32 | |||
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 |
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) );