trees
190 rows where Police Districts = 9 and qSpecies_id = 8 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
| 6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
| 18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
| 23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
| 31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
| 32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 34618 | 63613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24252 | 6005229.19307431 | 2109538.39058576 | 37.7726861107413 | -122.425322331795 | (37.7726861107413, -122.425322331795) | 7 | 9 | 11 | 28852 | 10 | ||
| 38299 | 66118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29177 | 6004443.55987266 | 2109134.3816324 | 37.771532383715 | -122.428011127655 | (37.771532383715, -122.428011127655) | 7 | 9 | 11 | 28852 | 10 | ||
| 46236 | 87868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
| 50099 | 52435 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
| 60161 | 33723 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 64853 | 52436 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
| 71932 | 88741 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 74042 | 61992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | 13 | 9 | 1 | 57 | 17 | ||
| 75073 | 63599 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | 8x6 | Permit Number 24233 | 6004551.34106685 | 2109096.89343089 | 37.7714355473733 | -122.427635635138 | (37.7714355473733, -122.427635635138) | 7 | 9 | 11 | 28852 | 10 | |
| 76415 | 87186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864 | 2119027 | 37.7986055186493 | -122.434182233436 | (37.7986055186493, -122.434182233436) | 13 | 9 | 1 | 57 | 17 | |||
| 77189 | 52437 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
| 78668 | 50867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.7946117985032 | -122.440503146962 | (37.7946117985032, -122.440503146962) | 13 | 9 | 1 | 57 | 27 | |||
| 81050 | 87866 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
| 81351 | 31348 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.7766352121679 | -122.42638959957 | (37.7766352121679, -122.42638959957) | 7 | 9 | 11 | 28852 | 10 | ||
| 87541 | 83184 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51667 | 6004633.65578728 | 2109108.35984762 | 37.7714716870977 | -122.427351721243 | (37.7714716870977, -122.427351721243) | 7 | 9 | 11 | 28852 | 10 | ||
| 96778 | 64972 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1627 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | Permit Number 26007 | 6005156.95767536 | 2119176.82289308 | 37.7991467663209 | -122.426258543392 | (37.7991467663209, -122.426258543392) | 13 | 9 | 1 | 57 | 17 | ||
| 102272 | 64786 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25781 | 6005246.79588468 | 2109227.98306531 | 37.7718348011935 | -122.425239349655 | (37.7718348011935, -122.425239349655) | 7 | 9 | 11 | 28852 | 10 | ||
| 104077 | 52438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48550 | 6004816.71348375 | 2115443.64861451 | 37.7888771790913 | -122.427169849357 | (37.7888771790913, -122.427169849357) | 13 | 9 | 11 | 28858 | 27 | ||
| 105374 | 52439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48550 | 6004816.71348375 | 2115443.64861451 | 37.7888771790913 | -122.427169849357 | (37.7888771790913, -122.427169849357) | 13 | 9 | 11 | 28858 | 27 | ||
| 111285 | 33722 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 118432 | 63598 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24232 | 6004516.72851683 | 2109144.57400335 | 37.7715645087532 | -122.427758759583 | (37.7715645087532, -122.427758759583) | 7 | 9 | 11 | 28852 | 10 | ||
| 120322 | 54863 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | Permit Number 24224 | 6005092.72768528 | 2109571.89850043 | 37.7727704046159 | -122.425796766194 | (37.7727704046159, -122.425796766194) | 7 | 9 | 11 | 28852 | 10 | ||
| 128831 | 50287 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 184 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46998 | 6005208.32538613 | 2109504.30413696 | 37.7725913386303 | -122.425392089284 | (37.7725913386303, -122.425392089284) | 7 | 9 | 11 | 28852 | 10 | ||||
| 134877 | 63600 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 232 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24234 | 6004580.75107621 | 2109153.49232734 | 37.7715926177163 | -122.427537937355 | (37.7715926177163, -122.427537937355) | 7 | 9 | 11 | 28852 | 10 | ||
| 139624 | 63612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24249 | 6004653.91972039 | 2109163.68469829 | 37.7716247417412 | -122.427285568873 | (37.7716247417412, -122.427285568873) | 7 | 9 | 11 | 28852 | 10 | ||
| 156402 | 63611 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24248 | 6004626.48147455 | 2109159.86255859 | 37.7716126952933 | -122.427380207094 | (37.7716126952933, -122.427380207094) | 7 | 9 | 11 | 28852 | 10 | ||
| 159777 | 31349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.7766352121679 | -122.42638959957 | (37.7766352121679, -122.42638959957) | 7 | 9 | 11 | 28852 | 10 | ||
| 171610 | 48731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2002 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | |||
| 171681 | 87867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
| 177772 | 83360 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2322 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50843 | 6000204.02563621 | 2119927.77926672 | 37.8009274898516 | -122.443451293811 | (37.8009274898516, -122.443451293811) | 13 | 9 | 1 | 57 | 17 | ||
| 180588 | 87454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2516 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50378 | 6000865 | 2118972 | 37.7983408450274 | -122.441095438221 | (37.7983408450274, -122.441095438221) | 13 | 9 | 1 | 57 | 17 | |||
| 183343 | 52128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | Permit Number 48312 | 6003680.41407753 | 2109722.31110522 | 37.7731034892906 | -122.430692851209 | (37.7731034892906, -122.430692851209) | 15 | 9 | 11 | 29492 | 10 | |||
| 187938 | 52127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48312 | 6003680.41407753 | 2109722.31110522 | 37.7731034892906 | -122.430692851209 | (37.7731034892906, -122.430692851209) | 15 | 9 | 11 | 29492 | 10 | ||
| 190922 | 69233 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 539 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33289 | 6005277.10094302 | 2110933.89585771 | 37.77652053588 | -122.42525593371 | (37.77652053588, -122.42525593371) | 7 | 9 | 11 | 28852 | 10 | ||
| 191996 | 52434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48548 | 6004817.68850791 | 2115436.94951127 | 37.7888588401734 | -122.427165998542 | (37.7888588401734, -122.427165998542) | 13 | 9 | 11 | 28858 | 27 | ||
| 193756 | 61982 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | 13 | 9 | 1 | 57 | 17 | ||
| 59517 | 139858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 702 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005734.4525 | 2112096.2581 | 37.779737926575 | -122.4237564888 | (37.779737926575, -122.4237564888) | 7 | 9 | 11 | 28852 | 41 | |||
| 70288 | 126514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Casa Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001509.62012 | 2121629.43894 | 37.8056741643903 | -122.439055417799 | (37.8056741643903, -122.439055417799) | 13 | 9 | 1 | 57 | 17 | |||
| 85115 | 100357 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
| 96474 | 142259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004708.2263 | 2110563.0976 | 37.7754702599594 | -122.427197416812 | (37.7754702599594, -122.427197416812) | 7 | 9 | 11 | 28852 | 10 | |||
| 109252 | 65832 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2205 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 1 | Permit Number 28822 | 6000136.86621 | 2120563.93301 | 37.8026703676171 | -122.443729421089 | (37.8026703676171, -122.443729421089) | 13 | 9 | 1 | 57 | 17 | |
| 115576 | 64968 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1674 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 1 | Permit Number 26003 | 6004952.75334 | 2119199.45471 | 37.7991973630238 | -122.426966773099 | (37.7991973630238, -122.426966773099) | 13 | 9 | 1 | 57 | 17 | |
| 154292 | 142260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004691.5283 | 2110560.7676 | 37.7754629180406 | -122.427255013183 | (37.7754629180406, -122.427255013183) | 7 | 9 | 11 | 28852 | 10 | |||
| 173377 | 126524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002732.93596 | 2121317.83643 | 37.8048881155466 | -122.434799663981 | (37.8048881155466, -122.434799663981) | 13 | 9 | 1 | 57 | 17 | |||
| 176409 | 100356 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
| 14856 | 126525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.8029309470697 | -122.430014078187 | (37.8029309470697, -122.430014078187) | 13 | 9 | 1 | 57 | 17 | |||
| 24312 | 126513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.8041193022167 | -122.438461940777 | (37.8041193022167, -122.438461940777) | 13 | 9 | 1 | 57 | 17 | |||
| 27761 | 126498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.7991247544637 | -122.426523212175 | (37.7991247544637, -122.426523212175) | 13 | 9 | 1 | 57 | 17 | |||
| 51136 | 224091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004510.25041 | 2109143.13465 | 37.7715601901838 | -122.427781065151 | (37.7715601901838, -122.427781065151) | 7 | 9 | 11 | 28852 | 10 | |||
| 97010 | 40609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 10 | Permit Number 41619 | 6005248.55961 | 2120627.08998 | 37.8031340049926 | -122.426044866398 | (37.8031340049926, -122.426044866398) | 13 | 9 | 1 | 28858 | 17 | ||
| 109183 | 246574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6005235.59585 | 2109292.29359 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | 7 | 9 | 11 | 28852 | 10 | |||
| 112160 | 68237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | 13 | 9 | 1 | 57 | 17 | |
| 136408 | 126504 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2520 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000806.13814 | 2118970.30741 | 37.798332844742 | -122.441298996056 | (37.798332844742, -122.441298996056) | 13 | 9 | 1 | 57 | 17 | |||
| 146753 | 68253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.92976 | 37.8051366728892 | -122.442254132748 | (37.8051366728892, -122.442254132748) | 13 | 9 | 1 | 57 | 17 | |
| 162028 | 64971 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | 10 | Permit Number 26006 | 6005064.1075 | 2119167.53641 | 37.7991160193549 | -122.426579175209 | (37.7991160193549, -122.426579175209) | 13 | 9 | 1 | 57 | 17 | |
| 187842 | 61998 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3337 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 10 | Permit Number 22065 | 6004092.37742 | 2120634.4827 | 37.8030888913932 | -122.430046392648 | (37.8030888913932, -122.430046392648) | 13 | 9 | 1 | 57 | 17 | |
| 9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
| 9725 | 31671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.7912416742097 | -122.419225877479 | (37.7912416742097, -122.419225877479) | 13 | 9 | 10 | 28858 | 21 | |
| 75209 | 224088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004610.98363 | 2109155.17088 | 37.7715989365628 | -122.427433480775 | (37.7715989365628, -122.427433480775) | 7 | 9 | 11 | 28852 | 10 | |||
| 87301 | 224087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004639.34009 | 2109155.86974 | 37.7716024592153 | -122.427335443897 | (37.7716024592153, -122.427335443897) | 7 | 9 | 11 | 28852 | 10 | |||
| 87764 | 61985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3212 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22052 | 6004200.44828 | 2120220.07156 | 37.8019571458696 | -122.429642837148 | (37.8019571458696, -122.429642837148) | 13 | 9 | 1 | 57 | 17 | |
| 149291 | 246575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6005230.8128 | 2109313.15324 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | 7 | 9 | 11 | 28852 | 10 | |||
| 155105 | 64970 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 11 | Permit Number 26005 | 6005030.07255 | 2119163.06773 | 37.7991018253479 | -122.426696629358 | (37.7991018253479, -122.426696629358) | 13 | 9 | 1 | 57 | 17 | |
| 165274 | 61980 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.4296037598 | (37.8009411736685, -122.4296037598) | 13 | 9 | 1 | 57 | 17 | |
| 179067 | 246576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216 | (37.7721221684335, -122.42531053216) | 7 | 9 | 11 | 28852 | 10 | |||
| 35395 | 64964 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.10624 | 2119511.23081 | 37.8000586419391 | -122.426669414059 | (37.8000586419391, -122.426669414059) | 13 | 9 | 1 | 57 | 17 | |
| 67463 | 55804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.7991487753414 | -122.42632699542 | (37.7991487753414, -122.42632699542) | 13 | 9 | 1 | 57 | 17 | ||
| 84723 | 126495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238 | (37.7951371326294, -122.44382203238) | 13 | 9 | 1 | 57 | 17 | |||
| 128406 | 246572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6005238.2187 | 2109262.186 | 37.7719282296287 | -122.425271453026 | (37.7719282296287, -122.425271453026) | 7 | 9 | 11 | 28852 | 10 | |||
| 11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
| 32015 | 61986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3219 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 13 | Permit Number 22053 | 6004150.64271 | 2120237.53433 | 37.8020022738516 | -122.429816434187 | (37.8020022738516, -122.429816434187) | 13 | 9 | 1 | 57 | 17 | |
| 93556 | 224095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004037.99786 | 2108888.07328 | 37.77083312788 | -122.429396421106 | (37.77083312788, -122.429396421106) | 7 | 9 | 11 | 29492 | 10 | |||
| 117720 | 224094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004048.7307 | 2108889.92984 | 37.7708388331853 | -122.42935942839 | (37.7708388331853, -122.42935942839) | 7 | 9 | 11 | 29492 | 10 | |||
| 124905 | 246577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | 7 | 9 | 11 | 28852 | 10 | |||
| 178180 | 246578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005224.61763 | 2109380.51832 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | 7 | 9 | 11 | 28852 | 10 | |||
| 187425 | 126520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000968.94208 | 2120040.14536 | 37.8012796092356 | -122.440812430464 | (37.8012796092356, -122.440812430464) | 13 | 9 | 1 | 57 | 17 | |||
| 114388 | 224085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004536.35935 | 2109097.26869 | 37.7714357303029 | -122.427687484405 | (37.7714357303029, -122.427687484405) | 7 | 9 | 11 | 28852 | 10 | |||
| 116146 | 246582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | 7 | 9 | 11 | 28852 | 10 | |||
| 142355 | 126518 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001004.11411 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | 13 | 9 | 1 | 57 | 17 | |||
| 98434 | 224090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.7715753671272 | -122.427616451463 | (37.7715753671272, -122.427616451463) | 7 | 9 | 11 | 28852 | 10 | |||
| 131226 | 54136 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | 13 | 9 | 1 | 57 | 27 | ||
| 26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
| 112806 | 121021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.8000754484782 | -122.42658871161 | (37.8000754484782, -122.42658871161) | 13 | 9 | 1 | 57 | 17 | |||
| 90366 | 55965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.14258 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | 5 | 9 | 1 | 28858 | 32 | |
| 20602 | 126531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005210.197 | 2117169.09516 | 37.7936370652524 | -122.425931322478 | (37.7936370652524, -122.425931322478) | 13 | 9 | 1 | 28858 | 27 | |||
| 57827 | 34683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 2 | Permit Number 770151 | 6003781.4605 | 2118989.07405 | 37.7985534124753 | -122.43100482351 | (37.7985534124753, -122.43100482351) | 13 | 9 | 1 | 57 | 17 | ||
| 61862 | 250069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 307 Austin St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | 13 | 9 | 1 | 28858 | 41 | |||
| 104631 | 250068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 307 Austin St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6005700.31875 | 2115344.38579 | 37.7886545567034 | -122.424105631271 | (37.7886545567034, -122.424105631271) | 13 | 9 | 1 | 28858 | 41 | |||
| 112026 | 114562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 774856 | 6005427.79379 | 2117145.93262 | 37.7935857616223 | -122.425176769692 | (37.7935857616223, -122.425176769692) | 13 | 9 | 1 | 28858 | 27 | ||
| 113129 | 126530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005227.37951 | 2117173.30895 | 37.7936496062927 | -122.425872169587 | (37.7936496062927, -122.425872169587) | 13 | 9 | 1 | 28858 | 27 | |||
| 113456 | 139822 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005086 | 2111993 | 37.7794177784995 | -122.425992418184 | (37.7794177784995, -122.425992418184) | 7 | 9 | 11 | 28852 | 41 | |||
| 147189 | 61923 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51174 | 6003804.33633 | 2118991.05291 | 37.7985601420962 | -122.430925807306 | (37.7985601420962, -122.430925807306) | 13 | 9 | 1 | 57 | 17 | |
| 168569 | 137794 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2001 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004786.5899 | 2115639.5455 | 37.7894133591775 | -122.427288032938 | (37.7894133591775, -122.427288032938) | 13 | 9 | 11 | 28858 | 27 | |||
| 188422 | 224093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 353 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004017.83242 | 2109024.56898 | 37.7712067701103 | -122.429475909489 | (37.7712067701103, -122.429475909489) | 7 | 9 | 11 | 29492 | 10 |
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) );