trees
163,064 rows where qCaretaker_id = 2 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72238 | 65564 | DPW Maintained 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.369882282876 | (37.8103949467147, -122.369882282876) | 2 | 9 | 62 | 37 | ||||
174692 | 65563 | DPW Maintained 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.369041103471 | (37.8103107984086, -122.369041103471) | 2 | 9 | 62 | 37 | ||||
33524 | 65565 | DPW Maintained 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | 2 | 9 | 62 | 37 | ||||
57815 | 65566 | Permitted Site 7 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | 2 | 9 | 62 | 37 | ||||
13244 | 135176 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6009043.29382 | 2122602.08116 | 37.8087705715725 | -122.41305277089 | (37.8087705715725, -122.41305277089) | 3 | 1 | 10 | 308 | 23 | |||
137935 | 135174 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6009066.35805 | 2122600.86777 | 37.8087685346166 | -122.412972864314 | (37.8087685346166, -122.412972864314) | 3 | 1 | 10 | 308 | 23 | |||
149013 | 135172 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6009083.40557 | 2122596.81093 | 37.8087583524833 | -122.412913579207 | (37.8087583524833, -122.412913579207) | 3 | 1 | 10 | 308 | 23 | |||
21235 | 135170 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6009098.25007 | 2122594.28253 | 37.8087522433743 | -122.412862026464 | (37.8087522433743, -122.412862026464) | 3 | 1 | 10 | 308 | 23 | |||
151262 | 135168 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6009115.60188 | 2122586.88161 | 37.8087328962651 | -122.41280145172 | (37.8087328962651, -122.41280145172) | 3 | 1 | 10 | 308 | 23 | |||
171062 | 135169 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009098.34948 | 2122580.92994 | 37.8087155861133 | -122.412860737758 | (37.8087155861133, -122.412860737758) | 3 | 1 | 10 | 308 | 23 | |||
44262 | 135175 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009042.10981 | 2122580.59629 | 37.808711513081 | -122.413055348348 | (37.808711513081, -122.413055348348) | 3 | 1 | 10 | 308 | 23 | |||
143801 | 135173 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009065.91093 | 2122578.9974 | 37.8087084590055 | -122.412972864333 | (37.8087084590055, -122.412972864333) | 3 | 1 | 10 | 308 | 23 | |||
139111 | 135171 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6009081.53777 | 2122578.30683 | 37.8087074400539 | -122.412918734125 | (37.8087074400539, -122.412918734125) | 3 | 1 | 10 | 308 | 23 | |||
133844 | 135167 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6009297.39065 | 2122561.16344 | 37.8086724825285 | -122.412170498192 | (37.8086724825285, -122.412170498192) | 3 | 1 | 10 | 308 | 23 | ||||
169670 | 66415 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1991 12:00:00 AM | Permit Number 29546 | 6006760.29248409 | 2122608.12240598 | 37.808658736106 | -122.420954201226 | (37.808658736106, -122.420954201226) | 1 | 1 | 28858 | 32 | |||||
79035 | 135165 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6009319.75047 | 2122555.32253 | 37.8086576994481 | -122.41209270231 | (37.8086576994481, -122.41209270231) | 3 | 1 | 10 | 308 | 23 | ||||
147803 | 135177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009002.92609 | 2122558.40528 | 37.8086483824759 | -122.413189385082 | (37.8086483824759, -122.413189385082) | 3 | 1 | 10 | 308 | 23 | |||
121184 | 135163 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | 3 | 1 | 10 | 308 | 23 | ||||
14516 | 135161 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009360.26763 | 2122546.84411 | 37.8086366930891 | -122.411951881091 | (37.8086366930891, -122.411951881091) | 3 | 1 | 10 | 308 | 23 | ||||
108338 | 135166 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6009296.71843 | 2122542.1924 | 37.8086203551155 | -122.412171482933 | (37.8086203551155, -122.412171482933) | 3 | 1 | 10 | 308 | 23 | |||
152195 | 135178 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008933.56816 | 2122548.59369 | 37.8086175483309 | -122.41342872435 | (37.8086175483309, -122.41342872435) | 3 | 1 | 10 | 308 | 23 | |||
9798 | 135164 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6009318.81698 | 2122537.49043 | 37.8086086846186 | -122.412094671852 | (37.8086086846186, -122.412094671852) | 3 | 1 | 10 | 308 | 23 | |||
166177 | 135162 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6009337.24139 | 2122533.99681 | 37.8086001257557 | -122.41203066169 | (37.8086001257557, -122.41203066169) | 3 | 1 | 10 | 308 | 23 | |||
168501 | 135179 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008885.32028 | 2122540.99865 | 37.8085939851782 | -122.41359516279 | (37.8085939851782, -122.41359516279) | 3 | 1 | 10 | 308 | 23 | |||
81836 | 135157 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009451.25096 | 2122529.40055 | 37.8085939015448 | -122.411635772999 | (37.8085939015448, -122.411635772999) | 3 | 1 | 10 | 308 | 23 | ||||
91865 | 135160 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6009356.48989 | 2122529.06979 | 37.8085876773375 | -122.411963698174 | (37.8085876773375, -122.411963698174) | 3 | 1 | 10 | 308 | 23 | |||
28678 | 135180 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008860.7937 | 2122537.90132 | 37.8085841034484 | -122.413679824982 | (37.8085841034484, -122.413679824982) | 3 | 1 | 10 | 308 | 23 | |||
73089 | 135156 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6009480.72759 | 2122523.69804 | 37.8085798973177 | -122.411533357278 | (37.8085798973177, -122.411533357278) | 3 | 1 | 10 | 308 | 23 | ||||
115662 | 135159 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6009379.72618 | 2122524.34495 | 37.8085760077391 | -122.41188294806 | (37.8085760077391, -122.41188294806) | 3 | 1 | 10 | 308 | 23 | |||
3092 | 261228 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6008836.81707 | 2122534.51599 | 37.8085734617661 | -122.413762563504 | (37.8085734617661, -122.413762563504) | 3 | 1 | 10 | 308 | 23 | ||||
15436 | 261230 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6008836.81707 | 2122534.51599 | 37.8085734617661 | -122.413762563504 | (37.8085734617661, -122.413762563504) | 3 | 1 | 10 | 308 | 23 | ||||
18299 | 261229 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6008836.81707 | 2122534.51599 | 37.8085734617661 | -122.413762563504 | (37.8085734617661, -122.413762563504) | 3 | 1 | 10 | 308 | 23 | ||||
130350 | 135181 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1415 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008836.81707 | 2122534.51599 | 37.8085734617661 | -122.413762563504 | (37.8085734617661, -122.413762563504) | 3 | 1 | 10 | 308 | 23 | |||
31143 | 135158 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6009395.60812 | 2122521.7536 | 37.8085697835351 | -122.411827800712 | (37.8085697835351, -122.411827800712) | 3 | 1 | 10 | 308 | 23 | |||
38514 | 135155 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009496.8532 | 2122519.11823 | 37.8085682268067 | -122.411477226088 | (37.8085682268067, -122.411477226088) | 3 | 1 | 10 | 308 | 23 | ||||
62841 | 131232 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1403 The Embarcadero | 27 | Sidewalk: Curb side : Pot | Tree | Private 2 | 34 | Width 10ft | 6009815.09333 | 2122512.40886 | 37.8085676494355 | -122.410375388423 | (37.8085676494355, -122.410375388423) | 3 | 1 | 10 | 308 | 23 | |||
64174 | 135153 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6009517.81435 | 2122514.43966 | 37.8085565563141 | -122.41140435313 | (37.8085565563141, -122.41140435313) | 3 | 1 | 10 | 308 | 23 | ||||
102118 | 135137 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6009675.17252 | 2122510.18452 | 37.8085536973592 | -122.410859468299 | (37.8085536973592, -122.410859468299) | 3 | 1 | 10 | 308 | 23 | ||||
148565 | 135151 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6009534.78747 | 2122509.55925 | 37.8085441079032 | -122.411345267671 | (37.8085441079032, -122.411345267671) | 3 | 1 | 10 | 308 | 23 | ||||
79974 | 135133 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009697.90214 | 2122506.13355 | 37.808543848874 | -122.410780519498 | (37.808543848874, -122.410780519498) | 3 | 1 | 10 | 308 | 23 | |||
81193 | 135149 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009556.32302 | 2122505.15261 | 37.8085332161949 | -122.411270426102 | (37.8085332161949, -122.411270426102) | 3 | 1 | 10 | 308 | 23 | ||||
59597 | 135129 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009719.11313 | 2122501.21683 | 37.8085315380587 | -122.4107067652 | (37.8085315380587, -122.4107067652) | 3 | 1 | 10 | 308 | 23 | |||
174271 | 135147 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009572.95679 | 2122501.76157 | 37.8085248381209 | -122.411212620383 | (37.8085248381209, -122.411212620383) | 3 | 1 | 10 | 308 | 23 | ||||
148183 | 135136 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6009674.61624 | 2122497.64189 | 37.8085192272561 | -122.410860507034 | (37.8085192272561, -122.410860507034) | 3 | 1 | 10 | 308 | 23 | ||||
132033 | 135154 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1413 The Embarcadero | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6009495.3394 | 2122500.73102 | 37.8085176552447 | -122.41148116512 | (37.8085176552447, -122.41148116512) | 3 | 1 | 10 | 308 | 23 | |||
182652 | 135145 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | 3 | 1 | 10 | 308 | 23 | ||||
89379 | 135127 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009796.65177 | 2122491.2642 | 37.8085085577008 | -122.410437716824 | (37.8085085577008, -122.410437716824) | 3 | 1 | 10 | 308 | 23 | |||
112722 | 135152 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6009514.30378 | 2122495.80991 | 37.808505206806 | -122.411415185469 | (37.808505206806, -122.411415185469) | 3 | 1 | 10 | 308 | 23 | |||
176066 | 135125 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009814.02361 | 2122489.41499 | 37.8085044540716 | -122.410377465851 | (37.8085044540716, -122.410377465851) | 3 | 1 | 10 | 308 | 23 | |||
98769 | 135143 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009614.4871 | 2122492.89174 | 37.8085028128125 | -122.411068265698 | (37.8085028128125, -122.411068265698) | 3 | 1 | 10 | 308 | 23 | ||||
153021 | 135132 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009696.09091 | 2122490.92652 | 37.8085019926339 | -122.410785713093 | (37.8085019926339, -122.410785713093) | 3 | 1 | 10 | 308 | 23 | |||
107400 | 135150 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6009533.57548 | 2122492.01614 | 37.8084958709589 | -122.411348221963 | (37.8084958709589, -122.411348221963) | 3 | 1 | 10 | 308 | 23 | |||
115460 | 135141 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6009636.62254 | 2122489.1519 | 37.8084937854328 | -122.410991395247 | (37.8084937854328, -122.410991395247) | 3 | 1 | 10 | 308 | 23 | ||||
70982 | 135148 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6009553.89624 | 2122488.10727 | 37.8084862778736 | -122.411277619761 | (37.8084862778736, -122.411277619761) | 3 | 1 | 10 | 308 | 23 | |||
163913 | 135139 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6009651.5635 | 2122485.85771 | 37.8084855782253 | -122.410939454894 | (37.8084855782253, -122.410939454894) | 3 | 1 | 10 | 308 | 23 | ||||
56858 | 135128 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 7ft | 6009778.15443 | 2122482.07693 | 37.8084822947981 | -122.410501083081 | (37.8084822947981, -122.410501083081) | 3 | 1 | 10 | 308 | 23 | |||
103186 | 135146 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6009571.76938 | 2122485.2677 | 37.8084794835077 | -122.411215563861 | (37.8084794835077, -122.411215563861) | 3 | 1 | 10 | 308 | 23 | |||
159384 | 135126 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 28 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6009794.33207 | 2122480.55113 | 37.8084790122577 | -122.410444987853 | (37.8084790122577, -122.410444987853) | 3 | 1 | 10 | 308 | 23 | |||
61438 | 107905 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2650 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008717 | 2122501 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | 3 | 1 | 10 | 308 | 23 | ||||
88031 | 107908 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2650 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122501 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | 3 | 1 | 10 | 308 | 23 | |||||
147498 | 107906 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2650 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122501 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | 3 | 1 | 10 | 308 | 23 | |||||
175877 | 107907 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2650 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122501 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | 3 | 1 | 10 | 308 | 23 | |||||
5415 | 135124 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6009811.99757 | 2122478.3969 | 37.8084740875856 | -122.410383699057 | (37.8084740875856, -122.410383699057) | 3 | 1 | 10 | 308 | 23 | |||
116038 | 135135 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009673.36232 | 2122480.3312 | 37.8084716261397 | -122.410863623176 | (37.8084716261397, -122.410863623176) | 3 | 1 | 10 | 308 | 23 | |||
27006 | 135144 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 The Embarcadero | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6009592.59224 | 2122479.55439 | 37.8084649639619 | -122.411143096484 | (37.8084649639619, -122.411143096484) | 3 | 1 | 10 | 308 | 23 | |||
115331 | 135131 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009694.30992 | 2122477.21308 | 37.8084642391119 | -122.410790907582 | (37.8084642391119, -122.410790907582) | 3 | 1 | 10 | 308 | 23 | |||
151614 | 135142 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6009611.73281 | 2122475.6117 | 37.8084552117099 | -122.411076576336 | (37.8084552117099, -122.411076576336) | 3 | 1 | 10 | 308 | 23 | |||
5770 | 135182 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008631.75152 | 2122495.19515 | 37.8084539787355 | -122.414469468391 | (37.8084539787355, -122.414469468391) | 3 | 1 | 10 | 308 | 23 | |||
60022 | 135140 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6009635.03806 | 2122470.3531 | 37.8084420798001 | -122.410995550124 | (37.8084420798001, -122.410995550124) | 3 | 1 | 10 | 308 | 23 | |||
56650 | 135183 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008602.26751 | 2122490.00271 | 37.8084380652267 | -122.414571138551 | (37.8084380652267, -122.414571138551) | 3 | 1 | 10 | 308 | 23 | |||
181757 | 135138 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6009649.70927 | 2122468.55895 | 37.8084379762014 | -122.410944649373 | (37.8084379762014, -122.410944649373) | 3 | 1 | 10 | 308 | 23 | |||
22335 | 135123 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009926.6128 | 2122461.41087 | 37.8084338726024 | -122.409985839882 | (37.8084338726024, -122.409985839882) | 3 | 1 | 10 | 308 | 23 | |||
79975 | 135134 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009670.63247 | 2122464.24581 | 37.8084273066306 | -122.410871933791 | (37.8084273066306, -122.410871933791) | 3 | 1 | 10 | 308 | 23 | |||
187498 | 135184 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008568.3734 | 2122486.00433 | 37.8084251824404 | -122.414688155629 | (37.8084251824404, -122.414688155629) | 3 | 1 | 10 | 308 | 23 | |||
165221 | 135121 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009946.94212 | 2122457.40911 | 37.8084240241286 | -122.40991520173 | (37.8084240241286, -122.40991520173) | 3 | 1 | 10 | 308 | 23 | |||
127481 | 135130 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1405 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6009691.87426 | 2122460.8233 | 37.8084191003246 | -122.410798178599 | (37.8084191003246, -122.410798178599) | 3 | 1 | 10 | 308 | 23 | |||
153822 | 135118 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009967.89586 | 2122454.59011 | 37.8084174581688 | -122.409842486156 | (37.8084174581688, -122.409842486156) | 3 | 1 | 10 | 308 | 23 | |||
183800 | 135115 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009986.16168 | 2122452.42406 | 37.8084125343708 | -122.409779119036 | (37.8084125343708, -122.409779119036) | 3 | 1 | 10 | 308 | 23 | |||
138782 | 135185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008537.7982 | 2122481.66229 | 37.8084115424152 | -122.4147936623 | (37.8084115424152, -122.4147936623) | 3 | 1 | 10 | 308 | 23 | |||
109666 | 85055 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 77X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2007 12:00:00 AM | Permit Number 49393 | 6008831 | 2122475 | 37.8084097192397 | -122.413778482528 | (37.8084097192397, -122.413778482528) | 3 | 1 | 10 | 308 | 23 | |||
101634 | 135098 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401 The Embarcadero | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6010217.76574 | 2122446.50226 | 37.808409250946 | -122.408977168373 | (37.808409250946, -122.408977168373) | 1 | 10 | 308 | 23 | |||||
96491 | 135113 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6010004.11504 | 2122449.66633 | 37.8084059684239 | -122.40971679149 | (37.8084059684239, -122.40971679149) | 3 | 1 | 10 | 308 | 23 | |||
140887 | 135122 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009935.99448 | 2122450.45895 | 37.8084043271757 | -122.409952598229 | (37.8084043271757, -122.409952598229) | 3 | 1 | 10 | 308 | 23 | |||
67984 | 135186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008499.16063 | 2122476.10539 | 37.8083941135688 | -122.414926985002 | (37.8083941135688, -122.414926985002) | 3 | 1 | 10 | 308 | 23 | |||
123966 | 135120 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009955.71768 | 2122446.17053 | 37.8083936576166 | -122.409884037512 | (37.8083936576166, -122.409884037512) | 3 | 1 | 10 | 308 | 23 | |||
133961 | 135110 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010045.12861 | 2122444.34572 | 37.808393657599 | -122.409574476475 | (37.808393657599, -122.409574476475) | 3 | 1 | 10 | 308 | 23 | |||
89617 | 135117 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009974.57717 | 2122443.69332 | 37.8083879127434 | -122.409818593865 | (37.8083879127434, -122.409818593865) | 3 | 1 | 10 | 308 | 23 | |||
144013 | 135107 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010064.28228 | 2122441.56354 | 37.8083870916662 | -122.40950799322 | (37.8083870916662, -122.40950799322) | 3 | 1 | 10 | 308 | 23 | |||
73761 | 135187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008466.65712 | 2122472.35446 | 37.8083819880082 | -122.415039206912 | (37.8083819880082, -122.415039206912) | 3 | 1 | 10 | 308 | 23 | |||
187815 | 135112 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010033.25655 | 2122436.21857 | 37.8083706772342 | -122.409614989141 | (37.8083706772342, -122.409614989141) | 3 | 1 | 10 | 308 | 23 | |||
158698 | 134958 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2571 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009185.01162 | 2122452.80097 | 37.8083686402722 | -122.412551754077 | (37.8083686402722, -122.412551754077) | 3 | 1 | 10 | 308 | 23 | |||
51101 | 135097 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6010211.16016 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | 3 | 1 | 10 | 308 | 23 | ||||
89810 | 135109 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010051.49773 | 2122432.85725 | 37.808362470021 | -122.409551622933 | (37.808362470021, -122.409551622933) | 3 | 1 | 10 | 308 | 23 | |||
53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
78816 | 84934 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||
99636 | 84933 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
102582 | 84932 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||||
177174 | 135188 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008435.19986 | 2122465.54658 | 37.8083615275283 | -122.415147591413 | (37.8083615275283, -122.415147591413) | 3 | 1 | 10 | 308 | 23 | |||
77891 | 135104 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1403 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010089.2658 | 2122430.29329 | 37.8083575462248 | -122.409420734681 | (37.8083575462248, -122.409420734681) | 3 | 1 | 10 | 308 | 23 | |||
176780 | 135189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Jefferson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008412.99212 | 2122463.79322 | 37.8083554652029 | -122.415224323337 | (37.8083554652029, -122.415224323337) | 3 | 1 | 10 | 308 | 23 |
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) );