Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 164715 | 164715 | 139060 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | |||
| 4763 | 4763 | 220524 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.770296793780396 | -122.431683217203 | (37.7702967937804, -122.431683217203) | |
| 32073 | 32073 | 234877 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | ||||
| 7574 | 7574 | 19781 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY19 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 50ST | ||||||||
| 61094 | 61094 | 196049 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 10ft | 6017090.910619999 | 2097040.61449 | 37.7390328376916 | -122.38342079293501 | (37.7390328376916, -122.383420792935) | |||
| 146490 | 146490 | 234888 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6010611.762999999 | 2100694.95228 | 37.7487066435094 | -122.40608021012699 | (37.7487066435094, -122.406080210127) | ||||
| 185485 | 185485 | 234874 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356001 | (37.7491536092595, -122.40577509356) | ||||
| 49096 | 49096 | 212850 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999489.821880001 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | |||
| 147141 | 147141 | 234872 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | ||||
| 106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
| 162455 | 162455 | 195979 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.739526454869704 | -122.39168875963999 | (37.7395264548697, -122.39168875964) | |||
| 182816 | 182816 | 234879 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6010587.102659999 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | ||||
| 24124 | 24124 | 234881 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.40624413046899 | (37.749070568567, -122.406244130469) | ||||
| 495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
| 55335 | 55335 | 234886 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6010522.647340001 | 2100819.38367 | 37.7490433200014 | -122.40639713934401 | (37.7490433200014, -122.406397139344) | ||||
| 149461 | 149461 | 234894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | ||||
| 180682 | 180682 | 234876 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6010649.76891 | 2100846.09542 | 37.749123775143204 | -122.405959431208 | (37.7491237751432, -122.405959431208) | ||||
| 72921 | 72921 | 234889 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | ||||
| 110210 | 110210 | 91057 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 750 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x4 | 6012569.0 | 2113092.0 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | |||
| 33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
| 51715 | 51715 | 234880 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.40620829069799 | (37.7490776534227, -122.406208290698) | ||||
| 70123 | 70123 | 248111 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010383.711069999 | 2099443.8594400003 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | ||||
| 74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
| 112632 | 112632 | 6098 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
| 165153 | 165153 | 195980 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6014694.29284 | 2097256.8818599996 | 37.7394939174204 | -122.39172238440399 | (37.7394939174204, -122.391722384404) | ||||
| 173066 | 173066 | 234898 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6009700.61042 | 2096445.6891 | 37.736988088737704 | -122.40893121572901 | (37.7369880887377, -122.408931215729) | ||||
| 175227 | 175227 | 140083 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | |||
| 177775 | 177775 | 53540 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.440219999 | 2113376.70713 | 37.782622110333904 | -122.462172779062 | (37.7826221103339, -122.462172779062) | ||
| 186239 | 186239 | 234899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | ||||
| 188309 | 188309 | 234896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 10ft | 6007240.7393 | 2101963.9408299997 | 37.7520018736867 | -122.41782715109501 | (37.7520018736867, -122.417827151095) | |||
| 69678 | 69678 | 195997 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | ||||
| 133456 | 133456 | 234878 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6010615.53478 | 2100839.3237900003 | 37.749103267009204 | -122.406077336824 | (37.7491032670092, -122.406077336824) | ||||
| 154008 | 154008 | 195993 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 3ft | 6012429.27896 | 2097757.0265 | 37.7407412159349 | -122.399588970171 | (37.7407412159349, -122.399588970171) | |||
| 156951 | 156951 | 195995 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 3ft | 6012483.54441 | 2097715.89022 | 37.7406312890986 | -122.399398452383 | (37.7406312890986, -122.399398452383) | |||
| 172182 | 172182 | 234883 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6010542.260840001 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | ||||
| 180467 | 180467 | 246918 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 5997638.105140001 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | |||
| 25030 | 25030 | 196022 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | ||||
| 73353 | 73353 | 196047 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6017083.0987599995 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | |||
| 38753 | 38753 | 234884 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6010535.25533 | 2100821.90556 | 37.749050949857796 | -122.406353718268 | (37.7490509498578, -122.406353718268) | ||||
| 102782 | 102782 | 196025 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6017042.181609999 | 2097072.1185299999 | 37.7391166482065 | -122.38359146989201 | (37.7391166482065, -122.383591469892) | |||
| 108312 | 108312 | 6094 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
| 146435 | 146435 | 196026 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | |||
| 171284 | 171284 | 249897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.40479885070101 | (37.8030148322229, -122.404798850701) | |||
| 172242 | 172242 | 234908 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6009679.550530001 | 2096368.23252 | 37.73677422993671 | -122.408998565949 | (37.7367742299367, -122.408998565949) | |||
| 182597 | 182597 | 196021 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | ||||
| 183132 | 183132 | 195994 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 3ft | 6012438.11131 | 2097750.05558 | 37.74072256758821 | -122.39955794174999 | (37.7407225675882, -122.39955794175) | |||
| 3855 | 3855 | 248614 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | |||
| 74651 | 74651 | 196034 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6017038.2356199995 | 2096967.92235 | 37.738830328350794 | -122.38359786136002 | (37.7388303283508, -122.38359786136) | |||
| 24297 | 24297 | 248119 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.40680643699301 | (37.7451368817742, -122.406806436993) | ||||
| 35215 | 35215 | 196035 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6017042.43736 | 2096973.9330400003 | 37.7388470647366 | -122.38358375190501 | (37.7388470647366, -122.383583751905) | |||
| 46578 | 46578 | 234892 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | ||||
| 47853 | 47853 | 196002 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6015985.51722 | 2110706.0962799997 | 37.7764941946745 | -122.38819621639799 | (37.7764941946745, -122.388196216398) | ||||
| 52998 | 52998 | 195998 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6016075.490669999 | 2110714.30849 | 37.776521728336604 | -122.387885542896 | (37.7765217283366, -122.387885542896) | ||||
| 61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
| 63128 | 63128 | 196020 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608171999 | (37.7764217471115, -122.38956608172) | ||||
| 156252 | 156252 | 234905 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993004 | -122.40896886942 | (37.736834783993, -122.40896886942) | |||
| 169265 | 169265 | 140081 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000726.183999999 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | |||
| 176193 | 176193 | 234907 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.40898933260401 | (37.7367941301369, -122.408989332604) | |||
| 184850 | 184850 | 234903 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6009692.653580001 | 2096419.54828 | 37.7369158659624 | -122.40895688234801 | (37.7369158659624, -122.408956882348) | ||||
| 185609 | 185609 | 248127 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.40672522818701 | (37.7452436393873, -122.406725228187) | ||||
| 3856 | 3856 | 246917 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5997637.485090001 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | |||
| 33398 | 33398 | 196014 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | ||||
| 46532 | 46532 | 196000 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016029.9014099995 | 2110710.35403 | 37.776508344609496 | -122.38804297461999 | (37.7765083446095, -122.38804297462) | ||||
| 46771 | 46771 | 140080 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | |||
| 47717 | 47717 | 234909 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6009677.77783 | 2096362.7223200002 | 37.73675900081071 | -122.409004306302 | (37.7367590008107, -122.409004306302) | |||
| 55642 | 55642 | 196036 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017046.41048 | 2096978.7292799999 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | |||
| 59758 | 59758 | 234871 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010740.989580001 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | ||||
| 68610 | 68610 | 234900 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6009696.65795 | 2096435.2295400002 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | ||||
| 69986 | 69986 | 196013 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015743.28218 | 2110693.6702799997 | 37.7764466511333 | -122.38903331613899 | (37.7764466511333, -122.389033316139) | ||||
| 71617 | 71617 | 196015 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015698.09519 | 2110690.66596 | 37.77643589704721 | -122.38918942227899 | (37.7764358970472, -122.389189422279) | ||||
| 72864 | 72864 | 234906 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6009686.024230001 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | |||
| 73079 | 73079 | 196019 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015611.09455 | 2110687.68162 | 37.776422879345496 | -122.389490176245 | (37.7764228793455, -122.389490176245) | ||||
| 127197 | 127197 | 249899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | |||
| 130896 | 130896 | 248113 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010385.30327 | 2099441.28079 | 37.745251666737296 | -122.40677496881099 | (37.7452516667373, -122.406774968811) | ||||
| 149012 | 149012 | 196010 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | ||||
| 168448 | 168448 | 196039 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017058.78761 | 2096996.2330599998 | 37.7389091998064 | -122.38352877183998 | (37.7389091998064, -122.38352877184) | |||
| 168626 | 168626 | 234893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | ||||
| 28993 | 28993 | 196012 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015764.416780001 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | ||||
| 29497 | 29497 | 135665 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5996326.409519999 | 2114621.95963 | 37.7861372526689 | -122.45648551290199 | (37.7861372526689, -122.456485512902) | |||
| 33120 | 33120 | 249800 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010811.58408 | 2121055.18857 | 37.8046222939481 | -122.406823966551 | (37.8046222939481, -122.406823966551) | |||
| 36823 | 36823 | 246562 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | |||
| 41087 | 41087 | 196003 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015962.95079 | 2110705.93329 | 37.776492496775106 | -122.388274269443 | (37.7764924967751, -122.388274269443) | ||||
| 45266 | 45266 | 196009 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | ||||
| 69044 | 69044 | 196048 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6017086.8639400005 | 2097032.1625700002 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | |||
| 137504 | 137504 | 196017 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | ||||
| 161996 | 161996 | 196004 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015940.35109 | 2110704.12187 | 37.776486270757204 | -122.388352322497 | (37.7764862707572, -122.388352322497) | ||||
| 166489 | 166489 | 195999 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6016051.5903 | 2110711.60548 | 37.7765129824099 | -122.387968033214 | (37.7765129824099, -122.387968033214) | ||||
| 178922 | 178922 | 196011 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015786.39152 | 2110696.3042599997 | 37.776456272983204 | -122.388884371337 | (37.7764562729832, -122.388884371337) | ||||
| 31815 | 31815 | 196007 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | ||||
| 46620 | 46620 | 248114 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | ||||
| 60534 | 60534 | 196005 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015919.22066 | 2110703.31156 | 37.7764828749315 | -122.38842536276 | (37.7764828749315, -122.38842536276) | ||||
| 65477 | 65477 | 196046 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017076.84536 | 2097020.9862799998 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | |||
| 135800 | 135800 | 196016 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015678.42156 | 2110690.23877 | 37.77643363342779 | -122.389257449686 | (37.7764336334278, -122.389257449686) | ||||
| 160001 | 160001 | 196024 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1670 Owen St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6013848.21751 | 2107498.5657599997 | 37.7675683801977 | -122.39536504787701 | (37.7675683801977, -122.395365047877) | |||
| 162017 | 162017 | 196037 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017049.14343 | 2096982.7375599998 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | |||
| 166201 | 166201 | 196038 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | |||
| 170865 | 170865 | 234887 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010600.221609999 | 2100713.10517 | 37.7487558418292 | -122.40612139908501 | (37.7487558418292, -122.406121399085) | ||||
| 180616 | 180616 | 234904 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6009689.76503 | 2096405.45865 | 37.73687701706479 | -122.408965875569 | (37.7368770170648, -122.408965875569) |
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");