Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
178251 | 178251 | 142103 | Undocumented 2 | Tristania conferta :: 79 | 902 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003027.1948 | 2110329.1208 | 37.7747326096469 | -122.432995779785 | (37.7747326096469, -122.432995779785) | |||
178246 | 178246 | 141548 | Undocumented 2 | Tristania conferta :: 79 | 53 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997966.0923 | 2111424.7661 | 37.7774525950111 | -122.450582087707 | (37.7774525950111, -122.450582087707) | |||
178219 | 178219 | 48780 | Permitted Site 1 | Tristania conferta :: 79 | 1366(REVISED) Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | Permit Number 46035 | 6003524.5015 | 2112470.6769 | 37.780640986928894 | -122.431428406628 | (37.7806409869289, -122.431428406628) | ||
178192 | 178192 | 141511 | Undocumented 2 | Tristania conferta :: 79 | 29 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997955.5108 | 2111504.1279 | 37.7776698962407 | -122.45062441553699 | (37.7776698962407, -122.450624415537) | |||
177734 | 177734 | 121012 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.39132435625099 | (37.7896702844128, -122.391324356251) | |||
177451 | 177451 | 143428 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010669.142000001 | 2116906.4357 | 37.793222859977604 | -122.407024299384 | (37.7932228599776, -122.407024299384) | |||
177435 | 177435 | 200894 | Undocumented 2 | Tristania conferta :: 79 | 4245 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015439.658 | 2097003.1217 | 37.7388384915964 | -122.389127500827 | (37.7388384915964, -122.389127500827) | |||
177266 | 177266 | 140697 | Undocumented 2 | Tristania conferta :: 79 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.44609838642599 | (37.7734481000077, -122.446098386426) | |||
177241 | 177241 | 138755 | Undocumented 2 | Tristania conferta :: 79 | 2343 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001410.063999999 | 2114215.486 | 37.7853117240421 | -122.43886831502701 | (37.7853117240421, -122.438868315027) | |||
177137 | 177137 | 200242 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014430.8844 | 2090146.5129 | 37.7199556562223 | -122.39213601225201 | (37.7199556562223, -122.392136012252) | |||
177106 | 177106 | 200935 | Undocumented 2 | Tristania conferta :: 79 | 4230 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015383.6815 | 2097122.3965 | 37.7391628925988 | -122.389329369915 | (37.7391628925988, -122.389329369915) | |||
176634 | 176634 | 244885 | Undocumented 2 | Tristania conferta :: 79 | 1421 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999764.5163 | 2109126.963 | 37.7712461849934 | -122.444195607915 | (37.7712461849934, -122.444195607915) | |||
176512 | 176512 | 143432 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.793259124815705 | -122.406731631165 | (37.7932591248157, -122.406731631165) | |||
176088 | 176088 | 199891 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016576.6972 | 2093089.2812 | 37.72815483243671 | -122.384923516456 | (37.7281548324367, -122.384923516456) | |||
175926 | 175926 | 142359 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005430.6231 | 2113387.7916 | 37.7832670039302 | -122.424899480788 | (37.7832670039302, -122.424899480788) | |||
175607 | 175607 | 141094 | Undocumented 2 | Tristania conferta :: 79 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | |||
175295 | 175295 | 142498 | Undocumented 2 | Tristania conferta :: 79 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.79983669458289 | -122.409693853229 | (37.7998366945829, -122.409693853229) | |||
175166 | 175166 | 138449 | Undocumented 2 | Tristania conferta :: 79 | 1700 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002092.4131 | 2114399.0626 | 37.7858545762691 | -122.436520742323 | (37.7858545762691, -122.436520742323) | |||
175069 | 175069 | 138409 | Undocumented 2 | Tristania conferta :: 79 | 2445 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002113.6961 | 2115006.6113 | 37.7875239591061 | -122.436490609497 | (37.7875239591061, -122.436490609497) | |||
175019 | 175019 | 244220 | Undocumented 2 | Tristania conferta :: 79 | 575 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997973.512 | 2108683.547 | 37.7699263384799 | -122.45035876711701 | (37.7699263384799, -122.450358767117) | |||
174641 | 174641 | 61380 | Permitted Site 1 | Tristania conferta :: 79 | 200 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1984 12:00:00 AM | 4 | Permit Number 21292 | 6014918.427 | 2115358.6091 | 37.78920975665721 | -122.392213077943 | (37.7892097566572, -122.392213077943) | ||
174224 | 174224 | 244385 | Undocumented 2 | Tristania conferta :: 79 | 897 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003194.2623 | 2110294.2764 | 37.774646410436 | -122.43241537047199 | (37.774646410436, -122.432415370472) | |||
174194 | 174194 | 244130 | Undocumented 2 | Tristania conferta :: 79 | 312 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004573.601 | 2109501.44 | 37.772547593050604 | -122.42758746355601 | (37.7725475930506, -122.427587463556) | |||
174143 | 174143 | 58337 | Permitted Site 1 | Tristania conferta :: 79 | 1593 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 12 | Permit Number 17362 | 6000161.6495 | 2110915.9391 | 37.77618090905529 | -122.442950404096 | (37.7761809090553, -122.442950404096) | ||
174142 | 174142 | 140342 | Undocumented 2 | Tristania conferta :: 79 | 1335 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004604.4556 | 2113518.6258 | 37.7835795423556 | -122.42776701682 | (37.7835795423556, -122.42776701682) | |||
173997 | 173997 | 139853 | Undocumented 2 | Tristania conferta :: 79 | 735 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005744.0619 | 2112263.2548 | 37.7801970011251 | -122.423735122838 | (37.7801970011251, -122.423735122838) | |||
173477 | 173477 | 141150 | Undocumented 2 | Tristania conferta :: 79 | 1940 O'Farrell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001933.2499 | 2113294.5086 | 37.7828127066631 | -122.436992295504 | (37.7828127066631, -122.436992295504) | |||
173254 | 173254 | 200897 | Undocumented 2 | Tristania conferta :: 79 | 4251 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015457.1359 | 2097071.1438 | 37.7390262352486 | -122.38907181799699 | (37.7390262352486, -122.389071817997) | |||
173240 | 173240 | 244136 | Undocumented 2 | Tristania conferta :: 79 | 358 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004373.2003 | 2109476.3538 | 37.7724673751924 | -122.42827888189801 | (37.7724673751924, -122.428278881898) | |||
173133 | 173133 | 199799 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015139.2762 | 2091096.4296 | 37.72260324722 | -122.389753639026 | (37.72260324722, -122.389753639026) | |||
172375 | 172375 | 140639 | Undocumented 2 | Tristania conferta :: 79 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | |||
172364 | 172364 | 245185 | Undocumented 2 | Tristania conferta :: 79 | 1134 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001109.3879 | 2109363.1674 | 37.77197137649289 | -122.43956058787501 | (37.7719713764929, -122.439560587875) | |||
172169 | 172169 | 199822 | Undocumented 2 | Tristania conferta :: 79 | 2350 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015555.1584 | 2091721.021 | 37.7243413054209 | -122.388359585978 | (37.7243413054209, -122.388359585978) | |||
172026 | 172026 | 200905 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015782.8389 | 2098148.8688 | 37.74200349709729 | -122.38802086245501 | (37.7420034970973, -122.388020862455) | |||
171974 | 171974 | 121009 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015134.359 | 2115477.8859 | 37.7895492505351 | -122.391474315503 | (37.7895492505351, -122.391474315503) | |||
171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
171962 | 171962 | 200993 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015477.7938 | 2115806.9252 | 37.790471772634604 | -122.390309056024 | (37.7904717726346, -122.390309056024) | |||
171880 | 171880 | 199710 | Undocumented 2 | Tristania conferta :: 79 | 1925 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016332.671 | 2092691.0173 | 37.7270477778667 | -122.38573938498999 | (37.7270477778667, -122.38573938499) | |||
171807 | 171807 | 137873 | Undocumented 2 | Tristania conferta :: 79 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | |||
171619 | 171619 | 141173 | Undocumented 2 | Tristania conferta :: 79 | 1830 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002027.3312 | 2112959.1326 | 37.7818971962022 | -122.436642800536 | (37.7818971962022, -122.436642800536) | |||
171611 | 171611 | 94414 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53653 | 6013808.0998 | 2092150.7804 | 37.7254243749067 | -122.394429043825 | (37.7254243749067, -122.394429043825) | |
171512 | 171512 | 47581 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 10 | Permit Number 45427 | 6014732.3141 | 2115093.3212 | 37.7884710015858 | -122.39283844369801 | (37.7884710015858, -122.392838443698) | ||
171370 | 171370 | 89051 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000933.3562 | 2114194.3706 | 37.7852266134024 | -122.440516060128 | (37.7852266134024, -122.440516060128) | |
171170 | 171170 | 200907 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015794.1759 | 2098187.1312 | 37.742109185886505 | -122.387984331771 | (37.7421091858865, -122.387984331771) | |||
171070 | 171070 | 199675 | Undocumented 2 | Tristania conferta :: 79 | 1451 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6015529.5331 | 2093336.0616 | 37.7287744664237 | -122.38856085121 | (37.7287744664237, -122.38856085121) | |||
171007 | 171007 | 200910 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.74229184539389 | -122.387921978414 | (37.7422918453939, -122.387921978414) | |||
170928 | 170928 | 141171 | Undocumented 2 | Tristania conferta :: 79 | 1804 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002115.9977 | 2112972.331 | 37.7819384740439 | -122.43633700083599 | (37.7819384740439, -122.436337000836) | |||
170871 | 170871 | 140351 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004431.2052 | 2113294.3783 | 37.782954012602296 | -122.42835040863899 | (37.7829540126023, -122.428350408639) | |||
170807 | 170807 | 47606 | Permitted Site 1 | Tristania conferta :: 79 | 965 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45442 | 6011251.7668 | 2111767.4922 | 37.779145121392105 | -122.404646435966 | (37.7791451213921, -122.404646435966) | |
170655 | 170655 | 140676 | Undocumented 2 | Tristania conferta :: 79 | 1309 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004177.9518 | 2113036.4332 | 37.7822314260012 | -122.429208162046 | (37.7822314260012, -122.429208162046) | |||
170461 | 170461 | 95307 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014265.14 | 2093118.9766 | 37.728108243383105 | -122.392916792791 | (37.7281082433831, -122.392916792791) | |||
170282 | 170282 | 61323 | Permitted Site 1 | Tristania conferta :: 79 | 1662 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | 14 | Permit Number 21226 | 5999808.8917 | 2110918.1953 | 37.776166985726704 | -122.444170847057 | (37.7761669857267, -122.444170847057) | |
170231 | 170231 | 137790 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005264.6664 | 2115686.9342 | 37.7895705021499 | -122.425637314961 | (37.7895705021499, -122.425637314961) | |||
170001 | 170001 | 244132 | Undocumented 2 | Tristania conferta :: 79 | 322 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004530.9257 | 2109493.9429 | 37.7725245939109 | -122.427734547545 | (37.7725245939109, -122.427734547545) | |||
169915 | 169915 | 139928 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005691.164 | 2112649.617 | 37.7812548708412 | -122.42394560326001 | (37.7812548708412, -122.42394560326) | |||
169442 | 169442 | 71258 | Undocumented 2 | Tristania conferta :: 79 | 923 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/1986 12:00:00 AM | 13 | 3x3 | 6001950.0126 | 2111666.817 | 37.778344429762 | -122.436817746544 | (37.778344429762, -122.436817746544) | |
169388 | 169388 | 248514 | Undocumented 2 | Tristania conferta :: 79 | 25 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997781.3681 | 2107812.9082 | 37.767524788446 | -122.450960596024 | (37.767524788446, -122.450960596024) | |||
169377 | 169377 | 122822 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.40940941357799 | (37.8019045299018, -122.409409413578) | |||
169360 | 169360 | 140564 | Undocumented 2 | Tristania conferta :: 79 | 1135 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003716.5963 | 2111756.5336 | 37.778691012166 | -122.430712882634 | (37.778691012166, -122.430712882634) | |||
169224 | 169224 | 89053 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51790 | 6000877.1335 | 2114188.3074 | 37.7852067638224 | -122.440710137812 | (37.7852067638224, -122.440710137812) | |
169198 | 169198 | 199766 | Undocumented 2 | Tristania conferta :: 79 | 2012 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016050.9086 | 2092395.1204 | 37.7262197079231 | -122.386692817183 | (37.7262197079231, -122.386692817183) | |||
169048 | 169048 | 199709 | Undocumented 2 | Tristania conferta :: 79 | 1925 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016317.7981 | 2092670.0851 | 37.7269894791605 | -122.385789342511 | (37.7269894791605, -122.385789342511) | |||
169016 | 169016 | 138746 | Undocumented 2 | Tristania conferta :: 79 | 2516 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000515.6821 | 2114142.2729 | 37.7850597745123 | -122.44195733925899 | (37.7850597745123, -122.441957339259) | |||
168984 | 168984 | 139331 | Undocumented 2 | Tristania conferta :: 79 | 1599 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004569.3314 | 2114306.6943 | 37.7857413949586 | -122.427944707864 | (37.7857413949586, -122.427944707864) | |||
168980 | 168980 | 137934 | Undocumented 2 | Tristania conferta :: 79 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005387.505 | 2114749.5421 | 37.7870035976345 | -122.425145578775 | (37.7870035976345, -122.425145578775) | |||
168967 | 168967 | 199795 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015060.1169 | 2090989.5967 | 37.7223055152201 | -122.39001981815599 | (37.7223055152201, -122.390019818156) | |||
168926 | 168926 | 138224 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998591.1654 | 2112638.1395 | 37.7808199616553 | -122.44850716898199 | (37.7808199616553, -122.448507168982) | |||
168852 | 168852 | 200933 | Undocumented 2 | Tristania conferta :: 79 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | |||
168783 | 168783 | 199718 | Undocumented 2 | Tristania conferta :: 79 | 1999 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016237.3741 | 2092566.5255 | 37.7267006741711 | -122.386060153377 | (37.7267006741711, -122.386060153377) | |||
168765 | 168765 | 141458 | Undocumented 2 | Tristania conferta :: 79 | 9 Kittredge Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997945.4102 | 2111586.3754 | 37.777895148355604 | -122.450665288127 | (37.7778951483556, -122.450665288127) | |||
168383 | 168383 | 142365 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005547.6156 | 2113403.0804 | 37.783315590695096 | -122.42449582084801 | (37.7833155906951, -122.424495820848) | |||
168378 | 168378 | 141774 | Undocumented 2 | Tristania conferta :: 79 | 1320 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003755.8174 | 2113288.9773 | 37.7829009427764 | -122.43068658483999 | (37.7829009427764, -122.43068658484) | |||
168347 | 168347 | 137838 | Undocumented 2 | Tristania conferta :: 79 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
168313 | 168313 | 140679 | Undocumented 2 | Tristania conferta :: 79 | 1303 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004187.9883 | 2112981.79 | 37.78208195753871 | -122.42916954278499 | (37.7820819575387, -122.429169542785) | |||
168052 | 168052 | 246240 | Undocumented 2 | Tristania conferta :: 79 | 1395 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999545.8017 | 2107831.5322 | 37.767676778692 | -122.4448590132 | (37.767676778692, -122.4448590132) | |||
167736 | 167736 | 139800 | Undocumented 2 | Tristania conferta :: 79 | 1779 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002066.4486 | 2112571.2476 | 37.7808343850105 | -122.43647970183399 | (37.7808343850105, -122.436479701834) | |||
167727 | 167727 | 143384 | Undocumented 2 | Tristania conferta :: 79 | 1650 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004460.6831 | 2119822.6068 | 37.8008805420914 | -122.428713951546 | (37.8008805420914, -122.428713951546) | |||
167554 | 167554 | 200986 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015348.2345 | 2115680.4507 | 37.7901173153756 | -122.390748484543 | (37.7901173153756, -122.390748484543) | |||
167448 | 167448 | 200913 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015728.5157 | 2097971.7279 | 37.7415140947501 | -122.388196336709 | (37.7415140947501, -122.388196336709) | |||
167083 | 167083 | 32805 | Permitted Site 1 | Tristania conferta :: 79 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) | |
166802 | 166802 | 184808 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.763213013686396 | -122.49619147733 | (37.7632130136864, -122.49619147733) | |||
166796 | 166796 | 244922 | Undocumented 2 | Tristania conferta :: 79 | 1306 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999852.2786 | 2108842.3283 | 37.770469656383604 | -122.44387158208 | (37.7704696563836, -122.44387158208) | |||
166788 | 166788 | 140437 | Undocumented 2 | Tristania conferta :: 79 | 1254 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003584.2946 | 2112137.3228 | 37.779729068249395 | -122.431197752602 | (37.7797290682494, -122.431197752602) | |||
166391 | 166391 | 138917 | Undocumented 2 | Tristania conferta :: 79 | 707 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004409.1552 | 2110814.8804 | 37.7761446763748 | -122.428249923485 | (37.7761446763748, -122.428249923485) | |||
165913 | 165913 | 139852 | Undocumented 2 | Tristania conferta :: 79 | 735 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005742.5037 | 2112286.6291 | 37.7802610932737 | -122.42374217582199 | (37.7802610932737, -122.423742175822) | |||
165690 | 165690 | 138523 | Undocumented 2 | Tristania conferta :: 79 | 1604 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001653.2482 | 2114047.3958 | 37.7848640239748 | -122.438014928593 | (37.7848640239748, -122.438014928593) | |||
165610 | 165610 | 245024 | Undocumented 2 | Tristania conferta :: 79 | 291 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001247.6582 | 2109580.5442 | 37.7725761073824 | -122.43909788373699 | (37.7725761073824, -122.439097883737) | |||
165315 | 165315 | 142193 | Undocumented 2 | Tristania conferta :: 79 | 1642 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999555.7794 | 2109844.0818 | 37.773203300666296 | -122.44496919507401 | (37.7732033006663, -122.444969195074) | |||
165162 | 165162 | 200994 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015517.8954 | 2115843.9421 | 37.7905756368486 | -122.390172893022 | (37.7905756368486, -122.390172893022) | |||
165014 | 165014 | 143131 | Undocumented 2 | Tristania conferta :: 79 | 2425 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000792.2705 | 2119235.098 | 37.7990590996693 | -122.44136599201 | (37.7990590996693, -122.44136599201) | |||
164892 | 164892 | 141477 | Undocumented 2 | Tristania conferta :: 79 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | |||
164839 | 164839 | 68142 | Permitted Site 1 | Tristania conferta :: 79 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | |
164606 | 164606 | 138235 | Undocumented 2 | Tristania conferta :: 79 | 230 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998964.7831 | 2112316.4696 | 37.779958094491604 | -122.447191491368 | (37.7799580944916, -122.447191491368) | |||
164491 | 164491 | 200999 | Undocumented 2 | Tristania conferta :: 79 | 200 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014874.2123 | 2115316.451 | 37.789091545114296 | -122.39236310676901 | (37.7890915451143, -122.392363106769) | |||
164219 | 164219 | 200924 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015492.5641 | 2097476.9144 | 37.7401423621251 | -122.38897764491001 | (37.7401423621251, -122.38897764491) | |||
164112 | 164112 | 199892 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016564.5785 | 2093072.2049 | 37.728107273971204 | -122.38496422243401 | (37.7281072739712, -122.384964222434) | |||
164064 | 164064 | 107146 | Undocumented 2 | Tristania conferta :: 79 | 2466 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 5985834.1864 | 2098423.2393 | 37.7410521276716 | -122.491592490194 | (37.7410521276716, -122.491592490194) | ||||
163961 | 163961 | 68141 | Permitted Site 1 | Tristania conferta :: 79 | 2528 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 14 | Permit Number 31895 | 6000471.2962 | 2114132.7617 | 37.7850311298137 | -122.442110217066 | (37.7850311298137, -122.442110217066) | |
163900 | 163900 | 244370 | Undocumented 2 | Tristania conferta :: 79 | 268 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005700.5651 | 2110352.5348 | 37.774948173633796 | -122.423749701707 | (37.7749481736338, -122.423749701707) | |||
163855 | 163855 | 200667 | Undocumented 2 | Tristania conferta :: 79 | 1593 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015303.436000001 | 2095600.1842 | 37.7349787586684 | -122.389500546178 | (37.7349787586684, -122.389500546178) |
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");