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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134959 | 134959 | 68463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 8 | Permit Number 32325 | 5991519.12103 | 2113131.34732 | 37.781767281646204 | -122.473008553548 | (37.7817672816462, -122.473008553548) | |
| 121033 | 121033 | 38222 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40349 | 5991678.28674141 | 2099849.72262287 | 37.745308688082396 | -122.471489828106 | (37.7453086880824, -122.471489828106) | |||
| 153199 | 153199 | 208100 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991679.25346 | 2099828.9819099996 | 37.7452517953444 | -122.471484974349 | (37.7452517953444, -122.471484974349) | |||
| 26594 | 26594 | 208099 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991681.99819 | 2099835.94672 | 37.745271077706704 | -122.471475991035 | (37.7452710777067, -122.471475991035) | |||
| 186783 | 186783 | 208098 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991684.149119999 | 2099849.94635 | 37.74530964152321 | -122.471469573465 | (37.7453096415232, -122.471469573465) | |||
| 44075 | 44075 | 124022 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991831.5909 | 2112929.38774 | 37.7812308417217 | -122.471912840662 | (37.7812308417217, -122.471912840662) | |||
| 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) | |||
| 111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
| 142779 | 142779 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
| 122400 | 122400 | 38006 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40217 | 5992035.60667724 | 2098055.00516972 | 37.740401516958705 | -122.47012362496099 | (37.7404015169587, -122.470123624961) | ||
| 153373 | 153373 | 208112 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992037.32657 | 2098038.7861599997 | 37.7403570831075 | -122.47011649758801 | (37.7403570831075, -122.470116497588) | |||
| 60879 | 60879 | 208111 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2559 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992039.89052 | 2098021.8056099997 | 37.740310607054894 | -122.470106396399 | (37.7403106070549, -122.470106396399) | |||
| 167306 | 167306 | 208019 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992092.96115 | 2106864.9565 | 37.7645946702215 | -122.470566813326 | (37.7645946702215, -122.470566813326) | |||
| 128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
| 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) | |||
| 60910 | 60910 | 97503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768347 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||
| 96178 | 96178 | 97500 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 102146 | 102146 | 97502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 111067 | 111067 | 97499 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 127577 | 127577 | 97501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 180850 | 180850 | 208057 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992245.259459999 | 2101079.6682 | 37.7487185865149 | -122.46961886943599 | (37.7487185865149, -122.469618869436) | |||
| 71209 | 71209 | 208056 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992245.83027 | 2101094.43022 | 37.7487591522095 | -122.46961797009399 | (37.7487591522095, -122.469617970094) | |||
| 67413 | 67413 | 208058 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992246.20583 | 2101062.80127 | 37.7486723289665 | -122.469614369217 | (37.7486723289665, -122.469614369217) | |||
| 68119 | 68119 | 208059 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992246.63721 | 2101046.2039400004 | 37.7486267819054 | -122.469611669441 | (37.7486267819054, -122.469611669441) | |||
| 29002 | 29002 | 208061 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992248.52602 | 2101024.65147 | 37.748567713538996 | -122.46960356926901 | (37.748567713539, -122.469603569269) | |||
| 148810 | 148810 | 208060 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992248.76597 | 2101036.0508 | 37.748599027031496 | -122.46960356926 | (37.7485990270315, -122.46960356926) | |||
| 188394 | 188394 | 208043 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992271.8581 | 2102134.57412 | 37.751616623007 | -122.469603676282 | (37.751616623007, -122.469603676282) | |||
| 154679 | 154679 | 208105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2339 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992296.97523 | 2099528.1746 | 37.7444615718506 | -122.469327124863 | (37.7444615718506, -122.469327124863) | |||
| 159073 | 159073 | 208104 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2349 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992300.54287 | 2099449.8007799997 | 37.7442465835224 | -122.469309085355 | (37.7442465835224, -122.469309085355) | |||
| 84595 | 84595 | 102523 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 3X3 | Permit Number 769544 | 5992300.8 | 2100554.8 | 37.7472806432819 | -122.46938861272601 | (37.7472806432819, -122.469388612726) | ||
| 129860 | 129860 | 208103 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2353 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992301.035730001 | 2099420.10379 | 37.7441650716512 | -122.469305220056 | (37.7441650716512, -122.469305220056) | |||
| 57153 | 57153 | 208102 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2357 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992303.47716 | 2099394.44752 | 37.7440947671662 | -122.46929491115401 | (37.7440947671662, -122.469294911154) | |||
| 74489 | 74489 | 208101 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2357 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992303.56626 | 2099363.27465 | 37.7440091795707 | -122.469292334575 | (37.7440091795707, -122.469292334575) | |||
| 152821 | 152821 | 208062 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5992310.81526 | 2100558.61038 | 37.7472916843786 | -122.469354258319 | (37.7472916843786, -122.469354258319) | |||
| 171296 | 171296 | 52472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1038@ 12th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | Permit Number 48583 | 5992323.330569999 | 2111390.84025 | 37.777034850900606 | -122.470099615521 | (37.7770348509006, -122.470099615521) | |
| 72962 | 72962 | 208050 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2338 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992343.816769999 | 2099531.60984 | 37.7444737108967 | -122.46916540785601 | (37.7444737108967, -122.469165407856) | |||
| 158220 | 158220 | 208049 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992344.1762 | 2099503.1223 | 37.744395512154796 | -122.46916209207899 | (37.7443955121548, -122.469162092079) | |||
| 25465 | 25465 | 208048 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2344 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992344.38135 | 2099463.27392 | 37.74428611053071 | -122.469158483081 | (37.7442861105307, -122.469158483081) | |||
| 73671 | 73671 | 208047 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2356 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992346.98246 | 2099405.01198 | 37.744126288412396 | -122.46914524958 | (37.7441262884124, -122.46914524958) | |||
| 56459 | 56459 | 208046 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2356 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992347.94359 | 2099384.54976 | 37.744070159913996 | -122.469140437284 | (37.744070159914, -122.469140437284) | |||
| 78079 | 78079 | 107066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1758 12th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/24/2014 12:00:00 AM | Permit Number 773344 | 5992506.32742 | 2103625.79831 | 37.7557246862805 | -122.468901366602 | (37.7557246862805, -122.468901366602) | |||
| 69538 | 69538 | 37593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 643 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40021 | 5992524.5893 | 2111069.01654 | 37.776162842853296 | -122.469379974251 | (37.7761628428533, -122.469379974251) | |
| 45512 | 45512 | 59134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | 7x7 | Permit Number 18439 | 5992554.02664 | 2110259.06028 | 37.7739406226936 | -122.469219178519 | (37.7739406226936, -122.469219178519) | |
| 72595 | 72595 | 208109 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992602.58698 | 2099633.7724 | 37.7447691723617 | -122.468278072002 | (37.7447691723617, -122.468278072002) | |||
| 158225 | 158225 | 208108 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992604.0801800005 | 2099624.3028 | 37.7447432574969 | -122.468272220082 | (37.7447432574969, -122.468272220082) | |||
| 58305 | 58305 | 208107 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992604.896919999 | 2099614.84743 | 37.7447173426335 | -122.468268708247 | (37.7447173426335, -122.468268708247) | |||
| 76625 | 76625 | 208106 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2367 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992612.0223 | 2099358.1816 | 37.744013015182 | -122.46822540229999 | (37.744013015182, -122.4682254023) | |||
| 180818 | 180818 | 208044 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992692.13842 | 2098948.0132400002 | 37.7428914239144 | -122.467918553594 | (37.7428914239144, -122.467918553594) | |||
| 172894 | 172894 | 208045 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992699.77164 | 2098959.9602799998 | 37.7429246682415 | -122.46789302904399 | (37.7429246682415, -122.467893029044) | |||
| 76968 | 76968 | 208097 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1578 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992786.16766 | 2104723.32687 | 37.7587543775304 | -122.468013427586 | (37.7587543775304, -122.468013427586) | |||
| 66100 | 66100 | 59119 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 534 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 16 | Permit Number 18423 | 5992850.01468 | 2111803.3179099998 | 37.778197836504 | -122.468307682232 | (37.778197836504, -122.468307682232) | ||
| 31555 | 31555 | 67316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 746 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 6 | Permit Number 30797 | 5992906.05892 | 2110364.3272599997 | 37.7742499931706 | -122.468009109205 | (37.7742499931706, -122.468009109205) | |
| 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) | |||
| 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) | |||
| 164304 | 164304 | 218332 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 490 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5992960.68129 | 2099942.11399 | 37.7456364758511 | -122.46706227402001 | (37.7456364758511, -122.46706227402) | |||
| 36958 | 36958 | 218331 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5992969.5872 | 2099943.88935 | 37.745641864594 | -122.46703160803601 | (37.745641864594, -122.467031608036) | |||
| 77020 | 77020 | 218330 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5992991.749009999 | 2099943.42348 | 37.7456418645961 | -122.46695494261499 | (37.7456418645961, -122.466954942615) | |||
| 70183 | 70183 | 218329 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5993003.09698 | 2099944.16622 | 37.745644558947895 | -122.466915757358 | (37.7456445589479, -122.466915757358) | |||
| 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) | |||
| 143009 | 143009 | 59112 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 671 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | 4x4 | Permit Number 18416 | 5993149.01942 | 2110913.66887 | 37.7757723653318 | -122.46720862222901 | (37.7757723653318, -122.467208622229) | |
| 85162 | 85162 | 66759 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 735 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1991 12:00:00 AM | 10 | 3x3 | Permit Number 30012 | 5993166.4558 | 2110466.57208 | 37.7745457641687 | -122.46711579213002 | (37.7745457641687, -122.46711579213) | |
| 31015 | 31015 | 59108 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 616 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18411 | 5993182.92211 | 2111277.08736 | 37.7767721716598 | -122.46711777381901 | (37.7767721716598, -122.467117773819) | ||
| 74832 | 74832 | 208034 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 335 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993191.52104 | 2104559.2790099997 | 37.7583273452475 | -122.46659961690001 | (37.7583273452475, -122.4665996169) | |||
| 40839 | 40839 | 208110 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5993194.87968 | 2099514.9753099997 | 37.744477176897504 | -122.466221422307 | (37.7444771768975, -122.466221422307) | |||
| 162228 | 162228 | 208033 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 335 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5993206.76196 | 2104560.12177 | 37.7583305387516 | -122.466546968789 | (37.7583305387516, -122.466546968789) | |||
| 170340 | 170340 | 218321 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 414 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5993266.671709999 | 2099966.5931 | 37.7457213466715 | -122.466005992402 | (37.7457213466715, -122.466005992402) | |||
| 128383 | 128383 | 106785 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 335 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x8 | 5993281.0 | 2104569.0 | 37.7583591997637 | -122.466290868324 | (37.7583591997637, -122.466290868324) | |||
| 50220 | 50220 | 218320 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5993320.26177 | 2099984.60198 | 37.7457738859626 | -122.465821995605 | (37.7457738859626, -122.465821995605) | |||
| 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) | |||
| 187159 | 187159 | 208135 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 15x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | |||
| 44840 | 44840 | 208096 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1504 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993391.51426 | 2105173.9377900003 | 37.760026577386206 | -122.465952620345 | (37.7600265773862, -122.465952620345) | |||
| 167431 | 167431 | 208095 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1506 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993392.85982 | 2105153.99383 | 37.759971894093596 | -122.465946517542 | (37.7599718940936, -122.465946517542) | |||
| 89696 | 89696 | 111418 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 5 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 103771 | 103771 | 111426 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 11 | Median : Yard 3 | Tree 1 | Private 1 | 6 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 128515 | 128515 | 48660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1518 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51136 | 5993396.16596973 | 2105141.2714508 | 37.7599371524818 | -122.465934158818 | (37.7599371524818, -122.465934158818) | ||
| 123711 | 123711 | 208032 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 245 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993439.73777 | 2104571.93456 | 37.7583764149554 | -122.46574210073601 | (37.7583764149554, -122.465742100736) | |||
| 166387 | 166387 | 67337 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 639 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | 9 | Permit Number 30821 | 5993452.94224 | 2111127.09035 | 37.776375902741 | -122.46617279824899 | (37.776375902741, -122.466172798249) | |
| 178079 | 178079 | 122999 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 42 07th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993659.38134 | 2115213.58534 | 37.787608218531794 | -122.46575564845699 | (37.7876082185318, -122.465755648457) | |||
| 84243 | 84243 | 109102 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
| 97430 | 97430 | 109101 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
| 72798 | 72798 | 208031 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1639 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5993679.7904900005 | 2104335.94155 | 37.7577422831841 | -122.46489476039801 | (37.7577422831841, -122.464894760398) | |||
| 33653 | 33653 | 208029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993680.14998 | 2104375.72277 | 37.7578515328401 | -122.464896406148 | (37.7578515328401, -122.464896406148) | |||
| 170254 | 170254 | 208030 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5993680.60393 | 2104352.02929 | 37.7577865028534 | -122.464893115536 | (37.7577865028534, -122.464893115536) | |||
| 130544 | 130544 | 208028 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1616 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993726.3852 | 2104458.9958200003 | 37.7580828447759 | -122.46474255373 | (37.7580828447759, -122.46474255373) | |||
| 167660 | 167660 | 208024 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1652 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993734.6687900005 | 2104236.25735 | 37.7574717401585 | -122.464697731525 | (37.7574717401585, -122.464697731525) | |||
| 179894 | 179894 | 208025 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1652 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993735.965559999 | 2104244.11909 | 37.7574934012238 | -122.464693817688 | (37.7574934012238, -122.464693817688) | |||
| 37797 | 37797 | 208027 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1648 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993736.02678 | 2104273.98394 | 37.7575754059053 | -122.464695774593 | (37.7575754059053, -122.464695774593) | |||
| 151047 | 151047 | 208022 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1670 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5993736.11126 | 2104143.24753 | 37.7572164424068 | -122.46468598908301 | (37.7572164424068, -122.464685989083) | |||
| 54384 | 54384 | 208026 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1648 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993736.35584 | 2104262.7066 | 37.7575444602181 | -122.464693817678 | (37.7575444602181, -122.464693817678) | |||
| 66953 | 66953 | 208023 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1662 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993736.46788 | 2104187.19404 | 37.7573371287194 | -122.46468794689899 | (37.7573371287194, -122.464687946899) | |||
| 43808 | 43808 | 208021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1684 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993741.97238 | 2104049.76533 | 37.7569601023484 | -122.464658931187 | (37.7569601023484, -122.464658931187) | |||
| 52402 | 52402 | 208035 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1722 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993749.1972900005 | 2103750.68638 | 37.7561393252901 | -122.464612228482 | (37.7561393252901, -122.464612228482) | |||
| 51342 | 51342 | 208037 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1794 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993763.2785 | 2103312.19081 | 37.7549361412039 | -122.46453169330299 | (37.7549361412039, -122.464531693303) | |||
| 36852 | 36852 | 208036 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1780 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993763.84013 | 2103377.07875 | 37.755114339159896 | -122.46453446231199 | (37.7551143391599, -122.464534462312) | |||
| 172704 | 172704 | 208038 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993764.599359999 | 2103288.67174 | 37.754871640034 | -122.46452541781 | (37.754871640034, -122.46452541781) | |||
| 41944 | 41944 | 208039 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993764.89188 | 2103262.79505 | 37.7548006061648 | -122.464522527406 | (37.7548006061648, -122.464522527406) | |||
| 41985 | 41985 | 208040 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993765.03944 | 2103252.9034 | 37.7547734547454 | -122.464521298918 | (37.7547734547454, -122.464521298918) | |||
| 157634 | 157634 | 208041 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993766.80604 | 2103235.31839 | 37.7547252726705 | -122.46451391281299 | (37.7547252726705, -122.464513912813) | |||
| 178319 | 178319 | 208042 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993767.09464 | 2103220.25366 | 37.7546839254342 | -122.464511820986 | (37.7546839254342, -122.464511820986) | |||
| 156691 | 156691 | 106659 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 492 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x9 | 5993768.84062 | 2112215.6427700003 | 37.7793829957774 | -122.465159109631 | (37.7793829957774, -122.465159109631) |
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");