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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 3492 | 3492 | 159213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998902.8056 | 2087977.93006 | 37.7131268274265 | -122.445655159179 | (37.7131268274265, -122.445655159179) | |||
| 3810 | 3810 | 193325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.754322548171395 | -122.389021302106 | (37.7543225481714, -122.389021302106) | |||
| 3814 | 3814 | 193324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | |||
| 3820 | 3820 | 193326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.3745800005 | 2102621.5534900003 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | |||
| 3825 | 3825 | 253557 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | ||||
| 3834 | 3834 | 244219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998052.0 | 2108644.0 | 37.76982224415679 | -122.450084429151 | (37.7698222441568, -122.450084429151) | |||
| 3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
| 4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
| 4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
| 4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 6751 | 6751 | 137889 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2034 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002935.6901 | 2115351.8703 | 37.7885186270288 | -122.433671363006 | (37.7885186270288, -122.433671363006) | ||||
| 8596 | 8596 | 115210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.789669227607604 | -122.45413840466298 | (37.7896692276076, -122.454138404663) | |||
| 8721 | 8721 | 94275 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001000.8133 | 2111684.213 | 37.778338202659995 | -122.440102619662 | (37.77833820266, -122.440102619662) | ||||
| 8801 | 8801 | 94278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | ||||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 15797 | 15797 | 101777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1700 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014038.07825 | 2093123.5904299999 | 37.72810829704029 | -122.39370208181101 | (37.7281082970403, -122.393702081811) | |||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 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) | ||||
| 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) | |||
| 22370 | 22370 | 244046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998376.5126 | 2109253.6935 | 37.771514871030995 | -122.44900587960699 | (37.771514871031, -122.449005879607) | |||
| 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) | |||
| 23398 | 23398 | 138455 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.787207199109204 | -122.433596947338 | (37.7872071991092, -122.433596947338) | |||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 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) | |||
| 23669 | 23669 | 138324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2492 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001634.5236 | 2114647.8572 | 37.7865116723619 | -122.438122738022 | (37.7865116723619, -122.438122738022) | |||
| 23795 | 23795 | 239276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007404.6677 | 2107881.43658 | 37.768259172860105 | -122.41767964611 | (37.7682591728601, -122.41767964611) | |||
| 23815 | 23815 | 239298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1475 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | |||
| 23839 | 23839 | 239303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009943.30832 | 2104181.7840400003 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | |||
| 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) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 24461 | 24461 | 138424 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003330.8547 | 2114478.3784 | 37.786142653739 | -122.432241748584 | (37.786142653739, -122.432241748584) | |||
| 24603 | 24603 | 239251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005376.329919999 | 2100765.1364700003 | 37.748605134322794 | -122.42418930690901 | (37.7486051343228, -122.424189306909) | |||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
| 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) | |||
| 25141 | 25141 | 213923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996379.96302 | 2106767.55131 | 37.76457417918571 | -122.455732270441 | (37.7645741791857, -122.455732270441) | |||
| 25291 | 25291 | 179283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | |||
| 25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
| 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) | |||
| 25710 | 25710 | 138447 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003269.2692 | 2114178.8859 | 37.7853168309586 | -122.432433419204 | (37.7853168309586, -122.432433419204) | |||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
| 26025 | 26025 | 136191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002535.252730001 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | |||
| 26041 | 26041 | 239277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006452.39888 | 2105218.17632 | 37.760892854741996 | -122.420784359417 | (37.760892854742, -122.420784359417) | |||
| 26202 | 26202 | 239326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009380.8265 | 2099841.0915200002 | 37.746293204883706 | -122.41027651786001 | (37.7462932048837, -122.41027651786) | |||
| 26220 | 26220 | 136266 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010225.4664 | 2116932.79358 | 37.793270394575295 | -122.40856131286101 | (37.7932703945753, -122.408561312861) | |||
| 26335 | 26335 | 239363 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003937.45795 | 2100690.36733 | 37.748318487114894 | -122.429159577477 | (37.7483184871149, -122.429159577477) | |||
| 26386 | 26386 | 136222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | |||
| 26410 | 26410 | 138128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 FILLMORE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003016.992000001 | 2114720.1259 | 37.786788630304706 | -122.433344910367 | (37.7867886303047, -122.433344910367) | |||
| 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) | |||
| 26458 | 26458 | 139278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004349.2802 | 2111499.4808 | 37.7780210326226 | -122.42850585599199 | (37.7780210326226, -122.428505855992) | |||
| 26489 | 26489 | 139379 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1409 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999686.4389 | 2113792.3684 | 37.7840517388464 | -122.44480108896799 | (37.7840517388464, -122.444801088968) | |||
| 26493 | 26493 | 239366 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3544 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004780.37134 | 2103118.67558 | 37.7550337374315 | -122.426417677652 | (37.7550337374315, -122.426417677652) | |||
| 26558 | 26558 | 136248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.800892734360296 | -122.414423864695 | (37.8008927343603, -122.414423864695) | |||
| 26661 | 26661 | 213931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.88729 | 2106669.96482 | 37.7643035299972 | -122.455888036623 | (37.7643035299972, -122.455888036623) | |||
| 26777 | 26777 | 138037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | |||
| 26848 | 26848 | 239353 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003763.4516900005 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | |||
| 26988 | 26988 | 248441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.44830520423099 | (37.7681031739849, -122.448305204231) | |||
| 27054 | 27054 | 239274 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007375.13668 | 2107234.3347 | 37.7664807212325 | -122.41773591849702 | (37.7664807212325, -122.417735918497) | |||
| 27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
| 27228 | 27228 | 239271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007373.17462 | 2107313.6356599997 | 37.7666983526646 | -122.417748326439 | (37.7666983526646, -122.417748326439) | |||
| 27334 | 27334 | 240136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004700.17371 | 2100146.19558 | 37.7468674642611 | -122.426483383002 | (37.7468674642611, -122.426483383002) | |||
| 27611 | 27611 | 239367 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004711.71138 | 2103517.26847 | 37.756124298509896 | -122.42668350644101 | (37.7561242985099, -122.426683506441) | |||
| 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) | |||
| 27916 | 27916 | 197079 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015561.72583 | 2105828.91514 | 37.763079033783605 | -122.389321587544 | (37.7630790337836, -122.389321587544) | |||
| 28029 | 28029 | 124413 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996133.62205 | 2115253.7929599998 | 37.787861027515895 | -122.45719822521299 | (37.7878610275159, -122.457198225213) | |||
| 28069 | 28069 | 239272 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007373.32106 | 2107298.89674 | 37.7666578912871 | -122.417746775107 | (37.7666578912871, -122.417746775107) | |||
| 28124 | 28124 | 239362 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003888.14228 | 2100073.30368 | 37.7466213818866 | -122.429286114783 | (37.7466213818866, -122.429286114783) | |||
| 28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
| 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) | |||
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 28416 | 28416 | 99761 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485.0 | 2101232.0 | 37.749723353108294 | -122.434220849449 | (37.7497233531083, -122.434220849449) | |||
| 28424 | 28424 | 239318 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2765 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010143.74039 | 2102787.8018900002 | 37.7544269567524 | -122.407846193561 | (37.7544269567524, -122.407846193561) | |||
| 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) | |||
| 28556 | 28556 | 136259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007679.1852400005 | 2119665.2919900003 | 37.800630222272794 | -122.417565392635 | (37.8006302222728, -122.417565392635) | |||
| 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) | |||
| 28756 | 28756 | 213918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996378.4642199995 | 2106655.73366 | 37.76426707058221 | -122.455729371032 | (37.7642670705822, -122.455729371032) | |||
| 28760 | 28760 | 136243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978456999 | (37.7932611216587, -122.42077978457) | |||
| 29126 | 29126 | 140884 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 642 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997209.5584 | 2113437.661 | 37.782936144733 | -122.453344534721 | (37.782936144733, -122.453344534721) | |||
| 29146 | 29146 | 179293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004018.855 | 2092658.23186 | 37.7262686762461 | -122.428305729646 | (37.7262686762461, -122.428305729646) | |||
| 29178 | 29178 | 197081 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015537.3565 | 2105827.07749 | 37.7630726369229 | -122.389405745189 | (37.7630726369229, -122.389405745189) | |||
| 29245 | 29245 | 240195 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1787 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004009.05897 | 2097810.30767 | 37.7404145605961 | -122.42870670406401 | (37.7404145605961, -122.428706704064) | |||
| 29246 | 29246 | 138000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002970.878 | 2115057.2879 | 37.78771177526961 | -122.433528557906 | (37.7877117752696, -122.433528557906) | |||
| 29544 | 29544 | 213971 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.07265 | 2091112.6142099998 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | |||
| 29555 | 29555 | 142821 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1760 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6006596.1444 | 2116951.8546 | 37.7931188048508 | -122.421120386791 | (37.7931188048508, -122.421120386791) | |||
| 29644 | 29644 | 239343 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010133.75357 | 2099974.1699200002 | 37.7467007857307 | -122.407682355972 | (37.7467007857307, -122.407682355972) | |||
| 30190 | 30190 | 136213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.78974632646779 | -122.45415312837099 | (37.7897463264678, -122.454153128371) | |||
| 30243 | 30243 | 138452 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002940.8815 | 2114925.0507 | 37.7873469835854 | -122.433622885577 | (37.7873469835854, -122.433622885577) | |||
| 30247 | 30247 | 179306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | |||
| 30274 | 30274 | 239311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 464 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005494.12674 | 2100990.71225 | 37.7492311640921 | -122.423798003785 | (37.7492311640921, -122.423798003785) | |||
| 30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
| 30474 | 30474 | 138425 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003355.5073 | 2114484.6624 | 37.786161305767706 | -122.432156906104 | (37.7861613057677, -122.432156906104) |
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");