trees

228 rows where qCaretaker_id = 2 and qSpecies_id = 59 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 228 ✖
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)
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
6092 196018 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree Private 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
10408 195999 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
15414 96980 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
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
21347 201996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968) 10 3 8 58 1
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
23490 196012 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree Private 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
24272 117475 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
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
26017 109376 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 3 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
28533 195986 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6018468.61509 2099561.76349 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987) 10 3 8 58 1
29793 195970 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 16 Back Yard : Yard Tree Private 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
30255 196014 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree Private 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
32582 196000 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
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
37957 196010 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree Private 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
39747 196021 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 25 Sidewalk: Property side : Yard Tree Private 2     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543) 14 3 9 310 20
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
42007 195956 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 2 Back Yard : Yard Tree Private 2     9     6015682.42479 2100340.57249 37.7480158985316 -122.388521013727 (37.7480158985316, -122.388521013727) 10 3 8 58 1
42959 117474 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
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
47866 195983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 10 Sidewalk: Curb side : Yard Tree Private 2     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939) 10 3 8 58 1
49343 196013 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard Tree Private 2     17     6015743.28218 2110693.67028 37.7764466511333 -122.389033316139 (37.7764466511333, -122.389033316139) 14 3 9 310 20
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
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
55799 195988 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6018362.60368 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078) 10 3 8 58 1
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
59791 96983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2     38   Permit Number 25529 6003522.34271 2118089.29041 37.796068153086 -122.431837171257 (37.796068153086, -122.431837171257) 13 9 1 57 17
61218 201995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2     6013319.20907 2092521.70031 37.7264156560521 -122.396145090149 (37.7264156560521, -122.396145090149) 10 3 8 58 1
61534 195959 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 5 Back Yard : Yard Tree Private 2     10     6015616.60441 2100338.74984 37.7480072461368 -122.388748492749 (37.7480072461368, -122.388748492749) 10 3 8 58 1
62379 195992 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 1 Sidewalk: Curb side : Yard Tree Private 2     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446) 10 3 8 58 1
63271 195965 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 11 Back Yard : Yard Tree Private 2     8     6015497.16873 2100330.63483 37.7479783437428 -122.389160933554 (37.7479783437428, -122.389160933554) 10 3 8 58 1
64076 195969 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 15 Back Yard : Yard Tree Private 2     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)   3 8 58 1
64096 195982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 11 Sidewalk: Curb side : Yard Tree Private 2     10     6018502.10258 2099556.87815 37.7460198865213 -122.378716163238 (37.7460198865213, -122.378716163238) 10 3 8 58 1
64778 109377 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 4 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
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
68586 196022 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 26 Sidewalk: Property side : Yard Tree Private 2     21     6015549.75144 2110684.1794 37.7764098616684 -122.389702136539 (37.7764098616684, -122.389702136539) 14 3 9 310 20
74182 195980 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Phelps St 2 Side Yard : Yard Tree Private 2     24     6014694.29284 2097256.88186 37.7394939174204 -122.391722384404 (37.7394939174204, -122.391722384404) 10 3 8 58 1
74255 96979 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
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
79032 195968 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 14 Back Yard : Yard Tree Private 2     7     6015437.03514 2100327.81381 37.7479672640843 -122.389368677829 (37.7479672640843, -122.389368677829)   3 8 58 1
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
80958 196006 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 10 Sidewalk: Property side : Yard Tree Private 2     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001) 14 3 9 310 20
81978 196007 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 11 Sidewalk: Property side : Yard Tree Private 2     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236) 14 3 9 310 20
82059 195984 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 9 Sidewalk: Curb side : Yard Tree Private 2     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093) 10 3 8 58 1
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
84576 196011 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 15 Sidewalk: Property side : Yard Tree Private 2     16     6015786.39152 2110696.30426 37.7764562729832 -122.388884371337 (37.7764562729832, -122.388884371337) 14 3 9 310 20
84676 109375 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 2 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
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
87935 196005 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 9 Sidewalk: Property side : Yard Tree Private 2     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276) 14 3 9 310 20
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
90159 195962 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 8 Back Yard : Yard Tree Private 2     9     6015556.60842 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422) 10 3 8 58 1
91372 96982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     41   Permit Number 25529 6003530.13563 2118059.26209 37.7959861448054 -122.431808061115 (37.7959861448054, -122.431808061115) 13 9 1 57 17
95955 117473 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
97183 201993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 5 Sidewalk: Curb side : Yard Tree Private 2     2     6013314.35101 2092488.44605 37.7263240762942 -122.396159554816 (37.7263240762942, -122.396159554816) 10 3 8 58 1
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
99139 195989 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6018358.23149 2099573.02507 37.7460562901585 -122.379214777067 (37.7460562901585, -122.379214777067) 10 3 8 58 1
100061 195998 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 2 Sidewalk: Property side : Yard Tree Private 2     18     6016075.49067 2110714.30849 37.7765217283366 -122.387885542896 (37.7765217283366, -122.387885542896) 14 3 9 310 20
103959 195966 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 12 Back Yard : Yard Tree Private 2     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)   3 8 58 1
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
104890 201994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251) 10 3 8 58 1
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
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
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
114094 117472 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
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
120240 195985 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 8 Sidewalk: Curb side : Yard Tree Private 2     5     6018474.35913 2099556.32192 37.7460168297129 -122.378812058831 (37.7460168297129, -122.378812058831) 10 3 8 58 1
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
121735 196003 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 7 Sidewalk: Property side : Yard Tree Private 2     16     6015962.95079 2110705.93329 37.7764924967751 -122.388274269443 (37.7764924967751, -122.388274269443) 14 3 9 310 20
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
123430 96984 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
126204 196009 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 13 Sidewalk: Property side : Yard Tree Private 2     16     6015830.73834 2110698.70731 37.776465329147 -122.388731129538 (37.776465329147, -122.388731129538) 14 3 9 310 20
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
127782 195991 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321) 10 3 8 58 1
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
135590 195990 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 3 Sidewalk: Curb side : Yard Tree Private 2     4     6018348.89198 2099575.3229 37.7460620845153 -122.379247231793 (37.7460620845153, -122.379247231793) 10 3 8 58 1
137112 196001 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 5 Sidewalk: Property side : Yard Tree Private 2     4     6016008.12939 2110708.52586 37.7765021186104 -122.388118163334 (37.7765021186104, -122.388118163334) 14 3 9 310 20
137889 109378 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 5 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
137920 195961 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 7 Back Yard : Yard Tree Private 2     10     6015577.60391 2100335.50195 37.7479961664858 -122.388883129368 (37.7479961664858, -122.388883129368) 10 3 8 58 1
138177 196019 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 23 Sidewalk: Property side : Yard Tree Private 2     17     6015611.09455 2110687.68162 37.7764228793455 -122.389490176245 (37.7764228793455, -122.389490176245) 14 3 9 310 20
138530 195967 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 13 Back Yard : Yard Tree Private 2     5     6015456.78398 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)   3 8 58 1
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
145197 196008 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 12 Sidewalk: Property side : Yard Tree Private 2     15     6015854.16157 2110700.296 37.7764709894889 -122.388650212137 (37.7764709894889, -122.388650212137) 14 3 9 310 20
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);