Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 122592 | 122592 | 12943 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 725X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | ||||
| 1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
| 6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
| 7946 | 7946 | 4639 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 75 | 3 | 6009873.723999999 | 2119435.9713 | 37.8001238030697 | -122.40995515916201 | (37.8001238030697, -122.409955159162) | |||
| 5299 | 5299 | 4716 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008306.8566 | 2120868.0824 | 37.803968081269204 | -122.415478587922 | (37.8039680812692, -122.415478587922) | |||
| 124851 | 124851 | 4719 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008486.129587 | 2120728.7244 | 37.803595514004 | -122.41484833114401 | (37.803595514004, -122.414848331144) | |||
| 6297 | 6297 | 4668 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009590.6555 | 2119701.3035 | 37.8008364710267 | -122.41095344028601 | (37.8008364710267, -122.410953440286) | |||
| 7054 | 7054 | 4734 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6007950.0877 | 2121194.0464 | 37.80484303663339 | -122.416736319981 | (37.8048430366334, -122.416736319981) | |||
| 7107 | 7107 | 4638 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009905.4204 | 2119408.7236 | 37.8000507639755 | -122.40984355245001 | (37.8000507639755, -122.40984355245) | |||
| 7649 | 7649 | 4666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 60 | 3 | Permit Number 769286 | 6009738.4106 | 2119565.7843 | 37.8004726529456 | -122.41043256902 | (37.8004726529456, -122.41043256902) | |
| 8911 | 8911 | 4637 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009937.8119 | 2119380.0857 | 37.7999739465801 | -122.409729442456 | (37.7999739465801, -122.409729442456) | |||
| 87462 | 87462 | 4736 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.804423590750396 | -122.41601752221001 | (37.8044235907504, -122.41601752221) | |||
| 7577 | 7577 | 4636 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 3 | 6009974.2224 | 2119345.7236 | 37.7998816370329 | -122.409601021151 | (37.7998816370329, -122.409601021151) | |||
| 5524 | 5524 | 4635 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/05/1990 12:00:00 AM | 35 | 3 | 6010009.8735 | 2119314.4873 | 37.7997978674726 | -122.409475448708 | (37.7997978674726, -122.409475448708) | ||
| 73021 | 73021 | 227798 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5997129.95127 | 2106058.68083 | 37.762670813522604 | -122.453087101682 | (37.7626708135226, -122.453087101682) | |||
| 3859 | 3859 | 23825 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003756.6414 | 2112968.1539 | 37.782020088596504 | -122.43066083333599 | (37.7820200885965, -122.430660833336) | |||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 116982 | 116982 | 23926 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
| 125350 | 125350 | 23923 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
| 40839 | 40839 | 208110 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5993194.87968 | 2099514.9753099997 | 37.744477176897504 | -122.466221422307 | (37.7444771768975, -122.466221422307) | |||
| 19304 | 19304 | 2308 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2205 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 26 | 5x5 | 6009667.68521 | 2104459.2052 | 37.7589895916184 | -122.40961048355 | (37.7589895916184, -122.40961048355) | ||
| 179466 | 179466 | 228000 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1229 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 5997430.92734 | 2105573.7354599996 | 37.761356520915896 | -122.452011149197 | (37.7613565209159, -122.452011149197) | |||
| 1958 | 1958 | 23757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003900.3372 | 2111922.0621 | 37.7791559204238 | -122.43008906318701 | (37.7791559204238, -122.430089063187) | |||
| 2284 | 2284 | 23758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003894.1493 | 2111953.6889 | 37.7792424093118 | -122.43011272647199 | (37.7792424093118, -122.430112726472) | |||
| 6949 | 6949 | 23761 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003883.1487 | 2112042.3815 | 37.7794853141392 | -122.430157111124 | (37.7794853141392, -122.430157111124) | |||
| 7438 | 7438 | 23859 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003649.3852 | 2113669.4444 | 37.783939579713504 | -122.431081960003 | (37.7839395797135, -122.431081960003) | |||
| 8475 | 8475 | 23759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003889.3366 | 2111985.3157 | 37.7793289760816 | -122.430131632423 | (37.7793289760816, -122.430131632423) | |||
| 8513 | 8513 | 23760 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003885.2113 | 2112011.4423 | 37.7794004795956 | -122.430147767922 | (37.7794004795956, -122.430147767922) | |||
| 62687 | 62687 | 227747 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 331 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6006987.22929 | 2096307.4498700001 | 37.7364561487303 | -122.41830281065201 | (37.7364561487303, -122.418302810652) | |||
| 125018 | 125018 | 23756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003937.3073429 | 2111811.4900601003 | 37.7788544107823 | -122.42995327885001 | (37.7788544107823, -122.42995327885) | |||
| 139971 | 139971 | 23878 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
| 8177 | 8177 | 4676 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3x4 | 6009334.3928 | 2119933.7869 | 37.8014604396574 | -122.411856657471 | (37.8014604396574, -122.411856657471) | |||
| 9026 | 9026 | 4677 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3x3 | 6009299.7627 | 2119967.4935 | 37.8015510467699 | -122.411978876948 | (37.8015510467699, -122.411978876948) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 17542 | 17542 | 2343 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2385 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6009722.48016 | 2103476.08894 | 37.7562932460395 | -122.40935159661501 | (37.7562932460395, -122.409351596615) | |||
| 143009 | 143009 | 59112 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 671 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | 4x4 | Permit Number 18416 | 5993149.01942 | 2110913.66887 | 37.7757723653318 | -122.46720862222901 | (37.7757723653318, -122.467208622229) | |
| 152755 | 152755 | 111648 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2201 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 12x6 | 6000328.99529 | 2116181.728 | 37.7906489481292 | -122.44274970953501 | (37.7906489481292, -122.442749709535) | |||
| 26117 | 26117 | 129704 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000269.523080001 | 2116153.9558 | 37.7905693023891 | -122.442953484235 | (37.7905693023891, -122.442953484235) | |||
| 64874 | 64874 | 129705 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000256.311000001 | 2116152.5364599996 | 37.7905646519773 | -122.442999095143 | (37.7905646519773, -122.442999095143) | |||
| 68304 | 68304 | 191117 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 699 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6014453.67904 | 2103916.00921 | 37.757765116097495 | -122.39302012769501 | (37.7577651160975, -122.393020127695) | |||
| 136601 | 136601 | 227889 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 180 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002384.00394 | 2107390.5502400002 | 37.7666275166849 | -122.435010496535 | (37.7666275166849, -122.435010496535) | |||
| 162441 | 162441 | 227985 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 222 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6004405.37253 | 2099591.374 | 37.7453273824517 | -122.427463259139 | (37.7453273824517, -122.427463259139) | |||
| 223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
| 2139 | 2139 | 23790 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003786.8931 | 2112715.8268 | 37.7813289751352 | -122.43053816621901 | (37.7813289751352, -122.430538166219) | |||
| 5117 | 5117 | 23827 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003747.0158 | 2113043.0957 | 37.7822253147353 | -122.430699482992 | (37.7822253147353, -122.430699482992) | |||
| 6075 | 6075 | 23828 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003742.203 | 2113074.035 | 37.78230999365589 | -122.430718341656 | (37.7823099936559, -122.430718341656) | |||
| 6800 | 6800 | 23823 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003765.5794 | 2112902.15 | 37.781839364726 | -122.430625200646 | (37.781839364726, -122.430625200646) | |||
| 7162 | 7162 | 23924 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x1 | 6003487.1069 | 2114786.6255 | 37.7869978805436 | -122.43172317383998 | (37.7869978805436, -122.43172317384) | |||
| 7311 | 7311 | 23920 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x12 | 6003521.972999999 | 2114612.7568 | 37.786522457310205 | -122.43159012740699 | (37.7865224573102, -122.431590127407) | |||
| 7386 | 7386 | 23826 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003751.8286 | 2113008.0312 | 37.78212930904171 | -122.43068032991002 | (37.7821293090417, -122.43068032991) | |||
| 7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) | |||
| 8006 | 8006 | 23900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003566.3311 | 2114312.7691 | 37.7857012808729 | -122.43141523648701 | (37.7857012808729, -122.431415236487) | |||
| 8325 | 8325 | 23708 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6003978.3577 | 2111349.4443 | 37.77758807209621 | -122.429778304865 | (37.7775880720962, -122.429778304865) | ||||
| 8565 | 8565 | 4733 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3x3 | 6007980.3619 | 2121165.8966 | 37.80476744709579 | -122.416629557244 | (37.8047674470958, -122.416629557244) | |||
| 8699 | 8699 | 23824 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003763.5168 | 2112936.527 | 37.78193363853529 | -122.430634790088 | (37.7819336385353, -122.430634790088) | |||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 43375 | 43375 | 208071 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5994586.62981 | 2100556.35867 | 37.74741675489079 | -122.46148455276399 | (37.7474167548908, -122.461484552764) | |||
| 70175 | 70175 | 227787 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 Miguel St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 6004401.88649 | 2096501.3080000002 | 37.7368425694131 | -122.42725524056101 | (37.7368425694131, -122.427255240561) | |||
| 94348 | 94348 | 23879 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
| 113595 | 113595 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 HIGUERA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 126155 | 126155 | 116878 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 129 HENRY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x5 | 6002678.0 | 2107362.0 | 37.766565813604295 | -122.43399157531401 | (37.7665658136043, -122.433991575314) | |||
| 141952 | 141952 | 26685 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/27/1999 12:00:00 AM | 20 | 3 | 6009783.7006387 | 2119558.1544154 | 37.800454241984404 | -122.41027530758998 | (37.8004542419844, -122.41027530759) | ||
| 159648 | 159648 | 208147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 213 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001401.19821 | 2095102.87221 | 37.7328326327156 | -122.437529806065 | (37.7328326327156, -122.437529806065) | |||
| 176667 | 176667 | 138291 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2435 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6002560.4532 | 2115416.5919 | 37.7886750374795 | -122.43497425370899 | (37.7886750374795, -122.434974253709) | |||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 164909 | 164909 | 227737 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1246 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997502.45152 | 2105394.21767 | 37.7608677069951 | -122.451750827852 | (37.7608677069951, -122.451750827852) | |||
| 166751 | 166751 | 59610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 19 | Permit Number 19012 | 6015498.92125 | 2104246.5894 | 37.7587308251729 | -122.389428301996 | (37.7587308251729, -122.389428301996) | ||
| 177633 | 177633 | 227850 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3945 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003516.46145 | 2101835.6997 | 37.751439460175206 | -122.4306970908 | (37.7514394601752, -122.4306970908) | |||
| 551 | 551 | 1664 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000454.8566 | 2109968.1462 | 37.7735952220186 | -122.441868082855 | (37.7735952220186, -122.441868082855) | |||
| 3886 | 3886 | 227724 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 937 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2001 12:00:00 AM | 18 | Width 4ft | Permit Number 17591 | 5999190.5409699995 | 2106890.47379 | 37.7650725879622 | -122.446020116632 | (37.7650725879622, -122.446020116632) | |
| 6547 | 6547 | 1660 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000641.8596 | 2109991.603 | 37.7736702824704 | -122.441222896356 | (37.7736702824704, -122.441222896356) | |||
| 7804 | 7804 | 1666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000356.4682 | 2109956.4177 | 37.7735574116821 | -122.44220758007401 | (37.7735574116821, -122.442207580074) | |||
| 8492 | 8492 | 1663 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000501.7702 | 2109972.7072 | 37.773610418483 | -122.44170612948601 | (37.773610418483, -122.441706129486) | |||
| 8814 | 8814 | 1661 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000589.0817 | 2109986.3904 | 37.773652963463796 | -122.441405088647 | (37.7736529634638, -122.441405088647) | |||
| 17261 | 17261 | 2372 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2527 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009769.958330001 | 2102611.45041 | 37.753921802157706 | -122.40912639109699 | (37.7539218021577, -122.409126391097) | |||
| 17278 | 17278 | 2375 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2547 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009774.35605 | 2102523.0562 | 37.753679337750604 | -122.409104945855 | (37.7536793377506, -122.409104945855) | |||
| 17306 | 17306 | 2392 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009810.34614 | 2101884.53168 | 37.751928107698 | -122.408935435327 | (37.751928107698, -122.408935435327) | |||
| 17638 | 17638 | 2318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2270 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5X5 | 6009620.42845 | 2104139.7744 | 37.7581098586044 | -122.40975137312999 | (37.7581098586044, -122.40975137313) | |||
| 18250 | 18250 | 2427 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2884 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009813.095380001 | 2100671.03054 | 37.7485962562324 | -122.408840321235 | (37.7485962562324, -122.408840321235) | |||
| 18300 | 18300 | 2394 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2661 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 7X6 | 6009814.716440001 | 2101845.61428 | 37.7518214939686 | -122.408917576591 | (37.7518214939686, -122.408917576591) | |||
| 18551 | 18551 | 2379 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2565 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009779.24964 | 2102431.71295 | 37.753428803702 | -122.40908157785101 | (37.753428803702, -122.409081577851) | |||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 19206 | 19206 | 2364 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009753.556480001 | 2102901.70574 | 37.754717859559996 | -122.40920359338499 | (37.75471785956, -122.409203593385) | |||
| 20167 | 20167 | 2332 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2318 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X6 | 6009643.236190001 | 2103731.69198 | 37.7569906343237 | -122.409643691024 | (37.7569906343237, -122.409643691024) | |||
| 21137 | 21137 | 2330 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2312 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009640.84961 | 2103785.73358 | 37.7571388866594 | -122.409655759023 | (37.7571388866594, -122.409655759023) | |||
| 21374 | 21374 | 2362 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2473 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009749.23862 | 2102948.41566 | 37.7548458726476 | -122.40922182173 | (37.7548458726476, -122.40922182173) | |||
| 44075 | 44075 | 124022 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991831.5909 | 2112929.38774 | 37.7812308417217 | -122.471912840662 | (37.7812308417217, -122.471912840662) | |||
| 48423 | 48423 | 129702 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 6000294.26409 | 2116157.6767599997 | 37.7905809297121 | -122.442868149367 | (37.7905809297121, -122.442868149367) | |||
| 48455 | 48455 | 227846 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1210 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003824.99851 | 2101233.9622 | 37.749804704938995 | -122.429587222175 | (37.749804704939, -122.429587222175) | |||
| 50633 | 50633 | 227818 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006782.14401 | 2097820.3325099996 | 37.7405986419274 | -122.419119157627 | (37.7405986419274, -122.419119157627) | |||
| 59603 | 59603 | 227803 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1253 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5997459.417780001 | 2105347.40102 | 37.7607366955736 | -122.45189628420601 | (37.7607366955736, -122.451896284206) | |||
| 61629 | 61629 | 227941 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2501 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6009766.693530001 | 2102694.57253 | 37.754149854037706 | -122.40914354655399 | (37.7541498540377, -122.409143546554) | |||
| 63354 | 63354 | 228017 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998195.21077 | 2106351.13938 | 37.7635348245821 | -122.44942384014601 | (37.7635348245821, -122.449423840146) | |||
| 87847 | 87847 | 19146 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003500.9045907995 | 2108066.1860563997 | 37.76854600349329 | -122.431195563592 | (37.7685460034933, -122.431195563592) | |||
| 103750 | 103750 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 112335 | 112335 | 2341 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2372 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009654.94661 | 2103556.3659 | 37.756509884537 | -122.409590817662 | (37.756509884537, -122.409590817662) | |||
| 114646 | 114646 | 21898 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
| 135962 | 135962 | 208148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6001401.2605 | 2095043.16775 | 37.7326687015796 | -122.43752531665899 | (37.7326687015796, -122.437525316659) | |||
| 146748 | 146748 | 227966 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 329 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009444.02265 | 2099567.83625 | 37.745546448317704 | -122.410038704746 | (37.7455464483177, -122.410038704746) |
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");