trees
661 rows where qCaretaker_id = 2 and qSpecies_id = 5 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
177137 | 189949 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513 | -122.392787475772 | (37.791203859513, -122.392787475772) | 12 | 2 | 9 | 28855 | 6 | |||
178073 | 189942 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014651.73587 | 2116280.65037 | 37.7917266570015 | -122.393200349112 | (37.7917266570015, -122.393200349112) | 12 | 2 | 9 | 28855 | 6 | |||
182570 | 189917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6013829.87851 | 2116068.4816 | 37.7910983996161 | -122.396029117153 | (37.7910983996161, -122.396029117153) | 12 | 2 | 9 | 28855 | 6 | |||
186270 | 119739 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | ||||
192269 | 189944 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.7916706589171 | -122.393114386531 | (37.7916706589171, -122.393114386531) | 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 | ||||
35427 | 35826 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.7188052443929 | -122.433947949751 | (37.7188052443929, -122.433947949751) | 9 | 7 | 6 | 28861 | 5 | ||
41676 | 175842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004274.97667 | 2092050.61974 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | 9 | 7 | 6 | 28861 | 5 | |||
43480 | 65221 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.7221490848593 | -122.434478026037 | (37.7221490848593, -122.434478026037) | 9 | 7 | 6 | 28861 | 5 | ||
119313 | 65609 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.02687 | 37.7295104552453 | -122.424720013038 | (37.7295104552453, -122.424720013038) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
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 | |||
187600 | 56853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.88058 | 2091960.10063 | 37.7243652845164 | -122.427429718013 | (37.7243652845164, -122.427429718013) | 9 | 7 | 6 | 28861 | 5 | ||
192846 | 175841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
57482 | 140579 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.431800729752 | (37.7783626547096, -122.431800729752) | 15 | 9 | 11 | 29492 | 41 | |||
77005 | 140023 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.424613016933 | (37.7794631941198, -122.424613016933) | 7 | 9 | 11 | 28852 | 41 | |||
108294 | 140580 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.7782945663272 | -122.43178620552 | (37.7782945663272, -122.43178620552) | 15 | 9 | 11 | 29492 | 41 | |||
139016 | 140578 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.7784358543561 | -122.431812198827 | (37.7784358543561, -122.431812198827) | 15 | 9 | 11 | 29492 | 41 | |||
6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | 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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
38322 | 206016 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
71731 | 205992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993371.39802 | 2093686.31414 | 37.728483309841 | -122.465187784693 | (37.728483309841, -122.465187784693) | 9 | 8 | 4 | 59 | 40 | |||
76986 | 205989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.463057021885 | (37.744370734026, -122.463057021885) | 1 | 8 | 4 | 29491 | 40 | |||
91647 | 205994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994253.11993 | 2101023.44894 | 37.7486800649323 | -122.462671676761 | (37.7486800649323, -122.462671676761) | 1 | 8 | 4 | 29491 | 40 | |||
111983 | 206019 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.7450917681756 | -122.460627918846 | (37.7450917681756, -122.460627918846) | 1 | 8 | 4 | 59 | 40 | |||
114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
115939 | 82092 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | 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 | ||
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 | |||
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 | ||||
145696 | 206010 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.474004761412 | (37.7394635005399, -122.474004761412) | 1 | 8 | 4 | 29491 | 40 | |||
146949 | 82141 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | 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 | ||
149414 | 205991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.7284735045328 | -122.465126926677 | (37.7284735045328, -122.465126926677) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
174999 | 205996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.7365620951723 | -122.446546561796 | (37.7365620951723, -122.446546561796) | 9 | 7 | 4 | 59 | 40 | |||
176911 | 206011 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.7394610849722 | -122.474090278863 | (37.7394610849722, -122.474090278863) | 1 | 8 | 4 | 29491 | 40 | |||
179167 | 206017 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 59 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996580.00391 | 2094034.75678 | 37.7296245567167 | -122.454120687124 | (37.7296245567167, -122.454120687124) | 9 | 7 | 4 | 28861 | 40 | |||
182568 | 206012 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.7394594751618 | -122.474129983014 | (37.7394594751618, -122.474129983014) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
94151 | 87254 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.7102434920179 | -122.414174016703 | (37.7102434920179, -122.414174016703) | 9 | 7 | 8 | 309 | 39 | |||
133859 | 87253 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | 9 | 7 | 8 | 309 | 39 | |||
9470 | 46514 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 525or larger Golden Gate Ave In A 24 Box | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44680 | 6007056.20383649 | 2112568.41573989 | 37.7811088818185 | -122.419217465788 | (37.7811088818185, -122.419217465788) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |
120772 | 51301 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.415599663608 | (37.7816708281319, -122.415599663608) | 7 | 10 | 9 | 28852 | 36 | ||
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 | |
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 | ||
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 | |
187721 | 125971 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008148.4886 | 2112831.14919 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | 7 | 10 | 9 | 28852 | 36 | |||
42305 | 182440 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356194 | (37.7585434265078, -122.49174356194) | 1 | 8 | 3 | 56 | 35 | |||
116296 | 182304 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2531 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986925.2797 | 2105029.7497 | 37.7592555273516 | -122.488305322992 | (37.7592555273516, -122.488305322992) | 1 | 8 | 3 | 56 | 35 | |||
142864 | 32581 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.7625660493627 | -122.492024105228 | (37.7625660493627, -122.492024105228) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
38377 | 189958 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010386.69691 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | 8 | 2 | 9 | 28853 | 34 | |||
40377 | 103339 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
60431 | 103341 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
62803 | 189959 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010397.61848 | 2108539.03358 | 37.7702327485634 | -122.40737363759 | (37.7702327485634, -122.40737363759) | 8 | 2 | 9 | 28853 | 34 | |||
71893 | 189957 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.7733037049339 | -122.403694422077 | (37.7733037049339, -122.403694422077) | 14 | 2 | 9 | 28853 | 34 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
108134 | 103342 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
124477 | 189963 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | 8 | 2 | 9 | 28853 | 34 | |||
127110 | 103340 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 772809 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | ||
134295 | 189961 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010424.61803 | 2108510.17842 | 37.7701550300493 | -122.407278211428 | (37.7701550300493, -122.407278211428) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | ||
179136 | 189964 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 287 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6010268.27805 | 2111003.99646 | 37.7769937249279 | -122.407994884783 | (37.7769937249279, -122.407994884783) | 14 | 2 | 9 | 28853 | 34 | |||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
60751 | 64436 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2445 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1988 12:00:00 AM | 12 | Permit Number 25292 | 6006658.75135 | 2119650.10198 | 37.8005310432266 | -122.421095439396 | (37.8005310432266, -122.421095439396) | 5 | 9 | 1 | 28858 | 32 | ||
77396 | 125972 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.8066066057793 | -122.420371657826 | (37.8066066057793, -122.420371657826) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
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 | |||
129067 | 51546 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.8066781199827 | -122.419815746942 | (37.8066781199827, -122.419815746942) | 5 | 1 | 1 | 28858 | 32 | |||
139674 | 101042 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 2 | 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 |
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) );