trees
8,659 rows where qSpecies_id = 11 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
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 | |||||||||||
8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
18098 | 259796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Somerset St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010266.31037 | 2091928.95171 | 37.7246177539405 | -122.406657122403 | (37.7246177539405, -122.406657122403) | 10 | 3 | 7 | 309 | 28 | |||
27569 | 86819 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1010 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49755 | 5995086.4 | 2090661.6 | 37.7202769199461 | -122.45904005327 | (37.7202769199461, -122.45904005327) | 9 | 8 | 6 | 28861 | 24 | ||||
29897 | 86721 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.7820531563646 | -122.392834816441 | (37.7820531563646, -122.392834816441) | 6 | 2 | 9 | 28856 | 6 | ||||
33510 | 97172 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008094.3658 | 2110608.12589 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | 8 | 2 | 9 | 28853 | 34 | ||||||
64688 | 52995 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1810 PINE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2006 12:00:00 AM | 3x3 | Permit Number 48976 | 6005259 | 2115487 | 37.7890212126999 | -122.425642684361 | (37.7890212126999, -122.425642684361) | 13 | 9 | 1 | 28858 | 27 | |||
76156 | 97171 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008094.3658 | 2110608.12589 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | 8 | 2 | 9 | 28853 | 34 | ||||||
98272 | 88425 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 999 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51391 | 6001075 | 2114514 | 37.7861122979784 | -122.440048944558 | (37.7861122979784, -122.440048944558) | 15 | 6 | 1 | 29490 | 27 | |||
105564 | 173929 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 High St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999870 | 2100717 | 37.7481605193068 | -122.443226610241 | (37.7481605193068, -122.443226610241) | 2 | 4 | 5 | 63 | 22 | |||||
121652 | 86719 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.7820531563646 | -122.392834816441 | (37.7820531563646, -122.392834816441) | 6 | 2 | 9 | 28856 | 6 | ||||
140267 | 86720 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.7820531563646 | -122.392834816441 | (37.7820531563646, -122.392834816441) | 6 | 2 | 9 | 28856 | 6 | ||||
142957 | 88135 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 184 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51163 | 5998299 | 2096312 | 37.7359757467102 | -122.448341887106 | (37.7359757467102, -122.448341887106) | 9 | 7 | 4 | 59 | 40 | |||
151632 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
152694 | 255719 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
159737 | 255720 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
164067 | 255486 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1145 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781956 | 6007615.88792 | 2116302.6982 | 37.7913938147597 | -122.417545974724 | (37.7913938147597, -122.417545974724) | 5 | 1 | 10 | 28858 | 21 | |
166990 | 255718 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
173947 | 89241 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 608 Webster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51878 | 6004068.2 | 2110881.6 | 37.7763085740745 | -122.429434138372 | (37.7763085740745, -122.429434138372) | 7 | 9 | 11 | 28852 | 10 | |||
175635 | 106332 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1160 MISSION ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 778325 | 6009057.1 | 2111529.8 | 37.7783695713182 | -122.412221910581 | (37.7783695713182, -122.412221910581) | 8 | 2 | 9 | 28853 | 34 | |||
26056 | 192728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1485 Innes Ave | 0 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016125.11301 | 2096726.19867 | 37.7381160912922 | -122.386738189609 | (37.7381160912922, -122.386738189609) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||||||||||
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 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | |||||||||||||
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 | |||
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 | ||
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 | ||
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 | |
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 | |
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 | ||
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 | |||
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 | |||
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 | ||
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 | |
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 | |
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 | |||||||||||||
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
2944 | 97145 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2001X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.413171184614 | (37.7654035712889, -122.413171184614) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
3437 | 79 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 899 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3X3 | 6002864.3199934 | 2107660.1796498 | 37.7673951141913 | -122.433368437593 | (37.7673951141913, -122.433368437593) | 15 | 5 | 5 | 28862 | 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 | ||
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 | |||
3570 | 228639 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 393 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002974.70416 | 2105985.24173 | 37.7628024032403 | -122.432866963362 | (37.7628024032403, -122.432866963362) | 15 | 4 | 5 | 28862 | 3 | |||
3575 | 130205 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1033 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009172.7127 | 2117683.88931 | 37.7952737045641 | -122.412257035446 | (37.7952737045641, -122.412257035446) | 3 | 1 | 10 | 28857 | 21 | |||
3586 | 217748 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 611 Frederick St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5996609.14457 | 2107297.9343 | 37.766043624629 | -122.45497792451 | (37.766043624629, -122.45497792451) | 15 | 5 | 11 | 29492 | 12 | |||
3616 | 7957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.7912122663809 | -122.424102272302 | (37.7912122663809, -122.424102272302) | 13 | 9 | 1 | 28858 | 27 | ||
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 | |
3861 | 92129 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1119 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52490 | 6009318.00263 | 2111672.54463 | 37.7787761506237 | -122.41132943422 | (37.7787761506237, -122.41132943422) | 8 | 2 | 9 | 28853 | 34 | |
3868 | 259094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
3877 | 228942 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009177.01611 | 2108023.17078 | 37.7687479166233 | -122.411559257765 | (37.7687479166233, -122.411559257765) | 8 | 4 | 7 | 28853 | 19 | |||
3879 | 260548 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776221 | |||||||||||
3927 | 228050 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008750.70184 | 2106410.9206 | 37.7642971286338 | -122.412919846582 | (37.7642971286338, -122.412919846582) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||
4118 | 60587 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1596 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 3x3 | Permit Number 50372 | 6000129.25218727 | 2110962.46444115 | 37.7763068086663 | -122.443065816912 | (37.7763068086663, -122.443065816912) | 15 | 5 | 11 | 29492 | 16 |
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) );