Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
6403 | 6403 | 11181 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.42044724225599 | (37.8065129467732, -122.420447242256) | |||
7949 | 7949 | 14640 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | |||
9160 | 9160 | 16481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9397 | 9397 | 2544 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6016440.0 | 2099034.0 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | |||
14457 | 14457 | 6846 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | |||
15063 | 15063 | 16523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016311.2033400005 | 2098218.94031 | 37.742225157565606 | -122.386198814044 | (37.7422251575656, -122.386198814044) | |||
15281 | 15281 | 2535 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016210.73833 | 2099105.1228400003 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | |||
15570 | 15570 | 2499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | |||
15943 | 15943 | 2515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | |||
25032 | 25032 | 189928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.79149401858479 | -122.397829357532 | (37.7914940185848, -122.397829357532) | |||
25691 | 25691 | 140580 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.778294566327205 | -122.43178620552 | (37.7782945663272, -122.43178620552) | |||
28725 | 28725 | 125974 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007013.058230001 | 2121870.81717 | 37.806648529474295 | -122.42002707360399 | (37.8066485294743, -122.420027073604) | |||
31280 | 31280 | 189919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013770.13743 | 2116011.13859 | 37.7909376251249 | -122.396231800058 | (37.7909376251249, -122.396231800058) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
43855 | 43855 | 206018 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | |||
46321 | 46321 | 115844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | |||
47133 | 47133 | 138241 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.784847050450104 | -122.444961483404 | (37.7848470504501, -122.444961483404) | |||
54211 | 54211 | 188484 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016633.990259999 | 2098788.07165 | 37.743805736753394 | -122.38512235163 | (37.7438057367534, -122.38512235163) | |||
54603 | 54603 | 119737 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | ||||
56567 | 56567 | 139360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000048.0331 | 2114373.2711 | 37.7856673759403 | -122.443591852007 | (37.7856673759403, -122.443591852007) | |||
57071 | 57071 | 205997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998801.07075 | 2096511.7970599998 | 37.736553033585295 | -122.446620405109 | (37.7365530335853, -122.446620405109) | |||
58573 | 58573 | 189943 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014663.902869999 | 2116268.03372 | 37.7916926905231 | -122.39315736781299 | (37.7916926905231, -122.393157367813) | |||
58705 | 58705 | 46514 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 525or larger Golden Gate Ave In A 24 Box | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44680 | 6007056.20383649 | 2112568.41573989 | 37.7811088818185 | -122.41921746578801 | (37.7811088818185, -122.419217465788) | |||
63520 | 63520 | 200192 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | |||
65825 | 65825 | 205992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993371.398019999 | 2093686.3141400001 | 37.728483309840996 | -122.46518778469299 | (37.728483309841, -122.465187784693) | |||
69557 | 69557 | 205989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.46305702188499 | (37.744370734026, -122.463057021885) | |||
74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
82357 | 82357 | 2507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
86488 | 86488 | 103341 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
88250 | 88250 | 48533 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
91297 | 91297 | 15123 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 300 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2X2 | 6013765.88916 | 2116013.74101 | 37.7909445343765 | -122.396246681474 | (37.7909445343765, -122.396246681474) | |||
91412 | 91412 | 21783 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2550 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | |||
91802 | 91802 | 14926 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
93430 | 93430 | 14909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | |||
94704 | 94704 | 94894 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
97633 | 97633 | 16512 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772611999 | (37.7426746595649, -122.38584772612) | |||
99990 | 99990 | 47241 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543097995 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) |
104253 | 104253 | 111888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | ||||
109098 | 109098 | 97181 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
109880 | 109880 | 50388 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
112042 | 112042 | 6647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
112168 | 112168 | 21794 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2598 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.41507438015499 | (37.8060518410095, -122.415074380155) | |||
113829 | 113829 | 82141 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
119094 | 119094 | 119743 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
119633 | 119633 | 103345 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 29899 | 6010491.0 | 2108479.0 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | ||
120157 | 120157 | 17414 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.39520830982599 | (37.7365002389252, -122.395208309826) | |||
121368 | 121368 | 101043 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
124297 | 124297 | 59670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297.0 | 2106864.0 | 37.76494883262271 | -122.449108733904 | (37.7649488326227, -122.449108733904) |
127210 | 127210 | 21778 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2500X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5X5 | 6008409.452819999 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | |||
127268 | 127268 | 14688 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 775 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | |||
127903 | 127903 | 102874 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | ||||
136895 | 136895 | 225067 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009115.2795 | 2103823.2478099996 | 37.7572124269416 | -122.41147603989401 | (37.7572124269416, -122.411476039894) | |||
136904 | 136904 | 125982 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | |||
138575 | 138575 | 16501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
138999 | 138999 | 7419 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6010341.13591 | 2111005.37017 | 37.777001575706 | -122.407742942642 | (37.777001575706, -122.407742942642) | |||
141444 | 141444 | 4914 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
146013 | 146013 | 16552 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
151813 | 151813 | 51298 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | |
152156 | 152156 | 140023 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.42461301693301 | (37.7794631941198, -122.424613016933) | |||
163641 | 163641 | 96473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | ||
166023 | 166023 | 222906 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791001 | (37.7734445081828, -122.42695971791) | |||
167856 | 167856 | 189934 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.791446374309395 | -122.398104485334 | (37.7914463743094, -122.398104485334) | |||
168072 | 168072 | 115848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.43180918435499 | (37.8035189184231, -122.431809184355) | |||
169791 | 169791 | 125979 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.80574229793179 | -122.41523987893999 | (37.8057422979318, -122.41523987894) | |||
172191 | 172191 | 206010 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.47400476141199 | (37.7394635005399, -122.474004761412) | |||
173011 | 173011 | 189946 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 6014709.0415900005 | 2116225.6637 | 37.7915788597386 | -122.39299822110901 | (37.7915788597386, -122.392998221109) | |||
180722 | 180722 | 125998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | |||
182276 | 182276 | 106027 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.819209999 | 2115987.9153400003 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | |
183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
188870 | 188870 | 189960 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010412.08756 | 2108524.3089900003 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | |||
23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
43924 | 43924 | 225098 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6004313.032319999 | 2109116.83696 | 37.7714768248189 | -122.42846137891199 | (37.7714768248189, -122.428461378912) | |||
185704 | 185704 | 188476 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6010896.57818 | 2106030.2080599996 | 37.763371997828706 | -122.405471012994 | (37.7633719978287, -122.405471012994) | |||
3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
35702 | 35702 | 189866 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | |||
38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
44243 | 44243 | 189896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.38492142508899 | (37.7426025436648, -122.384921425089) | |||
65891 | 65891 | 189889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.38428398832501 | (37.7425183122785, -122.384283988325) | |||
130575 | 130575 | 189868 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.38684957154899 | (37.7415077207098, -122.386849571549) | |||
155880 | 155880 | 189903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6016414.85135 | 2098379.02943 | 37.742670465863796 | -122.38585158400801 | (37.7426704658638, -122.385851584008) | |||
181190 | 181190 | 189878 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.742556117060104 | -122.38564105721399 | (37.7425561170601, -122.385641057214) | |||
28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
42030 | 42030 | 206000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997987.32263 | 2094070.28162 | 37.729802697139604 | -122.44925801953801 | (37.7298026971396, -122.449258019538) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");