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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 82405 | 82405 | 92905 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 89942 | 89942 | 92903 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 109586 | 109586 | 92904 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 119042 | 119042 | 92906 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 120300 | 120300 | 92902 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 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) | |||
| 12206 | 12206 | 65603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 131 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 15 | 3x3 | Permit Number 28506 | 6004245.84033 | 2093781.6134799998 | 37.7293660735617 | -122.427601053271 | (37.7293660735617, -122.427601053271) |
| 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) | |||
| 66612 | 66612 | 208088 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500x Junipero Serra Blvd | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991446.48536 | 2094319.42031 | 37.7301104703116 | -122.471888366152 | (37.7301104703116, -122.471888366152) | |||
| 68520 | 68520 | 208089 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500x Junipero Serra Blvd | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991450.70341 | 2094361.7324599999 | 37.730226892943705 | -122.471876866532 | (37.7302268929437, -122.471876866532) | |||
| 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) | |||
| 97080 | 97080 | 46078 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44459 | 6016168.14280668 | 2094664.01192279 | 37.7324561236274 | -122.38644566841499 | (37.7324561236274, -122.386445668415) | |||
| 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) | |||
| 92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
| 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) | ||||
| 88085 | 88085 | 35688 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38992 | 5994858.93773428 | 2095456.23739151 | 37.7334287567384 | -122.460173495672 | (37.7334287567384, -122.460173495672) | |||
| 65030 | 65030 | 54536 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 5 | Permit Number 10331 | 6009931.29054 | 2095213.10874 | 37.7336166059206 | -122.408046748666 | (37.7336166059206, -122.408046748666) | ||
| 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) | |||
| 93536 | 93536 | 119890 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | ||||
| 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) | |||
| 144524 | 144524 | 84799 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49306 | 6003755.0 | 2096568.0 | 37.7369890856012 | -122.42949656641501 | (37.7369890856012, -122.429496566415) | |||
| 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) | |||
| 75081 | 75081 | 31663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 154 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35171 | 6007340.50387 | 2096742.6904 | 37.7376711031279 | -122.41711221886699 | (37.7376711031279, -122.417112218867) | |
| 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) | |||
| 74327 | 74327 | 38387 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 13 | Permit Number 40446 | 6014272.48503 | 2096672.22783 | 37.7378651543499 | -122.39313992457399 | (37.7378651543499, -122.393139924574) | ||
| 86844 | 86844 | 53174 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 44@ DIAMOND Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49089 | 6001797.88022558 | 2096945.60904163 | 37.7379149076596 | -122.43629020957701 | (37.7379149076596, -122.436290209577) | ||
| 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) | |||
| 116540 | 116540 | 60660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 17 | Permit Number 20294 | 6004379.78679579 | 2097028.45773942 | 37.738288753282106 | -122.42736919019501 | (37.7382887532821, -122.427369190195) | |
| 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) | |||
| 144610 | 144610 | 70136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.738316654626395 | -122.41408448515101 | (37.7383166546264, -122.414084485151) | ||
| 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) | |||
| 100610 | 100610 | 96125 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
| 100691 | 100691 | 96126 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
| 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) |
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");