trees
856 rows where qSpecies_id = 5 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 9688 | 52724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | 12 | 2 | 9 | 28855 | 6 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 46538 | 205998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998781.20203 | 2096512.57724 | 37.7365540408212 | -122.446689155601 | (37.7365540408212, -122.446689155601) | 9 | 7 | 4 | 59 | 40 | |||
| 47524 | 205997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998801.07075 | 2096511.79706 | 37.7365530335853 | -122.446620405109 | (37.7365530335853, -122.446620405109) | 9 | 7 | 4 | 59 | 40 | |||
| 47941 | 218315 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.466425098064 | (37.7455947140337, -122.466425098064) | 1 | 8 | 4 | 29491 | 40 | |||
| 48301 | 225091 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | 15 | 5 | 5 | 28862 | 3 | |||
| 62178 | 189960 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010412.08756 | 2108524.30899 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | 8 | 2 | 9 | 28853 | 34 | |||
| 62483 | 119737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | 12 | 2 | 9 | 28855 | 6 | ||||
| 65626 | 189862 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6017103.28687 | 2098264.26759 | 37.7423934261135 | -122.383463161819 | (37.7423934261135, -122.383463161819) | 10 | 3 | 8 | 58 | 1 | |||
| 66742 | 225072 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.7573510817046 | -122.410574009103 | (37.7573510817046, -122.410574009103) | 2 | 4 | 7 | 28859 | 19 | |||
| 66893 | 199696 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | 10 | 3 | 8 | 58 | 1 | |||
| 67119 | 189932 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013255.69526 | 2116279.68267 | 37.7916463457648 | -122.398030607826 | (37.7916463457648, -122.398030607826) | 12 | 2 | 9 | 28855 | 6 | |||
| 67259 | 189842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6017136.08616 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | 10 | 3 | 8 | 58 | 1 | |||
| 70275 | 189859 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6017171.36242 | 2098242.65136 | 37.7423378345214 | -122.38322627048 | (37.7423378345214, -122.38322627048) | 10 | 3 | 8 | 58 | 1 | |||
| 70904 | 115849 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003588.62501 | 2120788.73766 | 37.8034838925183 | -122.431800659668 | (37.8034838925183, -122.431800659668) | 13 | 9 | 1 | 57 | 17 | |||
| 71028 | 189931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | 12 | 2 | 9 | 28855 | 6 | |||
| 71679 | 189860 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 10 | : | Tree | Private 2 | 7 | Width 3ft | 6017146.31011 | 2098252.64566 | 37.7423638923838 | -122.383313590143 | (37.7423638923838, -122.383313590143) | 10 | 3 | 8 | 58 | 1 | |||
| 72220 | 189941 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013331.4553 | 2116106.58194 | 37.7911752709767 | -122.397756329903 | (37.7911752709767, -122.397756329903) | 12 | 2 | 9 | 28855 | 6 | |||
| 75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
| 75940 | 51298 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | 7 | 10 | 9 | 28852 | 36 | |
| 84314 | 125975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007035.47478 | 2121873.14157 | 37.8066561746197 | -122.419949661756 | (37.8066561746197, -122.419949661756) | 5 | 1 | 1 | 28858 | 32 | |||
| 85138 | 189878 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.7425561170601 | -122.385641057214 | (37.7425561170601, -122.385641057214) | 10 | 3 | 8 | 58 | 1 | |||
| 87824 | 125999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.416912241104 | (37.8057404246312, -122.416912241104) | 5 | 1 | 10 | 308 | 23 | |||
| 98740 | 189925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013397.06496 | 2116134.82312 | 37.7912564680486 | -122.397531302439 | (37.7912564680486, -122.397531302439) | 12 | 2 | 9 | 28855 | 6 | |||
| 101145 | 3593 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | 10 | 3 | 8 | 58 | 1 | ||
| 102361 | 189877 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016448.85629 | 2098333.07564 | 37.7425461678608 | -122.385730801451 | (37.7425461678608, -122.385730801451) | 10 | 3 | 8 | 58 | 1 | |||
| 102811 | 189880 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | : | Tree | Private 2 | 7 | Width 3ft | 6016536.79452 | 2098327.43911 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | 10 | 3 | 8 | 58 | 1 | |||
| 108284 | 225093 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283 | -122.434083007749 | (37.770617436283, -122.434083007749) | 15 | 5 | 5 | 29492 | 9 | |||
| 110454 | 246421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003840.65408 | 2099855.19689 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | 2 | 7 | 5 | 63 | 22 | |||
| 115220 | 115850 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003589.56269 | 2120774.48991 | 37.8034448250715 | -122.431796396884 | (37.8034448250715, -122.431796396884) | 13 | 9 | 1 | 57 | 17 | |||
| 128316 | 206000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997987.32263 | 2094070.28162 | 37.7298026971396 | -122.449258019538 | (37.7298026971396, -122.449258019538) | 9 | 7 | 4 | 28861 | 40 | ||||
| 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 | |
| 144602 | 189930 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013282.15015 | 2116252.99602 | 37.7915745438725 | -122.397937200642 | (37.7915745438725, -122.397937200642) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 174476 | 189889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.384283988325 | (37.7425183122785, -122.384283988325) | 10 | 3 | 8 | 58 | 1 | |||
| 187401 | 119740 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013460.47758 | 2116066.81767 | 37.7910732716747 | -122.397307123936 | (37.7910732716747, -122.397307123936) | 12 | 2 | 9 | 28855 | 6 | ||||
| 188809 | 218314 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | 1 | 8 | 4 | 29491 | 40 | |||
| 189232 | 248206 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.7445726938814 | -122.41839208634 | (37.7445726938814, -122.41839208634) | 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 | |||||||||||||
| 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 | |||
| 35835 | 2509 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
| 40094 | 2518 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016498.61775 | 2098890.19219 | 37.7440786495081 | -122.385597557904 | (37.7440786495081, -122.385597557904) | 10 | 3 | 8 | 58 | 1 | |||
| 44548 | 189913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6013888.27035 | 2094422.90108 | 37.731667614051 | -122.39431091023 | (37.731667614051, -122.39431091023) | 10 | 3 | 8 | 58 | 1 | |||
| 47459 | 189921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013437.41222 | 2116091.23603 | 37.7911390345977 | -122.397388642991 | (37.7911390345977, -122.397388642991) | 12 | 2 | 9 | 28855 | 6 | |||
| 49549 | 13332 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011384.17484 | 2090567.17856 | 37.7209410845847 | -122.402697063866 | (37.7209410845847, -122.402697063866) | 10 | 7 | 8 | 309 | 28 | |||
| 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 | |||
| 60278 | 189935 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | 12 | 2 | 9 | 28855 | 6 | |||
| 70301 | 2533 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016180.33193 | 2099126.30756 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | 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 | |||
| 74298 | 225086 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.7563110786983 | -122.429732966312 | (37.7563110786983, -122.429732966312) | 2 | 4 | 5 | 28862 | 22 | |||
| 82733 | 14930 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 7 | 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 | |||
| 85869 | 2534 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.7446815361299 | -122.386659150015 | (37.7446815361299, -122.386659150015) | 10 | 3 | 8 | 58 | 1 | |||
| 99086 | 7417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.059 | 2111002.9309 | 37.7769959373466 | -122.407677309481 | (37.7769959373466, -122.407677309481) | 14 | 2 | 9 | 28853 | 34 | ||
| 102050 | 189886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | 10 | 3 | 8 | 58 | 1 | |||
| 102602 | 14927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 4 | 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 | |||
| 106760 | 2535 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016210.73833 | 2099105.12284 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | 10 | 3 | 8 | 58 | 1 | |||
| 107461 | 85255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 49553 | 6013503.0525 | 2116024.16318 | 37.7909585226636 | -122.39715682295 | (37.7909585226636, -122.39715682295) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 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 | |||
| 112108 | 16517 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 114975 | 115848 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.431809184355 | (37.8035189184231, -122.431809184355) | 13 | 9 | 1 | 57 | 17 | |||
| 118594 | 199693 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016099.111 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | 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 | |
| 120839 | 206020 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.461887948175 | (37.7487957447457, -122.461887948175) | 1 | 8 | 4 | 29491 | 40 | |||
| 122418 | 2519 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.385534806811 | (37.7440450526322, -122.385534806811) | 10 | 3 | 8 | 58 | 1 | |||
| 122812 | 23566 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2958 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2005 12:00:00 AM | 6 | 6005632.06356 | 2120580.68582 | 37.8030282582004 | -122.424714436346 | (37.8030282582004, -122.424714436346) | 5 | 9 | 1 | 28858 | 32 | |||
| 123006 | 189856 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 6017223.11391 | 2098220.28067 | 37.7422792688651 | -122.383045771154 | (37.7422792688651, -122.383045771154) | 10 | 3 | 8 | 58 | 1 | |||
| 123765 | 189939 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013302.11078 | 2116136.01551 | 37.7912544544909 | -122.397859927289 | (37.7912544544909, -122.397859927289) | 12 | 2 | 9 | 28855 | 6 | |||
| 124439 | 189888 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6016891.26784 | 2098307.49665 | 37.7425004040788 | -122.384199276697 | (37.7425004040788, -122.384199276697) | 10 | 3 | 8 | 58 | 1 | |||
| 125723 | 188487 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016679.39003 | 2098723.90702 | 37.7436320650598 | -122.384960899022 | (37.7436320650598, -122.384960899022) | 10 | 3 | 8 | 58 | 1 | |||
| 128143 | 16515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 135947 | 225081 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.425468699532 | (37.7353714997996, -122.425468699532) | 2 | 7 | 5 | 28861 | 2 | |||
| 141155 | 189927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013321.30985 | 2116211.38819 | 37.7914624793694 | -122.3977987878 | (37.7914624793694, -122.3977987878) | 12 | 2 | 9 | 28855 | 6 | |||
| 146281 | 189940 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013316.29733 | 2116121.55291 | 37.791215533629 | -122.39780982696 | (37.791215533629, -122.39780982696) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 149727 | 2515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 173950 | 16516 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 174571 | 225065 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006960.17815 | 2097772.45281 | 37.7404771992577 | -122.418500188445 | (37.7404771992577, -122.418500188445) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );