trees
2,421 rows where qSpecies_id = 8 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118575 | 126503 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2514 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000838.22718 | 2118974.91794 | 37.7983473319336 | -122.441188289519 | (37.7983473319336, -122.441188289519) | 13 | 9 | 1 | 57 | 17 | |||
| 120076 | 126511 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000979.36028 | 2119998.96358 | 37.8011671283179 | -122.44077342326 | (37.8011671283179, -122.44077342326) | 13 | 9 | 1 | 57 | 17 | |||
| 124459 | 126545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008151.87492 | 2119410.8388 | 37.7999581436157 | -122.415911658989 | (37.7999581436157, -122.415911658989) | 5 | 1 | 1 | 308 | 32 | |||
| 129950 | 6373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | 15 | 5 | 1 | 29490 | 41 | |||
| 130500 | 18913 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.7895937169197 | -122.436453930026 | (37.7895937169197, -122.436453930026) | 13 | 6 | 1 | 29490 | 27 | |||
| 130734 | 126548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | ||
| 133050 | 78962 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000164.38759 | 2119919.60804 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | 13 | 9 | 1 | 57 | 17 | |||
| 133357 | 33126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.77318 | 2118925.97012 | 37.7982114272598 | -122.441276314246 | (37.7982114272598, -122.441276314246) | 13 | 9 | 1 | 57 | 17 | |
| 134359 | 172715 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
| 135243 | 41814 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 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 | |||
| 140852 | 126508 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2241 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000053.49785 | 2120204.95376 | 37.801679951426 | -122.443992108573 | (37.801679951426, -122.443992108573) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |
| 146857 | 126543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | 5 | 1 | 1 | 308 | 32 | |||
| 147006 | 126509 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2259 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999989.15096 | 2120195.34054 | 37.801649885296 | -122.444214086407 | (37.801649885296, -122.444214086407) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 147719 | 126493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003443.96116 | 2118340.85925 | 37.796754452719 | -122.432126360859 | (37.796754452719, -122.432126360859) | 13 | 9 | 1 | 57 | 17 | |||
| 152745 | 126523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1436 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004946.35763 | 2120239.41034 | 37.8020524524204 | -122.427063015844 | (37.8020524524204, -122.427063015844) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 157873 | 126500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000899.88147 | 2118980.33539 | 37.7983657185536 | -122.440975336363 | (37.7983657185536, -122.440975336363) | 13 | 9 | 1 | 57 | 17 | |||
| 158010 | 87110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2932` Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50060 | 6000132.04641 | 2116463.71551 | 37.7914119824297 | -122.443451403763 | (37.7914119824297, -122.443451403763) | 13 | 6 | 1 | 29490 | 27 | |
| 158435 | 126499 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1636 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005076.86043 | 2119214.79365 | 37.7992464965988 | -122.426538412535 | (37.7992464965988, -122.426538412535) | 13 | 9 | 1 | 57 | 17 | |||
| 159289 | 68965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2271 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52893 | 5999938.80053 | 2120187.45751 | 37.8016253679701 | -122.444387754501 | (37.8016253679701, -122.444387754501) | 13 | 9 | 1 | 57 | 17 | |
| 160324 | 139106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2549 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999977.0599 | 2113664.9676 | 37.7837185099966 | -122.443786492869 | (37.7837185099966, -122.443786492869) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | |
| 162807 | 126502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000862.28412 | 2118975.43357 | 37.7983501180095 | -122.441105082435 | (37.7983501180095, -122.441105082435) | 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 | |
| 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 | ||
| 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 | |||
| 173635 | 126547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.7998627156539 | -122.41589197733 | (37.7998627156539, -122.41589197733) | 5 | 1 | 1 | 308 | 32 | |||
| 174474 | 47462 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1818 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 7 | Permit Number 45366 | 6000023.68636 | 2115243.51305 | 37.788055445441 | -122.443738626559 | (37.788055445441, -122.443738626559) | 13 | 6 | 1 | 29490 | 27 | |
| 175557 | 84618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2334 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000130.7318 | 2119914.64406 | 37.8008872440121 | -122.443703976566 | (37.8008872440121, -122.443703976566) | 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 | ||
| 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 | |||
| 178959 | 137812 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | |||
| 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 | |||
| 187626 | 126512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000962.49695 | 2119994.9542 | 37.8011551592542 | -122.440831489795 | (37.8011551592542, -122.440831489795) | 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 | |
| 192545 | 126515 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3616 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997525.9275 | 2115116.25328 | 37.7875632438067 | -122.452371201775 | (37.7875632438067, -122.452371201775) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 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 | |||
| 8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
| 8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |
| 10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
| 12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 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 | |||
| 15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
| 15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
| 16533 | 74989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.412162212732 | (37.798876023557, -122.412162212732) | 3 | 1 | 10 | 308 | 4 | |||
| 25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
| 26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
| 32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |||
| 37659 | 62959 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.7965860510683 | -122.416344986535 | (37.7965860510683, -122.416344986535) | 5 | 1 | 10 | 28858 | 21 | |
| 39577 | 126542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 789 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | 3 | 1 | 10 | 308 | 4 | |||
| 40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
| 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 | |||
| 45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
| 45874 | 126550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.7986426917617 | -122.402360227452 | (37.7986426917617, -122.402360227452) | 3 | 1 | 10 | 308 | 23 | |||
| 47502 | 126551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012059.41755 | 2118828.15816 | 37.7985771500692 | -122.402349010193 | (37.7985771500692, -122.402349010193) | 3 | 1 | 10 | 308 | 23 | |||
| 53575 | 46871 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 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 | |||
| 59528 | 126534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | |||
| 78300 | 126552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.402245448777 | (37.7993296056227, -122.402245448777) | 3 | 1 | 10 | 28860 | 6 | |||
| 79356 | 66089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.97147 | 2120081.10266 | 37.8017685454413 | -122.417803248017 | (37.8017685454413, -122.417803248017) | 5 | 1 | 10 | 308 | 32 | |
| 86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
| 88936 | 88727 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 92474 | 32710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776816 | 6008703.66491 | 2115446.6282 | 37.7891044021039 | -122.413721697414 | (37.7891044021039, -122.413721697414) | 5 | 1 | 10 | 28858 | 21 |
| 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 | |||
| 103676 | 126536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1859 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006939.28013 | 2117655.36372 | 37.7950698030789 | -122.419983060779 | (37.7950698030789, -122.419983060779) | 13 | 9 | 10 | 28858 | 32 | |||
| 105051 | 108580 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 106009 | 108578 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 112367 | 59922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1501 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19392 | 6009252.52632 | 2118479.54886 | 37.797462868466 | -122.412037123318 | (37.797462868466, -122.412037123318) | 3 | 1 | 10 | 308 | 21 | |
| 113991 | 126532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | 3 | 1 | 10 | 28857 | 4 | |||
| 116323 | 126538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | 3 | 1 | 10 | 308 | 32 | |||
| 129370 | 62958 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23344 | 6008125.85575238 | 2118255.57771401 | 37.7967846215561 | -122.415919842071 | (37.7967846215561, -122.415919842071) | 5 | 1 | 10 | 28858 | 21 | ||
| 136867 | 126533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008367.41227 | 2117875.57513 | 37.7957548058969 | -122.415057087242 | (37.7957548058969, -122.415057087242) | 5 | 1 | 10 | 28858 | 21 | |||
| 143270 | 88403 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071 | 2119078 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | 3 | 1 | 10 | 308 | 32 | ||
| 148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
| 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 | |
| 165412 | 46870 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 167960 | 126535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008372.45938 | 2117840.81731 | 37.7956596531341 | -122.415037161853 | (37.7956596531341, -122.415037161853) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | |||
| 172916 | 62981 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1317 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23371 | 6007225.76848 | 2118431.56402 | 37.7972171916732 | -122.419046847643 | (37.7972171916732, -122.419046847643) | 5 | 1 | 10 | 28858 | 32 | |
| 187764 | 108579 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 | |||
| 495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
| 908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 56 | 12 | |||
| 1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
| 1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
| 1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 3320 | 245104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999855.4831 | 2109410.1992 | 37.7720290692692 | -122.443901304248 | (37.7720290692692, -122.443901304248) | 15 | 5 | 11 | 29492 | 9 |
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) );