trees
1,626 rows where qSpecies_id = 53 sorted by Zip Codes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
| 38445 | 4501 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | 2 | 7 | 5 | 63 | 22 | |||
| 57759 | 4493 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.7450185306318 | -122.426882412261 | (37.7450185306318, -122.426882412261) | 2 | 7 | 5 | 63 | 22 | |||
| 61784 | 59066 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | 2 | 7 | 5 | 63 | 22 | |||
| 65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
| 82935 | 39773 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 |
| 115017 | 4281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | 2 | 4 | 5 | 63 | 22 | |||
| 116920 | 39774 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 | |
| 122006 | 4883 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2X2 | 6000657.5251593 | 2098217.505729 | 37.7413423773337 | -122.440324154875 | (37.7413423773337, -122.440324154875) | 2 | 7 | 5 | 63 | 7 | |||
| 129658 | 5136 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2842 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 1x1 | 6002395.52907 | 2095496.33738 | 37.7339694804636 | -122.434120273378 | (37.7339694804636, -122.434120273378) | 2 | 7 | 5 | 63 | 7 | |||
| 130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
| 140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
| 140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
| 141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
| 142768 | 112396 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 574 VALLEY ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002248 | 2099192 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | 2 | 7 | 5 | 63 | 22 | ||||
| 148900 | 57604 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 16491 | 5999828.22001193 | 2094390.77346711 | 37.7307878188175 | -122.442916855234 | (37.7307878188175, -122.442916855234) | 9 | 7 | 4 | 63 | 40 | ||
| 152624 | 4455 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.427235096559 | (37.7482893665971, -122.427235096559) | 2 | 4 | 5 | 63 | 22 | ||
| 160495 | 5728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1688 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005263.1161773 | 2098508.6699422 | 37.742402999925 | -122.42442032403 | (37.742402999925, -122.42442032403) | 2 | 7 | 5 | 63 | 22 | |||
| 166856 | 95409 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Added tree to database on 2/28/11. Appears to be 15-20 yrs old. | 6002410 | 2095371 | 37.7336261540057 | -122.434061286386 | (37.7336261540057, -122.434061286386) | 2 | 7 | 5 | 63 | 7 | ||
| 170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
| 178363 | 5655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005148.4988519 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | 2 | 4 | 5 | 63 | 22 | |||
| 181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
| 184670 | 59431 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.7355733371118 | -122.432419698468 | (37.7355733371118, -122.432419698468) | 2 | 7 | 5 | 63 | 7 | |
| 184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
| 33092 | 92818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883 | 2096019 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | 9 | 7 | 4 | 59 | 40 | ||
| 14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
| 14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
| 27391 | 6825 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 28345 | 6727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 29445 | 26153 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 37080 | 6828 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
| 41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 46216 | 6816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 52126 | 22281 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
| 52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 63265 | 6801 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.385024282227 | (37.7400094064471, -122.385024282227) | 10 | 3 | 8 | 58 | 1 | |||
| 66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
| 72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
| 78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 89965 | 116128 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 101295 | 29407 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2801X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6014804.18454 | 2090650.03815 | 37.7213589569903 | -122.390880803843 | (37.7213589569903, -122.390880803843) | 10 | 3 | 8 | 58 | 1 | |||
| 102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
| 110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
| 115268 | 6817 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 122922 | 99595 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
| 122954 | 6709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 129171 | 27857 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 142509 | 6722 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 149060 | 6808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | |||
| 150567 | 25558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | ||
| 158152 | 6829 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 163580 | 116126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
| 188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 4658 | 46466 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3310X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 12 | 3x3 | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |
| 6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 11093 | 95037 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 15062 | 102786 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | 13 | 9 | 1 | 57 | 17 | ||
| 16922 | 59787 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1981 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | 13 | 9 | 1 | 57 | 17 | ||
| 20994 | 100049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 768990 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | ||
| 21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
| 29776 | 44063 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 37162 | 18698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 5 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
| 41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
| 43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 49412 | 94931 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004522 | 2118744 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | 13 | 9 | 1 | 57 | 17 | |||||
| 50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 55002 | 13200 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
| 56427 | 44064 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 57812 | 13193 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002451.4681 | 2119463.3271 | 37.7997801365268 | -122.435640954547 | (37.7997801365268, -122.435640954547) | 13 | 9 | 1 | 57 | 17 | |||
| 59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
| 63529 | 56688 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1865X Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 17346 | 6002930 | 2119911 | 37.801036497901 | -122.434017077007 | (37.801036497901, -122.434017077007) | 13 | 9 | 1 | 57 | 17 | ||
| 66213 | 50374 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2727 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.7950566585474 | -122.43854412401 | (37.7950566585474, -122.43854412401) | 13 | 9 | 1 | 57 | 27 | ||||
| 67334 | 99615 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 70447 | 44061 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 70974 | 23955 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | |||
| 75083 | 46223 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1888 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
| 76207 | 127218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 7 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999923.49955 | 2117118.25276 | 37.7931972742965 | -122.44422002466 | (37.7931972742965, -122.44422002466) | 13 | 9 | 1 | 57 | 27 | ||
| 77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 77688 | 1668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
| 77847 | 13285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
| 85651 | 100050 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 90065 | 13211 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2190 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001897.52108 | 2119466.22991 | 37.7997566277665 | -122.437558020868 | (37.7997566277665, -122.437558020868) | 13 | 9 | 1 | 57 | 17 | |||
| 95876 | 26159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 210 Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999117.59522 | 2119823.02413 | 37.800577843616 | -122.447203245105 | (37.800577843616, -122.447203245105) | 13 | 9 | 1 | 57 | 17 | |||
| 99582 | 99612 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 107261 | 18696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 109441 | 127217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 6 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | Permit Number 782825 | 5999928.92975 | 2117120.95639 | 37.7932050075467 | -122.444201430254 | (37.7932050075467, -122.444201430254) | 13 | 9 | 1 | 57 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );