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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189104 | 189104 | 196973 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6014457.83967 | 2102608.3730099997 | 37.754174858803296 | -122.39291425318899 | (37.7541748588033, -122.392914253189) | |||
| 188936 | 188936 | 241351 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6009671.132730001 | 2105926.35263 | 37.7630182387282 | -122.409702117253 | (37.7630182387282, -122.409702117253) | |||
| 188901 | 188901 | 241286 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6011463.91629 | 2102032.72658 | 37.7524275057351 | -122.403227546213 | (37.7524275057351, -122.403227546213) | |||
| 188859 | 188859 | 241377 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 281 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004660.79755 | 2100144.09881 | 37.7468594809746 | -122.42661939287301 | (37.7468594809746, -122.426619392873) | |||
| 188471 | 188471 | 241372 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004512.71197 | 2101888.89737 | 37.7516419200596 | -122.427255725271 | (37.7516419200596, -122.427255725271) | |||
| 188003 | 188003 | 34259 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.46453448944901 | (37.7855927810379, -122.464534489449) | |
| 187478 | 187478 | 247601 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Tompkins Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6009211.63365 | 2096404.0635900002 | 37.7368463915456 | -122.410618895163 | (37.7368463915456, -122.410618895163) | |||
| 187168 | 187168 | 196993 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013912.096059999 | 2100139.0238799998 | 37.7473642236913 | -122.39462867398501 | (37.7473642236913, -122.394628673985) | |||
| 186926 | 186926 | 241319 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007346.30903 | 2107764.0705 | 37.7679336290724 | -122.417873182915 | (37.7679336290724, -122.417873182915) | |||
| 186567 | 186567 | 241357 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1099 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6008659.53051 | 2102232.0888799997 | 37.7528178906343 | -122.412939704518 | (37.7528178906343, -122.412939704518) | |||
| 186450 | 186450 | 196986 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | |||
| 185963 | 185963 | 241364 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 826 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6009889.67634 | 2104361.42581 | 37.7587335483391 | -122.408835831807 | (37.7587335483391, -122.408835831807) | |||
| 185439 | 185439 | 136184 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | |||
| 185013 | 185013 | 241316 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007332.32989 | 2108125.54734 | 37.768925372644205 | -122.41794716295 | (37.7689253726442, -122.41794716295) | |||
| 185002 | 185002 | 123179 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992862.96444 | 2110216.5600400004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | |||
| 184638 | 184638 | 196972 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014458.90845 | 2102627.41024 | 37.7542271903342 | -122.392911888877 | (37.7542271903342, -122.392911888877) | |||
| 184533 | 184533 | 36967 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39594 | 5994314.223669999 | 2112999.17695 | 37.781565804395704 | -122.463329288102 | (37.7815658043957, -122.463329288102) | |
| 184207 | 184207 | 241279 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1400 Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010767.41286 | 2100951.64139 | 37.7494201602129 | -122.40556004767201 | (37.7494201602129, -122.405560047672) | |||
| 184111 | 184111 | 37968 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 571 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40198 | 6013578.16137 | 2104406.11851 | 37.7590621767948 | -122.39608239838999 | (37.7590621767948, -122.39608239839) | |
| 183644 | 183644 | 241301 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 765 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007553.454530001 | 2105201.24032 | 37.7609083500518 | -122.41697508302799 | (37.7609083500518, -122.416975083028) | |||
| 183575 | 183575 | 136175 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3103 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001391.85411 | 2119087.81282 | 37.7986888314695 | -122.439280672761 | (37.7986888314695, -122.439280672761) | |||
| 183506 | 183506 | 241371 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2865 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6009580.01982 | 2102754.75587 | 37.754304644445895 | -122.40979336068999 | (37.7543046444459, -122.40979336069) | |||
| 182438 | 182438 | 241303 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007544.46079 | 2105381.89304 | 37.7614038747014 | -122.41701898884199 | (37.7614038747014, -122.417018988842) | |||
| 182069 | 182069 | 241345 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009569.08803 | 2105916.84613 | 37.762986417122605 | -122.410054385304 | (37.7629864171226, -122.410054385304) | |||
| 181885 | 181885 | 179279 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 223 Pioche St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006275.12702 | 2093408.7720700002 | 37.7284569075468 | -122.420559152977 | (37.7284569075468, -122.420559152977) | |||
| 181475 | 181475 | 241308 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.764198964923295 | -122.417285889641 | (37.7641989649233, -122.417285889641) | |||
| 180576 | 180576 | 35355 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1315 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 12 | Permit Number 38817 | 6011731.8197 | 2102219.99473 | 37.7529566614441 | -122.402314252327 | (37.7529566614441, -122.402314252327) | |
| 180332 | 180332 | 241380 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4050 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008348.5979 | 2096262.4488099997 | 37.7364091240834 | -122.413592786804 | (37.7364091240834, -122.413592786804) | |||
| 179843 | 179843 | 241315 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 754 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007487.69135 | 2105254.04954 | 37.7610496524471 | -122.41720627174601 | (37.7610496524471, -122.417206271746) | |||
| 179395 | 179395 | 241382 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008151.18943 | 2105840.29781 | 37.762696660032 | -122.414953006889 | (37.762696660032, -122.414953006889) | |||
| 178824 | 178824 | 196980 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 320 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013452.78538 | 2105563.26016 | 37.76223245789279 | -122.396597126255 | (37.7622324578928, -122.396597126255) | |||
| 177638 | 177638 | 196976 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 209 Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014043.63491 | 2106091.78418 | 37.7637165344031 | -122.39459059758998 | (37.7637165344031, -122.39459059759) | |||
| 177306 | 177306 | 241346 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.762993462413895 | -122.410011039795 | (37.7629934624139, -122.410011039795) | |||
| 176576 | 176576 | 196964 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015932.05228 | 2105848.0016400004 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | |||
| 175807 | 175807 | 247600 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Tompkins Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6009197.59612 | 2096407.4718900002 | 37.7368549629719 | -122.410667669902 | (37.7368549629719, -122.410667669902) | |||
| 175626 | 175626 | 38888 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.788086727476504 | -122.45028674235 | (37.7880867274765, -122.45028674235) | |
| 174484 | 174484 | 40680 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 227 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41663 | 6004891.014880001 | 2093810.36977 | 37.7294815042584 | -122.42537266900601 | (37.7294815042584, -122.425372669006) | |
| 174238 | 174238 | 241311 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007420.66445 | 2106451.36867 | 37.76433344145371 | -122.417522949121 | (37.7643334414537, -122.417522949121) | |||
| 174204 | 174204 | 196999 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 14 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013629.21679 | 2100123.8728 | 37.7473068910098 | -122.39560579639401 | (37.7473068910098, -122.395605796394) | |||
| 173684 | 173684 | 196971 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015840.83077 | 2105843.6976400004 | 37.7631350930254 | -122.38835728138201 | (37.7631350930254, -122.388357281382) | |||
| 173275 | 173275 | 246856 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001680.71036 | 2109929.19364 | 37.773558043107 | -122.43762488777901 | (37.773558043107, -122.437624887779) | |||
| 173220 | 173220 | 241336 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | |||
| 173145 | 173145 | 196992 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.747370139416205 | -122.394524516312 | (37.7473701394162, -122.394524516312) | |||
| 172717 | 172717 | 196966 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015902.3504800005 | 2105846.23751 | 37.7631454756938 | -122.38814468075701 | (37.7631454756938, -122.388144680757) | |||
| 171371 | 171371 | 31983 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.724640001 | 2113855.38064 | 37.7839533587811 | -122.46118939688499 | (37.7839533587811, -122.461189396885) |
| 171330 | 171330 | 241349 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009630.95541 | 2105923.9500700003 | 37.7630093903014 | -122.409840907855 | (37.7630093903014, -122.409840907855) | |||
| 171042 | 171042 | 41934 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.0131599996 | 37.776976538320106 | -122.461929924013 | (37.7769765383201, -122.461929924013) | |
| 170616 | 170616 | 196967 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015888.58147 | 2105846.04273 | 37.7631441779792 | -122.38819228996799 | (37.7631441779792, -122.388192289968) | |||
| 170083 | 170083 | 241383 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008148.21617 | 2105873.00555 | 37.7627863008585 | -122.41496560548201 | (37.7627863008585, -122.414965605482) | |||
| 168875 | 168875 | 31525 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1330 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 12 | 4x4 | Permit Number 35080 | 6011118.504819999 | 2102111.6957099997 | 37.7526250409161 | -122.404427600678 | (37.7526250409161, -122.404427600678) |
| 168727 | 168727 | 241384 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008146.34247 | 2105906.05304 | 37.7628769363446 | -122.414974425147 | (37.7628769363446, -122.414974425147) | |||
| 168188 | 168188 | 136185 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 800 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010045.724640001 | 2116634.21167 | 37.7924404929984 | -122.409162155311 | (37.7924404929984, -122.409162155311) | |||
| 166315 | 166315 | 136177 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003216.31619 | 2118958.4665599996 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | |||
| 166136 | 166136 | 136187 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 840 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010038.55828 | 2116686.60963 | 37.7925839636381 | -122.409190650353 | (37.7925839636381, -122.409190650353) | |||
| 165408 | 165408 | 179277 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005276.23831 | 2092458.42558 | 37.725791120054396 | -122.423944813618 | (37.7257911200544, -122.423944813618) | |||
| 165280 | 165280 | 241347 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009595.63011 | 2105921.4482 | 37.7630005409651 | -122.40996290986799 | (37.7630005409651, -122.409962909868) | |||
| 165267 | 165267 | 196969 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015866.243419999 | 2105844.6030099997 | 37.763138987107 | -122.388269449981 | (37.763138987107, -122.388269449981) | |||
| 165056 | 165056 | 241299 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007561.10393 | 2105083.1685099998 | 37.7605845824436 | -122.416940261287 | (37.7605845824436, -122.416940261287) | |||
| 164075 | 164075 | 241289 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6011466.52977 | 2102070.65758 | 37.7525318019104 | -122.403221176312 | (37.7525318019104, -122.403221176312) | |||
| 163897 | 163897 | 241320 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007347.086630001 | 2107747.30956 | 37.767887651234105 | -122.417869305024 | (37.7678876512341, -122.417869305024) | |||
| 163754 | 163754 | 196981 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.40952709750401 | (37.7683194004524, -122.409527097504) | |||
| 163725 | 163725 | 196982 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
| 163275 | 163275 | 241358 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6008654.31002 | 2102275.26835 | 37.7529361586965 | -122.412960810713 | (37.7529361586965, -122.412960810713) | |||
| 162667 | 162667 | 65010 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | ||
| 162522 | 162522 | 30565 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | ||
| 162475 | 162475 | 31508 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2419 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 13 | Permit Number 35068 | 6011299.52328 | 2102275.53688 | 37.7530850270762 | -122.403813131691 | (37.7530850270762, -122.403813131691) | |
| 162285 | 162285 | 241373 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.751647212562204 | -122.427186107874 | (37.7516472125622, -122.427186107874) | |||
| 162238 | 162238 | 80705 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3118 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50051 | 5996015.97757 | 2111454.39172 | 37.77742212663279 | -122.457330280254 | (37.7774221266328, -122.457330280254) | |
| 161791 | 161791 | 246445 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 457 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.43040580490101 | (37.7458198862793, -122.430405804901) | |||
| 161716 | 161716 | 35346 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1124 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | Permit Number 38809 | 6012181.54645 | 2103168.5427 | 37.7555862611206 | -122.400825637793 | (37.7555862611206, -122.400825637793) | |
| 161693 | 161693 | 241355 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | |||
| 161686 | 161686 | 241282 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011466.587590001 | 2101921.66983 | 37.7521227174025 | -122.403210496885 | (37.7521227174025, -122.403210496885) | |||
| 161481 | 161481 | 197008 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 503 Beale St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015819.96471 | 2114109.17282 | 37.785829105370105 | -122.389006570307 | (37.7858291053701, -122.389006570307) | |||
| 161370 | 161370 | 241304 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007541.98711 | 2105410.71397 | 37.761482871149894 | -122.417029586455 | (37.7614828711499, -122.417029586455) | |||
| 161219 | 161219 | 241342 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2122 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009546.723809999 | 2104789.44467 | 37.7598895755605 | -122.410052140597 | (37.7598895755605, -122.410052140597) | |||
| 160242 | 160242 | 241335 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | |||
| 160203 | 160203 | 241333 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 259 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007398.77752 | 2108173.34419 | 37.7690603509832 | -122.417720712761 | (37.7690603509832, -122.417720712761) | |||
| 159534 | 159534 | 241374 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004551.11836 | 2101892.73239 | 37.751654622063604 | -122.427123184105 | (37.7516546220636, -122.427123184105) | |||
| 159335 | 159335 | 196968 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015876.458740001 | 2105845.10564 | 37.7631409332394 | -122.38823415338899 | (37.7631409332394, -122.388234153389) | |||
| 158888 | 158888 | 196975 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014043.29115 | 2106063.3256200003 | 37.7636383743244 | -122.39458979361099 | (37.7636383743244, -122.394589793611) | |||
| 158188 | 158188 | 196985 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | |||
| 158009 | 158009 | 213852 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991160.0842699995 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | |||
| 157452 | 157452 | 241300 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 793 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007560.005419999 | 2105104.33275 | 37.7606426327636 | -122.416945560095 | (37.7606426327636, -122.416945560095) | |||
| 156225 | 156225 | 50665 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 5 | Permit Number 47244 | 6000927.33064 | 2091848.9350299998 | 37.7238711151562 | -122.43893497427901 | (37.7238711151562, -122.438934974279) | ||
| 154968 | 154968 | 196989 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.749089017243904 | -122.401913980245 | (37.7490890172439, -122.401913980245) | |||
| 154422 | 154422 | 70110 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 9 | 6006114.15907 | 2093862.3893900001 | 37.7296933683514 | -122.42114782490499 | (37.7296933683514, -122.421147824905) | ||
| 154012 | 154012 | 241378 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 273 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004715.159630001 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | |||
| 153311 | 153311 | 119966 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5987215.946719999 | 2112352.1893599997 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | |||
| 152596 | 152596 | 241277 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1400 Potrero Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010729.0783 | 2101044.09639 | 37.749671877762 | -122.405699121544 | (37.749671877762, -122.405699121544) | |||
| 152370 | 152370 | 196996 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 10 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | |||
| 152365 | 152365 | 196991 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014086.846369999 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | |||
| 152209 | 152209 | 179280 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 16 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010456.33755 | 2094955.50587 | 37.732938666383205 | -122.406213356571 | (37.7329386663832, -122.406213356571) | |||
| 151656 | 151656 | 241314 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 722 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007476.75646 | 2105385.74126 | 37.7614106322283 | -122.417253423206 | (37.7614106322283, -122.417253423206) | |||
| 151502 | 151502 | 241302 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007545.5728 | 2105350.70249 | 37.7613182952255 | -122.41701293280501 | (37.7613182952255, -122.417012932805) | |||
| 151179 | 151179 | 241322 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 442 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007381.66806 | 2107115.42092 | 37.76615457939621 | -122.417704898167 | (37.7661545793962, -122.417704898167) | |||
| 151046 | 151046 | 241306 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 635 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007512.51553 | 2105948.57414 | 37.7629580524843 | -122.41716963068501 | (37.7629580524843, -122.417169630685) | |||
| 150108 | 150108 | 241344 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2180 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009557.961759999 | 2104644.45965 | 37.7594921093986 | -122.410003038507 | (37.7594921093986, -122.410003038507) | |||
| 150026 | 150026 | 111741 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5992530.718830001 | 2112167.7442799998 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | |||
| 149584 | 149584 | 241343 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2170 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009555.0777199995 | 2104672.73912 | 37.7595695967776 | -122.41001500939801 | (37.7595695967776, -122.410015009398) | |||
| 149354 | 149354 | 241287 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6011467.38591 | 2102056.94062 | 37.7524941859569 | -122.403217250793 | (37.7524941859569, -122.403217250793) |
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");