trees
856 rows where qSpecies_id = 5 sorted by PlantDate
This data as json, CSV (advanced)
PlotSize ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 188479 | Prune Opt Out 3 | Ceratonia siliqua :: Carob 5 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 787847 | 6010817.79084 | 2106032.71885 | 37.7633744862602 | -122.405743691032 | (37.7633744862602, -122.405743691032) | 8 | 4 | 8 | 28859 | 19 | ||
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
372 | 189871 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6016028.58203 | 2097927.48174 | 37.7414092251604 | -122.387155715173 | (37.7414092251604, -122.387155715173) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
640 | 222906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791 | (37.7734445081828, -122.42695971791) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
857 | 189910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.7422441899167 | -122.386410241063 | (37.7422441899167, -122.386410241063) | 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 | |||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
2297 | 16623 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
3688 | 189905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | 10 | 3 | 8 | 58 | 1 | |||
4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||||
5811 | 2517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | 10 | 3 | 8 | 58 | 1 | |||
6962 | 189948 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6014781.22378 | 2116142.62721 | 37.7913548700732 | -122.392742658052 | (37.7913548700732, -122.392742658052) | 12 | 2 | 9 | 28855 | 6 | |||
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 | ||
8003 | 21791 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.415385378175 | (37.8057800612465, -122.415385378175) | 5 | 1 | 10 | 308 | 23 | |||
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 | ||
8125 | 189865 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.387293751216 | (37.7410155838051, -122.387293751216) | 10 | 3 | 8 | 58 | 1 | |||
8282 | 80561 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6013651.87309 | 2096197.81138 | 37.7365280090438 | -122.395252475224 | (37.7365280090438, -122.395252475224) | 10 | 3 | 8 | 58 | 1 | |||
8477 | 224897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007276.43224 | 2097752.07019 | 37.7404390320343 | -122.417405258456 | (37.7404390320343, -122.417405258456) | 2 | 7 | 7 | 28859 | 2 | |||
9018 | 126003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6007892.37102 | 2121599.81603 | 37.8059539308952 | -122.416964822665 | (37.8059539308952, -122.416964822665) | 5 | 1 | 10 | 308 | 23 | |||
9983 | 248199 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698122 | (37.7440974516285, -122.41868698122) | 2 | 7 | 7 | 28859 | 2 | |||
10434 | 189892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 6 | : | Tree | Private 2 | 13 | Width 4ft | 6016806.72009 | 2098324.89991 | 37.7425435148768 | -122.384492832481 | (37.7425435148768, -122.384492832481) | 10 | 3 | 8 | 58 | 1 | |||
10873 | 189885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6016834.26905 | 2098267.19561 | 37.7423865939792 | -122.384393557236 | (37.7423865939792, -122.384393557236) | 10 | 3 | 8 | 58 | 1 | |||
11061 | 189851 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 15 | : | Tree | Private 2 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.7418799384027 | -122.382562673322 | (37.7418799384027, -122.382562673322) | 10 | 3 | 8 | 58 | 1 | |||
11562 | 206018 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | 1 | 8 | 4 | 59 | 40 | |||
12569 | 111886 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
12712 | 19967 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
12741 | 188474 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6007923.25888 | 2109012.80714 | 37.7713948192467 | -122.415966013116 | (37.7713948192467, -122.415966013116) | 8 | 2 | 9 | 28853 | 19 | |||
13041 | 19762 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | ||||
14221 | 189868 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.386849571549 | (37.7415077207098, -122.386849571549) | 10 | 3 | 8 | 58 | 1 | |||
14738 | 103343 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
15607 | 189834 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 4 | : | Tree | Private 2 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | 10 | 3 | 8 | 58 | 1 | |||
15625 | 27616 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005483.48508 | 2112000.60744 | 37.7794611228941 | -122.424617889559 | (37.7794611228941, -122.424617889559) | 7 | 9 | 11 | 28852 | 41 | |||
16214 | 16506 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
16420 | 189843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.383277260246 | (37.742196046505, -122.383277260246) | 10 | 3 | 8 | 58 | 1 | |||
16430 | 119738 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013480.63892 | 2116044.41356 | 37.7910128776808 | -122.397235794198 | (37.7910128776808, -122.397235794198) | 12 | 2 | 9 | 28855 | 6 | ||||
16559 | 222925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.7635624787486 | -122.447245077795 | (37.7635624787486, -122.447245077795) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
17541 | 14919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 13 | 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 | |||
18217 | 222886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Webster St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | 7 | 9 | 11 | 29492 | 10 | |||
18347 | 189903 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016618 | 2098337 | 37.7425663014752 | -122.385146220096 | (37.7425663014752, -122.385146220096) | 10 | 3 | 8 | 58 | 1 | |||
18852 | 222928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.7649616790718 | -122.447513315894 | (37.7649616790718, -122.447513315894) | 15 | 5 | 11 | 29492 | 9 | |||
18931 | 16634 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.433406271499 | (37.7664480128774, -122.433406271499) | 15 | 5 | 5 | 28862 | 3 | |||
19053 | 153989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016386.30028 | 2098368.17483 | 37.7426390813321 | -122.385949549827 | (37.7426390813321, -122.385949549827) | 10 | 3 | 8 | 58 | 1 | |||
19336 | 247504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.445142787454 | (37.7703040400286, -122.445142787454) | 15 | 5 | 11 | 29492 | 9 | |||
19339 | 21778 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5X5 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | |||
19461 | 138737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.445772761062 | (37.7853686673978, -122.445772761062) | 15 | 6 | 1 | 29490 | 31 | |||
19610 | 14916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017173.30591 | 2098243.55942 | 37.7423404352704 | -122.383219613607 | (37.7423404352704, -122.383219613607) | 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 | |||
20273 | 18860 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | 13 | 9 | 1 | 29490 | 27 | |||
20489 | 225066 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 199 Franconia St | 13 | : Yard | Tree | Private 2 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.7458371865343 | -122.407720980957 | (37.7458371865343, -122.407720980957) | 2 | 7 | 7 | 28859 | 2 | |||
21283 | 225084 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.431927750974 | (37.7547027131682, -122.431927750974) | 2 | 4 | 5 | 28862 | 22 | |||
21471 | 139360 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2807 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000073 | 2114379 | 37.7856845299005 | -122.443505885647 | (37.7856845299005, -122.443505885647) | 15 | 6 | 1 | 29490 | 31 | |||
21523 | 189852 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Newhall St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586949 | (37.7420414890213, -122.38254586949) | 10 | 3 | 8 | 58 | 1 | |||
21860 | 206006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | 1 | 8 | 4 | 29491 | 40 | |||
21954 | 189895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016704.91422 | 2098345.41637 | 37.7425942186412 | -122.384846279543 | (37.7425942186412, -122.384846279543) | 10 | 3 | 8 | 58 | 1 | |||
22352 | 16479 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
22361 | 125968 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001336.41783 | 2115647.62359 | 37.7892398148051 | -122.439225792541 | (37.7892398148051, -122.439225792541) | 13 | 6 | 1 | 29490 | 27 | |||
22673 | 248195 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006895.3062 | 2099022.51404 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | 2 | 7 | 7 | 28859 | 2 | |||
23100 | 125989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | 5 | 1 | 10 | 308 | 23 | |||
23115 | 189845 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017192.34248 | 2098175.05438 | 37.7421533862633 | -122.383149023221 | (37.7421533862633, -122.383149023221) | 10 | 3 | 8 | 58 | 1 | |||
23322 | 189937 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013275.69539 | 2116164.65668 | 37.7913316253015 | -122.397953334494 | (37.7913316253015, -122.397953334494) | 12 | 2 | 9 | 28855 | 6 | |||
23738 | 4926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 15 | 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 | |||
24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
24686 | 20125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
24753 | 140022 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005467.685 | 2112000.1843 | 37.7794590687234 | -122.424672518677 | (37.7794590687234, -122.424672518677) | 7 | 9 | 11 | 28852 | 41 | |||
24789 | 188485 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016660.6215 | 2098754.7402 | 37.7437156885266 | -122.385027944407 | (37.7437156885266, -122.385027944407) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
24938 | 188478 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6010892.5271 | 2106015.01328 | 37.7633300498768 | -122.405483954234 | (37.7633300498768, -122.405483954234) | 8 | 4 | 8 | 28856 | 19 | |||
25251 | 14688 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
25898 | 225060 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.7643520771977 | -122.453277577199 | (37.7643520771977, -122.453277577199) | 15 | 5 | 11 | 29492 | 12 | |||
25903 | 125969 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | 13 | 6 | 1 | 29490 | 27 | |||
26053 | 16540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.7417809401523 | -122.386827291768 | (37.7417809401523, -122.386827291768) | 10 | 3 | 8 | 58 | 1 | |||
26621 | 222916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.428493839936 | (37.7712463798496, -122.428493839936) | 7 | 9 | 11 | 28852 | 10 | |||
26717 | 189875 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 15 | : | Tree | Private 2 | 12 | Width 3ft | 6015903.72942 | 2097762.72481 | 37.7409499215909 | -122.387575924289 | (37.7409499215909, -122.387575924289) | 10 | 3 | 8 | 58 | 1 | |||
26958 | 188469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6008084.26268 | 2108917.74209 | 37.771142843604 | -122.415402360325 | (37.771142843604, -122.415402360325) | 8 | 2 | 9 | 28853 | 19 | |||
27880 | 438 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 792X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6 | 6004975.0011312 | 2103729.1085203 | 37.7567208435744 | -122.425788038834 | (37.7567208435744, -122.425788038834) | 2 | 4 | 5 | 28862 | 3 | |||
28248 | 248203 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | 2 | 7 | 7 | 28859 | 2 | |||
29270 | 103687 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 903 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6008052 | 2102672 | 37.7539916655216 | -122.415071798268 | (37.7539916655216, -122.415071798268) | 2 | 4 | 7 | 28859 | 19 | |||
29463 | 189899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016506.94741 | 2098386.01279 | 37.7426947367801 | -122.385533625971 | (37.7426947367801, -122.385533625971) | 10 | 3 | 8 | 58 | 1 | |||
29579 | 189876 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 8 | : | Tree | Private 2 | 8 | Width 3ft | 6016406.62692 | 2098319.91707 | 37.7425077002596 | -122.385875902556 | (37.7425077002596, -122.385875902556) | 10 | 3 | 8 | 58 | 1 | |||
29632 | 102874 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
30088 | 5432 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6004968.15127 | 2105494.35348 | 37.7615674029223 | -122.425937381218 | (37.7615674029223, -122.425937381218) | 8 | 4 | 5 | 28859 | 19 | |||
30477 | 222899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005393.47694 | 2104277.70893 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | 2 | 4 | 5 | 28859 | 19 | |||
31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
32130 | 5658 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.7479520016853 | -122.42464442051 | (37.7479520016853, -122.42464442051) | 2 | 4 | 5 | 28859 | 19 | |||
32220 | 17420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.7369065543995 | -122.395898900707 | (37.7369065543995, -122.395898900707) | 10 | 3 | 8 | 58 | 1 | |||
32244 | 111887 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
32299 | 222920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998076.5165 | 2106905.97838 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
33818 | 206007 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991032.21326 | 2097741.26802 | 37.7394820166929 | -122.473570049822 | (37.7394820166929, -122.473570049822) | 1 | 8 | 4 | 29491 | 40 |
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) );