trees
8,659 rows where qSpecies_id = 11
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 4968 | 228582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3380 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007681.5536 | 2104447.74743 | 37.7588466371903 | -122.41647866898 | (37.7588466371903, -122.41647866898) | 2 | 4 | 7 | 28859 | 19 | |||
| 4975 | 251136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
| 4997 | 255137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 5074 | 22216 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4250X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6015384.98643 | 2097123.18461 | 37.7391651289337 | -122.389324913037 | (37.7391651289337, -122.389324913037) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 5124 | 208248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993720.3367 | 2097534.6228 | 37.739069929337 | -122.464260768027 | (37.739069929337, -122.464260768027) | 1 | 8 | 4 | 59 | 40 | |||
| 5131 | 172199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003534.5249 | 2091291.61932 | 37.7224888445726 | -122.429882596429 | (37.7224888445726, -122.429882596429) | 9 | 7 | 6 | 28861 | 5 | |||
| 5137 | 22068 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2955 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1997 12:00:00 AM | 8 | 3X3 | 6015998.15258 | 2101816.1551 | 37.7520850322075 | -122.387532157908 | (37.7520850322075, -122.387532157908) | 10 | 3 | 8 | 28856 | 1 | ||
| 5184 | 41797 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 18 | Permit Number 42199 | 6011431.47132 | 2107642.26388 | 37.7678282330246 | -122.403734417609 | (37.7678282330246, -122.403734417609) | 8 | 2 | 8 | 28853 | 20 | |
| 5214 | 264633 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1222 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2020 12:00:00 AM | 4x6 | 6015226 | 2090508 | 37.7209923441218 | -122.389412779223 | (37.7209923441218, -122.389412779223) | 10 | 3 | 8 | 58 | 1 | ||
| 5225 | 76274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6013063.67102 | 2119100.92888 | 37.7993821215331 | -122.398893108952 | (37.7993821215331, -122.398893108952) | 3 | 1 | 10 | 28860 | 6 | |||
| 5312 | 4705 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | 3 | 1 | 10 | 308 | 23 | ||
| 5327 | 208187 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 614 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992619.53239 | 2105964.8476 | 37.7621536431042 | -122.468680060852 | (37.7621536431042, -122.468680060852) | 1 | 8 | 11 | 56 | 12 | |||
| 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 | ||||
| 5377 | 208380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2153 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990986.04746 | 2100741.87447 | 37.747718234628 | -122.473948530418 | (37.747718234628, -122.473948530418) | 1 | 8 | 4 | 29491 | 40 | |||
| 5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
| 5386 | 262533 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
| 5405 | 76328 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013055.77037 | 2119154.19347 | 37.7995279331128 | -122.398924188599 | (37.7995279331128, -122.398924188599) | 3 | 1 | 10 | 28860 | 6 | |||
| 5555 | 256038 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6015087 | 2093984 | 37.7305290408635 | -122.390135976897 | (37.7305290408635, -122.390135976897) | 10 | 3 | 8 | 58 | 1 | ||
| 5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
| 5660 | 24445 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2251X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6015765.11922 | 2105348.0588 | 37.7617699797552 | -122.388584545263 | (37.7617699797552, -122.388584545263) | 10 | 3 | 8 | 28856 | 29 | ||
| 5686 | 129917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004089.66416 | 2110540.0338 | 37.7753719324971 | -122.429335525339 | (37.7753719324971, -122.429335525339) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 5691 | 228657 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001411.17707 | 2104612.02532 | 37.7589430822727 | -122.438176265734 | (37.7589430822727, -122.438176265734) | 2 | 4 | 5 | 28862 | 3 | |||
| 5699 | 62214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 17 | Permit Number 22337 | 5988393.1262 | 2114211.29352 | 37.7845510318996 | -122.483902110393 | (37.7845510318996, -122.483902110393) | 11 | 6 | 2 | 55 | 26 | |
| 5709 | 62987 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 139 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 11 | Permit Number 23387 | 5989577.1157 | 2114447.52745 | 37.7852685185368 | -122.479823246943 | (37.7852685185368, -122.479823246943) | 11 | 6 | 2 | 55 | 26 | |
| 5711 | 253201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:09:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
| 5749 | 214100 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:56:00 PM | 3 | Width 3ft | 5996085.5249 | 2091194.13993 | 37.7217965338776 | -122.455624901296 | (37.7217965338776, -122.455624901296) | 9 | 8 | 6 | 28861 | 24 | ||
| 5759 | 47617 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
| 5778 | 228654 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4244 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001858.18826 | 2104709.38537 | 37.7592358223878 | -122.436637263122 | (37.7592358223878, -122.436637263122) | 2 | 4 | 5 | 28862 | 3 | |||
| 5838 | 259349 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 244 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6009793.70664 | 2093331.31107 | 37.7284418848055 | -122.408389730347 | (37.7284418848055, -122.408389730347) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | |||
| 5871 | 75838 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6011420.31077 | 2107843.20731 | 37.7683793546411 | -122.403787161967 | (37.7683793546411, -122.403787161967) | 8 | 2 | 8 | 28853 | 20 | |||
| 5896 | 68729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32645 | 5998785.51386128 | 2099959.35584866 | 37.7460183133905 | -122.446922200801 | (37.7460183133905, -122.446922200801) | 2 | 7 | 5 | 63 | 7 | |||
| 5899 | 228878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004644.50049 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | 7 | 9 | 11 | 28852 | 10 | |||
| 5911 | 228080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 890 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999913.84424 | 2100703.76258 | 37.7481266725268 | -122.443074048252 | (37.7481266725268, -122.443074048252) | 2 | 4 | 5 | 63 | 22 | |||
| 5920 | 4544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Cleary Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 5933 | 71780 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 768726 | 6007445.70481 | 2115106.99549 | 37.7881011319113 | -122.418050003112 | (37.7881011319113, -122.418050003112) | 13 | 1 | 10 | 28858 | 21 | ||
| 5944 | 130091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 740 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005787.47808 | 2112322.76962 | 37.780362864998 | -122.423589158734 | (37.780362864998, -122.423589158734) | 7 | 9 | 11 | 28852 | 41 | |||
| 5966 | 229069 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997862.26563 | 2106825.97053 | 37.7648195394167 | -122.450609621445 | (37.7648195394167, -122.450609621445) | 15 | 5 | 11 | 29492 | 9 | |||
| 6050 | 11026 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1435 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2019 12:43:00 PM | 3 | 3x3 | 6007476.45198 | 2117303.69577 | 37.7941344595897 | -122.418099417266 | (37.7941344595897, -122.418099417266) | 5 | 1 | 10 | 28858 | 32 | ||
| 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 | |
| 6105 | 130370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011756.98576 | 2121020.06086 | 37.8045786948161 | -122.403549821892 | (37.8045786948161, -122.403549821892) | 3 | 1 | 10 | 28860 | 6 | |||
| 6123 | 19258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1868X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001940.6587 | 2112948.30853 | 37.7818625502091 | -122.436941871627 | (37.7818625502091, -122.436941871627) | 15 | 5 | 11 | 29490 | 41 | |||
| 6184 | 64799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25798 | 6003587.23896685 | 2100132.28558533 | 37.7467662928737 | -122.430330814023 | (37.7467662928737, -122.430330814023) | 2 | 7 | 5 | 63 | 22 | ||
| 6231 | 46141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 6263 | 200452 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014967.99048 | 2103722.97568 | 37.7572636433306 | -122.391227918229 | (37.7572636433306, -122.391227918229) | 10 | 3 | 8 | 28856 | 29 | |||
| 6287 | 6206 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1155 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005354.90901 | 2113296.39872 | 37.7830117847389 | -122.425154916389 | (37.7830117847389, -122.425154916389) | 7 | 9 | 11 | 28858 | 41 | |||
| 6372 | 160064 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:44:00 PM | 3 | Width 0ft | 6000438.16193 | 2090795.67407 | 37.7209512565735 | -122.440550438153 | (37.7209512565735, -122.440550438153) | 9 | 7 | 6 | 28861 | 25 | ||
| 6375 | 138396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 PINE ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002330.0089 | 2115035.313 | 37.7876150559957 | -122.43574426598 | (37.7876150559957, -122.43574426598) | 13 | 6 | 11 | 29490 | 27 | |||
| 6384 | 228964 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006487.40312 | 2108404.39444 | 37.7696434318162 | -122.420889513561 | (37.7696434318162, -122.420889513561) | 8 | 4 | 7 | 28853 | 19 | |||
| 6441 | 255157 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3098 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | |||||||||||||
| 6520 | 73325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6008557.19392 | 2112976.99217 | 37.7823151519537 | -122.414053685727 | (37.7823151519537, -122.414053685727) | 7 | 10 | 9 | 28852 | 36 | |||
| 6568 | 62216 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 275 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22339 | 5988348.59257 | 2114168.35653 | 37.7844305464846 | -122.484053030045 | (37.7844305464846, -122.484053030045) | 11 | 6 | 2 | 55 | 26 | |
| 6621 | 262544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1146 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 3x3 | 6014979 | 2090344 | 37.7205283348361 | -122.390255140049 | (37.7205283348361, -122.390255140049) | 10 | 3 | 8 | 58 | 1 | ||
| 6648 | 255227 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 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 | ||
| 6801 | 41801 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42199 | 6011430.3722 | 2107669.42894 | 37.7679027607219 | -122.403740131013 | (37.7679027607219, -122.403740131013) | 8 | 2 | 8 | 28853 | 20 | |
| 6806 | 105051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.7696337718916 | -122.445015457708 | (37.7696337718916, -122.445015457708) | 15 | 5 | 11 | 29492 | 9 | ||
| 6817 | 28534 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 365 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6006151.39178 | 2107502.55778 | 37.7671482574197 | -122.421987693677 | (37.7671482574197, -122.421987693677) | 8 | 4 | 7 | 28853 | 19 | ||
| 6830 | 260679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
| 6836 | 12723 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1538 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2012 12:00:00 AM | 3 | 3x3 | 5990625.74037 | 2114773.38232 | 37.7862240892432 | -122.476219173709 | (37.7862240892432, -122.476219173709) | 11 | 6 | 1 | 54 | 33 | ||
| 6848 | 177189 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2049 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012400.79335 | 2088277.25976 | 37.7147101360364 | -122.399022249793 | (37.7147101360364, -122.399022249793) | 10 | 3 | 8 | 309 | 1 | |||
| 6871 | 5785 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 545 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1990 12:00:00 AM | 12 | 3X3 | 6003239.05112 | 2108309.6004 | 37.7691995174597 | -122.432118677046 | (37.7691995174597, -122.432118677046) | 15 | 5 | 5 | 28862 | 3 | ||
| 6978 | 253743 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
| 7019 | 258770 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
| 7025 | 96977 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2220 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2005 12:00:00 AM | 3x3 | 6015794 | 2092051 | 37.7252605945934 | -122.387556947253 | (37.7252605945934, -122.387556947253) | 10 | 3 | 8 | 58 | 1 | |||
| 7035 | 3622 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017832.21147 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | 10 | 3 | 8 | 58 | 1 | |||
| 7036 | 38800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
| 7044 | 70398 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 153 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | Permit Number 775403 | 6006428.67416 | 2093189.72166 | 37.7278640951339 | -122.420012793267 | (37.7278640951339, -122.420012793267) | 9 | 7 | 7 | 309 | 5 | |
| 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 | ||
| 7086 | 255139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 17 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | ||
| 7107 | 9706 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6005904.98118 | 2111477.12508 | 37.7780475630877 | -122.423122534696 | (37.7780475630877, -122.423122534696) | 7 | 9 | 11 | 28852 | 10 | |||
| 7117 | 32574 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1010 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37048 | 6007564.21152 | 2103777.94683 | 37.7570009189802 | -122.416837039821 | (37.7570009189802, -122.416837039821) | 2 | 4 | 7 | 28859 | 19 | |
| 7150 | 260618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2019 12:00:00 AM | 3 | 6003090.98743 | 2109246.85163 | 37.7717645837124 | -122.432697781433 | (37.7717645837124, -122.432697781433) | 15 | 5 | 11 | 29492 | 9 | |||
| 7221 | 75198 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 675 17th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990644.77295 | 2110703.64966 | 37.7750508336714 | -122.475856010882 | (37.7750508336714, -122.475856010882) | 11 | 6 | 2 | 55 | 26 | |||
| 7273 | 72083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5988389.53404 | 2114272.57287 | 37.7847190784909 | -122.483919032846 | (37.7847190784909, -122.483919032846) | 11 | 6 | 2 | 55 | 26 | |||
| 7298 | 108182 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010686.57825 | 2116924.79472 | 37.7932742451254 | -122.406965263124 | (37.7932742451254, -122.406965263124) | 3 | 1 | 10 | 28857 | 4 | ||||
| 7305 | 29406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2845X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | ||
| 7311 | 255140 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 18 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||
| 7339 | 130136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 520 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005895.11777 | 2111561.87287 | 37.7782797032844 | -122.423162681334 | (37.7782797032844, -122.423162681334) | 7 | 9 | 11 | 28852 | 10 | |||
| 7353 | 16291 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 710 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/31/2001 12:00:00 AM | 3 | 3x3 | 5997353.28432 | 2094748.65298 | 37.7316290565338 | -122.451498861191 | (37.7316290565338, -122.451498861191) | 9 | 7 | 4 | 59 | 40 | ||
| 7363 | 35440 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
| 7393 | 259095 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
| 7434 | 201009 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2200 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015701.77252 | 2105218.85803 | 37.7614117114021 | -122.388794618095 | (37.7614117114021, -122.388794618095) | 10 | 3 | 8 | 28856 | 29 | |||
| 7506 | 24586 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6007916.4009439 | 2097214.6000353 | 37.7389992440645 | -122.415154455625 | (37.7389992440645, -122.415154455625) | 2 | 7 | 7 | 28859 | 2 | |||
| 7507 | 228121 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1049 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5997257.33539 | 2106808.69418 | 37.7647374591841 | -122.452700661207 | (37.7647374591841, -122.452700661207) | 15 | 5 | 11 | 29492 | 12 | |||
| 7548 | 6171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
| 7555 | 69133 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1624 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 18 | Permit Number 33160 | 6006948.32504 | 2116425.19331 | 37.7916925709073 | -122.419864429405 | (37.7916925709073, -122.419864429405) | 13 | 9 | 10 | 28858 | 21 | |
| 7573 | 64140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 408 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24912 | 6003905.86029931 | 2098394.49493183 | 37.7420127636574 | -122.429105167098 | (37.7420127636574, -122.429105167098) | 2 | 7 | 5 | 63 | 22 | ||
| 7582 | 170693 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2020 12:00:00 AM | 3 | Width 3ft | 6000671.26628 | 2092639.51564 | 37.726027296415 | -122.4398768019 | (37.726027296415, -122.4398768019) | 9 | 7 | 6 | 28861 | 25 | ||
| 7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 7619 | 35441 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
| 7678 | 171106 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1830 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6001167.19025 | 2091451.63812 | 37.7227938721177 | -122.438077374487 | (37.7227938721177, -122.438077374487) | 9 | 7 | 6 | 28861 | 25 |
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) );