trees
8,659 rows where qSpecies_id = 11 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9476 | 41802 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42199 | 6011432.49542 | 2107611.3986 | 37.7677435411696 | -122.403728703313 | (37.7677435411696, -122.403728703313) | 8 | 2 | 8 | 28853 | 20 | |
| 9835 | 30905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Henry Adams St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/1997 12:00:00 AM | 16 | Permit Number 38599 | 6011349.16675 | 2108265.74604 | 37.7695355752349 | -122.404062984032 | (37.7695355752349, -122.404062984032) | 8 | 2 | 8 | 28853 | 20 | |
| 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 | |
| 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 | |||
| 9958 | 147493 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 515 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5989673.3766 | 2111812.97412 | 37.7780403631101 | -122.47929741646 | (37.7780403631101, -122.47929741646) | 11 | 6 | 2 | 55 | 26 | |
| 9981 | 75898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6009892.14521 | 2105512.72299 | 37.761894888355 | -122.408908522215 | (37.761894888355, -122.408908522215) | 8 | 4 | 8 | 28859 | 19 | |||
| 10196 | 80809 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015599.17237 | 2102455.49099 | 37.7538184070991 | -122.388956535612 | (37.7538184070991, -122.388956535612) | 10 | 3 | 8 | 28856 | 29 | |||
| 10214 | 255235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 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 | |||
| 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 | |||
| 10624 | 47868 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 745 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/17/2002 12:00:00 AM | 8 | Permit Number 45622 | 5993132.36213 | 2113446.5394 | 37.7827259803362 | -122.467450470263 | (37.7827259803362, -122.467450470263) | 11 | 6 | 2 | 54 | 11 | |
| 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 | ||
| 11164 | 64419 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 111 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25267 | 6003583.64860345 | 2097735.92139782 | 37.740186227283 | -122.430172299864 | (37.740186227283, -122.430172299864) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | |||
| 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 | |||
| 11524 | 64282 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25086 | 6003895.1200055 | 2098341.81687307 | 37.7418675138214 | -122.429138548404 | (37.7418675138214, -122.429138548404) | 2 | 7 | 5 | 63 | 7 | ||
| 11612 | 65947 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1005 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 11 | Permit Number 28968 | 6007327.06617 | 2114853.5126 | 37.7873984520186 | -122.418442492445 | (37.7873984520186, -122.418442492445) | 13 | 9 | 10 | 28858 | 21 | |
| 11762 | 62725 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 109 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/1986 12:00:00 AM | Permit Number 23071 | 6001085.93774818 | 2105743.30332199 | 37.7620307920739 | -122.439382183867 | (37.7620307920739, -122.439382183867) | 15 | 5 | 5 | 28862 | 3 | ||
| 11805 | 33857 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1997 12:00:00 AM | 13 | Permit Number 37855 | 6014476.10973 | 2103508.37921 | 37.7566470977886 | -122.392914033755 | (37.7566470977886, -122.392914033755) | 10 | 3 | 8 | 28856 | 29 | |
| 11830 | 80810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6015596.09754 | 2102496.67483 | 37.7539313187876 | -122.388970044334 | (37.7539313187876, -122.388970044334) | 10 | 3 | 8 | 28856 | 29 | |||
| 11837 | 72084 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 262 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988392.79943 | 2114246.03166 | 37.7846463939543 | -122.48390578898 | (37.7846463939543, -122.48390578898) | 11 | 6 | 2 | 55 | 26 | |||
| 12380 | 83478 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6015481.04355 | 2105634.6159 | 37.762541056634 | -122.38958707191 | (37.762541056634, -122.38958707191) | 10 | 3 | 8 | 28856 | 29 | |||
| 12402 | 67521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31057 | 5997342.043029 | 2093839.69948247 | 37.7291326429008 | -122.451472187982 | (37.7291326429008, -122.451472187982) | 9 | 7 | 4 | 28861 | 40 | ||
| 12508 | 62227 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 228 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22352 | 6001110.06412505 | 2093217.52334826 | 37.7276393417973 | -122.438401301148 | (37.7276393417973, -122.438401301148) | 9 | 7 | 6 | 28861 | 25 | ||
| 12535 | 62417 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 681 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/1985 12:00:00 AM | 14 | Permit Number 22574 | 5991606.81123 | 2110812.04557 | 37.7754041903679 | -122.472536046893 | (37.7754041903679, -122.472536046893) | 11 | 6 | 2 | 54 | 26 | |
| 12635 | 74018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997681.3026 | 2115023.11514 | 37.7873164113684 | -122.451826915892 | (37.7873164113684, -122.451826915892) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |
| 12656 | 262184 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |||
| 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 | |
| 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 | ||
| 13122 | 67587 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 324 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 7 | Permit Number 31153 | 6014294.13475 | 2105553.95502 | 37.762253696265 | -122.393686543294 | (37.762253696265, -122.393686543294) | 10 | 3 | 8 | 28856 | 29 | |
| 13134 | 76293 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013060.18531 | 2119122.80042 | 37.7994419813198 | -122.398906706701 | (37.7994419813198, -122.398906706701) | 3 | 1 | 10 | 28860 | 6 | |||
| 13151 | 68243 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 493 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 10 | Permit Number 32043 | 6007581.69224 | 2091476.68313 | 37.7232253533521 | -122.415905517524 | (37.7232253533521, -122.415905517524) | 9 | 3 | 7 | 309 | 28 | |
| 13170 | 71778 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1035 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6007638.65798 | 2115077.87772 | 37.7880320397014 | -122.417380352623 | (37.7880320397014, -122.417380352623) | 13 | 1 | 10 | 28858 | 21 | |||
| 13227 | 70595 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 9 | 6004399.02118 | 2091228.09004 | 37.7223633261893 | -122.426889705722 | (37.7223633261893, -122.426889705722) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 13506 | 261535 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 791 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2020 12:00:00 AM | 3 | 5982260 | 2110395 | 37.7737136636786 | -122.504837403722 | (37.7737136636786, -122.504837403722) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 13749 | 39003 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | 8 | 4 | 7 | 28859 | 19 | ||
| 13907 | 68355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32175 | 5989388.74548019 | 2111065.82314724 | 37.7759723585503 | -122.480227347988 | (37.7759723585503, -122.480227347988) | 11 | 6 | 2 | 55 | 26 | ||
| 13938 | 68635 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1762 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32540 | 5990632.43795796 | 2103398.44981419 | 37.7549920050668 | -122.475365208722 | (37.7549920050668, -122.475365208722) | 1 | 8 | 4 | 56 | 12 | ||
| 14051 | 49873 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1721@ 21st AVE Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 0 | Permit Number 46641 | 5989549.03002443 | 2105119.85153385 | 37.7596556546053 | -122.479237819684 | (37.7596556546053, -122.479237819684) | 1 | 8 | 3 | 56 | 35 | |
| 14215 | 70147 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2927 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5989529.51616 | 2111917.79074 | 37.7783198039619 | -122.479802747413 | (37.7783198039619, -122.479802747413) | 11 | 6 | 2 | 55 | 26 | |||
| 14416 | 75854 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013512.94688 | 2112177.08416 | 37.7803958844882 | -122.396852757649 | (37.7803958844882, -122.396852757649) | 6 | 2 | 9 | 28856 | 34 | |||
| 14720 | 75940 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6013473.22084 | 2112140.331 | 37.7802927574459 | -122.396987611901 | (37.7802927574459, -122.396987611901) | 6 | 2 | 9 | 28856 | 34 | |||
| 14820 | 33852 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1997 12:00:00 AM | 6 | Permit Number 37855 | 6014471.03913 | 2103566.86369 | 37.75680740195 | -122.392935661554 | (37.75680740195, -122.392935661554) | 10 | 3 | 8 | 28856 | 29 | |
| 14829 | 76313 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015835.10862 | 2112662.38098 | 37.7818573808501 | -122.388853134261 | (37.7818573808501, -122.388853134261) | 6 | 2 | 9 | 28856 | 6 | |||
| 14864 | 70065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 370 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6014415.94114 | 2112258.25542 | 37.7806689825201 | -122.393734537439 | (37.7806689825201, -122.393734537439) | 6 | 2 | 9 | 28856 | 6 | |||
| 14933 | 37507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 7 | Permit Number 44548 | 6008745.37016 | 2115468.73196 | 37.7891674355628 | -122.413578966021 | (37.7891674355628, -122.413578966021) | 5 | 1 | 10 | 28858 | 21 | |
| 14956 | 75839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6011422.77778 | 2107820.32569 | 37.7683166647229 | -122.403777018493 | (37.7683166647229, -122.403777018493) | 8 | 2 | 8 | 28853 | 20 | |||
| 15004 | 82837 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 604 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004044.4214 | 2110838.57135 | 37.7761890816952 | -122.429513325784 | (37.7761890816952, -122.429513325784) | 7 | 9 | 11 | 28852 | 10 | |||
| 15271 | 62738 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4521 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/1986 12:00:00 AM | Permit Number 23085 | 6000942.99197149 | 2105197.51217307 | 37.7605240475123 | -122.439837443247 | (37.7605240475123, -122.439837443247) | 2 | 4 | 5 | 28862 | 3 | ||
| 15384 | 258139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | ||
| 15429 | 60677 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1098 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25704 | 6001311.54507479 | 2109393.91334387 | 37.7720673006946 | -122.438863516223 | (37.7720673006946, -122.438863516223) | 15 | 5 | 11 | 29492 | 9 | ||
| 15568 | 73765 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997676.95142 | 2115046.52536 | 37.7873804404128 | -122.451843659469 | (37.7873804404128, -122.451843659469) | 11 | 6 | 1 | 54 | 31 | |||
| 15756 | 75882 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6013498.81204 | 2112165.83052 | 37.7803641977969 | -122.396900867782 | (37.7803641977969, -122.396900867782) | 6 | 2 | 9 | 28856 | 34 | |||
| 15930 | 69139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 573 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1994 12:00:00 AM | Permit Number 33171 | 6008555.67489002 | 2114162.36008798 | 37.7855698016133 | -122.4141428296 | (37.7855698016133, -122.4141428296) | 7 | 10 | 9 | 28852 | 36 | ||
| 15954 | 79175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005975.99544 | 2111376.30995 | 37.777774756444 | -122.422869703793 | (37.777774756444, -122.422869703793) | 7 | 9 | 11 | 28852 | 10 | |||
| 16314 | 75902 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009908.64255 | 2105513.64874 | 37.7618983543372 | -122.408851529481 | (37.7618983543372, -122.408851529481) | 8 | 4 | 8 | 28859 | 19 | |||
| 16642 | 98248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.49549 | 2113344.84788 | 37.7832534614285 | -122.41849313956 | (37.7832534614285, -122.41849313956) | 7 | 9 | 9 | 28858 | 36 | |
| 16745 | 32715 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 6 | Permit Number 37110 | 6007284.26243 | 2115178.29888 | 37.7882878257567 | -122.418613625325 | (37.7882878257567, -122.418613625325) | 13 | 9 | 10 | 28858 | 21 | |
| 16750 | 75968 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6013460.77935 | 2112129.46261 | 37.7802622227699 | -122.397029890811 | (37.7802622227699, -122.397029890811) | 6 | 2 | 9 | 28856 | 34 | |||
| 16891 | 71181 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1054 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6007527.04046 | 2115114.42984 | 37.7881261222798 | -122.417769122357 | (37.7881261222798, -122.417769122357) | 13 | 1 | 10 | 28858 | 21 | |||
| 16969 | 73435 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 361 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6014513.73704 | 2112259.04827 | 37.7806765934897 | -122.393396267331 | (37.7806765934897, -122.393396267331) | 6 | 2 | 9 | 28856 | 6 | |||
| 17036 | 83454 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015474.85164 | 2105705.75268 | 37.7627360395529 | -122.389613456191 | (37.7627360395529, -122.389613456191) | 10 | 3 | 8 | 28856 | 29 | |||
| 17064 | 72082 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 246 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5988387.30119 | 2114347.80064 | 37.78492550261 | -122.483932275813 | (37.78492550261, -122.483932275813) | 11 | 6 | 2 | 55 | 26 | |||
| 17169 | 255230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 17267 | 64540 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1490 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 0 | Permit Number 25423 | 6015659.59998474 | 2095046.3964697 | 37.7334779106152 | -122.388230513889 | (37.7334779106152, -122.388230513889) | 10 | 3 | 8 | 58 | 1 | |
| 17313 | 72337 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 796 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5988859.60272 | 2109927.01745 | 37.7728147529064 | -122.481974327583 | (37.7728147529064, -122.481974327583) | 11 | 6 | 2 | 55 | 26 | |||
| 17428 | 66289 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1550 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1990 12:00:00 AM | 14 | Permit Number 29400 | 6006784.05132 | 2117383.92877 | 37.7943157638115 | -122.420500900308 | (37.7943157638115, -122.420500900308) | 13 | 9 | 10 | 28858 | 32 | |
| 17688 | 76282 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6015689.45429 | 2112593.04302 | 37.7816589202521 | -122.389352191465 | (37.7816589202521, -122.389352191465) | 6 | 2 | 9 | 28856 | 6 | |||
| 17775 | 73335 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 240 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6008418.7478 | 2112810.19773 | 37.7818493975717 | -122.414520843074 | (37.7818493975717, -122.414520843074) | 7 | 10 | 9 | 28852 | 36 | |||
| 17995 | 78360 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009959.42223 | 2105517.40924 | 37.7619115240195 | -122.408676167081 | (37.7619115240195, -122.408676167081) | 8 | 4 | 8 | 28859 | 19 | |||
| 18024 | 39449 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 40934 | 6007392.37160238 | 2108419.72859009 | 37.7697365039652 | -122.417760336994 | (37.7697365039652, -122.417760336994) | 8 | 4 | 7 | 28853 | 19 | ||
| 18091 | 75914 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013490.38104 | 2112155.30038 | 37.7803348151471 | -122.396929296245 | (37.7803348151471, -122.396929296245) | 6 | 2 | 9 | 28856 | 34 | |||
| 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 | |||
| 18333 | 62411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 651 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/17/1986 12:00:00 AM | 8 | Permit Number 22725 | 5991600.46907 | 2110976.65753 | 37.7758558028988 | -122.472569989741 | (37.7758558028988, -122.472569989741) | 11 | 6 | 2 | 54 | 26 | |
| 18351 | 74118 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 350 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6014525.18736 | 2112363.21501 | 37.7809632479025 | -122.393363946586 | (37.7809632479025, -122.393363946586) | 6 | 2 | 9 | 28856 | 6 | |||
| 18377 | 79432 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005955.30397 | 2111373.13166 | 37.7777648621077 | -122.422941056882 | (37.7777648621077, -122.422941056882) | 7 | 9 | 11 | 28852 | 10 | |||
| 18395 | 76233 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6015642.74628 | 2112555.88205 | 37.7815542949404 | -122.389511184418 | (37.7815542949404, -122.389511184418) | 6 | 2 | 9 | 28856 | 6 | |||
| 18456 | 33855 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1997 12:00:00 AM | 8 | Permit Number 37855 | 6014473.71312 | 2103525.16373 | 37.7566930513521 | -122.392923496436 | (37.7566930513521, -122.392923496436) | 10 | 3 | 8 | 28856 | 29 | |
| 18518 | 255232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 18553 | 64985 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1989 12:00:00 AM | Permit Number 26023 | 6005554.31706226 | 2098219.5570786 | 37.741625601295 | -122.423392889427 | (37.741625601295, -122.423392889427) | 2 | 7 | 7 | 28859 | 2 | ||
| 18593 | 71972 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6009259.78939 | 2119456.28205 | 37.8001451441351 | -122.412081054306 | (37.8001451441351, -122.412081054306) | 3 | 1 | 10 | 308 | 4 | |||
| 18640 | 66851 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4314 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30156 | 6001689.12791695 | 2104706.38300314 | 37.7592179697276 | -122.437221739283 | (37.7592179697276, -122.437221739283) | 2 | 4 | 5 | 28862 | 3 | ||
| 18767 | 67393 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 723 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | Permit Number 30890 | 5990653.53990007 | 2110457.0289972 | 37.7743741891543 | -122.475807670593 | (37.7743741891543, -122.475807670593) | 11 | 6 | 2 | 55 | 26 | ||
| 18900 | 73976 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1035 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007626.91149 | 2115081.86603 | 37.7880423297227 | -122.417421276264 | (37.7880423297227, -122.417421276264) | 13 | 1 | 10 | 28858 | 21 | |||
| 19035 | 255226 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 19065 | 255233 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 19067 | 70561 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 350 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6014495.83959 | 2112334.98723 | 37.7808841102582 | -122.393463499735 | (37.7808841102582, -122.393463499735) | 6 | 2 | 9 | 28856 | 6 | |||
| 19252 | 264635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1240 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2020 12:00:00 AM | 4x6 | 6015097 | 2090604 | 37.7212487882021 | -122.389865399961 | (37.7212487882021, -122.389865399961) | 10 | 3 | 8 | 58 | 1 | ||
| 19296 | 46101 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 250 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44468 | 6015276.73031133 | 2112998.11508414 | 37.7827482661819 | -122.39080835017 | (37.7827482661819, -122.39080835017) | 6 | 2 | 9 | 28856 | 6 | ||
| 19319 | 76263 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6015669.35223 | 2112574.47088 | 37.7816068108346 | -122.389420438302 | (37.7816068108346, -122.389420438302) | 6 | 2 | 9 | 28856 | 6 | |||
| 19402 | 70574 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 361 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6014535.60695 | 2112281.72508 | 37.7807400739275 | -122.393322195566 | (37.7807400739275, -122.393322195566) | 6 | 2 | 9 | 28856 | 6 | |||
| 19510 | 70615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 956 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007552.40866 | 2114767.26768 | 37.7871743274878 | -122.417656736796 | (37.7871743274878, -122.417656736796) | 13 | 1 | 10 | 28858 | 21 | |||
| 19584 | 261522 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 631 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2020 12:44:00 PM | 5982550.52878 | 2111435.68847 | 37.7765881781327 | -122.50390953034 | (37.7765881781327, -122.50390953034) | 11 | 6 | 2 | 55 | 26 | |||
| 19669 | 47662 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.402013969527 | (37.7682956086843, -122.402013969527) | 8 | 3 | 8 | 28853 | 20 | ||
| 19692 | 54342 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1355 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31371 | 5994852.82536741 | 2106359.83971446 | 37.7633669502332 | -122.460984638129 | (37.7633669502332, -122.460984638129) | 15 | 5 | 11 | 56 | 12 |
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) );