trees
2,421 rows where qSpecies_id = 8 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 118388 | 191088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 01st St | 19 | : Yard | Tree | Private 2 | 18 | 6014455.34951 | 2105889.69248 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | 14 | 3 | 8 | 28856 | 29 | ||||
| 28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
| 15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
| 117894 | 223384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005565.50658 | 2104580.7732 | 37.759092667419 | -122.423806408847 | (37.759092667419, -122.423806408847) | 2 | 4 | 5 | 28859 | 19 | |||
| 156214 | 223383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005540.24064 | 2104579.79946 | 37.7590885674118 | -122.423893721341 | (37.7590885674118, -122.423893721341) | 2 | 4 | 5 | 28859 | 19 | |||
| 36200 | 207691 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172672 | (37.7431261613357, -122.46701172672) | 1 | 8 | 4 | 59 | 40 | |||
| 56204 | 207693 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.466987567326 | (37.7431879987389, -122.466987567326) | 1 | 8 | 4 | 59 | 40 | |||
| 59586 | 52350 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 153388 | 207692 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992959.6562 | 2099040.51355 | 37.7431608508894 | -122.467000282841 | (37.7431608508894, -122.467000282841) | 1 | 8 | 4 | 59 | 40 | |||
| 158823 | 52349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 165563 | 52351 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
| 26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
| 43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
| 116544 | 176243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.7204250353617 | -122.400893277618 | (37.7204250353617, -122.400893277618) | 10 | 7 | 8 | 309 | 28 | |||
| 187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
| 47493 | 38141 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 4 | Permit Number 40298 | 6010551.38823 | 2093805.12649 | 37.7297852835414 | -122.40580373606 | (37.7297852835414, -122.40580373606) | 10 | 3 | 7 | 309 | 28 | |
| 72717 | 246573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.425276447877 | (37.771957957636, -122.425276447877) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 80158 | 48688 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 178014 | 48687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
| 69440 | 31713 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.7625336156627 | -122.44954088871 | (37.7625336156627, -122.44954088871) | 15 | 5 | 11 | 29492 | 9 | |
| 145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
| 55443 | 90161 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1000X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992485.27988 | 2111393.76315 | 37.7770522373591 | -122.469539600379 | (37.7770522373591, -122.469539600379) | 11 | 6 | 2 | 54 | 11 | ||
| 167142 | 90162 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1000X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992470.47116 | 2111395.13018 | 37.7770551349921 | -122.469590927435 | (37.7770551349921, -122.469590927435) | 11 | 6 | 2 | 54 | 11 | ||
| 85406 | 90352 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1001 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992411.32827 | 2111337.20647 | 37.7768926738444 | -122.469791301151 | (37.7768926738444, -122.469791301151) | 11 | 6 | 2 | 54 | 11 | ||
| 86374 | 90900 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1003 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992498.4502 | 2110659.84076 | 37.7750378461806 | -122.469440604249 | (37.7750378461806, -122.469440604249) | 11 | 6 | 2 | 54 | 11 | ||
| 36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
| 41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
| 54705 | 126555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | 3 | 1 | 10 | 308 | 23 | |||
| 63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
| 71572 | 126556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499876 | -122.402609980888 | (37.799883499876, -122.402609980888) | 3 | 1 | 10 | 308 | 23 | |||
| 96112 | 126554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | 3 | 1 | 10 | 308 | 23 | |||
| 169709 | 126558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | 3 | 1 | 10 | 308 | 23 | |||
| 3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
| 129472 | 19295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 6 | 3X3 | 5995238.34395 | 2110816.54883 | 37.7756260846481 | -122.459974134414 | (37.7756260846481, -122.459974134414) | 11 | 6 | 2 | 54 | 11 | ||
| 184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
| 159134 | 85529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | 8 | 2 | 9 | 28853 | 19 | ||
| 24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
| 158104 | 120821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.7857450701275 | -122.479859643088 | (37.7857450701275, -122.479859643088) | 11 | 6 | 2 | 55 | 26 | |||
| 56390 | 138230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998494.0384 | 2112624.2642 | 37.7807763098306 | -122.448842177387 | (37.7807763098306, -122.448842177387) | 15 | 6 | 2 | 54 | 16 | |||
| 174493 | 138228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998518.0663 | 2112627.9868 | 37.7807879051601 | -122.448759321794 | (37.7807879051601, -122.448759321794) | 15 | 6 | 2 | 54 | 16 | |||
| 132262 | 124029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991795.62331 | 2114277.55052 | 37.7849304438848 | -122.472135568047 | (37.7849304438848, -122.472135568047) | 11 | 6 | 2 | 54 | 11 | |||
| 158433 | 124028 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Funston Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991796.1991 | 2114253.0901 | 37.7848633156564 | -122.472131792452 | (37.7848633156564, -122.472131792452) | 11 | 6 | 2 | 54 | 11 | |||
| 46447 | 175836 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994366.58552 | 2086543.72285 | 37.7089288002067 | -122.46122985489 | (37.7089288002067, -122.46122985489) | 9 | 8 | 6 | 28861 | 25 | |||
| 99219 | 4397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | 2 | 4 | 5 | 28862 | 22 | |||
| 164066 | 64564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.409683212627 | (37.7941042450764, -122.409683212627) | 3 | 1 | 10 | 28857 | 21 | |
| 132271 | 141989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.7789487270827 | -122.42870472731 | (37.7789487270827, -122.42870472731) | 7 | 9 | 11 | 29490 | 41 | |||
| 113152 | 85530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.50444 | 37.7722888802537 | -122.418030010287 | (37.7722888802537, -122.418030010287) | 8 | 2 | 9 | 28853 | 19 | |||
| 125971 | 85531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007317.96828 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | 8 | 2 | 9 | 28853 | 19 | |||
| 27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
| 27976 | 67374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 6 | Permit Number 30868 | 5992412.40492 | 2111393.18626 | 37.7770464413981 | -122.469791653286 | (37.7770464413981, -122.469791653286) | 11 | 6 | 2 | 54 | 11 | |
| 78245 | 90163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992466.887805 | 2111387.622086 | 37.7770343127004 | -122.469602776563 | (37.7770343127004, -122.469602776563) | 11 | 6 | 2 | 54 | 11 | ||
| 146237 | 35565 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2003 12:00:00 AM | Permit Number 38935 | 6005771.77167049 | 2102851.56857317 | 37.7543563162185 | -122.422970143174 | (37.7543563162185, -122.422970143174) | 2 | 4 | 5 | 28859 | 19 | ||
| 164864 | 216659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1022 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:44:00 AM | 3 | Width 4ft | 5995946.33237 | 2090713.9624 | 37.7204700913979 | -122.456071352615 | (37.7204700913979, -122.456071352615) | 9 | 8 | 6 | 28861 | 24 | ||
| 156421 | 50409 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1023 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2003 12:00:00 AM | Permit Number 47064 | 6005772.16397035 | 2102844.45984762 | 37.7543368194422 | -122.422968281285 | (37.7543368194422, -122.422968281285) | 2 | 4 | 5 | 28859 | 19 | |||
| 11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
| 79617 | 90899 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992439.368739 | 2110665.968462 | 37.7750512566564 | -122.469645424238 | (37.7750512566564, -122.469645424238) | 11 | 6 | 2 | 54 | 11 | ||
| 17626 | 90350 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | 11 | 6 | 2 | 54 | 11 | ||
| 160841 | 90351 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992345.34525 | 2111334.78441 | 37.7768822094186 | -122.470019378014 | (37.7768822094186, -122.470019378014) | 11 | 6 | 2 | 54 | 11 | ||
| 190833 | 90349 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992315.42608 | 2111334.89456 | 37.7768807822567 | -122.470122884589 | (37.7768807822567, -122.470122884589) | 11 | 6 | 2 | 54 | 11 | ||
| 85918 | 84126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.83718 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | 10 | 7 | 8 | 309 | 28 | |
| 8997 | 47687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
| 71264 | 47688 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
| 92554 | 47689 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
| 157616 | 141987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004139.84 | 2111815.1387 | 37.7788758968254 | -122.429252898528 | (37.7788758968254, -122.429252898528) | 7 | 9 | 11 | 29490 | 41 | |||
| 52305 | 223550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997652.48315 | 2106877.54396 | 37.7649491371199 | -122.451338921264 | (37.7649491371199, -122.451338921264) | 15 | 5 | 11 | 29492 | 9 | |||
| 23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
| 33794 | 191086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | 14 | 3 | 8 | 28856 | 29 | |||
| 46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
| 124140 | 191087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | 14 | 3 | 8 | 28856 | 29 | ||||
| 186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
| 70526 | 66093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.416894219588 | (37.8004974059005, -122.416894219588) | 5 | 1 | 1 | 308 | 32 | |
| 194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
| 153618 | 191068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 106 Langton St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6010213.08223 | 2110716.24311 | 37.7762005309779 | -122.408165525739 | (37.7762005309779, -122.408165525739) | 8 | 2 | 9 | 28853 | 34 | |||
| 63409 | 46246 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | |||
| 63990 | 46247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | ||
| 183033 | 117303 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299 | -122.410120841459 | (37.754753524299, -122.410120841459) | 2 | 4 | 7 | 28859 | 19 | ||
| 45768 | 47096 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
| 180135 | 47097 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
| 4986 | 51031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.57141 | 2089923.66488 | 37.7191984823926 | -122.401143367398 | (37.7191984823926, -122.401143367398) | 10 | 7 | 8 | 309 | 28 | ||
| 30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
| 6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
| 15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
| 98940 | 223451 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 109 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998103.07896 | 2106202.61569 | 37.7631217452986 | -122.44973178961 | (37.7631217452986, -122.44973178961) | 15 | 5 | 11 | 29492 | 9 | |||
| 178719 | 223450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 109 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998091.45259 | 2106201.0539 | 37.7631167918352 | -122.449771888566 | (37.7631167918352, -122.449771888566) | 15 | 5 | 11 | 29492 | 9 | |||
| 53531 | 90553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1090 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992323.62833 | 2110709.32554 | 37.7751636133682 | -122.470048949636 | (37.7751636133682, -122.470048949636) | 11 | 6 | 2 | 54 | 11 | ||
| 126775 | 90552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1090 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992344.80015 | 2110709.94859 | 37.7751665479853 | -122.469975757615 | (37.7751665479853, -122.469975757615) | 11 | 6 | 2 | 54 | 11 | ||
| 43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 191324 | 30936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.99468 | 2091121.8923 | 37.7215880844914 | -122.456226438915 | (37.7215880844914, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 170486 | 95807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | 10 | 3 | 8 | 28856 | 29 | |
| 8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 |
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) );