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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79389 | 79389 | 98269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscape plot | Permit Number 768491 | 6009963.0 | 2103401.0 | 37.7561005415225 | -122.40851449565001 | (37.7561005415225, -122.40851449565) | |
| 25648 | 25648 | 191123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012425.58055 | 2105029.27463 | 37.7607090306229 | -122.400112358502 | (37.7607090306229, -122.400112358502) | |||
| 26311 | 26311 | 227767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000143.14107 | 2101645.6357400003 | 37.7507259002966 | -122.442348757612 | (37.7507259002966, -122.442348757612) | |||
| 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) | |||
| 46453 | 46453 | 227940 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2814 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 8ft | 6009799.68867 | 2100909.2655700003 | 37.74924964606829 | -122.40890348783 | (37.7492496460683, -122.40890348783) | |||
| 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) | |||
| 132565 | 132565 | 227768 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6000154.6428 | 2101646.40611 | 37.750728671093704 | -122.442309039053 | (37.7507286710937, -122.442309039053) | |||
| 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) | |||
| 178697 | 178697 | 191124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012423.59359 | 2105049.6302900002 | 37.760764811978 | -122.400120660154 | (37.760764811978, -122.400120660154) | |||
| 50223 | 50223 | 191523 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 7ft | 6015501.46651 | 2104207.8933 | 37.7586247150714 | -122.389416796942 | (37.7586247150714, -122.389416796942) | |||
| 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) | |||
| 73547 | 73547 | 191524 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 7ft | 6015503.99036 | 2104179.13483 | 37.7585458903883 | -122.38940605994499 | (37.7585458903883, -122.389406059945) | |||
| 136710 | 136710 | 191525 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6015505.26646 | 2104138.41993 | 37.758434166722395 | -122.38939880333099 | (37.7584341667224, -122.389398803331) | |||
| 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) | |||
| 187394 | 187394 | 227947 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009924.719330001 | 2103404.59086 | 37.7561082572986 | -122.40864713697901 | (37.7561082572986, -122.408647136979) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 136347 | 136347 | 227799 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 6ft | 5997473.24622 | 2105221.8097 | 37.760392645519 | -122.45183939756599 | (37.760392645519, -122.451839397566) | |||
| 156293 | 156293 | 227999 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1227 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 5997427.0236 | 2105612.47787 | 37.7614626741762 | -122.452027445805 | (37.7614626741762, -122.452027445805) | |||
| 162441 | 162441 | 227985 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 222 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6004405.37253 | 2099591.374 | 37.7453273824517 | -122.427463259139 | (37.7453273824517, -122.427463259139) | |||
| 162889 | 162889 | 227543 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Trainor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6008303.693390001 | 2108185.76376 | 37.769145333323294 | -122.41459153249501 | (37.7691453333233, -122.414591532495) | |||
| 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) | |||
| 175402 | 175402 | 208063 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 459 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5993844.11289 | 2101701.56795 | 37.750518442888705 | -122.464135229877 | (37.7505184428887, -122.464135229877) | |||
| 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) | |||
| 327 | 327 | 191528 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.38772046693501 | (37.76689343092, -122.387720466935) | ||
| 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) | |||
| 27352 | 27352 | 227958 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3627 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6005410.5124699995 | 2104865.85603 | 37.7598666869207 | -122.42436272946199 | (37.7598666869207, -122.424362729462) | |||
| 28612 | 28612 | 129695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000588.35894 | 2116200.69282 | 37.7907158028324 | -122.441853689821 | (37.7907158028324, -122.441853689821) | |||
| 29643 | 29643 | 246620 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009078.777530001 | 2099136.29589 | 37.744341055486295 | -122.411271191437 | (37.7443410554863, -122.411271191437) | |||
| 29850 | 29850 | 129698 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000533.7718 | 2116193.1450799997 | 37.7906919681164 | -122.442042015953 | (37.7906919681164, -122.442042015953) | |||
| 30507 | 30507 | 129709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002148.23302 | 2117769.42382 | 37.795111892265 | -122.436568947899 | (37.795111892265, -122.436568947899) | |||
| 31751 | 31751 | 129693 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000643.07515 | 2116204.21556 | 37.7907285930009 | -122.44166462801701 | (37.7907285930009, -122.441664628017) | |||
| 34137 | 34137 | 227955 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 19 Oakwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005250.99369 | 2105400.57172 | 37.761325881014 | -122.42495247159901 | (37.761325881014, -122.424952471599) | |||
| 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) | |||
| 34535 | 34535 | 129708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002098.95319 | 2117845.28879 | 37.7953173972439 | -122.43674489666 | (37.7953173972439, -122.43674489666) | |||
| 35111 | 35111 | 227862 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6004103.9626400005 | 2102911.44983 | 37.754426484617895 | -122.428742121152 | (37.7544264846179, -122.428742121152) | |||
| 35322 | 35322 | 227855 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 165 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004140.81956 | 2102204.0553900003 | 37.7524862314611 | -122.428564239772 | (37.7524862314611, -122.428564239772) | |||
| 36027 | 36027 | 123795 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5993809.03734 | 2112124.4569200003 | 37.7791349418605 | -122.465013428941 | (37.7791349418605, -122.465013428941) | |||
| 36206 | 36206 | 191526 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.766879529196295 | -122.387914043316 | (37.7668795291963, -122.387914043316) | |||
| 36858 | 36858 | 227859 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004104.47801 | 2102871.3530599996 | 37.75431641748921 | -122.428737480655 | (37.7543164174892, -122.428737480655) | |||
| 37926 | 37926 | 129692 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6000656.11857 | 2116207.7557599996 | 37.790739056615706 | -122.441619752742 | (37.7907390566157, -122.441619752742) | |||
| 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) | |||
| 39995 | 39995 | 129696 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000569.369419999 | 2116197.48764 | 37.7907059201805 | -122.441919162241 | (37.7907059201805, -122.441919162241) | |||
| 43056 | 43056 | 191129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012185.62091 | 2103105.89638 | 37.7554144753107 | -122.400807145928 | (37.7554144753107, -122.400807145928) | |||
| 43198 | 43198 | 191533 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | |||
| 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) | |||
| 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) | |||
| 50633 | 50633 | 227818 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006782.14401 | 2097820.3325099996 | 37.7405986419274 | -122.419119157627 | (37.7405986419274, -122.419119157627) | |||
| 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) | |||
| 54764 | 54764 | 246617 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 179 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009150.0999300005 | 2099139.59949 | 37.7443541262592 | -122.411024805947 | (37.7443541262592, -122.411024805947) | |||
| 58277 | 58277 | 191531 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.766912939908295 | -122.387275369984 | (37.7669129399083, -122.387275369984) | |||
| 61629 | 61629 | 227941 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2501 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6009766.693530001 | 2102694.57253 | 37.754149854037706 | -122.40914354655399 | (37.7541498540377, -122.409143546554) | |||
| 63018 | 63018 | 191557 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011781.42001 | 2106326.42405 | 37.7642347759329 | -122.40243144478 | (37.7642347759329, -122.40243144478) | |||
| 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) | |||
| 65932 | 65932 | 227864 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 12 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6004060.23994 | 2102916.80485 | 37.7544387135775 | -122.428893707302 | (37.7544387135775, -122.428893707302) | |||
| 67084 | 67084 | 123796 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5993793.84449 | 2112124.03486 | 37.7791329069537 | -122.465065956135 | (37.7791329069537, -122.465065956135) | |||
| 68304 | 68304 | 191117 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 699 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6014453.67904 | 2103916.00921 | 37.757765116097495 | -122.39302012769501 | (37.7577651160975, -122.393020127695) | |||
| 69140 | 69140 | 191529 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6016082.02245 | 2107209.5732299997 | 37.7668988547309 | -122.387618372283 | (37.7668988547309, -122.387618372283) | |||
| 73021 | 73021 | 227798 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5997129.95127 | 2106058.68083 | 37.762670813522604 | -122.453087101682 | (37.7626708135226, -122.453087101682) | |||
| 73104 | 73104 | 200264 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014856.837309999 | 2088987.16565 | 37.716795957049996 | -122.390582658263 | (37.71679595705, -122.390582658263) | |||
| 74914 | 74914 | 246619 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009083.01922 | 2099139.1845299997 | 37.7443492249476 | -122.411256728527 | (37.7443492249476, -122.411256728527) | |||
| 75604 | 75604 | 227857 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 165 Vicksburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6004140.06884 | 2102221.88721 | 37.7525351509765 | -122.42856810684799 | (37.7525351509765, -122.428568106848) | |||
| 75672 | 75672 | 227962 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6005350.15285 | 2103584.35946 | 37.7563445892338 | -122.42448033021999 | (37.7563445892338, -122.42448033022) | |||
| 76361 | 76361 | 191530 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | |||
| 77064 | 77064 | 227939 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2706 Bryant St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6009765.64243 | 2101530.20177 | 37.7509526922342 | -122.409065028537 | (37.7509526922342, -122.409065028537) | |||
| 126748 | 126748 | 227945 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6009688.462780001 | 2104079.3196099997 | 37.7579476757639 | -122.40951181351299 | (37.7579476757639, -122.409511813513) | |||
| 130497 | 130497 | 129710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2384 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6002133.54538 | 2117765.5714 | 37.7951004798686 | -122.43661949341002 | (37.7951004798686, -122.43661949341) | |||
| 131786 | 131786 | 129694 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000599.2332 | 2116202.1611599997 | 37.7907204541334 | -122.44181617097999 | (37.7907204541334, -122.44181617098) | |||
| 134358 | 134358 | 200263 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014881.06262 | 2088948.3619 | 37.7166907534629 | -122.39049621274799 | (37.7166907534629, -122.390496212748) | |||
| 135212 | 135212 | 227953 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 19 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6005251.70429 | 2105361.1833200003 | 37.761217769911205 | -122.424947211467 | (37.7612177699112, -122.424947211467) | |||
| 137070 | 137070 | 227956 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 19 Oakwood St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6005249.63454 | 2105418.9882400003 | 37.7613763716539 | -122.424958482665 | (37.7613763716539, -122.424958482665) | |||
| 147013 | 147013 | 227856 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 165 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004139.46574 | 2102214.32779 | 37.752514360449794 | -122.42856965367399 | (37.7525143604498, -122.428569653674) | |||
| 147762 | 147762 | 208136 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 255x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993099.62509 | 2100246.71576 | 37.746480853819 | -122.466603967821 | (37.746480853819, -122.466603967821) | |||
| 150669 | 150669 | 227994 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1306 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6003859.6662099995 | 2100626.63224 | 37.748139081362794 | -122.42942403481001 | (37.7481390813628, -122.42942403481) | |||
| 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) | |||
| 155420 | 155420 | 129712 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2015 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6004384.23212 | 2117333.6145200003 | 37.7940420803335 | -122.42880096471701 | (37.7940420803335, -122.428800964717) | |||
| 157738 | 157738 | 191527 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.76688400872221 | -122.387813186138 | (37.7668840087222, -122.387813186138) | |||
| 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) | |||
| 158479 | 158479 | 227880 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3841 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6003992.09135 | 2104786.97969 | 37.759569913329 | -122.429262730611 | (37.759569913329, -122.429262730611) | |||
| 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) | |||
| 160515 | 160515 | 129697 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6000546.57197 | 2116195.20818 | 37.7906983622821 | -122.441997876317 | (37.7906983622821, -122.441997876317) | |||
| 160654 | 160654 | 227797 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5997131.78555 | 2106048.44481 | 37.762642813136 | -122.453080018655 | (37.762642813136, -122.453080018655) | |||
| 161087 | 161087 | 129700 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000509.65087 | 2116188.56402 | 37.790678015119205 | -122.442125143875 | (37.7906780151192, -122.442125143875) | |||
| 162021 | 162021 | 227922 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 66 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6004271.33635 | 2097814.43726 | 37.7404407398594 | -122.42780014605499 | (37.7404407398594, -122.427800146055) | |||
| 162138 | 162138 | 227854 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 165 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6004142.14587 | 2102192.44756 | 37.7524544341373 | -122.42855882582701 | (37.7524544341373, -122.428558825827) | |||
| 163311 | 163311 | 191559 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011776.16151 | 2106411.778 | 37.7644688451864 | -122.40245563471399 | (37.7644688451864, -122.402455634714) | |||
| 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) | |||
| 165394 | 165394 | 227954 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 19 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6005250.78391 | 2105379.80731 | 37.7612688550002 | -122.42495171976101 | (37.7612688550002, -122.424951719761) | |||
| 166660 | 166660 | 191534 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016265.973669999 | 2107216.92727 | 37.7669292347089 | -122.386982621765 | (37.7669292347089, -122.386982621765) | |||
| 169931 | 169931 | 191532 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016209.16515 | 2107214.5091 | 37.766919449199 | -122.38717894646999 | (37.766919449199, -122.38717894647) | |||
| 170343 | 170343 | 227944 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2598 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6009724.544869999 | 2102254.83469 | 37.7529400707269 | -122.409258278447 | (37.7529400707269, -122.409258278447) | |||
| 173509 | 173509 | 191558 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011780.396819999 | 2106372.4113 | 37.7643609894929 | -122.402438217563 | (37.7643609894929, -122.402438217563) | |||
| 174324 | 174324 | 227942 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2498 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6009691.34242 | 2102846.16459 | 37.754561870337795 | -122.40941482795401 | (37.7545618703378, -122.409414827954) | |||
| 176023 | 176023 | 129701 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6000500.44634 | 2116185.5793 | 37.7906692952944 | -122.442156776619 | (37.7906692952944, -122.442156776619) | |||
| 176474 | 176474 | 227861 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004103.93841 | 2102899.4243799997 | 37.754393464190294 | -122.428741347735 | (37.7543934641903, -122.428741347735) | |||
| 177208 | 177208 | 129711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2015 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6004372.94608 | 2117332.24552 | 37.7940376826321 | -122.428839917937 | (37.7940376826321, -122.428839917937) | |||
| 179466 | 179466 | 228000 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1229 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 5997430.92734 | 2105573.7354599996 | 37.761356520915896 | -122.452011149197 | (37.7613565209159, -122.452011149197) |
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");