trees

8,298 rows where qLegalStatus_id = 4 sorted by qAddress

✎ View and edit SQL

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)
7333 262326 Undocumented 4 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 10 Roemer Way   Sidewalk: Property side : Cutout Tree Private 2       3x3   5998623 2086576 37.7092614661016 -122.446521459005 (37.7092614661016, -122.446521459005) 9 7 6 28861 5
173906 111924 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5988171 2115833 37.788990841692 -122.484789589413 (37.788990841692, -122.484789589413) 11 6 1 55 33
156419 250399 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5988151.26478 2115836.13663 37.7889983045622 -122.484858100014 (37.7889983045622, -122.484858100014) 11 6 1 55 33
84839 117534 Undocumented 4 Calocedrus decurrens :: Incense Cedar 206 100 BRENTWOOD AVE 1 Sidewalk: Property side : Yard Tree Private 2       4x10   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
43607 116022 Undocumented 4 Tree(s) :: 17 100 CORTES AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2016 12:00:00 AM 3 3x10 Permit Number 777819 5993193 2099364 37.7440625285098 -122.466216952212 (37.7440625285098, -122.466216952212) 1 8 4 29491 40
162164 116021 Undocumented 4 Tree(s) :: 17 100 CORTES AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2016 12:00:00 AM 3 3x10 Permit Number 777819 5993193 2099364 37.7440625285098 -122.466216952212 (37.7440625285098, -122.466216952212) 1 8 4 29491 40
187103 102053 Undocumented 4 Maytenus boaria :: Mayten 58 100 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6000816.5 2105709 37.7619212664781 -122.440311602097 (37.7619212664781, -122.440311602097) 15 5 5 28862 3
98565 98512 Undocumented 4 Tree(s) :: 17 100 De Montfort Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/2015 12:00:00 AM 24 3x3 Permit Number 775766 5995016.6 2091971.4 37.7238693046984 -122.459376132933 (37.7238693046984, -122.459376132933) 9 8 4 28861 24
192441 98513 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100 De Montfort Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3 Permit Number 775766 5995016.6 2091971.4 37.7238693046984 -122.459376132933 (37.7238693046984, -122.459376132933) 9 8 4 28861 24
79201 115832 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 100 FONT BLVD 1 Sidewalk: Property side : Yard Tree Private 2     2 30x30 Permit Number 777501 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
91818 106479 Undocumented 4 Tree(s) :: 17 100 HUGO ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5995395.2 2107084.6 37.7653881494052 -122.459161237509 (37.7653881494052, -122.459161237509) 15 5 11 56 12
101533 106478 Undocumented 4 Tree(s) :: 17 100 HUGO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5995395.2 2107084.6 37.7653881494052 -122.459161237509 (37.7653881494052, -122.459161237509) 15 5 11 56 12
70257 117635 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 100 LOCUST ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
163119 117636 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 100 LOCUST ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
115276 122590 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 100 MacOndray Ln 1 Unaccepted Street : Yard Tree Private 2           6008161 2119143 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147) 5 1 10 308 32
58154 121665 Undocumented 4 Ulmus pumila :: Siberian Elm 99 100 Montalvo Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993653 2099666 37.7449182738718 -122.464648312953 (37.7449182738718, -122.464648312953) 1 8 4 29491 40
151183 121666 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 100 Montalvo Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993653 2099666 37.7449182738718 -122.464648312953 (37.7449182738718, -122.464648312953) 1 8 4 29491 40
49045 108996 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
72852 108997 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
112186 108998 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
32599 106351 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 100 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443) 10 7 7 28859 2
86766 106352 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 100 PUTNAM ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443) 10 7 7 28859 2
125195 105371 Undocumented 4 Myoporum laetum :: Myoporum 62 100 WESTGATE DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5993373.5 2093728.3 37.7285987139119 -122.465183566455 (37.7285987139119, -122.465183566455) 9 8 4 59 40
23474 107219 Undocumented 4 Tree(s) :: 17 100 WINSTON DR 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2015 12:00:00 AM 36   Permit Number 776841 5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
43481 107218 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree Private 2     42     5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
141196 107220 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100 WINSTON DR 3 Sidewalk: Curb side : Cutout Tree Private 2           5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
194479 265136 Undocumented 4 :: Tree 573 100 Winston Dr 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
130833 106685 Undocumented 4 Juniperus chinensis :: Juniper 113 100 Yukon St   Front Yard : Cutout Tree Private 2         Permit Number 772768 6000197.4 2104288 37.757984281634 -122.442350801363 (37.757984281634, -122.442350801363) 2 4 5 28862 3
155251 103345 Undocumented 4 Ceratonia siliqua :: Carob 5 1000 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3 Permit Number 29899 6010491 2108479 37.7700731362443 -122.407046397751 (37.7700731362443, -122.407046397751) 8 2 9 28853 34
104452 110629 Undocumented 4 Pinus radiata :: Monterey Pine 15 1000X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
50482 103357 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
51920 103361 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 10 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
70238 103355 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
74442 103359 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
87854 103360 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
168063 103358 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
174866 103356 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
177428 103354 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
182306 103352 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
190388 103353 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
59753 104427 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1000x GILMAN AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 4x4   6015570 2089525 37.71831228448 -122.3881550967 (37.71831228448, -122.3881550967) 10 3 8 58 1
47816 107839 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
140859 107838 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1000x LEAVENWORTH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
143675 107836 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
179684 107837 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000x LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
23205 81367 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1001 Polk St 1 Sidewalk: Curb side : Pot Tree Private 2   11/08/2003 12:00:00 AM   3x3   6006914.85774282 2114314.60875621 37.7858955407321 -122.419830397182 (37.7858955407321, -122.419830397182) 13 9 9 28858 36
3800 261425 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4147 261430 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 24 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10988 261428 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 22 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
12827 261426 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 20 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
17743 261427 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 21 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
18242 261429 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 23 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
19066 261424 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 18 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
34416 110631 Undocumented 4 Tree(s) :: 17 1001X Mandalay Ln   Unaccepted Street : Cutout Tree Private 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
120884 113311 Undocumented 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1001x Alemany Blvd 10 Front Yard : Yard Tree Private 2   11/09/2015 12:00:00 AM 20   Permit Number 776808 6003491.75626 2094313.44879 37.7307836910976 -122.430245918511 (37.7307836910976, -122.430245918511) 9 7 6 28861 25
8597 262037 Undocumented 4 Myoporum laetum :: Myoporum 62 1002x Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5995668 2098205 37.7410226892773 -122.45757517033 (37.7410226892773, -122.45757517033) 1 7 4 59 40
47310 255326 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 1003x Turk St 1 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
65197 255327 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 1003x Turk St 2 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
136152 255328 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 1003x Turk St 3 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
78281 115487 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 1004 SANCHEZ ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003744 2102383 37.7529551066007 -122.4299492716 (37.7529551066007, -122.4299492716) 2 4 5 28862 22
4789 96243 Undocumented 4 Myoporum laetum :: Myoporum 62 100X 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
22788 96245 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
123550 96244 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
173039 96242 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
30910 110537 Undocumented 4 Tree(s) :: 17 100X ASHBURY ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
31418 110533 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
100634 110538 Undocumented 4 Tree(s) :: 17 100X ASHBURY ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
167224 110540 Undocumented 4 Maytenus boaria :: Mayten 58 100X ASHBURY ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
192954 110534 Undocumented 4 Maytenus boaria :: Mayten 58 100X ASHBURY ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
168614 108208 Undocumented 4 Pinus radiata :: Monterey Pine 15 100X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000799.34617 2109469.60329 37.7722459721119 -122.440640678445 (37.7722459721119, -122.440640678445) 15 5 11 29492 9
34794 83038 Undocumented 4 Ceratonia siliqua :: Carob 5 100X Cargo Way 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2006 12:00:00 AM       6018593.33009 2097780.6594 37.7411477742489 -122.378277419086 (37.7411477742489, -122.378277419086) 10 3 8 58 1
69177 116506 Undocumented 4 Tree(s) :: 17 100X FREDERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999550 2107755 37.7674668800993 -122.444838989899 (37.7674668800993, -122.444838989899) 15 5 11 29492 9
143620 106469 Undocumented 4 Shrub :: Shrub 66 100X HENRY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 5x5   6002548 2107375 37.7665941299684 -122.434442151396 (37.7665941299684, -122.434442151396) 15 5 5 28862 3
23186 103507 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
44956 103510 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
83367 103511 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
143719 103509 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
160338 103508 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
34132 111168 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6003190.19669 2119810.74673 37.8007759915841 -122.43310951859 (37.8007759915841, -122.43310951859) 13 9 1 57 17
47216 112606 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 100X Monument Way 1 Back Yard : Yard Tree Private 2       10x10   5999003 2105766 37.7619743535119 -122.446587863076 (37.7619743535119, -122.446587863076) 15 5 5 29492 9
125344 102759 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6010215.5 2111581.3 37.7785759102049 -122.408218187711 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
143277 102760 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010215.5 2111581.3 37.7785759102049 -122.408218187711 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
81967 111127 Undocumented 4 Tree(s) :: 17 100X SHIPLEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012490 2112498 37.7812200539304 -122.400414179056 (37.7812200539304, -122.400414179056) 6 2 9 28856 34
112333 111124 Undocumented 4 Tree(s) :: 17 100X SHIPLEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012490 2112498 37.7812200539304 -122.400414179056 (37.7812200539304, -122.400414179056) 6 2 9 28856 34
140761 111126 Undocumented 4 Tree(s) :: 17 100X SHIPLEY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012490 2112498 37.7812200539304 -122.400414179056 (37.7812200539304, -122.400414179056) 6 2 9 28856 34
185438 111125 Undocumented 4 Tree(s) :: 17 100X SHIPLEY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012490 2112498 37.7812200539304 -122.400414179056 (37.7812200539304, -122.400414179056) 6 2 9 28856 34
44180 107833 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100X SUSSEX ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
164005 107832 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100X SUSSEX ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
77968 100180 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 100x BELVEDERE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997991 2108152 37.7684678470263 -122.450259955793 (37.7684678470263, -122.450259955793) 15 5 11 29492 9
38711 116976 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 7 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
173000 116975 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 6 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
61331 115627 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 8 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
83780 115623 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 4 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
96129 115622 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
97571 115624 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
128938 115625 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 6 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
145765 115621 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
156658 115628 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20
171511 115626 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 100x CAROLINA ST 7 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3   6012240 2107486 37.7674443012314 -122.400926814605 (37.7674443012314, -122.400926814605) 14 3 8 28856 20

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