trees
8,659 rows where qSpecies_id = 11 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |
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 | |||
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 | |||
3675 | 192590 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008004 | 2110521 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | 8 | 2 | 9 | 28853 | 34 | |||
3797 | 260871 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
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 | |
4141 | 192575 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009254.82168 | 2110652.88864 | 37.7759728720816 | -122.411475945469 | (37.7759728720816, -122.411475945469) | 8 | 2 | 9 | 28853 | 34 | |||
4247 | 41540 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 775X 02nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42068 | 6015692.30699351 | 2111981.66601878 | 37.7799803743496 | -122.389299616981 | (37.7799803743496, -122.389299616981) | 6 | 2 | 9 | 28856 | 20 | |
4357 | 76336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015855.31224 | 2112664.17743 | 37.7818634332888 | -122.388783363957 | (37.7818634332888, -122.388783363957) | 6 | 2 | 9 | 28856 | 6 | |||
4421 | 15304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/10/2019 03:08:00 PM | 3 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.419408704778 | (37.7717697147956, -122.419408704778) | 8 | 2 | 9 | 28853 | 19 | ||
4482 | 73980 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 769778 | 6007997.42322 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | 7 | 10 | 9 | 28858 | 36 | ||
4571 | 192526 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1064 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009654 | 2112066 | 37.7798753251135 | -122.410194868954 | (37.7798753251135, -122.410194868954) | 14 | 2 | 9 | 28853 | 34 | |||
4648 | 200397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 8ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | |||
4682 | 75924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6007948.10688 | 2114213.26854 | 37.7856754391124 | -122.416248450599 | (37.7856754391124, -122.416248450599) | 13 | 10 | 9 | 28858 | 36 | |||
4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
4960 | 76355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6015869.61058 | 2112665.8481 | 37.7818688130373 | -122.388734014567 | (37.7818688130373, -122.388734014567) | 6 | 2 | 9 | 28856 | 6 | |||
5118 | 169123 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009469.52117 | 2113800.26568 | 37.7846268637924 | -122.410955591431 | (37.7846268637924, -122.410955591431) | 14 | 10 | 9 | 28852 | 36 | ||
5351 | 108330 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 86 11TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
5689 | 15213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1171 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 6 | 3X3 | 6008930.26718 | 2111302.55479 | 37.7777384921634 | -122.41264460546 | (37.7777384921634, -122.41264460546) | 8 | 2 | 9 | 28853 | 34 | ||
5858 | 191644 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012351.37316 | 2113981.62151 | 37.7852860020951 | -122.400998036035 | (37.7852860020951, -122.400998036035) | 12 | 2 | 9 | 28853 | 6 | |||
6075 | 15215 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1171 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 6 | 3X3 | 6008972.05843 | 2111339.16554 | 37.7778413620341 | -122.412502623208 | (37.7778413620341, -122.412502623208) | 8 | 2 | 9 | 28853 | 34 | ||
6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
6520 | 73325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6008557.19392 | 2112976.99217 | 37.7823151519537 | -122.414053685727 | (37.7823151519537, -122.414053685727) | 7 | 10 | 9 | 28852 | 36 | |||
6653 | 202390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015657.26603 | 2115099.16371 | 37.7885383750805 | -122.389638635413 | (37.7885383750805, -122.389638635413) | 6 | 2 | 9 | 28855 | 6 | |||
6778 | 28944 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 375 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2006 12:00:00 AM | 3 | 3x3 | 6009557.68758 | 2109521.72935 | 37.7728839562701 | -122.410348361997 | (37.7728839562701, -122.410348361997) | 8 | 2 | 9 | 28853 | 34 | ||
7053 | 93534 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 325 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
7314 | 249340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 839 Post St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008138.31912 | 2114803.99526 | 37.7873081250076 | -122.415632209079 | (37.7873081250076, -122.415632209079) | 13 | 1 | 9 | 28858 | 36 | |||
7773 | 202730 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 20 Long Bridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014698.52832 | 2109348.18499 | 37.7726942811501 | -122.39255330579 | (37.7726942811501, -122.39255330579) | 14 | 3 | 9 | 310 | 20 | |||
7805 | 75950 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007955.1578 | 2114181.95625 | 37.7855898596379 | -122.416221837886 | (37.7855898596379, -122.416221837886) | 13 | 10 | 9 | 28858 | 36 | |||
7968 | 28928 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 267 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 6009476.59536 | 2110522.60121 | 37.7756275701792 | -122.410699566146 | (37.7756275701792, -122.410699566146) | 8 | 2 | 9 | 28853 | 34 | ||
8263 | 28866 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013193.25193 | 2115823.02821 | 37.7903890018067 | -122.398214610023 | (37.7903890018067, -122.398214610023) | 12 | 2 | 9 | 28855 | 6 | ||
8336 | 75176 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 288 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009077.63424 | 2113593.69297 | 37.7840376819271 | -122.412296788176 | (37.7840376819271, -122.412296788176) | 14 | 10 | 9 | 28852 | 36 | |||
8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
8523 | 75002 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6015627.97358 | 2112537.98479 | 37.7815043339974 | -122.389561041014 | (37.7815043339974, -122.389561041014) | 6 | 2 | 9 | 28856 | 6 | |||
8621 | 202348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 234 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 3ft | 6013987.7588 | 2114901.70317 | 37.7879034797963 | -122.395401078311 | (37.7879034797963, -122.395401078311) | 6 | 2 | 9 | 28855 | 6 | ||
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 | |||
8972 | 23214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006727.4886023 | 2112541.6876005 | 37.7810169750537 | -122.42035276087 | (37.7810169750537, -122.42035276087) | 7 | 9 | 9 | 28852 | 36 | ||
9104 | 192527 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1064 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009654 | 2112066 | 37.7798753251135 | -122.410194868954 | (37.7798753251135, -122.410194868954) | 14 | 2 | 9 | 28853 | 34 | |||
9247 | 31823 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 17 | Permit Number 46493 | 6009289.61762 | 2110714.55017 | 37.7761441317862 | -122.41135993383 | (37.7761441317862, -122.41135993383) | 8 | 2 | 9 | 28853 | 34 | |
9352 | 200404 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 325 09th St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6009328.24749 | 2109756.9252 | 37.7735168847176 | -122.411158642161 | (37.7735168847176, -122.411158642161) | 8 | 2 | 9 | 28853 | 34 | |||
9539 | 202541 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 128 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015188.49279 | 2112122.3947 | 37.7803388396032 | -122.391052389471 | (37.7803388396032, -122.391052389471) | 6 | 2 | 9 | 28856 | 6 | |||
9750 | 169122 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009478.56357 | 2113738.5186 | 37.7844578281201 | -122.410919945006 | (37.7844578281201, -122.410919945006) | 14 | 10 | 9 | 28852 | 36 | ||
9875 | 23182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006776.0786915 | 2112192.9314348 | 37.7800621132124 | -122.42015990463 | (37.7800621132124, -122.42015990463) | 7 | 9 | 9 | 28852 | 36 | ||
9891 | 53917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 308 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1988 12:00:00 AM | 16 | Permit Number 25579 | 6008884.50238 | 2113564.96808 | 37.783947970966 | -122.412962925017 | (37.783947970966, -122.412962925017) | 7 | 10 | 9 | 28852 | 36 | |
9895 | 130101 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 01:58:00 PM | 2 | Width 4ft | 6008550.81103 | 2113028.31881 | 37.7824557240915 | -122.414079400045 | (37.7824557240915, -122.414079400045) | 7 | 10 | 9 | 28852 | 36 | ||
9927 | 83681 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009001.7145 | 2113646.06927 | 37.7841772342254 | -122.412563147579 | (37.7841772342254, -122.412563147579) | 14 | 10 | 9 | 28852 | 36 | |||
10354 | 43417 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 246 02nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43159 | 6013405.28311 | 2114204.36675 | 37.7859563423666 | -122.39736742979 | (37.7859563423666, -122.39736742979) | 6 | 2 | 9 | 28855 | 6 | ||
10415 | 43967 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43534 | 6006999.24602912 | 2112908.87547401 | 37.7820404937398 | -122.419438672428 | (37.7820404937398, -122.419438672428) | 7 | 9 | 9 | 28852 | 36 | |||
10465 | 75257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007991.6501 | 2114435.56963 | 37.7862882722428 | -122.416113552304 | (37.7862882722428, -122.416113552304) | 13 | 1 | 9 | 28858 | 36 | |||
10479 | 30512 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 340 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1995 12:00:00 AM | 12 | Permit Number 34525 | 6008741.77827 | 2113543.53334 | 37.7838811036663 | -122.413455183303 | (37.7838811036663, -122.413455183303) | 7 | 10 | 9 | 28852 | 36 | ||
10562 | 73885 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 350 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6014508.75776 | 2112348.63961 | 37.7809223143414 | -122.393419764809 | (37.7809223143414, -122.393419764809) | 6 | 2 | 9 | 28856 | 6 | |||
10574 | 80213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1522 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007910.8791 | 2109536.30897 | 37.7728315356664 | -122.416045915185 | (37.7728315356664, -122.416045915185) | 8 | 2 | 9 | 28853 | 19 | |||
10591 | 202779 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 77 Long Bridge St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014760.52181 | 2109341.40612 | 37.7726791104876 | -122.392338387631 | (37.7726791104876, -122.392338387631) | 14 | 3 | 9 | 310 | 20 | |||
10636 | 192525 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1064 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6009654 | 2112066 | 37.7798753251135 | -122.410194868954 | (37.7798753251135, -122.410194868954) | 14 | 2 | 9 | 28853 | 34 | |||
10695 | 258140 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | ||
11295 | 202609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 779780 | 6011126.85654 | 2109894.99849 | 37.7739967054258 | -122.404946679448 | (37.7739967054258, -122.404946679448) | 14 | 2 | 9 | 28853 | 34 | |
11331 | 80222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1032 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6010303.37801 | 2111828.67661 | 37.7792600686485 | -122.407931631844 | (37.7792600686485, -122.407931631844) | 14 | 2 | 9 | 28853 | 34 | |||
11376 | 200398 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011323 | 2110932 | 37.776855034552 | -122.404341187165 | (37.776855034552, -122.404341187165) | 14 | 2 | 9 | 28853 | 34 | |||
11379 | 75978 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6007956.14824 | 2114165.55971 | 37.7855448944115 | -122.416217249547 | (37.7855448944115, -122.416217249547) | 13 | 10 | 9 | 28858 | 36 | |||
11471 | 260869 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
11703 | 202393 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015702.17512 | 2115143.19393 | 37.7886617620833 | -122.389486331656 | (37.7886617620833, -122.389486331656) | 6 | 2 | 9 | 28855 | 6 | |||
11779 | 44518 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100X TOWNSEND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 9 | 3x3 | Permit Number 43820 | 6015218.7 | 2112179.2 | 37.7804964903429 | -122.390951859139 | (37.7804964903429, -122.390951859139) | 6 | 2 | 9 | 28856 | 6 | |
11815 | 192587 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008090.62264 | 2110584.41429 | 37.7757194889955 | -122.415498377362 | (37.7757194889955, -122.415498377362) | 8 | 2 | 9 | 28853 | 34 | |||
12295 | 108536 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 1036X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009831.24398 | 2112235.16984 | 37.7803497589148 | -122.409593644194 | (37.7803497589148, -122.409593644194) | 14 | 2 | 9 | 28853 | 34 | ||||
12452 | 130093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 70 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008660.01542 | 2112613.42872 | 37.7813226682591 | -122.413672244582 | (37.7813226682591, -122.413672244582) | 7 | 10 | 9 | 28852 | 36 | |||
12524 | 29159 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 532 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 8 | 3x3 | 6008904.683107 | 2114354.7787345 | 37.7861177338401 | -122.412948968266 | (37.7861177338401, -122.412948968266) | 5 | 10 | 9 | 28852 | 36 | ||
12650 | 92885 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1366 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2009 12:00:00 AM | 3x3 | Permit Number 53100 | 6008075 | 2110545 | 37.7756103885853 | -122.415549628976 | (37.7756103885853, -122.415549628976) | 8 | 2 | 9 | 28853 | 34 | |
12748 | 75994 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007959.81163 | 2114150.16473 | 37.7855028295219 | -122.416203484529 | (37.7855028295219, -122.416203484529) | 13 | 10 | 9 | 28858 | 36 | |||
12763 | 202571 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 728 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012197.01829 | 2110136.24558 | 37.7747188771942 | -122.401261742457 | (37.7747188771942, -122.401261742457) | 14 | 2 | 9 | 28853 | 34 | |||
12790 | 191613 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 202 Jessie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011974.62779 | 2114590.53506 | 37.7869369127497 | -122.402344296849 | (37.7869369127497, -122.402344296849) | 12 | 2 | 9 | 28855 | 6 | |||
12801 | 30518 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 409 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1995 12:00:00 AM | 5 | Permit Number 34527 | 6008424.27484 | 2113452.85192 | 37.7836142820115 | -122.41454721209 | (37.7836142820115, -122.41454721209) | 7 | 10 | 9 | 28852 | 36 | |
12862 | 192569 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1252 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008605.90777 | 2111078.72326 | 37.7771056940974 | -122.413750843528 | (37.7771056940974, -122.413750843528) | 8 | 2 | 9 | 28853 | 34 | |||
12907 | 57882 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 285 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1991 12:00:00 AM | Permit Number 16832 | 6008642.54194369 | 2113136.6674883 | 37.7827583753423 | -122.413769716445 | (37.7827583753423, -122.413769716445) | 7 | 10 | 9 | 28852 | 36 | ||
13148 | 202819 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014749.23519 | 2108723.69225 | 37.770982378473 | -122.392334217477 | (37.770982378473, -122.392334217477) | 14 | 3 | 9 | 310 | 20 | |||
13438 | 41722 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 232 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42170 | 6009584.56743913 | 2109048.70213008 | 37.7715866403458 | -122.410221977607 | (37.7715866403458, -122.410221977607) | 8 | 2 | 9 | 28853 | 34 | ||
13562 | 73666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007366.22469 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | 7 | 9 | 9 | 28858 | 36 | |||
13670 | 82752 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 955 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52442 | 6008071.60927 | 2109939.40824 | 37.7739473865897 | -122.41551847362 | (37.7739473865897, -122.41551847362) | 8 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );