trees
334 rows where qSpecies_id = 59 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
PlantDate ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164057 | 196049 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 10ft | 6017090.91062 | 2097040.61449 | 37.7390328376916 | -122.383420792935 | (37.7390328376916, -122.383420792935) | 10 | 3 | 8 | 58 | 1 | |||
167404 | 195963 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | 10 | 3 | 8 | 58 | 1 | ||||
169280 | 201997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.396163841002 | (37.7264024081338, -122.396163841002) | 10 | 3 | 8 | 58 | 1 | ||||
169477 | 255308 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | 6017061 | 2098665 | 37.7434914187463 | -122.383637271506 | (37.7434914187463, -122.383637271506) | 10 | 3 | 8 | 58 | 1 | ||
170444 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
173532 | 195957 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.388573036834 | (37.7480149542209, -122.388573036834) | 10 | 3 | 8 | 58 | 1 | ||||
176690 | 195958 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | 6015649.24062 | 2100340.89834 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | 10 | 3 | 8 | 58 | 1 | ||||
176786 | 195987 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | 10 | 3 | 8 | 58 | 1 | ||||
177168 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
178720 | 196029 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017027.27121 | 2097051.6476 | 37.7390596150087 | -122.383641598974 | (37.7390596150087, -122.383641598974) | 10 | 3 | 8 | 58 | 1 | |||
183244 | 195979 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 1 | Side Yard : Yard | Tree | Private 2 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.7395264548697 | -122.39168875964 | (37.7395264548697, -122.39168875964) | 10 | 3 | 8 | 58 | 1 | |||
185019 | 195976 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 22 | Back Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6015275.57642 | 2100315.10939 | 37.7479234275315 | -122.389926112714 | (37.7479234275315, -122.389926112714) | 3 | 8 | 58 | 1 | ||||
185083 | 195981 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6018524.13374 | 2099557.33259 | 37.7460223488573 | -122.378640013128 | (37.7460223488573, -122.378640013128) | 10 | 3 | 8 | 58 | 1 | ||||
189964 | 195993 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 2 | Side Yard : Yard | Tree | Private 2 | 23 | Width 3ft | 6012429.27896 | 2097757.0265 | 37.7407412159349 | -122.399588970171 | (37.7407412159349, -122.399588970171) | 10 | 3 | 8 | 58 | 1 | |||
192137 | 195960 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 6015597.7328 | 2100337.72732 | 37.7480033925609 | -122.388813679213 | (37.7480033925609, -122.388813679213) | 10 | 3 | 8 | 58 | 1 | ||||
3136 | 234897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009692.09622 | 2096449.43711 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | 10 | 7 | 7 | 28859 | 2 | ||||
19126 | 234903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009692.65358 | 2096419.54828 | 37.7369158659624 | -122.408956882348 | (37.7369158659624, -122.408956882348) | 10 | 7 | 7 | 28859 | 2 | ||||
19786 | 248125 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6010397.04877 | 2099427.00914 | 37.7452131370768 | -122.406733349058 | (37.7452131370768, -122.406733349058) | 2 | 7 | 7 | 28859 | 2 | ||||
20810 | 248173 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6007303.95131 | 2098726.55555 | 37.743116300271 | -122.417379150221 | (37.743116300271, -122.417379150221) | 2 | 7 | 7 | 28859 | 2 | ||||
21087 | 234873 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.405696174457 | (37.7491740112676, -122.405696174457) | 10 | 4 | 7 | 28859 | 19 | ||||
23378 | 234893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | 2 | 7 | 7 | 28859 | 2 | ||||
24893 | 234872 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | 10 | 4 | 7 | 28859 | 19 | ||||
34861 | 234884 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6010535.25533 | 2100821.90556 | 37.7490509498578 | -122.406353718268 | (37.7490509498578, -122.406353718268) | 10 | 4 | 7 | 28859 | 19 | ||||
35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
40536 | 248113 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | 6010385.30327 | 2099441.28079 | 37.7452516667373 | -122.406774968811 | (37.7452516667373, -122.406774968811) | 2 | 7 | 7 | 28859 | 2 | ||||
40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
47166 | 234889 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | 2 | 7 | 7 | 28859 | 2 | ||||
49707 | 234909 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6009677.77783 | 2096362.72232 | 37.7367590008107 | -122.409004306302 | (37.7367590008107, -122.409004306302) | 10 | 7 | 7 | 28859 | 2 | |||
52513 | 234888 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6010611.763 | 2100694.95228 | 37.7487066435094 | -122.406080210127 | (37.7487066435094, -122.406080210127) | 2 | 7 | 7 | 28859 | 2 | ||||
56401 | 234907 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.408989332604 | (37.7367941301369, -122.408989332604) | 10 | 7 | 7 | 28859 | 2 | |||
58340 | 234904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009689.76503 | 2096405.45865 | 37.7368770170648 | -122.408965875569 | (37.7368770170648, -122.408965875569) | 10 | 7 | 7 | 28859 | 2 | ||||
66581 | 234875 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | 10 | 4 | 7 | 28859 | 19 | ||||
76548 | 234891 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6010619.31212 | 2100642.55964 | 37.7485632070257 | -122.406050414705 | (37.7485632070257, -122.406050414705) | 2 | 7 | 7 | 28859 | 2 | ||||
77949 | 248121 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010387.39582 | 2099398.52057 | 37.7451343735684 | -122.406764720109 | (37.7451343735684, -122.406764720109) | 2 | 7 | 7 | 28859 | 2 | ||||
78172 | 234882 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6010551.46993 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | 10 | 4 | 7 | 28859 | 19 | ||||
80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
80814 | 248172 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6007302.01446 | 2098729.32454 | 37.7431237943252 | -122.417386043537 | (37.7431237943252, -122.417386043537) | 2 | 7 | 7 | 28859 | 2 | ||||
83040 | 234899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | 10 | 7 | 7 | 28859 | 2 | ||||
87689 | 248119 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 9 | Side Yard : Yard | Tree | Private 2 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.406806436993 | (37.7451368817742, -122.406806436993) | 2 | 7 | 7 | 28859 | 2 | ||||
89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
97525 | 234890 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.406036393361 | (37.7486290355994, -122.406036393361) | 2 | 7 | 7 | 28859 | 2 | ||||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
110194 | 234887 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010600.22161 | 2100713.10517 | 37.7487558418292 | -122.406121399085 | (37.7487558418292, -122.406121399085) | 2 | 7 | 7 | 28859 | 2 | ||||
111007 | 234892 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | 2 | 7 | 7 | 28859 | 2 | ||||
111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
113044 | 248122 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | 2 | 7 | 7 | 28859 | 2 | ||||
114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
117375 | 234878 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6010615.53478 | 2100839.32379 | 37.7491032670092 | -122.406077336824 | (37.7491032670092, -122.406077336824) | 10 | 4 | 7 | 28859 | 19 | ||||
121047 | 234886 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010522.64734 | 2100819.38367 | 37.7490433200014 | -122.406397139344 | (37.7490433200014, -122.406397139344) | 10 | 4 | 7 | 28859 | 19 | ||||
121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
122830 | 234901 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009690.97834 | 2096436.62736 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | 10 | 7 | 7 | 28859 | 2 | ||||
125376 | 234906 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6009686.02423 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | 10 | 7 | 7 | 28859 | 2 | |||
125984 | 234908 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6009679.55053 | 2096368.23252 | 37.7367742299367 | -122.408998565949 | (37.7367742299367, -122.408998565949) | 10 | 7 | 7 | 28859 | 2 | |||
126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 | ||||
131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
142091 | 234885 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | 10 | 4 | 7 | 28859 | 19 | ||||
145571 | 248126 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6010387.78953 | 2099433.6295 | 37.7452307970734 | -122.406765832574 | (37.7452307970734, -122.406765832574) | 2 | 7 | 7 | 28859 | 2 | ||||
146008 | 234876 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6010649.76891 | 2100846.09542 | 37.7491237751432 | -122.405959431208 | (37.7491237751432, -122.405959431208) | 10 | 4 | 7 | 28859 | 19 | ||||
146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 7 | 7 | 28859 | 2 | ||||
147412 | 234898 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009700.61042 | 2096445.6891 | 37.7369880887377 | -122.408931215729 | (37.7369880887377, -122.408931215729) | 10 | 7 | 7 | 28859 | 2 | ||||
150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
152488 | 234902 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009698.63441 | 2096418.94153 | 37.7369145349811 | -122.408936161078 | (37.7369145349811, -122.408936161078) | 10 | 7 | 7 | 28859 | 2 | ||||
164603 | 234905 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993 | -122.40896886942 | (37.736834783993, -122.40896886942) | 10 | 7 | 7 | 28859 | 2 | |||
165442 | 234871 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010740.98958 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | 10 | 4 | 7 | 28859 | 19 | ||||
172175 | 248118 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6010376.97092 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | 2 | 7 | 7 | 28859 | 2 | ||||
179780 | 234900 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6009696.65795 | 2096435.22954 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | 10 | 7 | 7 | 28859 | 2 | ||||
182229 | 234877 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | 10 | 4 | 7 | 28859 | 19 | ||||
187174 | 234894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 12 | Front Yard : Yard | Tree | Private 2 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | 2 | 7 | 7 | 28859 | 2 | ||||
191905 | 248123 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010392.06783 | 2099413.07866 | 37.7451746083214 | -122.406749590819 | (37.7451746083214, -122.406749590819) | 2 | 7 | 7 | 28859 | 2 | ||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
153116 | 24282 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Winding Way | 20 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
55125 | 98312 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
109416 | 212850 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5999489.82188 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | 9 | 7 | 4 | 63 | 40 | |||
140069 | 212849 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | 1 | 8 | 4 | 59 | 40 | |||
148446 | 53540 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.44022 | 2113376.70713 | 37.7826221103339 | -122.462172779062 | (37.7826221103339, -122.462172779062) | 11 | 6 | 2 | 54 | 11 | ||
193664 | 121867 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990303.78145 | 2112825.75308 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | 11 | 6 | 2 | 55 | 26 | |||
16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
19788 | 246559 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.423601653893 | (37.7722588698898, -122.423601653893) | 7 | 9 | 11 | 28852 | 10 | |||
24737 | 246562 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | 7 | 9 | 11 | 28852 | 10 | |||
26372 | 246564 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | 7 | 9 | 11 | 28852 | 10 | |||
32481 | 246567 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | 7 | 9 | 11 | 28852 | 10 | |||
34981 | 244429 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.7731450894818 | -122.4238458121 | (37.7731450894818, -122.4238458121) | 7 | 9 | 11 | 28852 | 10 | |||
37967 | 246565 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.7725208666788 | -122.423667646169 | (37.7725208666788, -122.423667646169) | 7 | 9 | 11 | 28852 | 10 | |||
39892 | 244430 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.423851185605 | (37.7731694680478, -122.423851185605) | 7 | 9 | 11 | 28852 | 10 | |||
44966 | 244263 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | 7 | 9 | 11 | 28852 | 10 | |||
46467 | 244336 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | 7 | 9 | 11 | 28852 | 10 | |||
59524 | 244335 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | 7 | 9 | 11 | 28852 | 10 | |||
61977 | 244407 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | 7 | 9 | 11 | 28852 | 10 | |||
67742 | 246560 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | 7 | 9 | 11 | 28852 | 10 | |||
74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
77096 | 244403 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005596.6857 | 2110150.2412 | 37.7743868598384 | -122.424094653801 | (37.7743868598384, -122.424094653801) | 7 | 9 | 11 | 28852 | 10 | |||
80487 | 246571 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 15 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | 7 | 9 | 11 | 28852 | 10 | |||
81955 | 246558 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.7722394013476 | -122.423593061791 | (37.7722394013476, -122.423593061791) | 7 | 9 | 11 | 28852 | 10 | |||
83859 | 139060 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | 15 | 6 | 11 | 29490 | 31 | |||
83892 | 244431 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.7732013716398 | -122.423856754026 | (37.7732013716398, -122.423856754026) | 7 | 9 | 11 | 28852 | 10 | |||
84264 | 246561 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.423619884948 | (37.7722999149342, -122.423619884948) | 7 | 9 | 11 | 28852 | 10 |
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) );