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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
169324 | 169324 | 118185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985597.25903 | 2112945.4232900003 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | |||
70320 | 70320 | 181741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985810.6327 | 2106942.082 | 37.7644411641486 | -122.492301073815 | (37.7644411641486, -122.492301073815) | |||
53492 | 53492 | 75980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.48982895296699 | (37.7797135654944, -122.489828952967) | ||
166878 | 166878 | 182744 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1769 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986859.8585 | 2103239.7166 | 37.754336768117206 | -122.488400024275 | (37.7543367681172, -122.488400024275) | |||
181096 | 181096 | 182748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1789 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986861.6929 | 2103148.806 | 37.754087259353206 | -122.488386999785 | (37.7540872593532, -122.488386999785) | |||
65500 | 65500 | 182749 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986862.6162 | 2103130.8030000003 | 37.754037881879 | -122.488382483852 | (37.754037881879, -122.488382483852) | |||
35976 | 35976 | 181801 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986905.9682 | 2099586.0566 | 37.744307492185 | -122.487972126615 | (37.744307492185, -122.487972126615) | |||
72832 | 72832 | 181803 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1915 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986942.1793 | 2099588.0871 | 37.7443151796952 | -122.487847067129 | (37.7443151796952, -122.487847067129) | |||
141691 | 141691 | 112080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
144808 | 144808 | 112082 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
126891 | 126891 | 120181 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987742.587230001 | 2115005.98358 | 37.7866951312776 | -122.486211085191 | (37.7866951312776, -122.486211085191) | |||
50738 | 50738 | 120183 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987744.35264 | 2114901.48572 | 37.7864083129421 | -122.486197303246 | (37.7864083129421, -122.486197303246) | |||
51338 | 51338 | 182788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1781 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988111.6274 | 2103184.2484 | 37.754257425098096 | -122.484067075117 | (37.7542574250981, -122.484067075117) | |||
74587 | 74587 | 182789 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988112.4655 | 2103151.9819 | 37.7541688787672 | -122.484061810783 | (37.7541688787672, -122.484061810783) | |||
188071 | 188071 | 182790 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988113.3036 | 2103133.9629 | 37.754119452236 | -122.48405759118499 | (37.754119452236, -122.484057591185) | |||
172764 | 172764 | 120258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.48405372444599 | (37.7867672160285, -122.484053724446) | |||
49709 | 49709 | 120248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.786334585774604 | -122.484046777757 | (37.7863345857746, -122.484046777757) | |||
176550 | 176550 | 120252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | |||
44437 | 44437 | 120251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.48404399839899 | (37.7864004688283, -122.484043998399) | |||
63345 | 63345 | 120250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | |||
77045 | 77045 | 120249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.786310429345704 | -122.48404330399599 | (37.7863104293457, -122.484043303996) | |||
22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
185841 | 185841 | 120256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.48404121988199 | (37.7866145875471, -122.484041219882) | |||
49555 | 49555 | 120257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988368.87318 | 2114954.3645200003 | 37.786589881739104 | -122.484040525506 | (37.7865898817391, -122.484040525506) | |||
153635 | 153635 | 120255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988367.99594 | 2114912.99225 | 37.7864762341937 | -122.484040525506 | (37.7864762341937, -122.484040525506) | |||
47047 | 47047 | 120253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.48403635730499 | (37.7865333323848, -122.484036357305) | |||
28239 | 28239 | 120254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | |||
39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
154275 | 154275 | 120315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 206 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5988712.81851 | 2113914.04057 | 37.7837534650339 | -122.48277430520001 | (37.7837534650339, -122.4827743052) | |||
75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
51119 | 51119 | 182028 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2209 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988891.7451 | 2106459.406 | 37.7632955122177 | -122.481609125496 | (37.7632955122177, -122.481609125496) | |||
114129 | 114129 | 101280 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2201 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988947.0 | 2106461.0 | 37.7633031017087 | -122.48141813594201 | (37.7633031017087, -122.481418135942) | ||||
73312 | 73312 | 120776 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | |||
149008 | 149008 | 120775 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.50277 | 2114844.1258799997 | 37.7863386601165 | -122.48097188408 | (37.7863386601165, -122.48097188408) | |||
28532 | 28532 | 120778 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989252.84217 | 2114809.1452099998 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | |||
69793 | 69793 | 120774 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.85466 | 2114850.93568 | 37.7863573783569 | -122.48097116542499 | (37.7863573783569, -122.480971165425) | |||
170056 | 170056 | 120777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5989253.41901 | 2114816.7810299997 | 37.786263574020204 | -122.480970171004 | (37.7862635740202, -122.480970171004) | |||
27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
39644 | 39644 | 121918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | |||
73880 | 73880 | 122099 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 451 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990895.26927 | 2112314.80254 | 37.7794891374062 | -122.47510713931001 | (37.7794891374062, -122.47510713931) | |||
20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
107775 | 107775 | 112864 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | |||
109062 | 109062 | 112867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
114300 | 114300 | 112865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
34193 | 34193 | 122096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990911.764769999 | 2111862.01127 | 37.778246853274105 | -122.475017013162 | (37.7782468532741, -122.475017013162) | |||
173179 | 173179 | 122094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 695 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990954.58445 | 2110703.0239 | 37.775067073184296 | -122.474784270445 | (37.7750670731843, -122.474784270445) | |||
45337 | 45337 | 213911 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990895.24857 | 2103389.01356 | 37.754981325851205 | -122.474455655417 | (37.7549813258512, -122.474455655417) | |||
38745 | 38745 | 121984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991256.96696 | 2112622.26651 | 37.780354305120504 | -122.47387832307501 | (37.7803543051205, -122.473878323075) | |||
37577 | 37577 | 213945 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2612 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991136.47615 | 2097605.20115 | 37.739114449377496 | -122.473199637055 | (37.7391144493775, -122.473199637055) | |||
23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
70433 | 70433 | 213934 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2434 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991403.06474 | 2098824.0005 | 37.7424763930825 | -122.472366729935 | (37.7424763930825, -122.472366729935) | |||
69725 | 69725 | 124089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | ||||
57568 | 57568 | 213989 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.47008343851299 | (37.7399257259925, -122.470083438513) | |||
65359 | 65359 | 213940 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2526 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992077.65136 | 2098235.486 | 37.7408995020175 | -122.46999139020599 | (37.7408995020175, -122.469991390206) | |||
68363 | 68363 | 213939 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2526 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992077.721369999 | 2098220.5392 | 37.7408584659515 | -122.469990060101 | (37.7408584659515, -122.469990060101) | |||
45070 | 45070 | 123102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992511.21682 | 2112680.96666 | 37.7805880471465 | -122.469543602377 | (37.7805880471465, -122.469543602377) | |||
72767 | 72767 | 123103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992512.64277 | 2112661.1585 | 37.7805337417535 | -122.46953722702601 | (37.7805337417535, -122.469537227026) | |||
47113 | 47113 | 111740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 498x 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5992531.49665 | 2112146.31797 | 37.779121219504106 | -122.46943451634199 | (37.7791212195041, -122.469434516342) | |||
31141 | 31141 | 123173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.890869999 | 2110769.52892 | 37.7753589775368 | -122.468253641396 | (37.7753589775368, -122.468253641396) | |||
39329 | 39329 | 213917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992756.585530001 | 2104219.0263799997 | 37.7573679916487 | -122.46807905201 | (37.7573679916487, -122.46807905201) | |||
176037 | 176037 | 213935 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992714.0636 | 2098999.44218 | 37.74303390080429 | -122.46784648283001 | (37.7430339008043, -122.46784648283) | |||
23855 | 23855 | 213936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992721.86042 | 2099019.1696099997 | 37.7430885175375 | -122.46782095827801 | (37.7430885175375, -122.467820958278) | |||
34527 | 34527 | 123209 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993132.47666 | 2112678.91247 | 37.7806182922184 | -122.46739423754299 | (37.7806182922184, -122.467394237543) | |||
149135 | 149135 | 213988 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992833.78766 | 2098132.51162 | 37.7406604415293 | -122.467369487819 | (37.7406604415293, -122.467369487819) | |||
70444 | 70444 | 213938 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992850.99558 | 2098086.47375 | 37.7405350265634 | -122.467306643206 | (37.7405350265634, -122.467306643206) | |||
26447 | 26447 | 213937 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 155 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992856.26396 | 2098093.99646 | 37.740555986160494 | -122.467288974202 | (37.7405559861605, -122.467288974202) | |||
136565 | 136565 | 123226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 774 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993220.36068 | 2110224.45324 | 37.773884082118705 | -122.46691172095899 | (37.7738840821187, -122.466911720959) | |||
135716 | 135716 | 213942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993008.95688 | 2093342.09181 | 37.72751725271729 | -122.466415744194 | (37.7275172527173, -122.466415744194) | |||
148254 | 148254 | 123265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993761.50417 | 2112485.6321900003 | 37.780123890844706 | -122.465204105338 | (37.7801238908447, -122.465204105338) | |||
168118 | 168118 | 123269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993762.13117 | 2112380.5079099997 | 37.779835284094204 | -122.46519429844801 | (37.7798352840942, -122.465194298448) | |||
159254 | 159254 | 123020 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.785796646929995 | -122.46454980212098 | (37.78579664693, -122.464549802121) | |||
25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
62773 | 62773 | 213916 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5993897.35256 | 2107155.07888 | 37.7654954419723 | -122.46434702200199 | (37.7654954419723, -122.464347022002) | |||
25584 | 25584 | 123293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 566 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994099.84027 | 2111646.79244 | 37.7778401670229 | -122.46397274776301 | (37.7778401670229, -122.463972747763) | |||
36045 | 36045 | 213990 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Kingston St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994010.049330001 | 2099244.86467 | 37.743782519860794 | -122.46338315652099 | (37.7437825198608, -122.463383156521) | |||
137145 | 137145 | 213941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 173 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994356.4044699995 | 2099261.98747 | 37.743849483363206 | -122.46218679288799 | (37.7438494833632, -122.462186792888) | |||
77190 | 77190 | 123342 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 655 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994692.32091 | 2111064.37501 | 37.7762751309174 | -122.461880922704 | (37.7762751309174, -122.461880922704) | |||
69784 | 69784 | 213949 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994439.2720800005 | 2091407.20179 | 37.722286941382706 | -122.46133096657199 | (37.7222869413827, -122.461330966572) | |||
54800 | 54800 | 213913 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994820.88687 | 2107315.71116 | 37.7659896869053 | -122.46116439324899 | (37.7659896869053, -122.461164393249) | |||
160675 | 160675 | 213914 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5994821.63869 | 2107263.01718 | 37.7658450462296 | -122.46115797296999 | (37.7658450462296, -122.46115797297) | |||
164333 | 164333 | 213951 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994724.0479999995 | 2090709.9007700002 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | |||
22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
160245 | 160245 | 123627 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995231.45698 | 2114622.12535 | 37.786074785036504 | -122.46027374413099 | (37.7860747850365, -122.460273744131) | |||
148294 | 148294 | 123628 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995232.14872 | 2114600.88341 | 37.7860165001902 | -122.460269811318 | (37.7860165001902, -122.460269811318) | |||
159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
160941 | 160941 | 213952 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994769.73406 | 2090948.84155 | 37.72104740759529 | -122.460155454611 | (37.7210474075953, -122.460155454611) | |||
44482 | 44482 | 213956 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994772.08022 | 2091060.8394799998 | 37.7213550620588 | -122.46015545460699 | (37.7213550620588, -122.460155454607) | |||
151351 | 151351 | 213953 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994770.431919999 | 2090973.1015700002 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | |||
28648 | 28648 | 213960 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994774.81066 | 2091163.6355700002 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | |||
152237 | 152237 | 213961 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994775.27388 | 2091185.74798 | 37.7216982145873 | -122.460153459921 | (37.7216982145873, -122.460153459921) | |||
66368 | 66368 | 213958 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.721536499390105 | -122.460152462564 | (37.7215364993901, -122.460152462564) | |||
177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
174480 | 174480 | 213955 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | |||
186622 | 186622 | 213959 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196813995 | -122.460149470543 | (37.721586196814, -122.460149470543) | |||
42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
69823 | 69823 | 213978 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994758.88079 | 2090253.13715 | 37.7191365451831 | -122.460142594324 | (37.7191365451831, -122.460142594324) |
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");