Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11938 | 11938 | 19762 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 11951 | 11951 | 19967 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 14483 | 14483 | 7418 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.77695044101711 | -122.407735574616 | (37.7769504410171, -122.407735574616) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 124746 | 124746 | 14912 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017247.980359999 | 2098210.14599 | 37.742252815079496 | -122.38295908456999 | (37.7422528150795, -122.38295908457) | |||
| 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) | |||
| 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) | |||
| 145790 | 145790 | 14915 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.742321829008496 | -122.383156775767 | (37.7423218290085, -122.383156775767) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 142096 | 142096 | 10409 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5999436.0 | 2108778.0 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | |||
| 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) | |||
| 14244 | 14244 | 2501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.38486546568599 | (37.7439199677279, -122.384865465686) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 13486 | 13486 | 2517 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | |||
| 14232 | 14232 | 2518 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016498.61775 | 2098890.1921900003 | 37.7440786495081 | -122.38559755790399 | (37.7440786495081, -122.385597557904) | |||
| 14264 | 14264 | 2516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 14317 | 14317 | 2533 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016180.33193 | 2099126.3075599996 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 15614 | 15614 | 17378 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1600 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6014792.92868 | 2095354.29337 | 37.7342752738796 | -122.391248382303 | (37.7342752738796, -122.391248382303) | |||
| 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) | |||
| 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) | |||
| 14293 | 14293 | 17415 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.73659758599771 | -122.395366549732 | (37.7365975859977, -122.395366549732) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 15046 | 15046 | 17433 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1160 | 1160 | 18860 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | |||
| 6620 | 6620 | 18859 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1992 12:00:00 AM | 12 | 3X3 | 6004082.46062 | 2116030.31556 | 37.7904464684691 | -122.429752123658 | (37.7904464684691, -122.429752123658) | ||
| 3418 | 3418 | 18865 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003863.26827 | 2115999.97726 | 37.7903507527417 | -122.43050834919501 | (37.7903507527417, -122.430508349195) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 144681 | 144681 | 21784 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2550X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2016 12:00:00 AM | 12 | 4X4 | 6008458.5658599995 | 2121488.77145 | 37.805680863133205 | -122.41499754514 | (37.8056808631332, -122.41499754514) | ||
| 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) | |||
| 126575 | 126575 | 21789 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/2015 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 125184 | 125184 | 21792 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2598 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.41507438015499 | (37.8060518410095, -122.415074380155) | |||
| 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) | |||
| 6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
| 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) | |||
| 7418 | 7418 | 11180 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357004 | -122.420440716763 | (37.806461391357, -122.420440716763) |
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");