trees
147 rows where PlotSize = "3x3" and qSpecies_id = 5 sorted by Fire Prevention 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110855 | 114592 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991433 | 2104626 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | ||||
| 438 | 16548 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016043.45751 | 2097947.55726 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | 10 | 3 | 8 | 58 | 1 | |||
| 1856 | 16547 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016044.76119 | 2097949.4335 | 37.7414703961451 | -122.387101303489 | (37.7414703961451, -122.387101303489) | 10 | 3 | 8 | 58 | 1 | |||
| 2472 | 6651 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | |||
| 3395 | 17446 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012949.46477 | 2096727.20845 | 37.7379425338291 | -122.397718137505 | (37.7379425338291, -122.397718137505) | 10 | 3 | 8 | 58 | 1 | |||
| 7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
| 8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
| 15049 | 16543 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.7416388751438 | -122.38696691509 | (37.7416388751438, -122.38696691509) | 10 | 3 | 8 | 58 | 1 | ||
| 20031 | 17400 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014126.91093 | 2095851.18558 | 37.7356026534403 | -122.393585802156 | (37.7356026534403, -122.393585802156) | 10 | 3 | 8 | 58 | 1 | |||
| 24626 | 93109 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.35417 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | 10 | 3 | 8 | 58 | 1 | |
| 32557 | 6849 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.7406745956723 | -122.387598567026 | (37.7406745956723, -122.387598567026) | 10 | 3 | 8 | 58 | 1 | |||
| 33168 | 14912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017247.98036 | 2098210.14599 | 37.7422528150795 | -122.38295908457 | (37.7422528150795, -122.38295908457) | 10 | 3 | 8 | 58 | 1 | |||
| 37237 | 16527 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016370.17243 | 2098292.39049 | 37.7424301004582 | -122.386000034169 | (37.7424301004582, -122.386000034169) | 10 | 3 | 8 | 58 | 1 | |||
| 39064 | 6846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | 10 | 3 | 8 | 58 | 1 | |||
| 43304 | 14908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 2 | 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 | |||
| 48636 | 16511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016438.27303 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | 10 | 3 | 8 | 58 | 1 | |||
| 49574 | 14913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | 10 | 3 | 8 | 58 | 1 | |||
| 52927 | 17415 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.7365975859977 | -122.395366549732 | (37.7365975859977, -122.395366549732) | 10 | 3 | 8 | 58 | 1 | |||
| 54911 | 16498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016898.45948 | 2098256.16023 | 37.7423598423185 | -122.384170835605 | (37.7423598423185, -122.384170835605) | 10 | 3 | 8 | 58 | 1 | |||
| 56857 | 16545 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.387038655827 | (37.7415453861211, -122.387038655827) | 10 | 3 | 8 | 58 | 1 | ||
| 58785 | 16556 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
| 62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
| 62892 | 16507 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016604.68474 | 2098314.93369 | 37.7425049753024 | -122.385190723599 | (37.7425049753024, -122.385190723599) | 10 | 3 | 8 | 58 | 1 | |||
| 63557 | 17398 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | 10 | 3 | 8 | 58 | 1 | |||
| 63725 | 96756 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | 10 | 3 | 8 | 58 | 1 | |||
| 65447 | 93113 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.49318 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | 10 | 3 | 8 | 58 | 1 | |
| 73224 | 16514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016343.32243 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | 10 | 3 | 8 | 58 | 1 | |||
| 73481 | 6848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.7406745956723 | -122.387598567026 | (37.7406745956723, -122.387598567026) | 10 | 3 | 8 | 58 | 1 | |||
| 76900 | 6652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 8 | 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 | |||
| 77909 | 14909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | 10 | 3 | 8 | 58 | 1 | |||
| 82714 | 94895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 4 | 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 |
| 84292 | 94894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 3 | 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 |
| 84909 | 14975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943 | (37.7404872941606, -122.38522858943) | 10 | 3 | 8 | 58 | 1 | |||
| 97684 | 115557 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
| 98289 | 14914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.7423051973143 | -122.383103612647 | (37.7423051973143, -122.383103612647) | 10 | 3 | 8 | 58 | 1 | |||
| 100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
| 102986 | 17458 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6012778.88075 | 2096779.84322 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | 10 | 3 | 8 | 58 | 1 | |||
| 106847 | 16553 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
| 107061 | 47237 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) | 10 | 3 | 8 | 58 | 1 |
| 107870 | 16512 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772612 | (37.7426746595649, -122.38584772612) | 10 | 3 | 8 | 58 | 1 | |||
| 109930 | 16491 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016683.07088 | 2098298.50072 | 37.7424641896573 | -122.384918540359 | (37.7424641896573, -122.384918540359) | 10 | 3 | 8 | 58 | 1 | |||
| 112435 | 47241 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543098 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) | 10 | 3 | 8 | 58 | 1 |
| 114719 | 6650 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 6 | 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 | |||
| 118720 | 17403 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6013944.43098 | 2095916.733 | 37.7357724918668 | -122.394221297579 | (37.7357724918668, -122.394221297579) | 10 | 3 | 8 | 58 | 1 | |||
| 120815 | 93114 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.71109 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | 10 | 3 | 8 | 58 | 1 | |
| 132285 | 94893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 2 | 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 |
| 137043 | 6850 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.7406745956723 | -122.387598567026 | (37.7406745956723, -122.387598567026) | 10 | 3 | 8 | 58 | 1 | ||
| 138537 | 47239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.7186233778889 | -122.393646260173 | (37.7186233778889, -122.393646260173) | 10 | 3 | 8 | 58 | 1 |
| 140399 | 6648 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 4 | 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 | |||
| 141218 | 93111 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.7426554067123 | -122.385264779961 | (37.7426554067123, -122.385264779961) | 10 | 3 | 8 | 58 | 1 | |
| 141600 | 6647 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | ||
| 145080 | 16513 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.7426632935725 | -122.385886149327 | (37.7426632935725, -122.385886149327) | 10 | 3 | 8 | 58 | 1 | |||
| 149371 | 14911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 |
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 |
| 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 | |||
| 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 | |||
| 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 | |||
| 173492 | 16554 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
| 177283 | 16490 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | 10 | 3 | 8 | 58 | 1 | |||
| 190306 | 93110 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.54888 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | 10 | 3 | 8 | 58 | 1 | |
| 191303 | 14915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.7423218290085 | -122.383156775767 | (37.7423218290085, -122.383156775767) | 10 | 3 | 8 | 58 | 1 | |||
| 193340 | 16552 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
| 1256 | 97187 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 9 | 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 | |||
| 5594 | 106035 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
| 17034 | 96473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | 12 | 2 | 9 | 28855 | 6 | ||
| 24818 | 97179 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013408 | 2116114 | 37.7911999015077 | -122.397492006217 | (37.7911999015077, -122.397492006217) | 12 | 2 | 9 | 28855 | 6 | |||
| 37802 | 119741 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 42963 | 97180 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 2 | 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 | |||
| 44569 | 119744 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 52265 | 95955 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675 | 2116143.7 | 37.791351915434 | -122.393110267966 | (37.791351915434, -122.393110267966) | 12 | 2 | 9 | 28855 | 6 | ||
| 53007 | 106030 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | 12 | 2 | 9 | 28855 | 6 | |||
| 54786 | 106031 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014640.7 | 2115990 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | 12 | 2 | 9 | 28855 | 6 | ||||
| 80077 | 106029 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.7908523118267 | -122.393229418798 | (37.7908523118267, -122.393229418798) | 12 | 2 | 9 | 28855 | 6 | |
| 89068 | 119742 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 101550 | 119745 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 103825 | 97186 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 8 | 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 | |||
| 105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
| 110444 | 97188 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 10 | 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 | |||
| 124374 | 97181 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 3 | 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 | |||
| 127764 | 97182 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 4 | 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 | |||
| 128485 | 97184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013138 | 2116168 | 37.791333135618 | -122.398429995238 | (37.791333135618, -122.398429995238) | 12 | 2 | 9 | 28855 | 6 | |||
| 131100 | 106027 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.81921 | 2115987.91534 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | 12 | 2 | 9 | 28855 | 6 | |
| 147008 | 106033 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 173505 | 119746 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 194245 | 106032 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
| 846 | 115842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003573.21553 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | 13 | 9 | 1 | 57 | 17 | |||
| 32402 | 115846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | 13 | 9 | 1 | 57 | 17 | |||
| 35660 | 115844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | 13 | 9 | 1 | 57 | 17 |
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) );