trees
8,659 rows where qSpecies_id = 11 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4252 | 229132 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 869 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1983 12:00:00 AM | 19 | Width 3ft | Permit Number 21019 | 6007588.0617 | 2104611.24937 | 37.759290317716 | -122.416813591769 | (37.759290317716, -122.416813591769) | 2 | 4 | 7 | 28859 | 19 | |
| 4300 | 72086 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 287 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5988351.63673 | 2114094.10602 | 37.7842268528731 | -122.484037051708 | (37.7842268528731, -122.484037051708) | 11 | 6 | 2 | 55 | 26 | |||
| 4330 | 68743 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3929 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32664 | 6003434.71793969 | 2105335.41306872 | 37.761044210169 | -122.431229551523 | (37.761044210169, -122.431229551523) | 2 | 4 | 5 | 28862 | 3 | ||
| 4374 | 228170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007791.31905 | 2097714.0061 | 37.7403634727908 | -122.415622282361 | (37.7403634727908, -122.415622282361) | 2 | 7 | 7 | 28859 | 2 | |||
| 4406 | 68340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 431 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32157 | 5991217.62534 | 2112456.91618 | 37.7798980198622 | -122.474002355247 | (37.7798980198622, -122.474002355247) | 11 | 6 | 2 | 54 | 26 | |
| 4409 | 60582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1426 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20198 | 6000937.5822 | 2111077.0426 | 37.7766674666338 | -122.440277805167 | (37.7766674666338, -122.440277805167) | 15 | 5 | 11 | 29492 | 41 | ||
| 4416 | 22971 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 590 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1997 12:00:00 AM | 8 | 3X3 | 6006160.16462 | 2106178.29258 | 37.763512632933 | -122.42186327248 | (37.763512632933, -122.42186327248) | 8 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 4428 | 66790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2150 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53367 | 6006860.21214417 | 2118575.27175394 | 37.79759118503 | -122.420321971868 | (37.79759118503, -122.420321971868) | 5 | 9 | 10 | 28858 | 32 | ||
| 4484 | 16615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | 15 | 5 | 5 | 28862 | 3 | |
| 4525 | 162657 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 187 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 09:54:00 AM | 3 | Width 0ft | 5996501.58023 | 2091123.57415 | 37.7216266438259 | -122.454181619811 | (37.7216266438259, -122.454181619811) | 9 | 8 | 6 | 28861 | 24 | ||
| 4532 | 70356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.421362640608 | (37.7943758388735, -122.421362640608) | 13 | 9 | 10 | 28858 | 32 | |||
| 4610 | 229157 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3195 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008470.80971 | 2100938.6622 | 37.7492558360924 | -122.413500868897 | (37.7492558360924, -122.413500868897) | 2 | 4 | 7 | 28859 | 19 | |||
| 4628 | 6858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1992 12:00:00 AM | 15 | 3X3 | 5997253 | 2087738 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | 9 | 7 | 6 | 28861 | 25 | ||
| 4694 | 229096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 411X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008233.66043 | 2096096.60482 | 37.735947297932 | -122.413978446675 | (37.735947297932, -122.413978446675) | 2 | 7 | 7 | 28859 | 2 | |||
| 4822 | 21978 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2573 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2015 08:55:00 AM | 3 | 3x3 | 6015890.4711579 | 2103611.9444914 | 37.757009926228 | -122.388029843479 | (37.757009926228, -122.388029843479) | 10 | 3 | 8 | 28856 | 29 | ||
| 4844 | 228872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 4x7 | Permit Number 781830 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.429273464001 | (37.7698314611737, -122.429273464001) | 7 | 9 | 5 | 29492 | 10 | |
| 4947 | 6953 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 609 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004373.4958 | 2110460.1271 | 37.7751685930556 | -122.428347988839 | (37.7751685930556, -122.428347988839) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7019 | 258770 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||||||||||||
| 7826 | 11042 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1540 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:37:00 PM | 3 | 3X3 | 6007470.84511 | 2117656.01984 | 37.7951015383692 | -122.418143807805 | (37.7951015383692, -122.418143807805) | 5 | 1 | 10 | 28858 | 32 | ||
| 7955 | 6258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1338X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2010 12:00:00 AM | 3 | 3X3 | 6004383.57489 | 2113288.83653 | 37.7829361010006 | -122.428514794701 | (37.7829361010006, -122.428514794701) | 7 | 9 | 11 | 29490 | 41 | ||
| 7977 | 63890 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.7738794203064 | -122.423454911884 | (37.7738794203064, -122.423454911884) | 7 | 9 | 11 | 28852 | 10 | ||
| 7995 | 10225 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005877.37579 | 2100867.12021 | 37.7489134363237 | -122.422463939564 | (37.7489134363237, -122.422463939564) | 2 | 4 | 5 | 28859 | 19 | |||
| 8373 | 16614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | 15 | 5 | 5 | 28862 | 3 | ||
| 8418 | 64139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 523 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24910 | 6003239.38144538 | 2098311.93722578 | 37.7417483289476 | -122.431403744863 | (37.7417483289476, -122.431403744863) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | |
| 8470 | 14592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1222 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3x3 | 5999472.8199 | 2108630.0925 | 37.7698652586639 | -122.445168866065 | (37.7698652586639, -122.445168866065) | 15 | 5 | 11 | 29492 | 9 | |||
| 8861 | 208247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993716.65368 | 2097514.87622 | 37.7390154978753 | -122.464272068903 | (37.7390154978753, -122.464272068903) | 1 | 8 | 4 | 59 | 40 | |||
| 9071 | 235849 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1165 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008684.91022 | 2101773.09182 | 37.7515590124405 | -122.412819488553 | (37.7515590124405, -122.412819488553) | 2 | 4 | 7 | 28859 | 19 | |||
| 9219 | 74232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997684.08326 | 2115006.73382 | 37.7872715918672 | -122.451816113239 | (37.7872715918672, -122.451816113239) | 11 | 6 | 1 | 54 | 31 | |||
| 9232 | 228951 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 118 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6005386.85226 | 2102866.95811 | 37.7543768447429 | -122.424302388563 | (37.7543768447429, -122.424302388563) | 2 | 4 | 5 | 28859 | 19 | |||
| 9313 | 129991 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1020 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005653.15394 | 2113299.68835 | 37.7830376609932 | -122.42412334433 | (37.7830376609932, -122.42412334433) | 7 | 9 | 11 | 28858 | 41 | |||
| 9362 | 152507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 26 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 3ft | 6006425.02683 | 2105698.61751 | 37.7622104910438 | -122.420913138755 | (37.7622104910438, -122.420913138755) | 8 | 4 | 7 | 28859 | 19 | ||
| 9367 | 83358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1160 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50875 | 5997390.75214654 | 2106213.86032098 | 37.7631118403797 | -122.452196286828 | (37.7631118403797, -122.452196286828) | 15 | 5 | 11 | 29492 | 9 | ||
| 9458 | 84830 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 939 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | Permit No. 49222 | 6002944 | 2110261 | 37.7745408475216 | -122.433278698665 | (37.7745408475216, -122.433278698665) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | |
| 9525 | 23031 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 938 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1992 12:00:00 AM | 25 | 3X3 | 6006272.23654 | 2104114.42979 | 37.7578520679407 | -122.421329079684 | (37.7578520679407, -122.421329079684) | 2 | 4 | 5 | 28859 | 19 | ||
| 9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
| 9551 | 261014 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | Width 2ft | 5989703 | 2110539 | 37.7745441031018 | -122.479101726445 | (37.7745441031018, -122.479101726445) | 11 | 6 | 2 | 55 | 26 | ||
| 9627 | 228661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | 2 | 4 | 5 | 28862 | 3 | |||
| 9704 | 13240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2346 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774035 | 6001131.9237 | 2119364.2962 | 37.7994331868979 | -122.440199950322 | (37.7994331868979, -122.440199950322) | 13 | 9 | 1 | 57 | 17 | |
| 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 | ||
| 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 | |
| 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 | |
| 10068 | 49666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | 13 | 9 | 1 | 57 | 17 | ||
| 10195 | 16208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 520 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/1990 12:00:00 AM | 12 | 3X3 | 5998621.53802 | 2094731.71409 | 37.7316550910103 | -122.447113056433 | (37.7316550910103, -122.447113056433) | 9 | 7 | 4 | 59 | 40 | ||
| 10216 | 228168 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 107 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007794.48494 | 2097031.13992 | 37.7384886507323 | -122.415563000831 | (37.7384886507323, -122.415563000831) | 2 | 7 | 7 | 28859 | 2 | |||
| 10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
| 10239 | 117493 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 156 DORADO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994380 | 2093088 | 37.7268985955584 | -122.461657658843 | (37.7268985955584, -122.461657658843) | 9 | 8 | 4 | 28861 | 40 | ||||
| 10531 | 84036 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 45 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50462 | 6001133.37697683 | 2103651.61212773 | 37.7562902176876 | -122.439068194619 | (37.7562902176876, -122.439068194619) | 2 | 4 | 5 | 28862 | 38 | ||
| 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 | |||
| 10590 | 13232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2301 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 10 | 3X3 | 6001301 | 2119283 | 37.7992195934801 | -122.439609056557 | (37.7992195934801, -122.439609056557) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |
| 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 | |||
| 10657 | 29740 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 629 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775746 | 6009949.88308 | 2119458.12885 | 37.8001889103038 | -122.409693183014 | (37.8001889103038, -122.409693183014) | 3 | 1 | 10 | 308 | 23 | |
| 10713 | 107324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 54 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774045 | 5993040.6 | 2097998.7 | 37.7403049657103 | -122.466644691653 | (37.7403049657103, -122.466644691653) | 1 | 8 | 4 | 59 | 40 | |
| 10853 | 14629 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166 | (37.7800133326755, -122.42137953166) | 7 | 9 | 11 | 28852 | 41 | |||
| 11081 | 17829 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1955 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004588.8583705 | 2115348.8927865 | 37.7886041154805 | -122.427951442059 | (37.7886041154805, -122.427951442059) | 13 | 9 | 11 | 28858 | 27 | |||
| 11097 | 16603 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6002870.97589 | 2107811.22943 | 37.7678102375823 | -122.433356210721 | (37.7678102375823, -122.433356210721) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | ||
| 11177 | 47475 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 11195 | 110472 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542 | 2111298 | 37.7775352389463 | -122.424365474196 | (37.7775352389463, -122.424365474196) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |
| 11307 | 255155 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3066 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 |
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) );