Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145072 | 145072 | 2511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 143682 | 143682 | 16516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 143020 | 143020 | 4916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 142575 | 142575 | 14917 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017157.89779 | 2098250.45331 | 37.7423585130106 | -122.383273370488 | (37.7423585130106, -122.383273370488) | |||
| 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) | |||
| 140926 | 140926 | 4919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 140142 | 140142 | 2505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 140042 | 140042 | 14931 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 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) | |||
| 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) | |||
| 127870 | 127870 | 4917 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:50:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 127219 | 127219 | 14910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017317.95316 | 2098168.33206 | 37.7421418684871 | -122.38271422871999 | (37.7421418684871, -122.38271422872) | |||
| 127149 | 127149 | 2509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 126452 | 126452 | 2545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1590X Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.744986343975704 | -122.38683233058599 | (37.7449863439757, -122.386832330586) | ||
| 126122 | 126122 | 20125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
| 125620 | 125620 | 4920 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:54:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 125499 | 125499 | 16479 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 116284 | 116284 | 2744 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5995591.7347 | 2110770.58853 | 37.775520208006604 | -122.458748349075 | (37.7755202080066, -122.458748349075) | |||
| 113730 | 113730 | 4923 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 113571 | 113571 | 22889 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 110377 | 110377 | 16641 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.949322799 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 102536 | 102536 | 4922 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 98251 | 98251 | 16517 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 88683 | 88683 | 16650 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | |||
| 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) | |||
| 85510 | 85510 | 4912 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 78717 | 78717 | 4915 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 66646 | 66646 | 3581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 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) | |||
| 23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
| 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) | ||
| 22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
| 22336 | 22336 | 3627 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | ||
| 22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
| 22312 | 22312 | 3652 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.38264747761299 | (37.7437309716031, -122.382647477613) | ||
| 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) | |||
| 20514 | 20514 | 5432 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 499 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6004968.151269999 | 2105494.35348 | 37.761567402922296 | -122.42593738121799 | (37.7615674029223, -122.425937381218) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 16340 | 16340 | 17417 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013526.86611 | 2096296.9772700001 | 37.7367933450374 | -122.39569162676099 | (37.7367933450374, -122.395691626761) | |||
| 16138 | 16138 | 14974 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | |||
| 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) | |||
| 15961 | 15961 | 17437 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | |||
| 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) | |||
| 15763 | 15763 | 2504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | |||
| 15689 | 15689 | 2500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016728.12134 | 2098825.14197 | 37.7439127309012 | -122.384799447345 | (37.7439127309012, -122.384799447345) | |||
| 15657 | 15657 | 2514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | |||
| 15597 | 15597 | 16524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016323.686869999 | 2098236.56346 | 37.7422742380775 | -122.386156877755 | (37.7422742380775, -122.386156877755) | |||
| 15581 | 15581 | 2519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.38553480681101 | (37.7440450526322, -122.385534806811) | |||
| 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) | |||
| 15447 | 15447 | 2513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016387.5124699995 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | |||
| 15444 | 15444 | 2521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016567.75907 | 2098840.9849799997 | 37.743947361995794 | -122.38535505210501 | (37.7439473619958, -122.385355052105) | |||
| 15374 | 15374 | 16525 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016336.5971099995 | 2098251.27907 | 37.7423153586798 | -122.38611326331801 | (37.7423153586798, -122.386113263318) | |||
| 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) | |||
| 15226 | 15226 | 16522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016298.51131 | 2098203.0123900003 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | |||
| 15110 | 15110 | 7417 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.058999999 | 2111002.9309 | 37.7769959373466 | -122.40767730948099 | (37.7769959373466, -122.407677309481) | ||
| 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) | |||
| 14957 | 14957 | 2540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | |||
| 14926 | 14926 | 17432 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.39646713286899 | (37.7370275033033, -122.396467132869) | |||
| 14851 | 14851 | 2534 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.744681536129896 | -122.38665915001499 | (37.7446815361299, -122.386659150015) | |||
| 14807 | 14807 | 2520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) |
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");