trees
856 rows where qSpecies_id = 5 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172314 | 225082 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002779.31526 | 2103257.03916 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) | 2 | 4 | 5 | 28862 | 22 | |||
| 172152 | 189849 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 12 | : | Tree | Private 2 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.7420233065307 | -122.38283152746 | (37.7420233065307, -122.38283152746) | 10 | 3 | 8 | 58 | 1 | |||
| 171993 | 225042 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999193.16537 | 2106656.55415 | 37.7644304531311 | -122.445994213458 | (37.7644304531311, -122.445994213458) | 15 | 5 | 11 | 29492 | 9 | |||
| 170988 | 225052 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000953.83658 | 2096674.21341 | 37.7371217252913 | -122.439189029173 | (37.7371217252913, -122.439189029173) | 2 | 7 | 5 | 63 | 7 | |||
| 170663 | 225064 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998981.07779 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | 15 | 5 | 11 | 29492 | 9 | |||
| 170609 | 206008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.473715632987 | (37.7394739659536, -122.473715632987) | 1 | 8 | 4 | 29491 | 40 | |||
| 170549 | 16497 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | 10 | 3 | 8 | 58 | 1 | |||
| 170432 | 199692 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | 10 | 3 | 8 | 58 | 1 | |||
| 169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
| 169891 | 205990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993405.09676 | 2093676.51676 | 37.7284583518695 | -122.46507057606 | (37.7284583518695, -122.46507057606) | 9 | 8 | 4 | 59 | 40 | |||
| 169680 | 225063 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998979.47876 | 2106681.18548 | 37.7644858801306 | -122.44673506599 | (37.7644858801306, -122.44673506599) | 15 | 5 | 11 | 29492 | 9 | |||
| 169536 | 222895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.09401 | 37.7650176483701 | -122.421511125848 | (37.7650176483701, -122.421511125848) | 8 | 4 | 7 | 28853 | 19 | ||
| 169246 | 14640 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | 7 | 9 | 11 | 28852 | 41 | |||
| 169044 | 16510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 168987 | 222912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004886.98291 | 2109837.99569 | 37.7734894140273 | -122.42652741201 | (37.7734894140273, -122.42652741201) | 7 | 9 | 11 | 28852 | 10 | |||
| 168615 | 4389 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | ||
| 168339 | 2544 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6016440 | 2099034 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | 10 | 3 | 8 | 58 | 1 | |||
| 168028 | 16541 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | 10 | 3 | 8 | 58 | 1 | |||
| 167962 | 189908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6016294.30511 | 2098287.70361 | 37.7424130322313 | -122.38626203637 | (37.7424130322313, -122.38626203637) | 10 | 3 | 8 | 58 | 1 | |||
| 167565 | 94892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
| 167516 | 51302 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 12 | Permit Number 47670 | 6008052.8861 | 2112760.32075 | 37.7816918867218 | -122.415783025366 | (37.7816918867218, -122.415783025366) | 7 | 10 | 9 | 28852 | 36 | |
| 167263 | 14924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
| 167066 | 125973 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006932.43872 | 2121860.17562 | 37.8066147680158 | -122.420305317544 | (37.8066147680158, -122.420305317544) | 5 | 1 | 1 | 28858 | 32 | |||
| 166582 | 14918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017351.5544479 | 2098138.8848753 | 37.7420628687633 | -122.382595996286 | (37.7420628687633, -122.382595996286) | 10 | 3 | 8 | 58 | 1 | |||
| 166537 | 6646 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | ||
| 166428 | 65950 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | 7 | 10 | 9 | 28852 | 36 | ||
| 166358 | 189847 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017231.39271 | 2098158.22234 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | 10 | 3 | 8 | 58 | 1 | |||
| 166336 | 188472 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.415854126661 | (37.7713614445082, -122.415854126661) | 8 | 2 | 9 | 28853 | 19 | |||
| 166205 | 175843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.426438147115 | (37.7258847232758, -122.426438147115) | 9 | 7 | 6 | 28861 | 5 | |||
| 166057 | 225074 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.7507448939762 | -122.417465967185 | (37.7507448939762, -122.417465967185) | 2 | 4 | 7 | 28859 | 19 | |||
| 166050 | 222891 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2759 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009566.16928 | 2103923.02169 | 37.7575116637409 | -122.409923724614 | (37.7575116637409, -122.409923724614) | 2 | 4 | 7 | 28859 | 19 | |||
| 165805 | 188470 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | 8 | 2 | 9 | 28853 | 19 | |||
| 165477 | 4918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
| 165457 | 225071 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009374.80383 | 2103883.56216 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | 2 | 4 | 7 | 28859 | 19 | |||
| 165394 | 17387 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6014551.02447 | 2095461.01119 | 37.7345548713079 | -122.392092190109 | (37.7345548713079, -122.392092190109) | 10 | 3 | 8 | 58 | 1 | |||
| 164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
| 164683 | 112815 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991472 | 2104830 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | 1 | 8 | 4 | 56 | 12 | ||||
| 164614 | 225069 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.7576228514299 | -122.41150982923 | (37.7576228514299, -122.41150982923) | 2 | 4 | 7 | 28859 | 19 | |||
| 164599 | 51670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.447690414133 | (37.765863591183, -122.447690414133) | 15 | 5 | 11 | 29492 | 9 | ||||
| 164547 | 14929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
| 164425 | 4913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
| 164263 | 6649 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | |||
| 163591 | 93112 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.385343417566 | (37.7426681627043, -122.385343417566) | 10 | 3 | 8 | 58 | 1 | |
| 163554 | 63121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 42 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23632 | 6007120.53987433 | 2099276.08223849 | 37.7446148564174 | -122.418052288309 | (37.7446148564174, -122.418052288309) | 2 | 7 | 7 | 28859 | 2 | ||
| 163469 | 3627 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | 10 | 3 | 8 | 58 | 1 | ||
| 163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 163249 | 189904 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6016400.23461 | 2098374.6941 | 37.7426577530525 | -122.385901822825 | (37.7426577530525, -122.385901822825) | 10 | 3 | 8 | 58 | 1 | |||
| 162327 | 60271 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1982 12:00:00 AM | 12 | 3x3 | Permit Number 19827 | 6009603.81924648 | 2103922.02713572 | 37.7575110429284 | -122.409793445145 | (37.7575110429284, -122.409793445145) | 2 | 4 | 7 | 28859 | 19 |
| 162252 | 189848 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 11 | : | Tree | Private 2 | 8 | Width 4ft | 6017264.73109 | 2098137.17538 | 37.7420533780644 | -122.38289608801 | (37.7420533780644, -122.38289608801) | 10 | 3 | 8 | 58 | 1 | |||
| 162198 | 189923 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013419.15414 | 2116110.66886 | 37.7911913760301 | -122.397453179235 | (37.7911913760301, -122.397453179235) | 12 | 2 | 9 | 28855 | 6 | |||
| 161983 | 189946 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 6014709.04159 | 2116225.6637 | 37.7915788597386 | -122.392998221109 | (37.7915788597386, -122.392998221109) | 12 | 2 | 9 | 28855 | 6 | |||
| 161658 | 225096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004357.77926 | 2109121.04656 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | 7 | 9 | 11 | 28852 | 10 | |||
| 161614 | 63122 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.418402950875 | (37.7447579331798, -122.418402950875) | 2 | 7 | 7 | 28859 | 2 | ||
| 161350 | 2503 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.7439716553617 | -122.384993582204 | (37.7439716553617, -122.384993582204) | 10 | 3 | 8 | 58 | 1 | |||
| 161298 | 47317 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | 10 | 4 | 8 | 28859 | 19 | |||
| 161276 | 188483 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016580.58877 | 2098830.37302 | 37.7439189335051 | -122.385309950204 | (37.7439189335051, -122.385309950204) | 10 | 3 | 8 | 58 | 1 | |||
| 161171 | 113383 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5994461 | 2101055 | 37.7487786662853 | -122.461955122224 | (37.7487786662853, -122.461955122224) | 1 | 8 | 4 | 29491 | 40 | |||
| 161147 | 60694 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2770 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20337 | 6009580.52702931 | 2103388.84293588 | 37.7560457337564 | -122.409836363248 | (37.7560457337564, -122.409836363248) | 2 | 4 | 7 | 28859 | 19 | ||
| 161042 | 101045 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
| 161020 | 189926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013338.6063 | 2116192.95214 | 37.7914128215027 | -122.397737648268 | (37.7914128215027, -122.397737648268) | 12 | 2 | 9 | 28855 | 6 | |||
| 160679 | 101685 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 12x9 | 6013519.41723 | 2105388.32273 | 37.7617558261822 | -122.396354408248 | (37.7617558261822, -122.396354408248) | 10 | 3 | 8 | 28856 | 29 | |||
| 159563 | 205993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994259.77922 | 2101011.29176 | 37.7486470679175 | -122.462647767404 | (37.7486470679175, -122.462647767404) | 1 | 8 | 4 | 29491 | 40 | |||
| 159417 | 57469 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.468312338233 | (37.7263014049972, -122.468312338233) | 9 | 8 | 4 | 59 | 40 | ||
| 159299 | 189945 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6014694.61322 | 2116242.67208 | 37.7916247593304 | -122.393049334066 | (37.7916247593304, -122.393049334066) | 12 | 2 | 9 | 28855 | 6 | |||
| 159275 | 225067 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009115.2795 | 2103823.24781 | 37.7572124269416 | -122.411476039894 | (37.7572124269416, -122.411476039894) | 2 | 4 | 7 | 28859 | 19 | |||
| 158939 | 17414 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.395208309826 | (37.7365002389252, -122.395208309826) | 10 | 3 | 8 | 58 | 1 | |||
| 158873 | 97183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
| 158664 | 189901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6016452.46192 | 2098385.21634 | 37.7426895350994 | -122.385721967406 | (37.7426895350994, -122.385721967406) | 10 | 3 | 8 | 58 | 1 | |||
| 158465 | 188476 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6010896.57818 | 2106030.20806 | 37.7633719978287 | -122.405471012994 | (37.7633719978287, -122.405471012994) | 8 | 4 | 8 | 28856 | 19 | |||
| 158043 | 222892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2751 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009588.6552 | 2103924.1994 | 37.7575161576583 | -122.409846042069 | (37.7575161576583, -122.409846042069) | 2 | 4 | 7 | 28859 | 19 | |||
| 157690 | 97185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
| 157121 | 248253 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006804.33159 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | 2 | 7 | 7 | 28859 | 2 | |||
| 156506 | 101043 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
| 156383 | 30908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1511 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34730 | 5999634.2212 | 2114153.2322 | 37.7850395970423 | -122.445007693392 | (37.7850395970423, -122.445007693392) | 15 | 6 | 1 | 29490 | 31 | ||
| 156238 | 189936 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013261.48411 | 2116177.89779 | 37.7913671907995 | -122.398003434816 | (37.7913671907995, -122.398003434816) | 12 | 2 | 9 | 28855 | 6 | |||
| 156051 | 139008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | 15 | 6 | 1 | 29490 | 31 | |||
| 155907 | 16488 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
| 155575 | 222907 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004783.41695 | 2109826.60113 | 37.7734522720333 | -122.426884850272 | (37.7734522720333, -122.426884850272) | 7 | 9 | 11 | 28852 | 10 | |||
| 155251 | 103345 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 29899 | 6010491 | 2108479 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | 8 | 2 | 9 | 28853 | 34 | ||
| 155081 | 2536 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016262.66893 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | 10 | 3 | 8 | 58 | 1 | |||
| 154770 | 47240 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1006X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013969.3769 | 2089681.5637 | 37.7186533627648 | -122.393698770823 | (37.7186533627648, -122.393698770823) | 10 | 3 | 8 | 58 | 1 |
| 154655 | 125978 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008392.85025 | 2121496.40648 | 37.8056981340166 | -122.415225505068 | (37.8056981340166, -122.415225505068) | 5 | 1 | 10 | 308 | 23 | |||
| 154516 | 189965 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 185 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009800.49683 | 2111495.15523 | 37.7783161303187 | -122.409647766737 | (37.7783161303187, -122.409647766737) | 14 | 2 | 9 | 28853 | 34 | |||
| 154349 | 60691 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2767 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20334 | 6009604.72609902 | 2103338.10407704 | 37.7559077723841 | -122.409749093146 | (37.7559077723841, -122.409749093146) | 2 | 4 | 7 | 28859 | 19 | ||
| 154326 | 175840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | 9 | 7 | 6 | 28861 | 5 | |||
| 153705 | 51299 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.7816834187084 | -122.415851598691 | (37.7816834187084, -122.415851598691) | 7 | 10 | 9 | 28852 | 36 | |
| 153552 | 248204 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006982.89792 | 2099182.49751 | 37.7443501458548 | -122.418521593214 | (37.7443501458548, -122.418521593214) | 2 | 7 | 7 | 28859 | 2 | |||
| 153332 | 96855 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007257 | 2097738 | 37.740399305054 | -122.417471450766 | (37.740399305054, -122.417471450766) | 2 | 7 | 7 | 28859 | 2 | |||
| 153327 | 16546 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6016053.72523 | 2097961.74591 | 37.7415046998888 | -122.387071167201 | (37.7415046998888, -122.387071167201) | 10 | 3 | 8 | 58 | 1 | |||
| 153227 | 248231 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.7441994158673 | -122.418730149576 | (37.7441994158673, -122.418730149576) | 2 | 7 | 7 | 28859 | 2 | |||
| 153118 | 189887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.7424897920671 | -122.384133016442 | (37.7424897920671, -122.384133016442) | 10 | 3 | 8 | 58 | 1 | |||
| 152653 | 51304 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767250 | 6001037.11613846 | 2102279.06351254 | 37.7525160532628 | -122.439302719451 | (37.7525160532628, -122.439302719451) | 2 | 4 | 5 | 28862 | 22 | |
| 152645 | 205995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | 9 | 7 | 4 | 59 | 40 | |||
| 152398 | 125977 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008401.62888 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | 5 | 1 | 10 | 308 | 23 | |||
| 151412 | 2504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | 10 | 3 | 8 | 58 | 1 | |||
| 151186 | 222896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.7662362369242 | -122.420959163358 | (37.7662362369242, -122.420959163358) | 8 | 4 | 7 | 28853 | 19 | |||
| 150613 | 21782 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2550 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | 3 | 1 | 10 | 308 | 23 | |||
| 150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
| 149944 | 248228 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692776 | -122.418618023005 | (37.744353692776, -122.418618023005) | 2 | 7 | 7 | 28859 | 2 | |||
| 149886 | 5523 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.7556899313628 | -122.425382766602 | (37.7556899313628, -122.425382766602) | 2 | 4 | 5 | 28859 | 19 |
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) );