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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 750 | 750 | 251368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6010822.0 | 2111616.0 | 37.7787051302825 | -122.40612250689199 | (37.7787051302825, -122.406122506892) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 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) | |||
| 15645 | 15645 | 105283 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009798.61642 | 2111399.33424 | 37.778052923046104 | -122.40964750682 | (37.7780529230461, -122.40964750682) | |||
| 15711 | 15711 | 105284 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009809.36345 | 2111386.0864 | 37.7780171498111 | -122.40960939355601 | (37.7780171498111, -122.409609393556) | |||
| 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) | |||
| 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) | |||
| 23630 | 23630 | 222878 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003263.67356 | 2105959.60231 | 37.7627483890498 | -122.431865689655 | (37.7627483890498, -122.431865689655) | |||
| 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) | |||
| 25929 | 25929 | 188459 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017898.8154 | 2096917.7474099998 | 37.7387400867836 | -122.38061886067499 | (37.7387400867836, -122.380618860675) | |||
| 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) | |||
| 33784 | 33784 | 125959 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.41655895865401 | (37.802457811042, -122.416558958654) | |||
| 34939 | 34939 | 175832 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994691.10568 | 2086786.7003099998 | 37.709614630390604 | -122.460125866041 | (37.7096146303906, -122.460125866041) | |||
| 35226 | 35226 | 222879 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | |||
| 36331 | 36331 | 188452 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.40339597754499 | (37.7642656181765, -122.403395977545) | |||
| 37407 | 37407 | 222866 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005593.12032 | 2102536.33181 | 37.753480666708704 | -122.423565555132 | (37.7534806667087, -122.423565555132) | |||
| 39299 | 39299 | 125958 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.802248350842795 | -122.41705558676901 | (37.8022483508428, -122.417055586769) | |||
| 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) | |||
| 43209 | 43209 | 188465 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011787.2831 | 2109744.8541900003 | 37.773621338281295 | -122.402651578111 | (37.7736213382813, -122.402651578111) | |||
| 43647 | 43647 | 205976 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1701 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990268.09461 | 2106501.35163 | 37.763490619320294 | -122.476851900801 | (37.7634906193203, -122.476851900801) | |||
| 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) | |||
| 46416 | 46416 | 125961 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.134880001 | 2120318.93587 | 37.802440037726 | -122.41668450579999 | (37.802440037726, -122.4166845058) | |||
| 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) | |||
| 47462 | 47462 | 188462 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | |||
| 53454 | 53454 | 188455 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011498.78949 | 2106422.9347099997 | 37.76448399066 | -122.40341577880899 | (37.76448399066, -122.403415778809) | |||
| 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) | |||
| 55877 | 55877 | 175834 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994720.17465 | 2086786.5738400002 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | |||
| 58112 | 58112 | 125960 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007965.18699 | 2120322.0284599997 | 37.8024495444817 | -122.416622255608 | (37.8024495444817, -122.416622255608) | |||
| 60072 | 60072 | 188463 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011854.3498599995 | 2109717.34943 | 37.773549560687705 | -122.402417648277 | (37.7735495606877, -122.402417648277) | |||
| 60521 | 60521 | 222880 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003225.6095199995 | 2105960.03054 | 37.7627474070019 | -122.431997370179 | (37.7627474070019, -122.431997370179) | |||
| 61421 | 61421 | 175833 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994704.65642 | 2086785.9340000001 | 37.709613305686 | -122.46007897716999 | (37.709613305686, -122.46007897717) | |||
| 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) | |||
| 63815 | 63815 | 106235 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 785 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6011771.382680001 | 2109636.80705 | 37.773323777798794 | -122.40269898048099 | (37.7733237777988, -122.402698980481) | ||||
| 63879 | 63879 | 188450 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | |||
| 65403 | 65403 | 188444 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011513.49426 | 2106142.7463700003 | 37.763715477720794 | -122.403345206341 | (37.7637154777208, -122.403345206341) | |||
| 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) | |||
| 67587 | 67587 | 175828 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010182.474880001 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | |||
| 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) | |||
| 72455 | 72455 | 125964 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007746.87512 | 2120288.68768 | 37.8023457186479 | -122.41737536049999 | (37.8023457186479, -122.4173753605) | |||
| 72694 | 72694 | 188448 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.763989324874295 | -122.403368255061 | (37.7639893248743, -122.403368255061) | |||
| 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) | ||||
| 85932 | 85932 | 115858 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 88142 | 88142 | 115865 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 93733 | 93733 | 115862 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 96110 | 96110 | 222863 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008222.11657 | 2107958.0474099996 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | |||
| 97521 | 97521 | 115866 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 106279 | 106279 | 106940 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1607 WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5997889.0 | 2108175.0 | 37.768525161365105 | -122.45061442154498 | (37.7685251613651, -122.450614421545) | ||||
| 107511 | 107511 | 115855 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 111752 | 111752 | 115860 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 113336 | 113336 | 115861 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 122479 | 122479 | 115863 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 124465 | 124465 | 115859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 129589 | 129589 | 188453 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011500.6075 | 2106371.58763 | 37.764343104663894 | -122.40340587818001 | (37.7643431046639, -122.40340587818) | |||
| 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) | |||
| 130681 | 130681 | 175825 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6003581.23003 | 2087608.2042099999 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | |||
| 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) | |||
| 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) | |||
| 133142 | 133142 | 125957 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1047 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009453.06953 | 2117007.5192299997 | 37.7934322851104 | -122.41123914946199 | (37.7934322851104, -122.411239149462) | |||
| 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) | |||
| 137261 | 137261 | 222859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004077.69446 | 2108250.00646 | 37.76908339881629 | -122.429213605151 | (37.7690833988163, -122.429213605151) | |||
| 139388 | 139388 | 115867 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 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) | |||||
| 142687 | 142687 | 115857 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 142898 | 142898 | 115856 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 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) | |||
| 143939 | 143939 | 115864 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 147749 | 147749 | 188458 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158001 | (37.7386016766138, -122.38038486158) | |||
| 148126 | 148126 | 188447 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386002 | (37.7638765831644, -122.40336267386) | |||
| 149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
| 150703 | 150703 | 222868 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005340.76956 | 2101936.5260900003 | 37.7518194920941 | -122.42439557991699 | (37.7518194920941, -122.424395579917) | |||
| 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) | |||
| 152099 | 152099 | 188457 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.738562560606105 | -122.38033159384199 | (37.7385625606061, -122.380331593842) | |||
| 154453 | 154453 | 222872 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4250 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002245.78823 | 2100636.8852 | 37.7480757286172 | -122.435005495434 | (37.7480757286172, -122.435005495434) | |||
| 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) | |||
| 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) | |||
| 157528 | 157528 | 175827 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6003539.767469999 | 2087618.6367900001 | 37.7124039361582 | -122.42960264823999 | (37.7124039361582, -122.42960264824) | |||
| 158361 | 158361 | 184174 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1655 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985601.1485 | 2103943.8243 | 37.7561965316146 | -122.492804758993 | (37.7561965316146, -122.492804758993) | |||
| 159807 | 159807 | 188449 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011506.747280001 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | |||
| 159956 | 159956 | 188461 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011834.924330001 | 2109696.1650799997 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | |||
| 161840 | 161840 | 188445 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011511.3367099995 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | |||
| 162239 | 162239 | 125954 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999004.62741 | 2115731.3369 | 37.7893367050801 | -122.447299501178 | (37.7893367050801, -122.447299501178) | |||
| 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) | ||||
| 164186 | 164186 | 182455 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1500 31st Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5986551.2997 | 2104640.4864 | 37.7581648905277 | -122.48957008427 | (37.7581648905277, -122.48957008427) | |||
| 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) | |||
| 164926 | 164926 | 188446 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011512.27704 | 2106186.3574200002 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) |
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");