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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
29957 | 29957 | 187712 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013733.01886 | 2087017.8562099999 | 37.7113262093072 | -122.39432937061301 | (37.7113262093072, -122.394329370613) | |||
30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | |||
30436 | 30436 | 203829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | ||||
32164 | 32164 | 188743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | |||
33836 | 33836 | 246868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | ||||
35636 | 35636 | 187736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016350.44721 | 2096194.4230400003 | 37.7366684157019 | -122.38592203240101 | (37.7366684157019, -122.385922032401) | ||||
37011 | 37011 | 187739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016069.71075 | 2096081.9732700002 | 37.736344111196 | -122.38688482859399 | (37.736344111196, -122.386884828594) | ||||
37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
41904 | 41904 | 188655 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.38154925430099 | (37.7428536469791, -122.381549254301) | ||||
44332 | 44332 | 188644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | ||||
50657 | 50657 | 187735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 299x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016637.03713 | 2096003.6378799998 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | ||||
53526 | 53526 | 188662 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.38506465383101 | (37.7449879810223, -122.385064653831) | ||||
54181 | 54181 | 187745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016145.55201 | 2096259.4396400002 | 37.7368355969845 | -122.386634982516 | (37.7368355969845, -122.386634982516) | ||||
55759 | 55759 | 188646 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6018092.675340001 | 2098102.14022 | 37.74200288923021 | -122.380030855133 | (37.7420028892302, -122.380030855133) | ||||
56776 | 56776 | 187772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427x Innes Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | ||||
56907 | 56907 | 187701 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | |||
57966 | 57966 | 188747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6014639.494109999 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | |||
58370 | 58370 | 187738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016145.734540001 | 2096191.5007099998 | 37.7366490605065 | -122.38662961537399 | (37.7366490605065, -122.386629615374) | ||||
58643 | 58643 | 246871 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5999923.98222 | 2105342.76453 | 37.760864817484396 | -122.443372153705 | (37.7608648174844, -122.443372153705) | ||||
60507 | 60507 | 188584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710205995 | -122.39978828959299 | (37.756276710206, -122.399788289593) | ||||
63133 | 63133 | 188742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6014513.510980001 | 2086966.09658 | 37.7112274421761 | -122.391628153428 | (37.7112274421761, -122.391628153428) | |||
63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
65570 | 65570 | 188736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | |||
69580 | 69580 | 188649 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.734213959905205 | -122.393020304839 | (37.7342139599052, -122.393020304839) | |||
71411 | 71411 | 188737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014387.73209 | 2086976.03412 | 37.7112477461551 | -122.39206357459899 | (37.7112477461551, -122.392063574599) | |||
71605 | 71605 | 188746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | |||
71608 | 71608 | 188660 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017087.3290800005 | 2098898.6066400004 | 37.7441343103446 | -122.38356249103902 | (37.7441343103446, -122.383562491039) | ||||
72358 | 72358 | 124133 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5996054.79965 | 2112880.00292 | 37.781338707390105 | -122.45729914105499 | (37.7813387073901, -122.457299141055) | ||||
72616 | 72616 | 188650 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014234.97615 | 2095377.1002900002 | 37.734306916536 | -122.39317901359699 | (37.734306916536, -122.393179013597) | ||||
74110 | 74110 | 188585 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.39972630024799 | (37.755629771207, -122.399726300248) | ||||
75165 | 75165 | 188735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014342.21925 | 2086979.24909 | 37.711254046810495 | -122.39222110431601 | (37.7112540468105, -122.392221104316) | |||
104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
107099 | 107099 | 111243 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 3x3 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | |||
119608 | 119608 | 188659 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | ||||
126758 | 126758 | 203783 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 198x San Anselmo Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993617.28141 | 2096303.72288 | 37.735684244431795 | -122.464527731782 | (37.7356842444318, -122.464527731782) | ||||
130923 | 130923 | 188582 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.39981880719999 | (37.7565745414011, -122.3998188072) | ||||
133052 | 133052 | 203807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994179.6676199995 | 2101287.15386 | 37.7493999011887 | -122.46294480178699 | (37.7493999011887, -122.462944801787) | |||
133316 | 133316 | 203782 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 66x Santa Monica Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993630.457230001 | 2097428.51442 | 37.7387734012664 | -122.46456382517599 | (37.7387734012664, -122.464563825176) | ||||
133432 | 133432 | 203808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994148.64523 | 2101441.5060099997 | 37.7498219260394 | -122.46306327486 | (37.7498219260394, -122.46306327486) | |||
133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
133838 | 133838 | 188745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014589.916680001 | 2086958.4326 | 37.711210639227 | -122.39136353872101 | (37.711210639227, -122.391363538721) | |||
133969 | 133969 | 188661 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | ||||
136589 | 136589 | 188651 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6017373.9642900005 | 2098663.52344 | 37.7435046581055 | -122.38255500572399 | (37.7435046581055, -122.382555005724) | ||||
137062 | 137062 | 188645 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6018140.58939 | 2098064.90862 | 37.7419033019107 | -122.37986259559601 | (37.7419033019107, -122.379862595596) | ||||
137116 | 137116 | 188583 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012480.57258 | 2103516.6299400004 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | ||||
137306 | 137306 | 125295 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1306x Montgomery St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6011445.958380001 | 2119999.7387 | 37.801759761770604 | -122.40455429893998 | (37.8017597617706, -122.40455429894) | |||
137718 | 137718 | 188648 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018027.576669999 | 2098147.2670299998 | 37.7421232068329 | -122.380259083311 | (37.7421232068329, -122.380259083311) | ||||
137789 | 137789 | 188763 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014060.27429 | 2087007.0702 | 37.711314778934295 | -122.39319752976601 | (37.7113147789343, -122.393197529766) | |||
146596 | 146596 | 188586 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.01622 | 2103043.06832 | 37.755259550009896 | -122.399711994725 | (37.7552595500099, -122.399711994725) | ||||
147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
147853 | 147853 | 188761 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 8ft | 6013991.40971 | 2087009.0790099998 | 37.7113164687655 | -122.39343568552 | (37.7113164687655, -122.39343568552) | |||
149419 | 149419 | 188738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014415.87146 | 2086974.70005 | 37.7112456453465 | -122.39196622388799 | (37.7112456453465, -122.391966223888) | |||
152573 | 152573 | 187713 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013756.4546300005 | 2087023.9293400003 | 37.71134418764721 | -122.394248794959 | (37.7113441876472, -122.394248794959) | |||
153654 | 153654 | 188652 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6017392.84765 | 2098647.1595799997 | 37.7434607693943 | -122.382488572792 | (37.7434607693943, -122.382488572792) | ||||
153767 | 153767 | 187700 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014134.283869999 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | |||
155047 | 155047 | 187744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016140.58365 | 2096258.2267599998 | 37.736831991603296 | -122.38665207592899 | (37.7368319916033, -122.386652075929) | ||||
155305 | 155305 | 188580 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | ||||
157079 | 157079 | 187711 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013709.84578 | 2087009.9917799998 | 37.711303326954706 | -122.394408912955 | (37.7113033269547, -122.394408912955) | |||
158166 | 158166 | 188643 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018388.81738 | 2097879.37789 | 37.7414075614118 | -122.378991412446 | (37.7414075614118, -122.378991412446) | ||||
163246 | 163246 | 187737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016156.13559 | 2096195.78467 | 37.7366613992076 | -122.386593952757 | (37.7366613992076, -122.386593952757) | ||||
165803 | 165803 | 203827 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993824.2375 | 2096507.58297 | 37.7362559218691 | -122.463827002518 | (37.7362559218691, -122.463827002518) | ||||
166461 | 166461 | 188581 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012475.30485 | 2103528.81943 | 37.75659188303771 | -122.39983502019 | (37.7565918830377, -122.39983502019) | ||||
166786 | 166786 | 188760 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6013911.80932 | 2087014.9974599998 | 37.7113282966477 | -122.393711220721 | (37.7113282966477, -122.393711220721) | |||
168459 | 168459 | 188642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) | ||||
168939 | 168939 | 188741 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.39171045846399 | (37.7112309432358, -122.391710458464) | |||
170303 | 170303 | 188764 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014090.1968 | 2087004.6185400002 | 37.711309709434 | -122.393093937756 | (37.711309709434, -122.393093937756) | |||
173558 | 173558 | 188762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6014035.24999 | 2087007.2689599998 | 37.71131393444921 | -122.39328403465299 | (37.7113139344492, -122.393284034653) | |||
174612 | 174612 | 188734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014314.36158 | 2086981.8522700001 | 37.71125964778079 | -122.39231757011801 | (37.7112596477808, -122.392317570118) | |||
174842 | 174842 | 203828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993850.84574 | 2096478.66288 | 37.7361780477826 | -122.463732909161 | (37.7361780477826, -122.463732909161) | ||||
175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
186558 | 186558 | 187746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016141.394640001 | 2096265.75957 | 37.7368527200761 | -122.38664979707501 | (37.7368527200761, -122.386649797075) | ||||
186731 | 186731 | 188739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014439.36233 | 2086971.4204900002 | 37.7112379444543 | -122.39188480373801 | (37.7112379444543, -122.391884803738) | |||
187551 | 187551 | 188647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018073.116719999 | 2098111.74487 | 37.7420281826481 | -122.38009915058001 | (37.7420281826481, -122.38009915058) | ||||
188008 | 188008 | 187747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016140.5122 | 2096271.0286 | 37.7368671389145 | -122.38665321539801 | (37.7368671389145, -122.386653215398) |
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");