trees

484 rows where qSpecies_id = 56 sorted by Fire Prevention Districts

✎ 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)
115843 208957 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 625 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 8ft   5993588.44342 2096129.23717 37.7352034875532 -122.46461476908 (37.7352034875532, -122.46461476908) 1 8 4 59 40
116722 208960 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 601 Saint Francis Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     44 Width 8ft   5993401.29019 2096115.48675 37.7351549412444 -122.465260822223 (37.7351549412444, -122.465260822223) 1 8 4 59 40
116774 207776 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 110 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 10ft   5993235.98614 2096867.28826 37.7372096663776 -122.46588694193 (37.7372096663776, -122.46588694193) 1 8 4 59 40
119017 105441 Private 9 Eucalyptus globulus :: Blue Gum 56 425 WAWONA ST   unknown : Yard Tree Private 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
119656 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
121390 207802 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 65 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 10ft   5993322.83202 2097078.2937 37.7377940440554 -122.465602003431 (37.7377940440554, -122.465602003431) 1 8 4 59 40
123942 114396 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2           5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
126064 207794 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 213 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 10ft   5993149.25155 2096563.99491 37.736371894833 -122.46616478659 (37.736371894833, -122.46616478659) 1 8 4 59 40
128096 256447 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 31 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
129458 207796 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 145 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     45 Width 10ft   5993217.29355 2096710.01575 37.7367767570402 -122.465940145823 (37.7367767570402, -122.465940145823) 1 8 4 59 40
131453 208923 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 201 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5992447.89906 2096049.02744 37.734917433899 -122.468552177239 (37.734917433899, -122.468552177239) 1 8 4 59 40
132170 253847 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
132508 254295 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 7 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
132855 207793 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 215 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     38 Width 10ft   5993139.69787 2096516.18073 37.7362400578338 -122.466194343712 (37.7362400578338, -122.466194343712) 1 8 4 59 40
134035 114403 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
134921 207789 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 275 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.466199073252 (37.735400404893, -122.466199073252) 1 8 4 59 40
136621 209007 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 3 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5994745.50567 2098641.39451 37.7421678860404 -122.460796414937 (37.7421678860404, -122.460796414937) 1 8 4 59 40
138399 254281 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 5 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
139166 176348 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 0 Fuente Ave 2 Sidewalk: Curb side : Yard Tree Private 2     26     5989603.79735 2090546.09261 37.7196430676648 -122.477982952958 (37.7196430676648, -122.477982952958) 1 8 4 64 14
140152 208932 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 435 Saint Francis Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     47 Width 10ft   5992980.53983 2096066.62854 37.7349965157706 -122.4667119458 (37.7349965157706, -122.4667119458) 1 8 4 59 40
140860 253846 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 150 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       3x3   5991384 2095197 37.7325164679088 -122.472168327848 (37.7325164679088, -122.472168327848) 1 8 4 64 40
142283 114069 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     40     5988091 2090188 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801) 1 8 4 64 14
143583 208924 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 235 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     44 Width 10ft   5992506.66791 2096052.38869 37.7349300576612 -122.468349238953 (37.7349300576612, -122.468349238953) 1 8 4 59 40
143744 207783 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 260 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     28 Width 10ft   5993078.05201 2096316.5606 37.7356883939084 -122.466392973362 (37.7356883939084, -122.466392973362) 1 8 4 59 40
143887 207777 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 118 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     34 Width 10ft   5993220.09553 2096827.09916 37.7370984004648 -122.465938963216 (37.7370984004648, -122.465938963216) 1 8 4 59 40
143983 208934 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 405 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     33 Width 10ft   5992888.06418 2096062.32962 37.7349793747065 -122.467031351742 (37.7349793747065, -122.467031351742) 1 8 4 59 40
144155 208987 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5993980.02644 2096844.06194 37.7371887859367 -122.463312789075 (37.7371887859367, -122.463312789075) 1 8 4 59 40
148291 207805 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 35 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 10ft   5993257.87377 2097404.51842 37.738686028527 -122.465850290071 (37.738686028527, -122.465850290071) 1 8 4 59 40
151227 207804 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 55 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 10ft   5993316.27316 2097156.75234 37.738009093546 -122.465630378851 (37.738009093546, -122.465630378851) 1 8 4 59 40
152264 207803 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 55 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5993318.63441 2097122.65017 37.7379155937141 -122.465619738075 (37.7379155937141, -122.465619738075) 1 8 4 59 40
152308 256445 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 29 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
152776 253841 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 1 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
157123 66251 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1990 12:00:00 AM     Permit Number 29352 5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
157725 208918 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5992207.01448 2096041.6179 37.7348831715052 -122.469384453049 (37.7348831715052, -122.469384453049) 1 8 4 59 40
158118 114076 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     24     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
158749 207799 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 10ft   5993278.01218 2096833.03373 37.7371180362587 -122.465739151856 (37.7371180362587, -122.465739151856) 1 8 4 59 40
163725 207792 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 255 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     28 Width 10ft   5993127.30718 2096365.92491 37.7358267779692 -122.466226266925 (37.7358267779692, -122.466226266925) 1 8 4 59 40
163869 208917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Saint Francis Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     41 Width 10ft Permit Number 782932 5992152.90186 2096040.12972 37.7348759580475 -122.469571429275 (37.7348759580475, -122.469571429275) 1 8 4 59 40
166600 254313 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 5 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
170594 209005 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5994782.01847 2098589.82391 37.7420283868014 -122.460666429624 (37.7420283868014, -122.460666429624) 1 8 4 59 40
171112 207771 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 50 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 10ft   5993253.43088 2097238.90262 37.7382310327445 -122.465853621172 (37.7382310327445, -122.465853621172) 1 8 4 59 40
171148 256446 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 30 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
171379 207780 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 250 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     20 Width 10ft   5993075.61435 2096444.65306 37.7360399631594 -122.466410708005 (37.7360399631594, -122.466410708005) 1 8 4 59 40
171661 207788 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 285 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 10ft   5993135.10109 2096167.22841 37.7352816566244 -122.46618488553 (37.7352816566244, -122.46618488553) 1 8 4 59 40
173822 254318 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
174677 208913 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 25 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     52 Width 10ft   5991855.18446 2096027.35196 37.7348236624713 -122.470599802253 (37.7348236624713, -122.470599802253) 1 8 4 59 40
177622 254294 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 6 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
177674 207779 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 126 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5993175.19587 2096740.86685 37.7368590378112 -122.46608793591 (37.7368590378112, -122.46608793591) 1 8 4 59 40
178630 254286 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100X Junipero Serra Blvd 2 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40
179682 207769 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     40 Width 10ft   5993228.66009 2097329.84492 37.7384793085579 -122.465945871829 (37.7384793085579, -122.465945871829) 1 8 4 59 40
186983 208979 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 46 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5992891.21268 2101728.13425 37.7505364203394 -122.467432335147 (37.7505364203394, -122.467432335147) 1 8 4 29491 12
189787 208965 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 56 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 6ft   5993745.43898 2096960.72106 37.7374955851482 -122.464132325055 (37.7374955851482, -122.464132325055) 1 8 4 59 40
191199 207791 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 255 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     33 Width 10ft   5993127.95212 2096331.51719 37.7357323401679 -122.466221537416 (37.7357323401679, -122.466221537416) 1 8 4 59 40
192427 185929 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897) 1 8 3 29491 35
776 113502 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x MANSELL ST 8 Median : Cutout Tree DPW 1     30 3x3   6011136 2090597 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831) 10 3 7 309 28
973 176338 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100x Mansell St 6 Median : Cutout Tree DPW 1     5 Width 0ft   6011479.2515 2090641.1055 37.721149380822 -122.402373605767 (37.721149380822, -122.402373605767) 10 7 8 309 28
4988 224247 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 701X Powhattan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     46     6008745.22263 2098103.60695 37.7414868060782 -122.412351580256 (37.7414868060782, -122.412351580256) 10 7 7 28859 2
8037 257932 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
11269 247818 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1158x Jarboe Ave 1 Unaccepted Street : Yard Tree Private 2     46     6009634.53348 2096844.36766 37.7380790724954 -122.409187798594 (37.7380790724954, -122.409187798594) 10 7 7 28859 2
15695 262389 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 67 Rosenkranz St 1 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
17952 176334 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 7 Side Yard : Yard Tree Private 2     34     6012223.87562 2087782.54699 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764) 10 3 8 309 1
20776 247930 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 3 Side Yard : Yard Tree Private 2     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818) 10 7 7 28859 2
22979 176339 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100x Mansell St 7 Median : Cutout Tree DPW 1     26 Width 0ft   6011461.59774 2090655.36204 37.7211875408569 -122.402435631998 (37.7211875408569, -122.402435631998) 10 3 8 309 28
26442 176342 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Mansell St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6011455.5144 2090588.63485 37.7210039820195 -122.402451970878 (37.7210039820195, -122.402451970878) 10 7 8 309 28
35559 122678 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 701x Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6008711 2098131 37.741560100881 -122.412471846631 (37.741560100881, -122.412471846631) 10 7 7 28859 2
36331 256763 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
44889 191727 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1790 23rd St 1 Sidewalk: Property side : Yard Tree Private 2     21     6013509.42079 2102917.94191 37.7549721419751 -122.396215837988 (37.7549721419751, -122.396215837988) 10 3 8 28856 29
45615 251302 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 1 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
46802 176341 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 500x Mansell St 17 Median : Cutout Tree DPW 1     11 Width 0ft   6010266.44711 2090286.24099 37.7201072185592 -122.406540946309 (37.7201072185592, -122.406540946309) 10 3 8 309 28
47155 176337 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100x Mansell St 5 Median : Cutout Tree DPW 1     59 Width 0ft   6011478.9031 2090656.66454 37.7211920833183 -122.402375903539 (37.7211920833183, -122.402375903539) 10 3 8 309 28
51387 224267 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 3 Front Yard : Yard Tree Private 2     26     6011260.20343 2103721.90369 37.7570542343818 -122.40405088815 (37.7570542343818, -122.40405088815) 10 4 8 28859 19
63828 247922 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 7 Side Yard : Yard Tree Private 2     24     6010270.94858 2098720.09099 37.7432650373678 -122.40711956383 (37.7432650373678, -122.40711956383) 10 7 7 28859 2
64758 191722 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     18     6014479.64038 2101959.5389 37.7523945096015 -122.392793471535 (37.7523945096015, -122.392793471535) 10 3 8 28856 1
65425 191724 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 950x Kansas St 5 Median : Yard Tree DPW 1     43     6011608.52294 2103823.60133 37.7573529289142 -122.402853412073 (37.7573529289142, -122.402853412073) 10 3 8 28856 29
67100 247923 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     17     6010288.87158 2098729.72842 37.7432925026595 -122.407058269637 (37.7432925026595, -122.407058269637) 10 7 7 28859 2
71078 247924 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 9 Side Yard : Yard Tree Private 2     23     6010297.69523 2098727.78354 37.7432876562154 -122.407027622545 (37.7432876562154, -122.407027622545) 10 7 7 28859 2
76221 224266 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 2 Front Yard : Yard Tree Private 2     28     6011271.09407 2103721.28577 37.7570531461907 -122.404013180481 (37.7570531461907, -122.404013180481) 10 4 8 28859 19
88934 247919 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 4 Side Yard : Yard Tree Private 2     22     6010242.48982 2098715.37522 37.7432504962209 -122.40721763491 (37.7432504962209, -122.40721763491) 10 7 7 28859 2
89575 113506 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x Mansell St 12 Median : Cutout Tree DPW 1     39 3x3   6011135.08211 2090555.53588 37.7208952054249 -122.403557288932 (37.7208952054249, -122.403557288932) 10 3 7 309 28
96951 247928 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     22     6010393.74755 2098772.89885 37.7434169076795 -122.406698675702 (37.7434169076795, -122.406698675702) 10 7 7 28859 2
97103 247917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     32     6010231.88216 2098716.76824 37.7432537274832 -122.407254411775 (37.7432537274832, -122.407254411775) 10 7 7 28859 2
103215 3751 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 990 Carolina St 1 Median : Cutout Tree DPW 1     42 18   6012435.5557064 2103342.2152382 37.7560772927341 -122.399959384248 (37.7560772927341, -122.399959384248) 10 3 8 28856 29
103652 247921 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 6 Side Yard : Yard Tree Private 2     38     6010260.8237 2098716.17835 37.7432537274883 -122.407154297447 (37.7432537274883, -122.407154297447) 10 7 7 28859 2
110057 191738 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 920 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     39     6011311.04969 2104026.19787 37.757892599481 -122.403896453867 (37.757892599481, -122.403896453867) 10 3 8 28856 29
112880 191737 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6010885.73151 2096220.33708 37.7364356342809 -122.404817839882 (37.7364356342809, -122.404817839882) 10 3 8 58 1
114444 176336 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 9 Side Yard : Yard Tree Private 2     31     6012249.60162 2087766.47281 37.7132991905898 -122.39950899437 (37.7132991905898, -122.39950899437) 10 3 8 309 1
119025 176335 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 5 Side Yard : Yard Tree Private 2     17     6012233.93602 2087774.20569 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027) 10 3 8 309 1
124028 257931 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
126653 191723 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x Carolina St 30 Median : Yard Tree DPW 1     50     6012476.48508 2103328.88343 37.7560429683291 -122.399816899747 (37.7560429683291, -122.399816899747) 10 3 8 28856 29
130715 251303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 2 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
134451 247927 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 12 Side Yard : Yard Tree Private 2     34     6010318.55961 2098736.7728 37.7433135063186 -122.406956112045 (37.7433135063186, -122.406956112045) 10 7 7 28859 2
137649 108201 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 2 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
142651 247929 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     37     6010384.75611 2098766.60945 37.7433991352743 -122.406729322823 (37.7433991352743, -122.406729322823) 10 7 7 28859 2
146246 191736 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 1 Sidewalk: Curb side : Yard Tree Private 2     57     6010895.57722 2096228.10312 37.7364575084979 -122.404784345514 (37.7364575084979, -122.404784345514) 10 3 8 58 1
152900 257934 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
154190 121341 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 401X Cargo Way 2 Side Yard : Yard Tree Private 2     18 3x3   6017217 2098844 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195) 10 3 8 58 1
158886 247820 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 Jarboe Ave 2 Front Yard : Yard Tree Private 2     7     6009707.55977 2096850.28614 37.7380994142676 -122.408935726717 (37.7380994142676, -122.408935726717) 10 7 7 28859 2
162813 191721 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1150x Tennessee St 7 Median : Yard Tree DPW 1     50     6015559.12531 2103608.85918 37.7569830917109 -122.389175557402 (37.7569830917109, -122.389175557402) 10 3 8 28856 29
165630 108200 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 1 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
165894 247821 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 Jarboe Ave 3 Front Yard : Yard Tree Private 2     8     6009717.95526 2096849.33319 37.7380973799798 -122.40889971695 (37.7380973799798, -122.40889971695) 10 7 7 28859 2

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