Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4925 | 4925 | 253721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 260 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2017 12:00:00 AM | 3 | 3.5x9 | Permit Number 780843 | 5994045.0 | 2113761.0 | 37.7836420503516 | -122.464315992766 | (37.7836420503516, -122.464315992766) | |
| 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) | ||||
| 2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 3419 | 3419 | 252969 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998180.94106 | 2087280.50358 | 37.711170613109104 | -122.448099970249 | (37.7111706131091, -122.448099970249) | |||||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 149811 | 149811 | 249400 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008085.571690001 | 2113256.87585 | 37.7830571448252 | -122.41570511799699 | (37.7830571448252, -122.415705117997) | |||
| 55329 | 55329 | 249399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 222 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008090.577380001 | 2113215.48771 | 37.78294378436429 | -122.41568486886999 | (37.7829437843643, -122.41568486887) | |||
| 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) | |||
| 179044 | 179044 | 248303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006799.1058 | 2099943.7824 | 37.7464301139591 | -122.419211100336 | (37.7464301139591, -122.419211100336) | |||
| 134057 | 134057 | 248302 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006787.2124 | 2099920.739 | 37.746366172175 | -122.41925059210199 | (37.746366172175, -122.419250592102) | |||
| 188523 | 188523 | 248301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3175 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006762.6824 | 2099881.3423 | 37.7462566162113 | -122.419332619842 | (37.7462566162113, -122.419332619842) | |||
| 172539 | 172539 | 248300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.41936235698401 | (37.74621325229, -122.419362356984) | |||
| 54021 | 54021 | 248025 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 443 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009980.9710099995 | 2098457.93236 | 37.7425289746384 | -122.408103750406 | (37.7425289746384, -122.408103750406) | |||
| 186441 | 186441 | 248005 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009949.03766 | 2098432.55716 | 37.7424575118092 | -122.408212377719 | (37.7424575118092, -122.408212377719) | |||
| 169427 | 169427 | 248000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 402 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009971.140819999 | 2098682.22782 | 37.7431442907726 | -122.408153555751 | (37.7431442907726, -122.408153555751) | |||
| 160304 | 160304 | 247591 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Tompkins Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008974.65943 | 2096434.5209700002 | 37.736916732029705 | -122.411440373668 | (37.7369167320297, -122.411440373668) | ||||
| 40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
| 69161 | 69161 | 247568 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.734071490194296 | -122.41235633497101 | (37.7340714901943, -122.412356334971) | |||
| 60831 | 60831 | 247567 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | |||
| 160606 | 160606 | 247566 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008741.21767 | 2095435.4350400001 | 37.7341603621059 | -122.41217689865101 | (37.7341603621059, -122.412176898651) | |||
| 44172 | 44172 | 247564 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | |||
| 44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
| 147505 | 147505 | 247402 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 944 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | |||
| 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) | |||
| 154405 | 154405 | 246962 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6002859.8798400005 | 2106886.32393 | 37.7652700431031 | -122.43332849181999 | (37.7652700431031, -122.43332849182) | |||
| 46583 | 46583 | 246509 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | |||
| 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) | |||
| 75038 | 75038 | 246064 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997522.9034 | 2108415.3867 | 37.7691642400439 | -122.45189805652399 | (37.7691642400439, -122.451898056524) | |||
| 36006 | 36006 | 246059 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 602 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997560.3028 | 2108454.9059 | 37.76927489165771 | -122.451771545977 | (37.7692748916577, -122.451771545977) | |||
| 71155 | 71155 | 246033 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998175.5001 | 2108450.8177 | 37.769298881123 | -122.44964332461001 | (37.769298881123, -122.44964332461) | |||
| 43382 | 43382 | 246032 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998172.7746 | 2108470.8044 | 37.7693536035765 | -122.44965419238501 | (37.7693536035765, -122.449654192385) | |||
| 74416 | 74416 | 246027 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998205.4802 | 2108541.9693 | 37.76955087528 | -122.449546194352 | (37.76955087528, -122.449546194352) | |||
| 153252 | 153252 | 246026 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998207.6 | 2108524.1023 | 37.7695019383238 | -122.44953757446899 | (37.7695019383238, -122.449537574469) | |||
| 160235 | 160235 | 246010 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1509 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998926.3648 | 2108660.5268 | 37.7699176174446 | -122.447061224692 | (37.7699176174446, -122.447061224692) | |||
| 157021 | 157021 | 245987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999858.6241 | 2108792.1061 | 37.7703321208314 | -122.44384602423 | (37.7703321208314, -122.44384602423) | |||
| 43844 | 43844 | 245441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2911 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007346.0609 | 2106731.0495 | 37.7650971816433 | -122.417800808591 | (37.7650971816433, -122.417800808591) | |||
| 69751 | 69751 | 245375 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005426.8606 | 2097389.365 | 37.7393388868642 | -122.42377457529301 | (37.7393388868642, -122.423774575293) | |||
| 60392 | 60392 | 244923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1318 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999810.5322 | 2108837.5844 | 37.7704542495024 | -122.444015641705 | (37.7704542495024, -122.444015641705) | |||
| 59502 | 59502 | 244531 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | |||
| 166691 | 166691 | 244474 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1909 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997392.6079 | 2108791.0607 | 37.7701882806465 | -122.452375851759 | (37.7701882806465, -122.452375851759) | |||
| 1105 | 1105 | 244414 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 261 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:17:00 PM | 3 | Width 0ft | 6005541.7456 | 2110219.4552 | 37.7745738026307 | -122.424289625835 | (37.7745738026307, -122.424289625835) | ||
| 1093 | 1093 | 244319 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:00:00 PM | 3 | Width 0ft | 6005497.6412 | 2110517.1934 | 37.7753888290162 | -122.424463374134 | (37.7753888290162, -122.424463374134) | ||
| 1108 | 1108 | 244318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:08:00 PM | 3 | Width 0ft | 6005494.8083 | 2110541.2729 | 37.7754547855001 | -122.424474886956 | (37.7754547855001, -122.424474886956) | ||
| 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) | |||
| 159802 | 159802 | 244178 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1628 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998757.1914 | 2109033.6603 | 37.770932480068105 | -122.447673254342 | (37.7709324800681, -122.447673254342) | |||
| 68220 | 68220 | 244177 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1628 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998770.8634 | 2109036.2238 | 37.7709403001609 | -122.44762614728701 | (37.7709403001609, -122.447626147287) | |||
| 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) | |||
| 136242 | 136242 | 244040 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 540 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997548.4099 | 2108554.3655 | 37.7695473010692 | -122.451819858751 | (37.7695473010692, -122.451819858751) | |||
| 42229 | 42229 | 240207 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | |||
| 132617 | 132617 | 240206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003903.54766 | 2097252.3303400003 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | |||
| 179041 | 179041 | 240205 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002599.9876 | 2096899.86345 | 37.737834842704004 | -122.433513665818 | (37.737834842704, -122.433513665818) | |||
| 44860 | 44860 | 240204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.276330001 | 2096896.15431 | 37.7378224050816 | -122.43365070183901 | (37.7378224050816, -122.433650701839) | |||
| 44193 | 44193 | 240203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.6439 | 2096455.85562 | 37.736613467133004 | -122.433617972817 | (37.736613467133, -122.433617972817) | |||
| 131009 | 131009 | 240202 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3006 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002850.86093 | 2096098.0434 | 37.7356474594489 | -122.43258901797701 | (37.7356474594489, -122.432589017977) | |||
| 175081 | 175081 | 240201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3004 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002850.8471 | 2096117.4239599998 | 37.735700673245 | -122.432590449705 | (37.735700673245, -122.432590449705) | |||
| 36074 | 36074 | 240200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.43395336236401 | (37.736769456354, -122.433953362364) | |||
| 61577 | 61577 | 240199 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002587.38275 | 2096084.8942099998 | 37.7355964094447 | -122.433499023086 | (37.7355964094447, -122.433499023086) | |||
| 154667 | 154667 | 240198 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002599.46299 | 2096074.44073 | 37.735568391971604 | -122.433456510332 | (37.7355683919716, -122.433456510332) | |||
| 133936 | 133936 | 240197 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002619.5193 | 2096053.2786 | 37.7355114234985 | -122.43338565634599 | (37.7355114234985, -122.433385656346) | |||
| 74866 | 74866 | 240196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.735811408553296 | -122.42861695621 | (37.7358114085533, -122.42861695621) | |||
| 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) | |||
| 69666 | 69666 | 240194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004261.63308 | 2097975.00788 | 37.7408810812017 | -122.42784513465901 | (37.7408810812017, -122.427845134659) | |||
| 165461 | 165461 | 240193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004261.16012 | 2097999.70879 | 37.740948877501204 | -122.42784852959998 | (37.7409488775012, -122.4278485296) | |||
| 30852 | 30852 | 240192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.42777298295401 | (37.7415368893219, -122.427772982954) | |||
| 48649 | 48649 | 240191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004293.70696 | 2098089.97952 | 37.7411985814464 | -122.427742424874 | (37.7411985814464, -122.427742424874) | |||
| 162571 | 162571 | 240190 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004298.57929 | 2097992.8261599997 | 37.7409320961319 | -122.427718657607 | (37.7409320961319, -122.427718657607) | |||
| 173604 | 173604 | 240189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004299.90436 | 2097973.73041 | 37.7408797385189 | -122.427712715772 | (37.7408797385189, -122.427712715772) | |||
| 135932 | 135932 | 240188 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004313.76435 | 2097764.66953 | 37.74030648905929 | -122.42764990171499 | (37.7403064890593, -122.427649901715) | |||
| 58478 | 58478 | 240187 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 84 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004879.89291 | 2097658.89878 | 37.7400480733545 | -122.425684927129 | (37.7400480733545, -122.425684927129) | |||
| 74659 | 74659 | 240186 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004876.9244 | 2097755.23098 | 37.740312411980206 | -122.425702045734 | (37.7403124119802, -122.425702045734) | |||
| 182814 | 182814 | 240185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001017.63107 | 2106166.1197099998 | 37.76318785445999 | -122.439648742804 | (37.76318785446, -122.439648742804) | |||
| 170390 | 170390 | 240184 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3371 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004431.11432 | 2106566.00014 | 37.764479523721704 | -122.427871135859 | (37.7644795237217, -122.427871135859) | |||
| 55365 | 55365 | 240183 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3371 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004376.30162 | 2106560.65422 | 37.764461744133 | -122.428060337037 | (37.764461744133, -122.428060337037) | |||
| 184836 | 184836 | 240182 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3399 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004311.1947099995 | 2106557.83586 | 37.7644503218386 | -122.42828532312299 | (37.7644503218386, -122.428285323123) | |||
| 185509 | 185509 | 240181 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3399 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004284.27774 | 2106554.82474 | 37.7644405309357 | -122.42837820690201 | (37.7644405309357, -122.428378206902) | |||
| 30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
| 186113 | 186113 | 240179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008252.0977 | 2096866.76003 | 37.7380630114909 | -122.41396916654199 | (37.7380630114909, -122.413969166542) | |||
| 188451 | 188451 | 240178 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 425 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008247.1635300005 | 2096824.3418400001 | 37.737946263300294 | -122.413983226571 | (37.7379462633003, -122.413983226571) | |||
| 149069 | 149069 | 240177 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 431 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008245.857419999 | 2096810.19574 | 37.7379073478479 | -122.41398674200799 | (37.7379073478479, -122.413986742008) | |||
| 176007 | 176007 | 240176 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 437 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.87185 | 2096776.8693400002 | 37.737815616996606 | -122.41399816519301 | (37.7378156169966, -122.413998165193) | |||
| 173878 | 173878 | 240175 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 449 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008238.06241 | 2096739.7432799998 | 37.7377134629997 | -122.414008710659 | (37.7377134629997, -122.414008710659) | |||
| 58670 | 58670 | 240174 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008235.53885 | 2096703.3498099998 | 37.7376133927535 | -122.414014861994 | (37.7376133927535, -122.414014861994) | |||
| 165779 | 165779 | 240173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 479 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008226.13214 | 2096616.22603 | 37.737373641567395 | -122.414041223846 | (37.7373736415674, -122.414041223846) | |||
| 133737 | 133737 | 240172 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008195.53017 | 2096250.8800700002 | 37.73636876251379 | -122.414121189761 | (37.7363687625138, -122.414121189761) | |||
| 62846 | 62846 | 240171 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 457 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007878.36492 | 2096720.03268 | 37.7376391331344 | -122.415250966654 | (37.7376391331344, -122.415250966654) | |||
| 170342 | 170342 | 240170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.763508882764796 | -122.45091719498699 | (37.7635088827648, -122.450917194987) | |||
| 59141 | 59141 | 240169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 204 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5998975.98045 | 2106976.10403 | 37.7652954525443 | -122.446768387673 | (37.7652954525443, -122.446768387673) | |||
| 167097 | 167097 | 240168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 116 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998899.29279 | 2107504.14215 | 37.766740931067204 | -122.447071634562 | (37.7667409310672, -122.447071634562) | |||
| 63717 | 63717 | 240167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.764260973182395 | -122.44740261924 | (37.7642609731824, -122.44740261924) | |||
| 67554 | 67554 | 240166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998780.1300099995 | 2106624.27042 | 37.7643182159335 | -122.44742045909099 | (37.7643182159335, -122.447420459091) | |||
| 181921 | 181921 | 240165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998776.9827 | 2106633.40006 | 37.7643431037773 | -122.447432001889 | (37.7643431037773, -122.447432001889) | |||
| 173465 | 173465 | 240164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | |||
| 56601 | 56601 | 240163 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 499 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998551.61498 | 2106310.67674 | 37.7634441054949 | -122.448188242691 | (37.7634441054949, -122.448188242691) | |||
| 164262 | 164262 | 240162 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 497 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998550.13742 | 2106327.4431 | 37.763490057236204 | -122.448194560431 | (37.7634900572362, -122.448194560431) | |||
| 31164 | 31164 | 240161 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 504 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998591.56873 | 2106281.83073 | 37.7633671855679 | -122.448047979048 | (37.7633671855679, -122.448047979048) | |||
| 35505 | 35505 | 240160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) |
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");