Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141839 | 141839 | 115853 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401x KANSAS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011620.0 | 2106285.0 | 37.764112022223394 | -122.402986839965 | (37.7641120222234, -122.402986839965) | |||||
| 9602 | 9602 | 40720 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748834998 | (37.7391809774349, -122.41025748835) | ||
| 10041 | 10041 | 173806 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007805.7000400005 | 2120292.0567099997 | 37.802358278640206 | -122.41717203578699 | (37.8023582786402, -122.417172035787) | ||||
| 14149 | 14149 | 105282 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009783.34609 | 2111415.87404 | 37.7780974817408 | -122.40970150032899 | (37.7780974817408, -122.409701500329) | |||
| 18521 | 18521 | 19046 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 115 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995705.68255 | 2087377.98209 | 37.711296457039204 | -122.45666206600201 | (37.7112964570392, -122.456662066002) | |||
| 21964 | 21964 | 52299 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | ||
| 23700 | 23700 | 222864 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.753232969139795 | -122.413002991602 | (37.7532329691398, -122.413002991602) | |||
| 25251 | 25251 | 244200 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 540 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003980.524 | 2109759.8502 | 37.773223560287796 | -122.429657410606 | (37.7732235602878, -122.429657410606) | |||
| 27674 | 27674 | 33308 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1534 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | Permit Number 37456 | 6004490.72276 | 2120176.84619 | 37.8018548920575 | -122.42863526732 | (37.8018548920575, -122.42863526732) | |
| 29660 | 29660 | 74449 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 21 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2000 12:00:00 AM | 9 | 6014188.34415 | 2094602.28938 | 37.732176853381205 | -122.393286035632 | (37.7321768533812, -122.393286035632) | ||
| 30476 | 30476 | 244481 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001413.516 | 2109405.0473 | 37.77210367272939 | -122.43851158928499 | (37.7721036727294, -122.438511589285) | |||
| 33544 | 33544 | 44052 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3100 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43582 | 6001963.46914 | 2118819.46564 | 37.79798453192029 | -122.43728348086901 | (37.7979845319203, -122.437283480869) | ||
| 37424 | 37424 | 40707 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 49 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41686 | 6002532.07349 | 2093390.4237799998 | 37.728194869385796 | -122.433497753227 | (37.7281948693858, -122.433497753227) | |
| 38168 | 38168 | 59248 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 939 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 9 | Permit Number 18580 | 6007864.8919400005 | 2120254.38142 | 37.8022581615512 | -122.41696453128999 | (37.8022581615512, -122.41696453129) | ||
| 40338 | 40338 | 222869 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997758.85551 | 2107160.25032 | 37.765731467257396 | -122.45099139535299 | (37.7657314672574, -122.450991395353) | |||
| 40399 | 40399 | 125952 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.79789841912879 | -122.437172562074 | (37.7978984191288, -122.437172562074) | |||
| 42583 | 42583 | 32638 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 787 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 13 | Permit Number 37084 | 6011713.6673099995 | 2109582.88625 | 37.77317250104971 | -122.402894833955 | (37.7731725010497, -122.402894833955) | |
| 46237 | 46237 | 247494 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002693.3039 | 2109766.0565 | 37.77316763021489 | -122.434110515465 | (37.7731676302149, -122.434110515465) | |||
| 46896 | 46896 | 175829 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994644.581040001 | 2086786.22758 | 37.709610656266996 | -122.460286627948 | (37.709610656267, -122.460286627948) | |||
| 47789 | 47789 | 73626 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994249.9774400005 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | ||
| 49111 | 49111 | 40430 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 242 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1999 12:00:00 AM | Permit Number 41525 | 6007877.26148184 | 2097485.40267829 | 37.7397406088372 | -122.415308947554 | (37.7397406088372, -122.415308947554) | ||
| 51627 | 51627 | 49757 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1360 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46553 | 6011586.487000001 | 2088506.8492599998 | 37.7152951315438 | -122.40185297295601 | (37.7152951315438, -122.401852972956) | |
| 53157 | 53157 | 32629 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37081 | 6011821.137130001 | 2109777.45892 | 37.7737127534642 | -122.40253676438299 | (37.7737127534642, -122.402536764383) | |
| 55015 | 55015 | 222871 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | |||
| 56122 | 56122 | 59251 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 955 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 15 | Permit Number 18583 | 6007775.57137 | 2120243.85461 | 37.8022242328199 | -122.417272878267 | (37.8022242328199, -122.417272878267) | ||
| 57495 | 57495 | 71603 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994523.67906 | 2086453.64687 | 37.708690512219206 | -122.460680397897 | (37.7086905122192, -122.460680397897) | ||
| 58198 | 58198 | 37963 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 655 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 11 | Permit Number 40194 | 6014150.1956400005 | 2104114.25281 | 37.75829258736211 | -122.39408358501001 | (37.7582925873621, -122.39408358501) | |
| 61853 | 61853 | 116770 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 307 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x6 | 6013506.88243 | 2105617.60092 | 37.7623846762351 | -122.39641383275101 | (37.7623846762351, -122.396413832751) | |||
| 63245 | 63245 | 71602 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.46031306439899 | (37.7084405258897, -122.460313064399) | ||
| 64137 | 64137 | 75992 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 188 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994660.40681 | 2086732.9831599998 | 37.7094653698917 | -122.46022807666401 | (37.7094653698917, -122.460228076664) | ||
| 64872 | 64872 | 38246 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.41515711380501 | (37.7684933273993, -122.415157113805) | ||
| 67016 | 67016 | 205980 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | |||
| 70259 | 70259 | 71645 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 193 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994617.0264 | 2086718.3617900002 | 37.7094227276519 | -122.460376946856 | (37.7094227276519, -122.460376946856) | ||
| 71722 | 71722 | 101286 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3333 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001806.51614 | 2119614.34242 | 37.8001581312395 | -122.43788354539 | (37.8001581312395, -122.43788354539) | |||
| 72847 | 72847 | 65051 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3026 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2013 12:00:00 AM | 5 | Permit Number 769905 | 6003418.47474 | 2118846.82882 | 37.7981422694136 | -122.432250702931 | (37.7981422694136, -122.432250702931) | ||
| 73171 | 73171 | 222867 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005333.3615 | 2101936.42428 | 37.751818794216206 | -122.424421190788 | (37.7518187942162, -122.424421190788) | |||
| 75387 | 75387 | 123032 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 660 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991952.29381 | 2110935.71162 | 37.775763734780504 | -122.47134996528 | (37.7757637347805, -122.47134996528) | |||
| 77568 | 77568 | 115854 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 80967 | 80967 | 32635 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | ||
| 81403 | 81403 | 52318 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 4354DOUGLASS 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48474 | 6000907.18250943 | 2103314.58552811 | 37.7553519514145 | -122.439826288335 | (37.7553519514145, -122.439826288335) | ||
| 81997 | 81997 | 47695 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45494 | 6004612.55463086 | 2097920.97092871 | 37.7407525536623 | -122.42662793081999 | (37.7407525536623, -122.42662793082) | ||
| 83424 | 83424 | 35160 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38691 | 6002701.11607915 | 2109682.95719093 | 37.7729399034438 | -122.43407755068701 | (37.7729399034438, -122.434077550687) | ||
| 85731 | 85731 | 26664 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1997 12:00:00 AM | 12 | 3X3 | 6005893.217896201 | 2099270.732028 | 37.7445310117825 | -122.422295750657 | (37.7445310117825, -122.422295750657) | ||
| 86213 | 86213 | 35150 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 220 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | ||
| 90110 | 90110 | 42464 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 673 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42606 | 5996989.53231216 | 2095248.10603498 | 37.7329795980092 | -122.452792452541 | (37.7329795980092, -122.452792452541) | ||
| 91541 | 91541 | 35990 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 3x3 | Permit Number 39141 | 6006789.604255901 | 2098298.49411338 | 37.7419119870032 | -122.41912727155199 | (37.7419119870032, -122.419127271552) | |
| 91636 | 91636 | 40256 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | ||
| 95602 | 95602 | 52141 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | Permit Number 48322 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | ||
| 99287 | 99287 | 37428 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1223 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39903 | 6003243.0646952 | 2101122.55260682 | 37.749465833086205 | -122.431591620497 | (37.7494658330862, -122.431591620497) | ||
| 99424 | 99424 | 48741 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 964 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46597 | 6009929.68094635 | 2103590.07459933 | 37.7566178319635 | -122.40864306235001 | (37.7566178319635, -122.40864306235) | ||
| 100404 | 100404 | 60676 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1983 12:00:00 AM | 12 | Permit Number 20313 | 6001422.6196434 | 2109409.49491386 | 37.772116402608 | -122.438480417824 | (37.772116402608, -122.438480417824) | ||
| 100678 | 100678 | 35156 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1076 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38687 | 6001413.36342647 | 2109408.19644929 | 37.772112310828206 | -122.43851234271999 | (37.7721123108282, -122.43851234272) | ||
| 107637 | 107637 | 37019 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.41296855192302 | (37.753266951872, -122.412968551923) | ||
| 116229 | 116229 | 52257 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | ||
| 117240 | 117240 | 48945 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 819 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46132 | 6009934.90888897 | 2104445.04060173 | 37.758965669214795 | -122.408685294891 | (37.7589656692148, -122.408685294891) | ||
| 117622 | 117622 | 36005 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39154 | 6008606.55118779 | 2100215.49511804 | 37.7472778014217 | -122.412980345984 | (37.7472778014217, -122.412980345984) | ||
| 118234 | 118234 | 38808 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 202 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963120995 | 2111590.96099347 | 37.7788497186051 | -122.39287985258801 | (37.7788497186051, -122.392879852588) | ||
| 118937 | 118937 | 34576 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | ||
| 120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) | |||
| 123596 | 123596 | 50666 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | |||
| 123628 | 123628 | 37175 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39748 | 6005894.17436162 | 2099270.44010947 | 37.7445302641925 | -122.42229242265101 | (37.7445302641925, -122.422292422651) | ||
| 124458 | 124458 | 35063 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1600 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | ||
| 126483 | 126483 | 49776 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.710775910974704 | -122.406280195673 | (37.7107759109747, -122.406280195673) | ||
| 126665 | 126665 | 52212 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | |||
| 127524 | 127524 | 37556 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 4528 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1998 12:00:00 AM | Permit Number 39995 | 6000974.70295267 | 2104668.04462068 | 37.7590720640705 | -122.439689810342 | (37.7590720640705, -122.439689810342) | ||
| 129164 | 129164 | 35972 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 323 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39130 | 6006883.86528874 | 2096321.14092587 | 37.7364879223661 | -122.41866115506399 | (37.7364879223661, -122.418661155064) | ||
| 129275 | 129275 | 68712 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32625 | 6003279.54613576 | 2105963.01747728 | 37.762758666054395 | -122.43181103593099 | (37.7627586660544, -122.431811035931) | ||
| 129865 | 129865 | 222882 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.740738898373706 | -122.42665275413201 | (37.7407388983737, -122.426652754132) | |||
| 130456 | 130456 | 205978 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 26 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993683.84565 | 2099240.9868799997 | 37.7437530733501 | -122.464510801149 | (37.7437530733501, -122.464510801149) | |||
| 131181 | 131181 | 125965 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 960 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007714.843640001 | 2120286.14045 | 37.8023369223605 | -122.41748602476801 | (37.8023369223605, -122.417486024768) | |||
| 131526 | 131526 | 78188 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 61 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | ||
| 132028 | 132028 | 32658 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 18 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 12 | Permit Number 37091 | 6011613.66818 | 2110190.11377 | 37.7748342242639 | -122.40328347056999 | (37.7748342242639, -122.40328347057) | |
| 132154 | 132154 | 59247 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 10 | Permit Number 24729 | 6008002.901330001 | 2120325.62134 | 37.8024615306389 | -122.41649199961701 | (37.8024615306389, -122.416491999617) | |
| 132217 | 132217 | 247474 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 850 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002489.937999999 | 2109552.4307 | 37.772569522732795 | -122.43479870425301 | (37.7725695227328, -122.434798704253) | |||
| 132484 | 132484 | 59252 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 961 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 11 | Permit Number 18584 | 6007751.14837 | 2120241.22842 | 37.8022156478981 | -122.41735720767599 | (37.8022156478981, -122.417357207676) | ||
| 136116 | 136116 | 222865 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | |||
| 136942 | 136942 | 188460 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011827.042669999 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | |||
| 138414 | 138414 | 42255 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | ||
| 139079 | 139079 | 50085 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | ||
| 140209 | 140209 | 37586 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 2775 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40017 | 6001162.31345404 | 2105517.18376133 | 37.7614142693336 | -122.439101823773 | (37.7614142693336, -122.439101823773) | ||
| 140537 | 140537 | 41705 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.733954758005794 | -122.431850206764 | (37.7339547580058, -122.431850206764) | ||
| 140635 | 140635 | 32637 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.773533368787106 | -122.402722477064 | (37.7735333687871, -122.402722477064) | ||
| 141184 | 141184 | 45193 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2001 12:00:00 AM | Permit Number 44037 | 5997793.88507772 | 2107168.4294301 | 37.765755930379704 | -122.45087082602 | (37.7657559303797, -122.45087082602) | ||
| 141667 | 141667 | 34617 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3299 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38300 | 5999016.0246967 | 2115927.38259794 | 37.789875646134895 | -122.44727418368 | (37.7898756461349, -122.44727418368) | ||
| 151386 | 151386 | 125962 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 952 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007785.23718 | 2120295.4388099997 | 37.802366413836204 | -122.41724308731001 | (37.8023664138362, -122.41724308731) | |||
| 151433 | 151433 | 125953 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999000.411280001 | 2115755.88881 | 37.7894038772406 | -122.44731585625799 | (37.7894038772406, -122.447315856258) | |||
| 154306 | 154306 | 49782 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 11 | Permit Number 46567 | 6012093.71999 | 2087090.7414400002 | 37.711435076735 | -122.40000035424801 | (37.711435076735, -122.400000354248) | |
| 155668 | 155668 | 247476 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 856 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | |||
| 155727 | 155727 | 42253 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 439 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | Permit Number 42498 | 6011074.3833099995 | 2112201.77293 | 37.7803276394387 | -122.405290671934 | (37.7803276394387, -122.405290671934) | |
| 155799 | 155799 | 222877 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003276.24685 | 2105959.7003900004 | 37.7627493711059 | -122.43182221013001 | (37.7627493711059, -122.43182221013) | |||
| 162578 | 162578 | 205979 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.743715225367104 | -122.46489100842301 | (37.7437152253671, -122.464891008423) | |||
| 163850 | 163850 | 106234 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 785 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6011757.19214 | 2109625.51022 | 37.7732919669825 | -122.40274727317801 | (37.7732919669825, -122.402747273178) | ||||
| 164317 | 164317 | 222874 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 462 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001154.00187 | 2103552.8212599996 | 37.7560201354351 | -122.43898978706999 | (37.7560201354351, -122.43898978707) | |||
| 164782 | 164782 | 125963 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007766.23356 | 2120291.4942799998 | 37.8023545140073 | -122.41730856964399 | (37.8023545140073, -122.417308569644) | |||
| 166599 | 166599 | 33139 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3122 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 14 | Permit Number 37366 | 6001955.19491 | 2118883.5060400004 | 37.798159899724396 | -122.437316700005 | (37.7981598997244, -122.437316700005) | ||
| 168575 | 168575 | 222862 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008204.356240001 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | |||
| 170113 | 170113 | 222875 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.43182793522301 | (37.7340120027534, -122.431827935223) | |||
| 171391 | 171391 | 32659 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 55 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 14 | Permit Number 37092 | 6011762.8277199995 | 2110068.09254 | 37.7745075113438 | -122.402758910415 | (37.7745075113438, -122.402758910415) | |
| 176430 | 176430 | 59254 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 985 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 16 | Permit Number 18586 | 6007686.6975 | 2120231.45266 | 37.802185179755604 | -122.41757954618299 | (37.8021851797556, -122.417579546183) | ||
| 177603 | 177603 | 59249 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 948 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 10 | Permit Number 18581 | 6007857.82328 | 2120305.56138 | 37.80239829122 | -122.416992620734 | (37.80239829122, -122.416992620734) |
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");