Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184420 | 184420 | 201549 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6020789.549380001 | 2093251.9329799998 | 37.728833562500206 | -122.370370588629 | (37.7288335625002, -122.370370588629) | |||
156960 | 156960 | 201545 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6020633.70615 | 2093371.77747 | 37.729154078192394 | -122.37091763995701 | (37.7291540781924, -122.370917639957) | ||||
65523 | 65523 | 201544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 601 Innes Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6020625.625519999 | 2093377.92947 | 37.7291705267859 | -122.370946000964 | (37.7291705267859, -122.370946000964) | ||||
76765 | 76765 | 201543 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6020620.74495 | 2093375.17595 | 37.72916269819 | -122.370962683378 | (37.72916269819, -122.370962683378) | ||||
184047 | 184047 | 201550 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020135.10106 | 2093474.49697 | 37.7294087400981 | -122.372648486831 | (37.7294087400981, -122.372648486831) | ||||
57763 | 57763 | 201551 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020116.66531 | 2093486.6381700002 | 37.7294410644355 | -122.37271306177901 | (37.7294410644355, -122.372713061779) | ||||
45320 | 45320 | 201553 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6019956.36355 | 2093604.98051 | 37.72975719952 | -122.373275437534 | (37.72975719952, -122.373275437534) | ||||
47244 | 47244 | 201554 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 6019933.4891099995 | 2093619.80077 | 37.729796635696296 | -122.373355543719 | (37.7297966356963, -122.373355543719) | ||||
72337 | 72337 | 201555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6019901.03231 | 2093652.00045 | 37.7298832655955 | -122.373469980666 | (37.7298832655955, -122.373469980666) | ||||
173224 | 173224 | 201556 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6019865.267469999 | 2093672.4938299998 | 37.729937570248 | -122.37359504397101 | (37.729937570248, -122.373595043971) | ||||
146878 | 146878 | 201557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 9ft | 6019843.77362 | 2093685.4029299999 | 37.7299718344327 | -122.373670245296 | (37.7299718344327, -122.373670245296) | |||
150959 | 150959 | 201558 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6019824.624340001 | 2093697.32313 | 37.7300035121512 | -122.37373727266899 | (37.7300035121512, -122.373737272669) | |||
68526 | 68526 | 201560 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6019794.81537 | 2093720.05192 | 37.7300642820202 | -122.373841900702 | (37.7300642820202, -122.373841900702) | |||
54120 | 54120 | 201561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Jerrold Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6019745.83299 | 2093765.2966200002 | 37.730185821819795 | -122.374014373583 | (37.7301858218198, -122.374014373583) | |||
43046 | 43046 | 201567 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6019712.532430001 | 2093705.4483299998 | 37.730019658579295 | -122.37412535530899 | (37.7300196585793, -122.374125355309) | |||
178131 | 178131 | 201566 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6019697.16467 | 2093717.76615 | 37.7300526357971 | -122.374179337111 | (37.7300526357971, -122.374179337111) | ||||
153819 | 153819 | 201565 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6019673.98228 | 2093813.8250099998 | 37.730315120044295 | -122.374266134286 | (37.7303151200443, -122.374266134286) | ||||
166299 | 166299 | 192724 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 900 Kirkwood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6019533.42418 | 2093575.80573 | 37.729653833243 | -122.37473558218001 | (37.729653833243, -122.37473558218) | |||
137993 | 137993 | 187765 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | ||||
46008 | 46008 | 187764 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6019412.692980001 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | ||||
32440 | 32440 | 197209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6019354.09765 | 2093629.3399099999 | 37.729790960977205 | -122.375359249432 | (37.7297909609772, -122.375359249432) | ||||
173760 | 173760 | 197208 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6019334.40687 | 2093641.6466599999 | 37.7298236693276 | -122.375428176194 | (37.7298236693276, -122.375428176194) | ||||
55829 | 55829 | 197207 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6019325.738419999 | 2093646.8502 | 37.729837480194796 | -122.375458504919 | (37.7298374801948, -122.375458504919) | ||||
41414 | 41414 | 197206 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6019299.00025 | 2093665.65157 | 37.729887633603504 | -122.37555224573799 | (37.7298876336035, -122.375552245738) | ||||
156925 | 156925 | 197205 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6019275.32859 | 2093678.30312 | 37.729921069492505 | -122.375634959101 | (37.7299210694925, -122.375634959101) | ||||
138131 | 138131 | 201517 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.37621683574699 | (37.7321368236424, -122.376216835747) | |||
31479 | 31479 | 195925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018989.61551 | 2093779.2666099998 | 37.7301825662676 | -122.376629714494 | (37.7301825662676, -122.376629714494) | ||||
70829 | 70829 | 187762 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Reardon Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6018971.39793 | 2093438.5075400001 | 37.72924590436129 | -122.37666906882099 | (37.7292459043613, -122.376669068821) | ||||
75816 | 75816 | 187763 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Reardon Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6018954.68397 | 2093453.67115 | 37.7292866202724 | -122.376727902495 | (37.7292866202724, -122.376727902495) | ||||
35550 | 35550 | 201645 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6018982.720369999 | 2095633.61521 | 37.7352738675975 | -122.37678213339301 | (37.7352738675975, -122.376782133393) | |||
178651 | 178651 | 201636 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6018955.1601 | 2095613.4067900002 | 37.735216861374 | -122.376876019021 | (37.735216861374, -122.376876019021) | |||
188467 | 188467 | 201641 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6018954.75158 | 2095601.04105 | 37.7351828849697 | -122.376876573893 | (37.7351828849697, -122.376876573893) | |||
160498 | 160498 | 201643 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018953.750080001 | 2095594.20439 | 37.735164057679704 | -122.376879562369 | (37.7351640576797, -122.376879562369) | |||
136273 | 136273 | 201639 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6018953.99087 | 2095608.77642 | 37.7352040828873 | -122.376879740411 | (37.7352040828873, -122.376879740411) | |||
64968 | 64968 | 201640 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6018953.49192 | 2095604.5204099999 | 37.7351923692359 | -122.376881170334 | (37.7351923692359, -122.376881170334) | |||
62691 | 62691 | 201647 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018952.706230001 | 2095578.53847 | 37.735120984634705 | -122.376882084965 | (37.7351209846347, -122.376882084965) | |||
28462 | 28462 | 201642 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6018952.658430001 | 2095598.17526 | 37.735174900789396 | -122.37688361201599 | (37.7351749007894, -122.376883612016) | |||
27946 | 27946 | 201649 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6018951.64564 | 2095587.01417 | 37.735144198837794 | -122.37688633962799 | (37.7351441988378, -122.376886339628) | |||
183540 | 183540 | 201644 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6018951.31321 | 2095591.04744 | 37.7351552551001 | -122.376887768675 | (37.7351552551001, -122.376887768675) | |||
77023 | 77023 | 201648 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6018950.3933 | 2095564.6244 | 37.735082651931705 | -122.37688911676202 | (37.7350826519317, -122.376889116762) | |||
147319 | 147319 | 201646 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018949.93188 | 2095582.2358799998 | 37.7351309842009 | -122.37689193341299 | (37.7351309842009, -122.376891933413) | |||
34892 | 34892 | 201651 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6018949.0123 | 2095555.4014599998 | 37.7350572514812 | -122.376893251826 | (37.7350572514812, -122.376893251826) | |||
64633 | 64633 | 201650 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018947.62701 | 2095560.29465 | 37.7350706109287 | -122.37689838066099 | (37.7350706109287, -122.376898380661) | |||
57002 | 57002 | 201637 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6018946.919840001 | 2095539.74446 | 37.7350141451746 | -122.376899400488 | (37.7350141451746, -122.376899400488) | |||
33423 | 33423 | 201652 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018946.92095 | 2095551.1859 | 37.735045561194205 | -122.376900190105 | (37.7350455611942, -122.376900190105) | |||
134546 | 134546 | 201653 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6018946.1342400005 | 2095546.77058 | 37.7350333942595 | -122.376902603873 | (37.7350333942595, -122.376902603873) | |||
38569 | 38569 | 201638 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6018923.171519999 | 2095473.9331900002 | 37.734832132296205 | -122.37697694364401 | (37.7348321322962, -122.376976943644) | |||
70116 | 70116 | 201489 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 404 Hawes St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018812.86035 | 2095041.8046099998 | 37.733639515247795 | -122.37732835733 | (37.7336395152478, -122.37732835733) | ||||
23516 | 23516 | 201490 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 404 Hawes St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018801.89872 | 2095027.62617 | 37.7335999801502 | -122.37736527181299 | (37.7335999801502, -122.377365271813) | ||||
70241 | 70241 | 201491 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 410 Hawes St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018753.58694 | 2094959.0414599997 | 37.7334089983181 | -122.377527543687 | (37.7334089983181, -122.377527543687) | ||||
185732 | 185732 | 201492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 410 Hawes St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018741.78505 | 2094936.2414099998 | 37.7333457436025 | -122.37756676489401 | (37.7333457436025, -122.377566764894) | ||||
59424 | 59424 | 201493 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 410 Hawes St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6018736.96879 | 2094929.02833 | 37.7333256725358 | -122.37758291583499 | (37.7333256725358, -122.377582915835) | ||||
152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
160827 | 160827 | 201494 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 410 Hawes St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018722.258219999 | 2094905.4003700002 | 37.7332599842609 | -122.377632135729 | (37.7332599842609, -122.377632135729) | ||||
153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
179878 | 179878 | 201515 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 1001 Innes Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6018702.03341 | 2094815.0321 | 37.733010736257704 | -122.37769578973 | (37.7330107362577, -122.37769578973) | |||
132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
181426 | 181426 | 201513 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018634.55292 | 2094871.3359599998 | 37.7331616173072 | -122.377932996723 | (37.7331616173072, -122.377932996723) | |||
166097 | 166097 | 201509 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018596.778580001 | 2094899.20439 | 37.73323605689679 | -122.378065528029 | (37.7332360568968, -122.378065528029) | |||
38646 | 38646 | 201508 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018593.65925 | 2094901.94124 | 37.7332433998449 | -122.378076502435 | (37.7332433998449, -122.378076502435) | |||
153857 | 153857 | 201507 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018590.61876 | 2094904.2906900002 | 37.733249683412296 | -122.37808717738599 | (37.7332496834123, -122.378087177386) | |||
88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
70787 | 70787 | 201506 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018588.36983 | 2094906.5368 | 37.7332557268509 | -122.378095108499 | (37.7332557268509, -122.378095108499) | |||
180204 | 180204 | 201503 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 1001 Innes Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018539.45605 | 2094929.8909099998 | 37.7333171568604 | -122.378265839401 | (37.7333171568604, -122.378265839401) | ||||
36188 | 36188 | 201372 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6018490.42115 | 2095382.8253 | 37.734558123266204 | -122.378466804612 | (37.7345581232662, -122.378466804612) | ||||
56931 | 56931 | 188677 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6018476.48235 | 2096364.95743 | 37.7372540964924 | -122.37858316699499 | (37.7372540964924, -122.378583166995) | |||
63519 | 63519 | 187749 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6018386.6897599995 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | ||||
181853 | 181853 | 201499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6018416.79538 | 2095102.4725900001 | 37.7337842710237 | -122.37870189547701 | (37.7337842710237, -122.378701895477) | ||||
143125 | 143125 | 201373 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018334.732369999 | 2095383.1099099999 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | ||||
49471 | 49471 | 201375 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6018327.36542 | 2095666.8943900003 | 37.7353291318294 | -122.379050271262 | (37.7353291318294, -122.379050271262) | ||||
159053 | 159053 | 201374 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Hare St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6018319.37911 | 2095383.7784900002 | 37.7345513108793 | -122.37905822666 | (37.7345513108793, -122.37905822666) | ||||
125555 | 125555 | 198253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6018226.96048 | 2093133.1999700002 | 37.728366565251605 | -122.3792214842 | (37.7283665652516, -122.3792214842) | ||||
181959 | 181959 | 201376 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6018269.69343 | 2095669.23069 | 37.7353323666994 | -122.379249829039 | (37.7353323666994, -122.379249829039) | |||
153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
33152 | 33152 | 187750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018189.80767 | 2093163.42935 | 37.728447520437705 | -122.379352023493 | (37.7284475204377, -122.379352023493) | ||||
134949 | 134949 | 194519 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1108 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6018142.03115 | 2092982.0233 | 37.7279467796967 | -122.379504594361 | (37.7279467796967, -122.379504594361) | |||
187072 | 187072 | 187751 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6018129.3732900005 | 2093209.5083299999 | 37.7285707113551 | -122.379564150189 | (37.7285707113551, -122.379564150189) | ||||
182989 | 182989 | 187753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018088.91826 | 2093246.2132 | 37.72866926445229 | -122.37970655600901 | (37.7286692644523, -122.379706556009) | ||||
171668 | 171668 | 191989 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6018085.22941 | 2093254.8331099998 | 37.72869272957939 | -122.379719907353 | (37.7286927295794, -122.379719907353) | ||||
168868 | 168868 | 187752 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6018083.616719999 | 2093238.62842 | 37.7286481456935 | -122.379724357202 | (37.7286481456935, -122.379724357202) | ||||
74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
53137 | 53137 | 191990 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6018074.25782 | 2093264.02641 | 37.7287173674097 | -122.379758475681 | (37.7287173674097, -122.379758475681) | ||||
169436 | 169436 | 188282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | |||
154696 | 154696 | 191991 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6018056.783869999 | 2093269.9322799998 | 37.728732619904 | -122.37981929503 | (37.728732619904, -122.37981929503) | ||||
170575 | 170575 | 191992 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6018050.15302 | 2093281.6022599998 | 37.7287642976303 | -122.37984302904499 | (37.7287642976303, -122.379843029045) | ||||
24305 | 24305 | 187754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.37985934635799 | (37.728760777668, -122.379859346358) | ||||
30738 | 30738 | 187755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | ||||
64021 | 64021 | 187756 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6018040.44211 | 2093268.12413 | 37.728726753622496 | -122.379875664545 | (37.7287267536225, -122.379875664545) | ||||
37873 | 37873 | 195921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6018012.35548 | 2092964.6692 | 37.72789197591621 | -122.379951686024 | (37.7278919759162, -122.379951686024) | |||
73037 | 73037 | 188218 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 Rosie Lee Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6018038.291119999 | 2094428.2288 | 37.7319120561012 | -122.379963677596 | (37.7319120561012, -122.379963677596) | |||
73253 | 73253 | 195922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6017988.36084 | 2092981.7840200001 | 37.7279376461829 | -122.38003582571899 | (37.7279376461829, -122.380035825719) | |||
69737 | 69737 | 194499 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Evans Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6018054.76691 | 2096792.7027 | 37.7384053438433 | -122.38007096131201 | (37.7384053438433, -122.380070961312) | ||||
179577 | 179577 | 188427 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 15 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6017957.00667 | 2093516.4296900001 | 37.729403949426796 | -122.380181357598 | (37.7294039494268, -122.380181357598) | |||
164669 | 164669 | 195920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 Baldwin Ct | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6017944.92051 | 2093525.0251099998 | 37.7294268839465 | -122.38022373813101 | (37.7294268839465, -122.380223738131) | |||
133193 | 133193 | 195923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6017931.94783 | 2093024.26142 | 37.7280511685158 | -122.380233799755 | (37.7280511685158, -122.380233799755) | |||
72368 | 72368 | 195924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6017916.47309 | 2093037.8784299998 | 37.728087704366395 | -122.380288242927 | (37.7280877043664, -122.380288242927) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
156153 | 156153 | 187757 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6017577.45499 | 2093289.4287599998 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | ||||
133165 | 133165 | 187758 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.38153877989299 | (37.7287884075452, -122.381538779893) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");