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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133317 | 133317 | 177153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 701 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002643.53653 | 2087345.7216599998 | 37.711603783270704 | -122.43268080909401 | (37.7116037832707, -122.432680809094) | |||
| 167014 | 167014 | 177146 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 183 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010243.9758 | 2087974.1482400002 | 37.7137574284457 | -122.406455788622 | (37.7137574284457, -122.406455788622) | |||
| 64816 | 64816 | 177147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 184 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010274.23891 | 2088006.9688799998 | 37.71384924022011 | -122.406353498838 | (37.7138492402201, -122.406353498838) | |||
| 41501 | 41501 | 109608 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | |||
| 117105 | 117105 | 109646 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 CURTIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6000484.3 | 2088475.7 | 37.7145837584364 | -122.44022466861401 | (37.7145837584364, -122.440224668614) | |||
| 162256 | 162256 | 177150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991357.8727400005 | 2088731.5467 | 37.7147624226096 | -122.471787632218 | (37.7147624226096, -122.471787632218) | |||
| 52418 | 52418 | 177149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991352.53535 | 2088761.3617099999 | 37.714843978538205 | -122.47180825186301 | (37.7148439785382, -122.471808251863) | |||
| 179602 | 179602 | 208091 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 247 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994538.89775 | 2088695.72634 | 37.714847610008 | -122.46079017812599 | (37.714847610008, -122.460790178126) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 189027 | 189027 | 177145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 646 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001109.079969999 | 2090060.7156599998 | 37.718971408083796 | -122.438178657041 | (37.7189714080838, -122.438178657041) | |||
| 44961 | 44961 | 208090 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994177.92287 | 2090747.0249299998 | 37.720459209606396 | -122.46218652760099 | (37.7204592096064, -122.462186527601) | |||
| 28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
| 45277 | 45277 | 208077 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 338 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995744.67706 | 2091237.28528 | 37.7218954350055 | -122.456806235434 | (37.7218954350055, -122.456806235434) | |||
| 174064 | 174064 | 177152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 649 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6009816.38769 | 2091371.81115 | 37.7230627793063 | -122.408173178961 | (37.7230627793063, -122.408173178961) | |||
| 135648 | 135648 | 208078 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994204.15445 | 2092252.12785 | 37.7245933696677 | -122.462204953795 | (37.7245933696677, -122.462204953795) | |||
| 172116 | 172116 | 208079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 370 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994204.7092699995 | 2092293.8325900002 | 37.7247079127335 | -122.462206059069 | (37.7247079127335, -122.462206059069) | |||
| 24703 | 24703 | 208140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994042.19484 | 2092647.64079 | 37.7256700254358 | -122.462793502527 | (37.7256700254358, -122.462793502527) | |||
| 31262 | 31262 | 177151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 183 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004046.6041 | 2092611.27045 | 37.7261413007669 | -122.428206457066 | (37.7261413007669, -122.428206457066) | |||
| 53038 | 53038 | 208160 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 366 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997663.5494099995 | 2093590.68698 | 37.7284673190039 | -122.45034277641399 | (37.7284673190039, -122.450342776414) | |||
| 137384 | 137384 | 208053 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 111 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5993326.69721 | 2093754.23227 | 37.7286672184966 | -122.465347248004 | (37.7286672184966, -122.465347248004) | |||
| 72799 | 72799 | 208158 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999136.82993 | 2093762.64441 | 37.7290236809976 | -122.445261947704 | (37.7290236809976, -122.445261947704) | |||
| 67524 | 67524 | 208159 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999853.60531 | 2093798.1643400001 | 37.7291620992495 | -122.442786557466 | (37.7291620992495, -122.442786557466) | |||
| 55067 | 55067 | 208055 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 920 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5994534.77621 | 2093970.7327700001 | 37.729331273397705 | -122.46118656331998 | (37.7293312733977, -122.46118656332) | |||
| 75826 | 75826 | 208118 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 907 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994500.10104 | 2094002.40377 | 37.7294162386642 | -122.461308732617 | (37.7294162386642, -122.461308732617) | |||
| 166578 | 166578 | 208119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 915 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994530.86611 | 2094005.87306 | 37.7294275350513 | -122.461202626994 | (37.7294275350513, -122.461202626994) | |||
| 173727 | 173727 | 208120 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 925 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994563.96243 | 2094007.92247 | 37.7294350668528 | -122.461088359166 | (37.7294350668528, -122.461088359166) | |||
| 158601 | 158601 | 208076 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 442 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998485.7432 | 2094410.1353900002 | 37.7307643520895 | -122.447559384561 | (37.7307643520895, -122.447559384561) | |||
| 41487 | 41487 | 208150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 210 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000776.72095 | 2094702.6231900002 | 37.7316981172754 | -122.439660093143 | (37.7316981172754, -122.439660093143) | |||
| 73080 | 73080 | 208074 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994748.8803900005 | 2095031.81828 | 37.732257074696705 | -122.460523248557 | (37.7322570746967, -122.460523248557) | |||
| 58750 | 58750 | 208151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001394.62924 | 2094896.4943 | 37.7322655930748 | -122.43753774257799 | (37.7322655930748, -122.437537742578) | |||
| 69558 | 69558 | 208157 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000676.4727 | 2094919.4754400002 | 37.7322878369069 | -122.440022214175 | (37.7322878369069, -122.440022214175) | ||||
| 41780 | 41780 | 208153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 435 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999203.01227 | 2094950.2253400001 | 37.732288277587706 | -122.445118495046 | (37.7322882775877, -122.445118495046) | |||
| 152753 | 152753 | 208156 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6000658.62955 | 2094922.8183799998 | 37.732296000053 | -122.440084141493 | (37.732296000053, -122.440084141493) | ||||
| 134696 | 134696 | 208073 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5994756.9312 | 2095079.7197900002 | 37.732389063688395 | -122.46049888501999 | (37.7323890636884, -122.46049888502) | |||
| 135110 | 135110 | 208051 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992912.8595 | 2095175.00787 | 37.7325444413573 | -122.466881141568 | (37.7325444413573, -122.466881141568) | |||
| 179943 | 179943 | 208052 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992910.68234 | 2095197.7097 | 37.732606649283106 | -122.466890318243 | (37.7326066492831, -122.466890318243) | |||
| 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) | |||
| 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) | |||
| 180624 | 180624 | 208155 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997950.371590001 | 2095226.7551900002 | 37.7329759855362 | -122.449469058051 | (37.7329759855362, -122.449469058051) | ||||
| 188107 | 188107 | 208154 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997951.24674 | 2095236.71061 | 37.7330033708131 | -122.449466749514 | (37.7330033708131, -122.449466749514) | ||||
| 174097 | 174097 | 208149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hamerton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6001382.20466 | 2095404.6567400002 | 37.7336601834577 | -122.43761707629 | (37.7336601834577, -122.43761707629) | |||
| 37582 | 37582 | 208152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80 Nordhoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000435.90571 | 2095588.3603299998 | 37.7341107411125 | -122.44090187344999 | (37.7341107411125, -122.44090187345) | |||
| 25894 | 25894 | 227929 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3110 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002869.05371 | 2095746.24255 | 37.7346825264594 | -122.432500998617 | (37.7346825264594, -122.432500998617) | |||
| 68130 | 68130 | 227745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006858.63803 | 2095797.2986700002 | 37.7350481467491 | -122.418711238627 | (37.7350481467491, -122.418711238627) | |||
| 39989 | 39989 | 227790 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 127 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003497.77442 | 2096110.61078 | 37.735718631796395 | -122.430353286268 | (37.7357186317964, -122.430353286268) | |||
| 71904 | 71904 | 227791 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 125 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003492.804819999 | 2096117.76895 | 37.7357380050008 | -122.430370978657 | (37.7357380050008, -122.430370978657) | |||
| 184300 | 184300 | 227789 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003244.21071 | 2096170.02845 | 37.7358674129555 | -122.43123419382201 | (37.7358674129555, -122.431234193822) | |||
| 48143 | 48143 | 208054 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 San Fernando Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992102.39322 | 2096463.5019599998 | 37.736035512423 | -122.46977686683 | (37.736035512423, -122.46977686683) | |||
| 167232 | 167232 | 227544 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 288 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002936.87727 | 2096251.7785 | 37.7360744584526 | -122.432302602791 | (37.7360744584526, -122.432302602791) | ||||
| 167028 | 167028 | 227928 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 27 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002674.88554 | 2096258.78019 | 37.736078824679105 | -122.433208913461 | (37.7360788246791, -122.433208913461) | |||
| 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) | |||
| 77194 | 77194 | 227785 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6004415.353080001 | 2096483.81995 | 37.7367953127564 | -122.42720743529699 | (37.7367953127564, -122.427207435297) | |||
| 76362 | 76362 | 227786 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 Miguel St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6004409.26315 | 2096492.33537 | 37.7368183497736 | -122.427229097246 | (37.7368183497736, -122.427229097246) | |||
| 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) | |||
| 130051 | 130051 | 227930 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 60 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002467.73938 | 2096558.4933900002 | 37.7368900149663 | -122.433946517617 | (37.7368900149663, -122.433946517617) | |||
| 66497 | 66497 | 227925 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001796.41757 | 2096593.1915099998 | 37.736947167771795 | -122.436270052841 | (37.7369471677718, -122.436270052841) | |||
| 131248 | 131248 | 227926 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001798.975190001 | 2096621.3956 | 37.737024754984 | -122.43626322786301 | (37.737024754984, -122.436263227863) | |||
| 135828 | 135828 | 227927 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001800.50314 | 2096635.61515 | 37.7370638853866 | -122.436258962388 | (37.7370638853866, -122.436258962388) | |||
| 31548 | 31548 | 227788 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003786.51974 | 2096596.76601 | 37.7370698550876 | -122.42938963933099 | (37.7370698550876, -122.429389639331) | |||
| 31295 | 31295 | 227823 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 316 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006968.36013 | 2096533.98003 | 37.737077088338 | -122.41838410663799 | (37.737077088338, -122.418384106638) | |||
| 49319 | 49319 | 227793 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001793.11618 | 2096866.54712 | 37.7376975512926 | -122.43630102458499 | (37.7376975512926, -122.436301024585) | |||
| 168652 | 168652 | 218235 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 359 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 5991961.59976 | 2097124.91171 | 37.73784343751829 | -122.470311793456 | (37.7378434375183, -122.470311793456) | |||
| 173491 | 173491 | 227748 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 95 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009090.18719 | 2096911.9137799998 | 37.738234028369604 | -122.411074651796 | (37.7382340283696, -122.411074651796) | |||
| 147613 | 147613 | 227749 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 95 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009066.20939 | 2096913.9304400003 | 37.7382382210078 | -122.411157697894 | (37.7382382210078, -122.411157697894) | |||
| 177357 | 177357 | 227792 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004387.52295 | 2097025.09932 | 37.7382799693533 | -122.427342203202 | (37.7382799693533, -122.427342203202) | |||
| 38974 | 38974 | 227825 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008200.416540001 | 2096957.1149400002 | 37.7383082035529 | -122.414154245241 | (37.7383082035529, -122.414154245241) | |||
| 61896 | 61896 | 227750 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 609 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008693.585969999 | 2096947.7514900002 | 37.7383101820654 | -122.41244843994 | (37.7383101820654, -122.41244843994) | |||
| 163534 | 163534 | 227824 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008211.90866 | 2096957.8323099997 | 37.73831081878821 | -122.41411456174801 | (37.7383108187882, -122.414114561748) | |||
| 133606 | 133606 | 227826 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008183.98795 | 2096960.54649 | 37.738316703045996 | -122.41421129012899 | (37.738316703046, -122.414211290129) | |||
| 34966 | 34966 | 227751 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 609 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008668.3519 | 2096950.8118099999 | 37.738317168894504 | -122.412535903535 | (37.7383171688945, -122.412535903535) | |||
| 46842 | 46842 | 227827 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008166.78412 | 2096961.13655 | 37.738317356855504 | -122.414270814451 | (37.7383173568555, -122.414270814451) | |||
| 165681 | 165681 | 227752 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 609 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008645.38555 | 2096952.29887 | 37.7383199631034 | -122.41261541527099 | (37.7383199631034, -122.412615415271) | |||
| 146942 | 146942 | 227828 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 330 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008123.600819999 | 2096965.82983 | 37.738327817767896 | -122.414420453565 | (37.7383278177679, -122.414420453565) | |||
| 184247 | 184247 | 227829 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 330 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008104.996669999 | 2096968.11505 | 37.7383330473413 | -122.41448493944999 | (37.7383330473413, -122.41448493945) | |||
| 173001 | 173001 | 200279 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.91134 | 2097012.03507 | 37.7389520983484 | -122.383560561973 | (37.7389520983484, -122.383560561973) | |||
| 153586 | 153586 | 200280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017039.14807 | 2097019.94402 | 37.7389732198275 | -122.383598327225 | (37.7389732198275, -122.383598327225) | |||
| 181542 | 181542 | 200281 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017058.90214 | 2097021.55085 | 37.7389787236965 | -122.38353013790702 | (37.7389787236965, -122.383530137907) | |||
| 162698 | 162698 | 200278 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017026.25444 | 2097031.5540099998 | 37.739004385852795 | -122.383643715978 | (37.7390043858528, -122.383643715978) | |||
| 34090 | 34090 | 200282 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.10078 | 2097031.29718 | 37.7390049434275 | -122.383564705169 | (37.7390049434275, -122.383564705169) | |||
| 187429 | 187429 | 200283 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017069.557019999 | 2097033.93305 | 37.7390133116224 | -122.383494159632 | (37.7390133116224, -122.383494159632) | |||
| 177185 | 177185 | 200277 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017033.1973 | 2097041.97927 | 37.7390333952753 | -122.38362043613 | (37.7390333952753, -122.38362043613) | |||
| 175173 | 175173 | 200284 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017057.48354 | 2097042.3029900002 | 37.739035626492296 | -122.38353648713199 | (37.7390356264923, -122.383536487132) | |||
| 26638 | 26638 | 200276 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017047.12766 | 2097054.90505 | 37.7390696568319 | -122.383573170476 | (37.7390696568319, -122.383573170476) | |||
| 177285 | 177285 | 200285 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017066.92688 | 2097055.31943 | 37.739071888953795 | -122.38350474196699 | (37.7390718889538, -122.383504741967) | |||
| 68482 | 68482 | 200275 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017053.42195 | 2097063.51512 | 37.7390936462465 | -122.38355200672702 | (37.7390936462465, -122.383552006727) | |||
| 66780 | 66780 | 227746 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 284 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008050.17777 | 2097273.48405 | 37.739168443760704 | -122.414696081382 | (37.7391684437607, -122.414696081382) | |||
| 51194 | 51194 | 99324 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5989313.9402 | 2097680.7708 | 37.739216248209 | -122.479506595172 | (37.739216248209, -122.479506595172) | |||
| 173203 | 173203 | 99323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5989330.3766 | 2097681.8666 | 37.73922021170971 | -122.479449846275 | (37.7392202117097, -122.479449846275) | |||
| 165203 | 165203 | 99322 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5989346.812999999 | 2097682.9624 | 37.739224175183 | -122.479393097373 | (37.739224175183, -122.479393097373) | |||
| 91835 | 91835 | 99325 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150@23rd Ave Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x6 | 5989403.0 | 2097682.0 | 37.73922479603689 | -122.479198759749 | (37.7392247960369, -122.479198759749) | ||||
| 59050 | 59050 | 99321 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989362.5919 | 2097683.4007 | 37.7392262951159 | -122.47933857369101 | (37.7392262951159, -122.479338573691) | |||
| 166570 | 166570 | 99320 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5989380.1241 | 2097683.1815 | 37.7392267115304 | -122.479277939862 | (37.7392267115304, -122.479277939862) | |||
| 134764 | 134764 | 99319 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989394.1498 | 2097683.839 | 37.73922933145371 | -122.479229493917 | (37.7392293314537, -122.479229493917) | |||
| 76802 | 76802 | 99318 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989408.3581 | 2097684.4234 | 37.7392317612483 | -122.47918041128 | (37.7392317612483, -122.47918041128) | |||
| 162278 | 162278 | 183548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2590 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989271.0961 | 2097748.8175 | 37.7394005980364 | -122.479659706735 | (37.7394005980364, -122.479659706735) | |||
| 31953 | 31953 | 227817 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 177 Wool St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007367.5579 | 2097392.89252 | 37.7394579364345 | -122.417064737348 | (37.7394579364345, -122.417064737348) | |||
| 159731 | 159731 | 227816 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 177 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007369.02598 | 2097414.123 | 37.7395163132196 | -122.41706116526501 | (37.7395163132196, -122.417061165265) | |||
| 173625 | 173625 | 227815 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 245 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008093.40262 | 2097451.32224 | 37.7396591768336 | -122.414559209965 | (37.7396591768336, -122.414559209965) | |||
| 60879 | 60879 | 208111 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2559 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992039.89052 | 2098021.8056099997 | 37.740310607054894 | -122.470106396399 | (37.7403106070549, -122.470106396399) | |||
| 153373 | 153373 | 208112 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992037.32657 | 2098038.7861599997 | 37.7403570831075 | -122.47011649758801 | (37.7403570831075, -122.470116497588) |
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");