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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125202 | 125202 | 1546 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5995568.83899 | 2112743.54668 | 37.7809361120605 | -122.458970433284 | (37.7809361120605, -122.458970433284) | |||
| 143104 | 143104 | 1547 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995572.6443300005 | 2112729.1538400003 | 37.7808968119003 | -122.458956226418 | (37.7808968119003, -122.458956226418) | |||
| 90820 | 90820 | 1548 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995571.41042 | 2112712.2375 | 37.7808502932087 | -122.45895926991501 | (37.7808502932087, -122.458959269915) | |||
| 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) | |||
| 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) | ||
| 21196 | 21196 | 28504 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | |||
| 141550 | 141550 | 28505 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | |||
| 102262 | 102262 | 28506 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | |||
| 69719 | 69719 | 32628 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37081 | 6011809.7571 | 2109765.86877 | 37.7736802942351 | -122.40257531472601 | (37.7736802942351, -122.402575314726) | |
| 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) | |
| 104661 | 104661 | 32630 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 7 | 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) | ||
| 90837 | 90837 | 32631 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 3 | 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) | ||
| 88232 | 88232 | 32632 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 6 | 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) | ||
| 106614 | 106614 | 32633 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 4 | 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) | ||
| 89682 | 89682 | 32634 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 2 | 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) | ||
| 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) | ||
| 108330 | 108330 | 32636 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 5 | 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) | ||
| 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) | ||
| 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) | |
| 165372 | 165372 | 32639 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 787 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 11 | Permit Number 37084 | 6011743.68261 | 2109609.56566 | 37.7732474325671 | -122.402792883183 | (37.7732474325671, -122.402792883183) | |
| 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) | |
| 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) | |
| 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) | ||
| 85898 | 85898 | 33286 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1055@Clay Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2002 12:00:00 AM | 3x3 | Permit Number 44830 | 6009456.49724061 | 2116992.25574546 | 37.7933905675371 | -122.411226210566 | (37.7933905675371, -122.411226210566) | |
| 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) | |
| 78946 | 78946 | 34015 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1570 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46940 | 5986558.24673304 | 2104566.10079282 | 37.7579610536344 | -122.48954058892001 | (37.7579610536344, -122.48954058892) | ||
| 90669 | 90669 | 34575 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 2 | 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) | ||
| 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) | ||
| 142465 | 142465 | 34577 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 3 | 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) | ||
| 105959 | 105959 | 34580 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2012 12:00:00 AM | Permit Number 769651 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | |||
| 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) | ||
| 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) | ||
| 92668 | 92668 | 35064 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1600 10th Ave | 2 | 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) | ||
| 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) | ||
| 97829 | 97829 | 35151 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 220 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 109821 | 109821 | 37018 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 78366 | 78366 | 38245 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 2 | 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) | ||
| 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) | ||
| 138867 | 138867 | 38247 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.41515711380501 | (37.7684933273993, -122.415157113805) | |
| 87280 | 87280 | 38807 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 202 Townsend St | 2 | 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) | ||
| 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) | ||
| 140149 | 140149 | 38809 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 202 Townsend St | 3 | 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) | ||
| 106226 | 106226 | 40255 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 115591 | 115591 | 41704 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 2 | 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) | ||
| 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) | ||
| 180652 | 180652 | 42252 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 151 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50766 | 6010454.20711 | 2111454.0742900004 | 37.778239941556 | -122.407383433006 | (37.778239941556, -122.407383433006) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 185225 | 185225 | 46860 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.726474917775896 | -122.424891746668 | (37.7264749177759, -122.424891746668) | ||
| 138719 | 138719 | 46864 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 16461 | 16461 | 51365 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.39340338185801 | (37.7322472522973, -122.393403381858) |
| 15170 | 15170 | 51367 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.732402057093296 | -122.39336736943001 | (37.7324020570933, -122.39336736943) |
| 16516 | 16516 | 51368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.092119999 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) |
| 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) | ||
| 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) | |||
| 120629 | 120629 | 52213 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 2 | 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) | |||
| 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) | ||
| 104311 | 104311 | 52258 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th St | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 166100 | 166100 | 71685 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994260.16312 | 2086694.7455400003 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | ||
| 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) |
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");