Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 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) | ||||
| 14140 | 14140 | 6797 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | |||
| 23331 | 23331 | 5163 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 288 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001824.579 | 2109378.5545 | 37.7720543041481 | -122.437087794368 | (37.7720543041481, -122.437087794368) | ||||
| 23343 | 23343 | 18087 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2996 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 5999641.9923 | 2114716.1155 | 37.7865855715731 | -122.44502128728998 | (37.7865855715731, -122.44502128729) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 79195 | 79195 | 21052 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5984987.6230272995 | 2100889.8482373003 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | ||||
| 81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
| 83174 | 83174 | 111552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
| 90127 | 90127 | 89023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Hollywood Ct | 1 | unknown : Cutout 12 | Tree 1 | DPW 2 | 6000329.0 | 2088600.0 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | |||||
| 91280 | 91280 | 20611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1403X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5984795.0202245 | 2105623.5542948004 | 37.7607614301436 | -122.495716480052 | (37.7607614301436, -122.495716480052) | ||||
| 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) | ||||
| 109591 | 109591 | 115677 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | ||||
| 114205 | 114205 | 114109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 117156 | 117156 | 29742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5990444.69382 | 2114760.65318 | 37.786178638127204 | -122.47684461043 | (37.7861786381272, -122.47684461043) | ||||
| 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) | ||||
| 123948 | 123948 | 29904 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||||
| 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) | ||||
| 133148 | 133148 | 49664 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.0669299997 | 37.80315153908379 | -122.44339041353399 | (37.8031515390838, -122.443390413534) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 141167 | 141167 | 111532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 143355 | 143355 | 111556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 143490 | 143490 | 111510 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 800x BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 78097 | 78097 | 20683 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984815.4830729 | 2104956.7094961004 | 37.758931658696106 | -122.49559652289 | (37.7589316586961, -122.49559652289) | |||
| 80479 | 80479 | 20923 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1903X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984941.4072484 | 2102249.5254402 | 37.751505852825105 | -122.49496141157199 | (37.7515058528251, -122.494961411572) | |||
| 85770 | 85770 | 20843 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1803X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984917.659181099 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | |||
| 87108 | 87108 | 21258 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2403X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | 5985057.6849307995 | 2098850.8710983 | 37.7421808791716 | -122.49430882372101 | (37.7421808791716, -122.494308823721) | |||
| 90510 | 90510 | 21015 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2005X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984974.2355899 | 2101546.5171136 | 37.7495775063784 | -122.49479606228901 | (37.7495775063784, -122.494796062289) | |||
| 97019 | 97019 | 21092 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | |||
| 108679 | 108679 | 21058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2103X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 10 | 5984987.6230272995 | 2100889.8482373003 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | |||
| 110502 | 110502 | 20519 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984732.1426283 | 2106336.4245009 | 37.7627150896217 | -122.495986533771 | (37.7627150896217, -122.495986533771) | |||
| 111458 | 111458 | 21090 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | |||
| 121696 | 121696 | 20846 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1803X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 10 | 5984917.659181099 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | |||
| 122635 | 122635 | 20681 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1503X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984815.4830729 | 2104956.7094961004 | 37.758931658696106 | -122.49559652289 | (37.7589316586961, -122.49559652289) | |||
| 124152 | 124152 | 21123 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5985013.335853799 | 2100217.4790898 | 37.745930619038 | -122.49456289016199 | (37.745930619038, -122.494562890162) | |||
| 141903 | 141903 | 21256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2403X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5985057.6849307995 | 2098850.8710983 | 37.7421808791716 | -122.49430882372101 | (37.7421808791716, -122.494308823721) | |||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 6746 | 6746 | 20018 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 7838 | 7838 | 20021 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 12211 | 12211 | 20025 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16846 | 16846 | 20022 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
| 15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
| 16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 9889 | 9889 | 3743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 906 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 9898 | 9898 | 3765 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1074 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.39986024500799 | (37.7550481677782, -122.399860245008) | |||
| 9903 | 9903 | 3758 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1056 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) |
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");