Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83588 | 83588 | 6719 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 86611 | 86611 | 6726 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 93092 | 93092 | 6705 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 107944 | 107944 | 6709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 113171 | 113171 | 6722 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 122890 | 122890 | 6721 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 126237 | 126237 | 6727 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 88023 | 88023 | 6773 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016787.8631263 | 2097291.0360598997 | 37.7397036915046 | -122.38448604022699 | (37.7397036915046, -122.384486040227) | |||
| 142537 | 142537 | 6788 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | |||
| 89158 | 89158 | 6799 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x9 | 6016685.620596901 | 2097367.3215875 | 37.73990750174121 | -122.384844867735 | (37.7399075017412, -122.384844867735) | |||
| 87520 | 87520 | 6801 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.38502428222701 | (37.7400094064471, -122.385024282227) | |||
| 113479 | 113479 | 6808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | |||
| 84017 | 84017 | 6816 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 108134 | 108134 | 6817 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 139108 | 139108 | 6818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 145043 | 145043 | 6815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 77710 | 77710 | 6828 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 104985 | 104985 | 27857 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 117415 | 117415 | 6829 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 126966 | 126966 | 6825 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 58954 | 58954 | 11429 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016007.44377 | 2096780.4211400002 | 37.738258459777605 | -122.38714881562599 | (37.7382584597776, -122.387148815626) | |||
| 109416 | 109416 | 21969 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2565 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015991.1899 | 2103495.5101900003 | 37.756695801845204 | -122.38767339341999 | (37.7566958018452, -122.38767339342) | |||
| 112221 | 112221 | 21975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2565 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4x6 | 6015991.1899 | 2103495.5101900003 | 37.756695801845204 | -122.38767339341999 | (37.7566958018452, -122.38767339342) | |||
| 142064 | 142064 | 21930 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2347 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x5 | 6015939.394730001 | 2104425.48438 | 37.7592464441674 | -122.38791741203 | (37.7592464441674, -122.38791741203) | |||
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 94954 | 94954 | 21986 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 102981 | 102981 | 21991 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x6 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 106780 | 106780 | 21987 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 108699 | 108699 | 21983 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 114695 | 114695 | 21984 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 125926 | 125926 | 21980 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2575 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6015881.32806 | 2103602.42313 | 37.756983276036294 | -122.388060799634 | (37.7569832760363, -122.388060799634) | |||
| 101509 | 101509 | 21977 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015880.48539 | 2103611.32219 | 37.757007664280295 | -122.388064334928 | (37.7570076642803, -122.388064334928) | |||
| 102625 | 102625 | 21960 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2525 03RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | |||
| 118039 | 118039 | 21959 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2525 03RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | |||
| 79837 | 79837 | 21956 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015841.2226599995 | 2104083.6923599998 | 37.758302516993105 | -122.38823308755899 | (37.7583025169931, -122.388233087559) | |||
| 77387 | 77387 | 109858 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5x8 | 6015836.2 | 2104173.0 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | |||
| 83564 | 83564 | 21952 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2455 03RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4x9 | 6015836.2 | 2104173.0 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | |||
| 105647 | 105647 | 21948 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2435 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | |||
| 127036 | 127036 | 85059 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2435 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | |||
| 128824 | 128824 | 26153 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 80976 | 80976 | 41195 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 92780 | 92780 | 41199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 93983 | 93983 | 41198 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 94306 | 94306 | 41194 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 118500 | 118500 | 41193 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 122099 | 122099 | 41200 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 126809 | 126809 | 41196 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 140702 | 140702 | 41192 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 97718 | 97718 | 29407 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6014804.18454 | 2090650.03815 | 37.7213589569903 | -122.390880803843 | (37.7213589569903, -122.390880803843) | |||
| 100223 | 100223 | 100260 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 30X Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x3 | 6015074.6 | 2113439.2 | 37.783948168266704 | -122.39153848852501 | (37.7839481682667, -122.391538488525) | |||
| 109549 | 109549 | 100259 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 30X Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x3 | 6015074.6 | 2113439.2 | 37.783948168266704 | -122.39153848852501 | (37.7839481682667, -122.391538488525) | |||
| 10044 | 10044 | 120656 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10045 | 10045 | 120661 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10058 | 10058 | 120660 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10065 | 10065 | 120663 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10066 | 10066 | 120655 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10073 | 10073 | 120662 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 9032 | 9032 | 173593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9033 | 9033 | 173592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9040 | 9040 | 173594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9043 | 9043 | 173595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 87141 | 87141 | 114283 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 90613 | 90613 | 114282 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 96878 | 96878 | 114284 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 109566 | 109566 | 114285 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 122833 | 122833 | 114281 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 81089 | 81089 | 100262 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 88006 | 88006 | 100265 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 110541 | 110541 | 100261 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 120612 | 120612 | 100264 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 140723 | 140723 | 100263 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 13244 | 13244 | 113373 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2015 12:00:00 AM | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | |||
| 19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 108974 | 108974 | 99595 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 92983 | 92983 | 116128 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 117524 | 117524 | 116126 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 141081 | 141081 | 116127 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 77535 | 77535 | 111597 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 78813 | 78813 | 111595 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 98499 | 98499 | 111590 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | |||
| 98808 | 98808 | 111592 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 102700 | 102700 | 111598 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 113746 | 113746 | 111596 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 114527 | 114527 | 111593 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 117778 | 117778 | 111591 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 140397 | 140397 | 111594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 103029 | 103029 | 25995 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191002 | (37.7364675981514, -122.39375225191) | |||
| 79481 | 79481 | 49286 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 84072 | 84072 | 49260 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 85495 | 85495 | 49269 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 89466 | 89466 | 49274 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 92066 | 92066 | 49276 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 94374 | 94374 | 49264 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 97841 | 97841 | 49277 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 98933 | 98933 | 49266 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 100900 | 100900 | 49285 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) |
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");