Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
82512 | 82512 | 176641 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 89 Belle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5991622.07464 | 2086489.1085299999 | 37.708620512601705 | -122.47071121118 | (37.7086205126017, -122.47071121118) | |||
145739 | 145739 | 176592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2249 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5996118.04902 | 2086754.98706 | 37.70960952494271 | -122.455191839948 | (37.7096095249427, -122.455191839948) | |||
76107 | 76107 | 187484 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 701 Velasco Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6006683.55132 | 2086560.9884900001 | 37.7096773634854 | -122.418661795732 | (37.7096773634854, -122.418661795732) | |||
92201 | 92201 | 176628 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3067 Alemany Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5996456.31752 | 2087068.2457400002 | 37.7104890628041 | -122.454045341035 | (37.7104890628041, -122.454045341035) | |||
60393 | 60393 | 176642 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993005.954030001 | 2087230.75027 | 37.7107368152174 | -122.465982240383 | (37.7107368152174, -122.465982240383) | |||
130769 | 130769 | 176644 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992981.09091 | 2087231.27267 | 37.7107368152211 | -122.466068210177 | (37.7107368152211, -122.466068210177) | |||
153643 | 153643 | 176643 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992994.85836 | 2087232.28697 | 37.7107403945151 | -122.46602070080401 | (37.7107403945151, -122.466020700804) | |||
72240 | 72240 | 176634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 600 Blanken Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6013132.57563 | 2086873.0357 | 37.7108951651419 | -122.396394525203 | (37.7108951651419, -122.396394525203) | |||
177708 | 177708 | 176591 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 170 Lawrence Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.41137 | 2087266.2974900003 | 37.711053623008 | -122.45280815898501 | (37.711053623008, -122.452808158985) | |||
66575 | 66575 | 176855 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002700.83355 | 2087431.53609 | 37.711842660275394 | -122.43248890094499 | (37.7118426602754, -122.432488900945) | |||
61753 | 61753 | 176856 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002702.07598 | 2087433.5886 | 37.7118483664744 | -122.43248475327499 | (37.7118483664744, -122.432484753275) | |||
157915 | 157915 | 176857 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002703.472569999 | 2087435.53377 | 37.711853786683 | -122.432480065122 | (37.711853786683, -122.432480065122) | |||
176436 | 176436 | 176858 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002704.995180001 | 2087438.5155900002 | 37.711862060452205 | -122.432475015405 | (37.7118620604522, -122.432475015405) | |||
47827 | 47827 | 176859 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002706.29177 | 2087440.6711400002 | 37.7118680526473 | -122.432470687896 | (37.7118680526473, -122.432470687896) | |||
52511 | 52511 | 176860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002707.3669 | 2087442.2073099997 | 37.711872331601704 | -122.432467081601 | (37.7118723316017, -122.432467081601) | |||
149485 | 149485 | 176861 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002708.23559 | 2087443.8519099997 | 37.7118768965747 | -122.43246419656 | (37.7118768965747, -122.43246419656) | |||
185500 | 185500 | 176862 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002709.09569 | 2087445.08105 | 37.711880320298 | -122.43246131155199 | (37.711880320298, -122.432461311552) | |||
161312 | 161312 | 176863 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002709.8582 | 2087446.62401 | 37.7118846001685 | -122.43245878624201 | (37.7118846001685, -122.432458786242) | |||
39238 | 39238 | 176826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 635 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002712.89216 | 2087452.0684200001 | 37.711899721374 | -122.432448688654 | (37.711899721374, -122.432448688654) | |||
149343 | 149343 | 176640 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Payson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5991761.59345 | 2087760.80597 | 37.7121203547524 | -122.47032156819401 | (37.7121203547524, -122.470321568194) | |||
60604 | 60604 | 176825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 23 Seville St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002184.50257 | 2087581.6181299998 | 37.7122254594191 | -122.434284204968 | (37.7122254594191, -122.434284204968) | |||
25117 | 25117 | 219340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5993976.2548 | 2087899.9330400003 | 37.7126301615391 | -122.462677198595 | (37.7126301615391, -122.462677198595) | |||
46662 | 46662 | 219339 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5993976.06053 | 2087910.0728799999 | 37.712657991947 | -122.46267860514999 | (37.712657991947, -122.46267860515) | |||
130317 | 130317 | 219338 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5993976.25604 | 2087919.3939099999 | 37.7126835965453 | -122.462678605151 | (37.7126835965453, -122.462678605151) | |||
52462 | 52462 | 219337 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 5993976.47705 | 2087929.93053 | 37.712712540334 | -122.462678605144 | (37.712712540334, -122.462678605144) | |||
167871 | 167871 | 219336 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5993977.06233 | 2087938.43241 | 37.7127359181885 | -122.462677198601 | (37.7127359181885, -122.462677198601) | |||
183956 | 183956 | 176627 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5998745.61831 | 2087840.43325 | 37.712740316791795 | -122.44618856505699 | (37.7127403167918, -122.446188565057) | |||
57570 | 57570 | 176626 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5998755.95892 | 2087850.85961 | 37.712769535747206 | -122.446153574254 | (37.7127695357472, -122.446153574254) | |||
125302 | 125302 | 176625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5998763.992880001 | 2087858.5335799998 | 37.712791065527796 | -122.446126358062 | (37.7127910655278, -122.446126358062) | |||
183779 | 183779 | 176633 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000954.59421 | 2087879.4605599998 | 37.7129733823892 | -122.43855644963399 | (37.7129733823892, -122.438556449634) | |||
130697 | 130697 | 176632 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.713012287961604 | -122.43857351247499 | (37.7130122879616, -122.438573512475) | |||
148159 | 148159 | 176631 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000945.59643 | 2087907.6965599998 | 37.7130504003174 | -122.438589570763 | (37.7130504003174, -122.438589570763) | |||
68329 | 68329 | 176623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5999086.11922 | 2088154.6418400002 | 37.713622502239794 | -122.445034263618 | (37.7136225022398, -122.445034263618) | |||
181201 | 181201 | 219362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992423.9143900005 | 2088481.1554 | 37.7141365322476 | -122.468084780709 | (37.7141365322476, -122.468084780709) | |||
184432 | 184432 | 219244 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4 Farallones St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5996960.480830001 | 2088401.3270400001 | 37.7141782922784 | -122.452398988125 | (37.7141782922784, -122.452398988125) | |||
32661 | 32661 | 176624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Foote Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998633.901980001 | 2088379.60151 | 37.714214369464 | -122.446613458762 | (37.714214369464, -122.446613458762) | |||
164120 | 164120 | 176827 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1791 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5997883.80423 | 2088433.1189700002 | 37.7143184408223 | -122.44920992919799 | (37.7143184408223, -122.449209929198) | |||
27887 | 27887 | 176613 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5998491.328480001 | 2088788.6230099997 | 37.7153293039925 | -122.447135664507 | (37.7153293039925, -122.447135664507) | |||
168891 | 168891 | 176612 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 275 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5998463.137019999 | 2088828.41793 | 37.715436960924 | -122.44723596859 | (37.715436960924, -122.44723596859) | |||
162215 | 162215 | 176611 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 275 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5998451.26815 | 2088839.7013700001 | 37.7154672644752 | -122.447277804138 | (37.7154672644752, -122.447277804138) | |||
175687 | 175687 | 176609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1659 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5998355.24802 | 2088872.09815 | 37.7155507314505 | -122.447612021886 | (37.7155507314505, -122.447612021886) | |||
161661 | 161661 | 176610 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1659 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998366.15646 | 2088880.1893799999 | 37.7155735715352 | -122.447574899658 | (37.7155735715352, -122.447574899658) | |||
134236 | 134236 | 176680 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5998334.393730001 | 2088961.07404 | 37.715793846985996 | -122.44769050482701 | (37.715793846986, -122.447690504827) | |||
175110 | 175110 | 219346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5991911.85592 | 2089125.7971700002 | 37.7158769767191 | -122.46990154251999 | (37.7158769767191, -122.46990154252) | |||
75947 | 75947 | 219345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5991911.8899300005 | 2089150.8332900002 | 37.7159457217874 | -122.469903246754 | (37.7159457217874, -122.469903246754) | |||
28406 | 28406 | 219344 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991912.69269 | 2089165.54418 | 37.71598616072 | -122.469901542523 | (37.71598616072, -122.469901542523) | |||
68468 | 68468 | 219360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5993732.0948 | 2089263.8820200001 | 37.7163611752992 | -122.46362001454901 | (37.7163611752992, -122.463620014549) | |||
180880 | 180880 | 219359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5993732.18416 | 2089268.1403400002 | 37.7163728727759 | -122.46362001455601 | (37.7163728727759, -122.463620014556) | |||
48887 | 48887 | 219358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5993732.273519999 | 2089272.39867 | 37.71638457028 | -122.463620014563 | (37.71638457028, -122.463620014563) | |||
36980 | 36980 | 219357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5993732.37033 | 2089277.01188 | 37.7163972426289 | -122.463620014561 | (37.7163972426289, -122.463620014561) | |||
181470 | 181470 | 219356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5993733.55118 | 2089282.3121 | 37.7164118638057 | -122.46361631744699 | (37.7164118638057, -122.463616317447) | |||
165769 | 165769 | 176683 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5999409.94736 | 2089269.75185 | 37.7167028187559 | -122.443995073633 | (37.7167028187559, -122.443995073633) | |||
62081 | 62081 | 176614 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1531 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5998790.48593 | 2089284.65203 | 37.7167083747673 | -122.44613730731301 | (37.7167083747673, -122.446137307313) | |||
61598 | 61598 | 176615 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 73 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5999173.59476 | 2089300.0418599998 | 37.716772502713596 | -122.44481420042801 | (37.7167725027136, -122.444814200428) | |||
43812 | 43812 | 176599 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998280.541680001 | 2089346.8494799999 | 37.716850019794606 | -122.44790439957899 | (37.7168500197946, -122.447904399579) | |||
151929 | 151929 | 219350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993263.513069999 | 2089526.9590200002 | 37.717056510421 | -122.465258746617 | (37.717056510421, -122.465258746617) | |||
49144 | 49144 | 219352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993266.488919999 | 2089531.0532200001 | 37.71706792372179 | -122.465248757836 | (37.7170679237218, -122.465248757836) | |||
44302 | 44302 | 219351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993263.35325 | 2089534.6361099998 | 37.7170775806463 | -122.46525985636002 | (37.7170775806463, -122.46525985636) | |||
152831 | 152831 | 176834 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1457 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5999029.42353 | 2089515.22336 | 37.7173551132383 | -122.445327990315 | (37.7173551132383, -122.445327990315) | |||
72856 | 72856 | 219335 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 261 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5994423.037830001 | 2089616.126 | 37.7173681417119 | -122.461257314797 | (37.7173681417119, -122.461257314797) | |||
182517 | 182517 | 190822 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 13 Jennings Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6012854.0546699995 | 2089293.52608 | 37.7175258486306 | -122.397526813914 | (37.7175258486306, -122.397526813914) | |||
163530 | 163530 | 190821 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 13 Jennings Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6012858.0659300005 | 2089298.3166900002 | 37.7175392260401 | -122.39751328452499 | (37.7175392260401, -122.397513284525) | |||
147731 | 147731 | 219334 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 800 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5995082.86973 | 2089689.0619599998 | 37.717606358621104 | -122.45898187623001 | (37.7176063586211, -122.45898187623) | |||
166819 | 166819 | 176630 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 271 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6004066.09018 | 2089571.2619999999 | 37.7177952090644 | -122.427922568075 | (37.7177952090644, -122.427922568075) | |||
161516 | 161516 | 219361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 606 Shields St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 5992405.16075 | 2089868.2609299999 | 37.717944105311 | -122.468250447523 | (37.717944105311, -122.468250447523) | |||
29711 | 29711 | 218145 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5994144.20993 | 2090116.67038 | 37.7187264660332 | -122.462257368104 | (37.7187264660332, -122.462257368104) | ||||
173591 | 173591 | 219330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | |||
65469 | 65469 | 219343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991924.98252 | 2090428.4017299998 | 37.7194543701096 | -122.469950959395 | (37.7194543701096, -122.469950959395) | |||
188529 | 188529 | 219331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | |||
166707 | 166707 | 219342 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5991925.44739 | 2090450.4823200002 | 37.719515024881794 | -122.469950959366 | (37.7195150248818, -122.469950959366) | |||
24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
32303 | 32303 | 219349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992970.2206 | 2090529.11347 | 37.719791266033 | -122.466345302087 | (37.719791266033, -122.466345302087) | |||
184130 | 184130 | 219353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993539.38524 | 2090524.66713 | 37.7198118820929 | -122.46437759357201 | (37.7198118820929, -122.464377593572) | |||
44537 | 44537 | 219348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5992970.49595 | 2090542.2168 | 37.7198272604875 | -122.466345302117 | (37.7198272604875, -122.466345302117) | |||
67231 | 67231 | 219354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5993538.524669999 | 2090540.93075 | 37.7198564884635 | -122.46438174842699 | (37.7198564884635, -122.464381748427) | |||
187898 | 187898 | 219347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992971.18683 | 2090558.0944400001 | 37.7198708965006 | -122.46634406733999 | (37.7198708965006, -122.46634406734) | |||
57377 | 57377 | 219355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993537.41459 | 2090564.39449 | 37.719920850243 | -122.464387288237 | (37.719920850243, -122.464387288237) | |||
40817 | 40817 | 176682 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1998 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000630.5225599995 | 2090456.6587099999 | 37.7200313490478 | -122.43986121213301 | (37.7200313490478, -122.439861212133) | |||
161077 | 161077 | 176681 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1998 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000637.29788 | 2090464.1729400002 | 37.7200523670946 | -122.439838330692 | (37.7200523670946, -122.439838330692) | |||
62283 | 62283 | 219329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995365.77553 | 2090599.7710099998 | 37.7201232084876 | -122.45806987824699 | (37.7201232084876, -122.458069878247) | |||
172065 | 172065 | 219328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995301.79244 | 2090610.0663299998 | 37.720147800462996 | -122.458291789543 | (37.720147800463, -122.458291789543) | |||
171560 | 171560 | 219327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995301.64396 | 2090617.7903200001 | 37.720169000171296 | -122.458292861552 | (37.7201690001713, -122.458292861552) | |||
187057 | 187057 | 219326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995302.40607 | 2090624.5686700002 | 37.7201876557032 | -122.45829071756701 | (37.7201876557032, -122.458290717567) | |||
32893 | 32893 | 176636 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009567.85058 | 2090563.67809 | 37.7208298948579 | -122.40897533376301 | (37.7208298948579, -122.408975333763) | |||
153257 | 153257 | 176637 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6009580.5453 | 2090567.0766099999 | 37.7208399376015 | -122.40893169145001 | (37.7208399376015, -122.40893169145) | |||
59824 | 59824 | 176593 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 556 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5999236.66404 | 2090814.9322900001 | 37.7209356443574 | -122.44470502632099 | (37.7209356443574, -122.444705026321) | |||
155443 | 155443 | 219333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 159 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5994132.08627 | 2090976.61214 | 37.721086961572496 | -122.46236161210699 | (37.7210869615725, -122.462361612107) | |||
37643 | 37643 | 219320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5995079.65544 | 2091128.71847 | 37.7215591281313 | -122.459097172915 | (37.7215591281313, -122.459097172915) | |||
32089 | 32089 | 219321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.45909980971201 | (37.7216008413857, -122.459099809712) | |||
32651 | 32651 | 219322 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.87033 | 2091157.1990200002 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | |||
147745 | 147745 | 219323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.72755 | 2091168.59616 | 37.7216686268896 | -122.459099809715 | (37.7216686268896, -122.459099809715) | |||
42679 | 42679 | 219324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995080.31545 | 2091178.4589099998 | 37.721695741442396 | -122.459098491311 | (37.7216957414424, -122.459098491311) | |||
134794 | 134794 | 219325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5995080.6810800005 | 2091195.9220900002 | 37.721743712182395 | -122.459098491296 | (37.7217437121824, -122.459098491296) | |||
30656 | 30656 | 176851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6004177.9913099995 | 2091279.54891 | 37.7224921207944 | -122.427657419158 | (37.7224921207944, -122.427657419158) | |||
26978 | 26978 | 176852 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6004182.999 | 2091286.4234200001 | 37.7225112799465 | -122.427640598252 | (37.7225112799465, -122.427640598252) | |||
34914 | 34914 | 176818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 695 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009866.42198 | 2091203.0617799999 | 37.722602230178 | -122.407988325128 | (37.722602230178, -122.407988325128) | |||
60723 | 60723 | 176819 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 691 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6009861.20828 | 2091223.43353 | 37.7226578748526 | -122.40800778375099 | (37.7226578748526, -122.408007783751) | |||
73755 | 73755 | 187586 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6010130.12486 | 2091286.0001700001 | 37.7228447224995 | -122.407082601693 | (37.7228447224995, -122.407082601693) | |||
176573 | 176573 | 176820 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 667 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009838.84445 | 2091294.60305 | 37.722852039372505 | -122.408090107681 | (37.7228520393725, -122.408090107681) |
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");