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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99106 | 99106 | 111065 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | ||||
| 59133 | 59133 | 227950 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009943.9384 | 2103453.89323 | 37.756244706952295 | -122.408584148445 | (37.7562447069523, -122.408584148445) | |||
| 147808 | 147808 | 227948 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.19062 | 2103487.1600900004 | 37.756335896405396 | -122.40859599791 | (37.7563358964054, -122.40859599791) | |||
| 160514 | 160514 | 227949 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.58696 | 2103473.27819 | 37.756297802015794 | -122.408593647988 | (37.7562978020158, -122.408593647988) | |||
| 176124 | 176124 | 227951 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.616780001 | 2103443.6327299997 | 37.7562165159053 | -122.408584536948 | (37.7562165159053, -122.408584536948) | |||
| 175051 | 175051 | 129722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007108.76695 | 2120556.6740099997 | 37.8030456187175 | -122.419602556719 | (37.8030456187175, -122.419602556719) | |||
| 33495 | 33495 | 105991 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 997 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x9 | 6015541.70538 | 2104536.18595 | 37.7595283673583 | -122.389300555992 | (37.7595283673583, -122.389300555992) | |||
| 32758 | 32758 | 208066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994517.25257 | 2100489.12784 | 37.7472281625491 | -122.46171957892099 | (37.7472281625491, -122.461719578921) | |||
| 76885 | 76885 | 208068 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5994541.71354 | 2100515.18677 | 37.7473011218565 | -122.461636884428 | (37.7473011218565, -122.461636884428) | |||
| 167817 | 167817 | 208069 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994554.01203 | 2100525.45715 | 37.7473300296505 | -122.461595101959 | (37.7473300296505, -122.461595101959) | |||
| 183642 | 183642 | 208067 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5994528.34567 | 2100501.93042 | 37.7472639537695 | -122.461682148211 | (37.7472639537695, -122.461682148211) | |||
| 168136 | 168136 | 227720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 985 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998802.56823 | 2106492.37283 | 37.7639573404853 | -122.447333357965 | (37.7639573404853, -122.447333357965) | |||
| 95312 | 95312 | 39197 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 982 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773799 | 6009935.22104907 | 2103489.58059063 | 37.756342208225604 | -122.408616813596 | (37.7563422082256, -122.408616813596) |
| 3893 | 3893 | 227810 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 974 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | 11 | Width 3ft | Permit Number 18080 | 5999262.93769 | 2106710.24786 | 37.7645818665711 | -122.44575675288401 | (37.7645818665711, -122.445756752884) | |
| 179852 | 179852 | 71574 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 970 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | 10 | 6015483.05138 | 2104523.27151 | 37.759489655143 | -122.389502510438 | (37.759489655143, -122.389502510438) | ||
| 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) | |||
| 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) | |||
| 72954 | 72954 | 227719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 939 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998748.85164 | 2106710.4264 | 37.7645529911446 | -122.44753484385599 | (37.7645529911446, -122.447534843856) | |||
| 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) | |
| 155217 | 155217 | 227718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 931 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998731.85066 | 2106753.68375 | 37.764670793356 | -122.44759675949 | (37.764670793356, -122.44759675949) | |||
| 3885 | 3885 | 227809 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 9 | Width 3ft | Permit Number 17590 | 5999239.85444 | 2106888.20822 | 37.765069183133 | -122.445849391156 | (37.765069183133, -122.445849391156) | |
| 48453 | 48453 | 227808 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999237.81252 | 2106917.22715 | 37.7651487452469 | -122.445858540841 | (37.7651487452469, -122.445858540841) | |||
| 97101 | 97101 | 58441 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17590 | 5999238.33920715 | 2106913.89639282 | 37.765139629896204 | -122.445856479597 | (37.7651396298962, -122.445856479597) | |||
| 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) | |||
| 34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
| 39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
| 49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
| 164766 | 164766 | 200273 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014418.93045 | 2089354.50359 | 37.7177802911084 | -122.392121973844 | (37.7177802911084, -122.392121973844) | |||
| 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) | |||
| 182930 | 182930 | 227721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 918 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998766.13277 | 2106812.06725 | 37.764833058920495 | -122.44748239 | (37.7648330589205, -122.44748239) | |||
| 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) | |||
| 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) | |||
| 163363 | 163363 | 247405 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 904 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002202.1057 | 2109513.8943 | 37.772447365636296 | -122.435791586631 | (37.7724473656363, -122.435791586631) | |||
| 168874 | 168874 | 140496 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900x WEBSTER ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003908.5877 | 2111892.4979 | 37.779075211733996 | -122.430058411766 | (37.779075211734, -122.430058411766) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 81858 | 81858 | 62560 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22760 | 6002239.76573177 | 2109514.87514883 | 37.7724521979542 | -122.435661387293 | (37.7724521979542, -122.435661387293) | ||
| 123013 | 123013 | 10137 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005656.6056289 | 2103722.2710656 | 37.7567405635363 | -122.423430312617 | (37.7567405635363, -122.423430312617) | |||
| 157674 | 157674 | 227769 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 90 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000345.07571 | 2101218.5910099996 | 37.74956484585729 | -122.441619809413 | (37.7495648458573, -122.441619809413) | |||
| 182976 | 182976 | 227963 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 90 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005370.370519999 | 2103212.80554 | 37.7553255305724 | -122.42438398405899 | (37.7553255305724, -122.424383984059) | |||
| 103585 | 103585 | 60713 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1983 12:00:00 AM | 12 | 5x5 | Permit Number 20366 | 6005260.97523206 | 2105400.53272708 | 37.761326337757104 | -122.424917946837 | (37.7613263377571, -122.424917946837) | |
| 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) | |||
| 52216 | 52216 | 227894 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003800.9862 | 2108297.42077 | 37.7691979184882 | -122.430174105378 | (37.7691979184882, -122.430174105378) | |||
| 149844 | 149844 | 227895 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Belcher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003801.38989 | 2108316.99064 | 37.769251675456296 | -122.43017410535101 | (37.7692516754563, -122.430174105351) | |||
| 180898 | 180898 | 227893 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003803.161309999 | 2108272.90307 | 37.7691307220413 | -122.430164832458 | (37.7691307220413, -122.430164832458) | |||
| 153154 | 153154 | 32482 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 89 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 7 | 3x3 | Permit Number 36990 | 6000124.50964 | 2105955.15278 | 37.762557717473896 | -122.442722593195 | (37.7625577174739, -122.442722593195) |
| 46266 | 46266 | 227757 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 89 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007139.6685 | 2106793.6732099997 | 37.7652575146348 | -122.418519111993 | (37.7652575146348, -122.418519111993) | |||
| 154355 | 154355 | 191130 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 887 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012179.6238400005 | 2104272.6112 | 37.758617683286 | -122.400909853925 | (37.758617683286, -122.400909853925) | |||
| 160391 | 160391 | 120011 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 886 29th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5987003.60348 | 2109935.62097 | 37.7727302588392 | -122.48839498846 | (37.7727302588392, -122.48839498846) | |||
| 58680 | 58680 | 46532 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2002 12:00:00 AM | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) | |||
| 97453 | 97453 | 46531 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) | ||||
| 15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
| 15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
| 16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
| 54747 | 54747 | 121720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6014432.547780001 | 2103023.07571 | 37.755312138768204 | -122.39303073340099 | (37.7553121387682, -122.393030733401) | ||||
| 56286 | 56286 | 121708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014420.072369999 | 2103257.32043 | 37.7559546315195 | -122.393090266722 | (37.7559546315195, -122.393090266722) | ||||
| 60865 | 60865 | 121710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6014421.90164 | 2103226.1823299997 | 37.7558692345973 | -122.39308176182199 | (37.7558692345973, -122.393081761822) | ||||
| 69648 | 69648 | 191550 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014425.29285 | 2102980.5331200003 | 37.7551949229254 | -122.39305284682301 | (37.7551949229254, -122.393052846823) | ||||
| 74264 | 74264 | 121711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014421.639169999 | 2103213.20868 | 37.7558335971581 | -122.393081761812 | (37.7558335971581, -122.393081761812) | ||||
| 88170 | 88170 | 121721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 116383 | 116383 | 121705 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 121023 | 121023 | 121709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 131597 | 131597 | 121718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014431.62012 | 2103050.15485 | 37.7553864407519 | -122.393035836129 | (37.7553864407519, -122.393035836129) | ||||
| 148441 | 148441 | 121722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014436.80562 | 2102990.4188599996 | 37.7552227065741 | -122.39301372360599 | (37.7552227065741, -122.393013723606) | ||||
| 158352 | 158352 | 191549 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014417.54899 | 2103314.9204700002 | 37.756112648686795 | -122.393103023604 | (37.7561126486868, -122.393103023604) | ||||
| 164690 | 164690 | 121706 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6014418.475869999 | 2103299.96349 | 37.7560716315206 | -122.39309877161199 | (37.7560716315206, -122.393098771612) | ||||
| 166932 | 166932 | 121719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014433.09577 | 2103038.00285 | 37.7553531559357 | -122.39302988263799 | (37.7553531559357, -122.393029882638) | ||||
| 175212 | 175212 | 121714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014427.84636 | 2103131.0451599997 | 37.755608338569104 | -122.39305454654699 | (37.7556083385691, -122.393054546547) | ||||
| 177683 | 177683 | 121712 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014424.3017 | 2103198.95123 | 37.755794597164396 | -122.393071556308 | (37.7557945971644, -122.393071556308) | ||||
| 177856 | 177856 | 121713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014428.12864 | 2103144.99804 | 37.755646665865605 | -122.39305454654499 | (37.7556466658656, -122.393054546545) | ||||
| 183264 | 183264 | 121707 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014418.633880001 | 2103271.30813 | 37.755992958831705 | -122.393096220215 | (37.7559929588317, -122.393096220215) | ||||
| 49082 | 49082 | 81252 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 877 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | 6011897.37583 | 2104298.81412 | 37.7586738828079 | -122.40188784325001 | (37.7586738828079, -122.40188784325) | ||
| 70702 | 70702 | 103127 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 871 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6x9 | 6012175.18388 | 2104366.0320599996 | 37.758873948693 | -122.40093177310499 | (37.758873948693, -122.400931773105) | |||
| 181716 | 181716 | 227844 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 870 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003075.387490001 | 2103155.88804 | 37.7550393860631 | -122.43231665379601 | (37.7550393860631, -122.432316653796) | |||
| 30357 | 30357 | 227761 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.61046 | 2099602.37866 | 37.745415306472204 | -122.42393276538601 | (37.7454153064722, -122.423932765386) | |||
| 59487 | 59487 | 227538 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.60172 | 2099601.35924 | 37.7454125068841 | -122.42393272313 | (37.7454125068841, -122.42393272313) | |||
| 97436 | 97436 | 62351 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22494 | 6005350.50245062 | 2099593.00770081 | 37.7453852789219 | -122.424195268575 | (37.7453852789219, -122.424195268575) | ||
| 160181 | 160181 | 227765 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 869 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001308.58538 | 2101306.39787 | 37.7498607911403 | -122.438294258574 | (37.7498607911403, -122.438294258574) | |||
| 39152 | 39152 | 227713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 869 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998668.89091 | 2107167.7132099997 | 37.765804015560605 | -122.447844329357 | (37.7658040155606, -122.447844329357) | |||
| 177100 | 177100 | 191131 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 863 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012174.34155 | 2104398.8086099997 | 37.758963898878996 | -122.400936989166 | (37.758963898879, -122.400936989166) | |||
| 26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
| 50356 | 50356 | 200269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014632.09061 | 2089229.7896900002 | 37.7174496841459 | -122.39137645477501 | (37.7174496841459, -122.391376454775) | |||
| 51688 | 51688 | 200270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014621.84489 | 2089234.87823 | 37.717463087626705 | -122.39141222532 | (37.7174630876267, -122.39141222532) | |||
| 63521 | 63521 | 200266 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014773.14657 | 2089094.60205 | 37.7170863130726 | -122.39087944264999 | (37.7170863130726, -122.39087944265) | |||
| 151014 | 151014 | 200268 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014637.958740001 | 2089223.7051900001 | 37.7174333029868 | -122.39135574608801 | (37.7174333029868, -122.391355746088) | |||
| 157992 | 157992 | 200265 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014784.79531 | 2089078.0954900002 | 37.7170416356268 | -122.390838025257 | (37.7170416356268, -122.390838025257) | |||
| 187258 | 187258 | 191132 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 853 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012171.3747 | 2104414.8785 | 37.759007857755 | -122.400948379065 | (37.759007857755, -122.400948379065) | |||
| 133383 | 133383 | 227723 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 851 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999127.12543 | 2107358.99693 | 37.766355413304 | -122.446273160673 | (37.766355413304, -122.446273160673) | |||
| 92227 | 92227 | 94505 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x15 | 5999436.0 | 2106966.0 | 37.7652939775851 | -122.445176567667 | (37.7652939775851, -122.445176567667) | |||
| 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) | |||
| 154610 | 154610 | 208070 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Marcela Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994562.006580001 | 2100534.56463 | 37.7473554966651 | -122.461568117774 | (37.7473554966651, -122.461568117774) | |||
| 151977 | 151977 | 227775 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 847 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000923.85721 | 2101987.44345 | 37.7517088889594 | -122.439673482255 | (37.7517088889594, -122.439673482255) | |||
| 24770 | 24770 | 227722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 845 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999121.83175 | 2107384.4786900003 | 37.7664250774754 | -122.44629330369601 | (37.7664250774754, -122.446293303696) | |||
| 1457 | 1457 | 248600 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 840 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17869 | 5997201.7532 | 2107543.996 | 37.7667532252023 | -122.452945984051 | (37.7667532252023, -122.452945984051) | |
| 93583 | 93583 | 58647 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 840 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17869 | 5997188.31162677 | 2107608.64597093 | 37.7669299671715 | -122.45299714312 | (37.7669299671715, -122.45299714312) | ||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) |
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");