Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16090 | 16090 | 2536 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016262.668930001 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | |||
16099 | 16099 | 16541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | |||
16103 | 16103 | 17387 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6014551.02447 | 2095461.0111900002 | 37.7345548713079 | -122.39209219010901 | (37.7345548713079, -122.392092190109) | |||
16423 | 16423 | 2503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.743971655361705 | -122.384993582204 | (37.7439716553617, -122.384993582204) | |||
16483 | 16483 | 16521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.742129650455205 | -122.38628939735099 | (37.7421296504552, -122.386289397351) | |||
16723 | 16723 | 2498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016761.82696 | 2098799.8032400003 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | |||
16790 | 16790 | 16509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | ||
16852 | 16852 | 16499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | |||
16898 | 16898 | 2502 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016691.633780001 | 2098834.3481 | 37.743935990943996 | -122.38492625536001 | (37.743935990944, -122.38492625536) | |||
16981 | 16981 | 16634 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.43340627149901 | (37.7664480128774, -122.433406271499) | |||
17478 | 17478 | 5658 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.74795200168529 | -122.42464442051 | (37.7479520016853, -122.42464442051) | |||
18731 | 18731 | 5529 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6005093.86648 | 2103161.8218799997 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | |||
19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
20318 | 20318 | 5479 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 695 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 8 | 6005031.79334 | 2104320.1538400003 | 37.758346924379 | -122.42563369543801 | (37.758346924379, -122.425633695438) | |||
21055 | 21055 | 5523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.755689931362795 | -122.425382766602 | (37.7556899313628, -122.425382766602) | |||
23044 | 23044 | 16540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.741780940152296 | -122.386827291768 | (37.7417809401523, -122.386827291768) | |||
23049 | 23049 | 14686 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 775 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6005447.7824 | 2111997.5051 | 37.779450588232706 | -122.424741179621 | (37.7794505882327, -122.424741179621) | |||
23084 | 23084 | 16626 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | ||
26487 | 26487 | 189910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.742244189916704 | -122.386410241063 | (37.7422441899167, -122.386410241063) | |||
35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
50159 | 50159 | 27616 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 775 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005483.48508 | 2112000.60744 | 37.7794611228941 | -122.424617889559 | (37.7794611228941, -122.424617889559) | |||
51434 | 51434 | 16506 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
55275 | 55275 | 189902 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | |||
67563 | 67563 | 14916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017173.30591 | 2098243.5594200003 | 37.7423404352704 | -122.38321961360701 | (37.7423404352704, -122.383219613607) | |||
67565 | 67565 | 14919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
78541 | 78541 | 14928 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
78897 | 78897 | 20969 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2002X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
79162 | 79162 | 20965 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2002X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
79625 | 79625 | 14913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | |||
79676 | 79676 | 4925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
79948 | 79948 | 16484 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
81285 | 81285 | 16511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016438.273030001 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | |||
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) | |||
82455 | 82455 | 14908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
82964 | 82964 | 13332 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 145 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011384.17484 | 2090567.17856 | 37.7209410845847 | -122.402697063866 | (37.7209410845847, -122.402697063866) | |||
83106 | 83106 | 16498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016898.459480001 | 2098256.16023 | 37.7423598423185 | -122.38417083560499 | (37.7423598423185, -122.384170835605) | |||
86724 | 86724 | 14925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
87292 | 87292 | 16507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016604.68474 | 2098314.9336900003 | 37.7425049753024 | -122.385190723599 | (37.7425049753024, -122.385190723599) | |||
88469 | 88469 | 96756 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | |||
89283 | 89283 | 16514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016343.322430001 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | |||
89437 | 89437 | 16489 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
89537 | 89537 | 21785 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | |||
90964 | 90964 | 16503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
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) | |||
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) | |||
92151 | 92151 | 2522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.0270005 | 2099019.0971083 | 37.744424041089395 | -122.386141087772 | (37.7444240410894, -122.386141087772) | |||
92209 | 92209 | 14930 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
92651 | 92651 | 6652 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
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) | |||
93500 | 93500 | 15124 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 300 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2X2 | 6013752.67684 | 2116000.07901 | 37.7909062865319 | -122.396291437927 | (37.7909062865319, -122.396291437927) | |||
94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | 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) |
94554 | 94554 | 2524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449.0 | 2099041.0 | 37.7444899913278 | -122.38577963578699 | (37.7444899913278, -122.385779635787) | ||
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) |
96782 | 96782 | 16520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
97576 | 97576 | 21793 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2598 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.41507438015499 | (37.8060518410095, -122.415074380155) | |||
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) | |||
97917 | 97917 | 14920 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017135.89317 | 2098259.62578 | 37.7423824826909 | -122.383350094901 | (37.7423824826909, -122.383350094901) | |||
97975 | 97975 | 14927 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
98026 | 98026 | 15122 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 300 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6013811.40838 | 2116056.32171 | 37.791063983762896 | -122.396092171091 | (37.7910639837629, -122.396092171091) | |||
98540 | 98540 | 16491 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016683.0708800005 | 2098298.50072 | 37.7424641896573 | -122.384918540359 | (37.7424641896573, -122.384918540359) | |||
99918 | 99918 | 2546 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1590X Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.744986343975704 | -122.38683233058599 | (37.7449863439757, -122.386832330586) | |||
100205 | 100205 | 2512 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
100227 | 100227 | 16500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
102458 | 102458 | 22886 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
102486 | 102486 | 14932 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
102582 | 102582 | 16504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
103628 | 103628 | 21776 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2500X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008409.452819999 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | |||
103848 | 103848 | 14914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.742305197314295 | -122.383103612647 | (37.7423051973143, -122.383103612647) | |||
104168 | 104168 | 94893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 2 | 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) |
107427 | 107427 | 6650 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
108484 | 108484 | 16515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
108888 | 108888 | 16502 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
109094 | 109094 | 20967 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2002X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
109213 | 109213 | 18922 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2620 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002038.8 | 2115762.8 | 37.7895960030005 | -122.436803887406 | (37.7895960030005, -122.436803887406) | |||
110164 | 110164 | 2510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
110305 | 110305 | 6648 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
110644 | 110644 | 16505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
110804 | 110804 | 21781 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2550X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6008458.5658599995 | 2121488.77145 | 37.805680863133205 | -122.41499754514 | (37.8056808631332, -122.41499754514) | ||
111285 | 111285 | 2541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016218.6051359 | 2099112.8628025004 | 37.7446745598911 | -122.38658131155898 | (37.7446745598911, -122.386581311559) | |||
111965 | 111965 | 16519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
112145 | 112145 | 6850 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | ||
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) | |||
112741 | 112741 | 16513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.742663293572505 | -122.38588614932699 | (37.7426632935725, -122.385886149327) | |||
113999 | 113999 | 14911 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | |||
114992 | 114992 | 116858 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002788.0 | 2107242.0 | 37.7662425648461 | -122.43360252819201 | (37.7662425648461, -122.433602528192) | |||
116558 | 116558 | 21795 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2598 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.41507438015499 | (37.8060518410095, -122.415074380155) | |||
116667 | 116667 | 14918 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
116782 | 116782 | 4389 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | ||
117916 | 117916 | 4913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
118155 | 118155 | 14929 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
118268 | 118268 | 14924 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
119053 | 119053 | 6649 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
119228 | 119228 | 94892 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 1 | 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) |
119784 | 119784 | 16497 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | |||
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) | |||
120176 | 120176 | 6646 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
122367 | 122367 | 4918 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
122698 | 122698 | 16510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
123471 | 123471 | 6651 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
124291 | 124291 | 4926 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) |
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");