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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186919 | 186919 | 236965 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 151 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006579.97062 | 2098816.08158 | 37.7433213582914 | -122.419888837923 | (37.7433213582914, -122.419888837923) | |||
186905 | 186905 | 236386 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 138 Carl St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5997744.87985 | 2107159.8634 | 37.7657296047634 | -122.451039706011 | (37.7657296047634, -122.451039706011) | |||
186895 | 186895 | 196150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6013505.49575 | 2104693.9882799997 | 37.7598485610787 | -122.396353889321 | (37.7598485610787, -122.396353889321) | |||
186881 | 186881 | 248500 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998823.4029 | 2107855.6071 | 37.767701628786995 | -122.44735942334499 | (37.767701628787, -122.447359423345) | |||
186867 | 186867 | 237611 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001014.58495 | 2104947.25452 | 37.759840976186396 | -122.43957189572399 | (37.7598409761864, -122.439571895724) | |||
186809 | 186809 | 178765 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 185 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003594.440280001 | 2094635.94585 | 37.7316750109714 | -122.42991391890101 | (37.7316750109714, -122.429913918901) | |||
186797 | 186797 | 236848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1442 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5996859.967569999 | 2106373.72376 | 37.7635203643883 | -122.454043627814 | (37.7635203643883, -122.454043627814) | |||
186770 | 186770 | 78427 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001123.9692400005 | 2089480.39079 | 37.7173788130682 | -122.43808564286199 | (37.7173788130682, -122.438085642862) | ||
186768 | 186768 | 196121 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 889 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012182.661669999 | 2104242.52295 | 37.75853523703729 | -122.40089723372299 | (37.7585352370373, -122.400897233723) | |||
186740 | 186740 | 213062 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2101 09th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993656.47292 | 2101131.0792900003 | 37.7489412100718 | -122.46474267513901 | (37.7489412100718, -122.464742675139) | |||
186729 | 186729 | 212524 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 231 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996040.28289 | 2098087.9416900002 | 37.740722653926504 | -122.456279498025 | (37.7407226539265, -122.456279498025) | |||
186726 | 186726 | 237840 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002656.38995 | 2097260.0383900004 | 37.7388269999663 | -122.43334438554199 | (37.7388269999663, -122.433344385542) | |||
186724 | 186724 | 178727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 315 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002534.17565 | 2091732.34883 | 37.723642288038995 | -122.43337205140499 | (37.723642288039, -122.433372051405) | |||
186645 | 186645 | 237674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 187 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001739.29135 | 2107730.05702 | 37.7675230903329 | -122.437264753368 | (37.7675230903329, -122.437264753368) | |||
186627 | 186627 | 236519 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007518.43278 | 2099165.37263 | 37.7443332592681 | -122.41666860848301 | (37.7443332592681, -122.416668608483) | |||
186616 | 186616 | 196131 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012036.935319999 | 2101652.28346 | 37.751414877192104 | -122.40121920810499 | (37.7514148771921, -122.401219208105) | ||||
186576 | 186576 | 236472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007717.14359 | 2097625.55778 | 37.740116443412106 | -122.415872490846 | (37.7401164434121, -122.415872490846) | |||
186568 | 186568 | 37600 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 767 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | 5x6 | Permit Number 40027 | 5992555.22947 | 2110228.65123 | 37.773857197137 | -122.46921280405701 | (37.773857197137, -122.469212804057) |
186550 | 186550 | 212928 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1922 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5990971.4901 | 2102273.63801 | 37.751923214506505 | -122.474110615235 | (37.7519232145065, -122.474110615235) | |||
186504 | 186504 | 143143 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2004 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002763.9046 | 2119588.4077 | 37.8001413162664 | -122.434568758341 | (37.8001413162664, -122.434568758341) | |||
186483 | 186483 | 237791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999972.622769999 | 2106855.11148 | 37.765020120596105 | -122.44331255653499 | (37.7650201205961, -122.443312556535) | |||
186480 | 186480 | 246987 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.749401917482295 | -122.426458941248 | (37.7494019174823, -122.426458941248) | |||
186476 | 186476 | 54020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 862 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 13 | Permit Number 9739 | 5985131.43408 | 2109993.46709 | 37.7727796747305 | -122.49487519957701 | (37.7727796747305, -122.494875199577) | ||
186458 | 186458 | 84356 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 755 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51578 | 5993171.12842 | 2110327.56261 | 37.7741643511675 | -122.467089520018 | (37.7741643511675, -122.467089520018) | |
186447 | 186447 | 235735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2709 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009841.51025 | 2103938.67968 | 37.7575700846188 | -122.408972585433 | (37.7575700846188, -122.408972585433) | |||
186415 | 186415 | 31371 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 537 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34973 | 5991501.22289 | 2099052.17268 | 37.7431085759965 | -122.472043958778 | (37.7431085759965, -122.472043958778) | |
186411 | 186411 | 212594 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994725.97999 | 2090829.66593 | 37.720717663074296 | -122.460298068198 | (37.7207176630743, -122.460298068198) | |||
186399 | 186399 | 202168 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.728359287049706 | -122.396753038148 | (37.7283592870497, -122.396753038148) | |||
186380 | 186380 | 84919 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 215 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2007 12:00:00 AM | 3 | Permit Number 49339 | 6009512.67609 | 2094567.40157 | 37.731820184958 | -122.409448471593 | (37.731820184958, -122.409448471593) | ||
186373 | 186373 | 235680 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 360 Church St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004156.62243 | 2106773.54095 | 37.7650338487635 | -122.428835325093 | (37.7650338487635, -122.428835325093) | |||
186371 | 186371 | 43586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1983 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 2 | Permit Number 43247 | 5986913.6448 | 2101776.5179 | 37.7503223588527 | -122.48810650903799 | (37.7503223588527, -122.488106509038) | |
186364 | 186364 | 214275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 222 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999252.48995 | 2094096.64212 | 37.7299473620799 | -122.44488610301 | (37.7299473620799, -122.44488610301) | |||
186351 | 186351 | 82720 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1013 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51582 | 5992460.12309 | 2110660.03692 | 37.7750361697564 | -122.46957319916099 | (37.7750361697564, -122.469573199161) | |
186339 | 186339 | 183428 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2430 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5989548.6064 | 2098792.6969999997 | 37.742282937054 | -122.478776534673 | (37.742282937054, -122.478776534673) | |||
186315 | 186315 | 196228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010909.1819400005 | 2109688.5937900003 | 37.773417795633605 | -122.40568511549 | (37.7734177956336, -122.40568511549) | |||
186308 | 186308 | 94531 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1545@ Post St Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2010 12:00:00 AM | 2 | Permit Number 53714 | 6001073.2705 | 2113819.9294 | 37.784206460012605 | -122.440005142548 | (37.7842064600126, -122.440005142548) | ||
186301 | 186301 | 196232 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 615 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013100.84916 | 2111783.99463 | 37.77929360435729 | -122.398250818526 | (37.7792936043573, -122.398250818526) | |||
186278 | 186278 | 218119 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 51 Lopez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5994014.29186 | 2100634.4512400003 | 37.747598218302606 | -122.463469309776 | (37.7475982183026, -122.463469309776) | |||
186255 | 186255 | 139401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 935 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003057.7248 | 2111318.2811 | 37.7774503299772 | -122.43296085431601 | (37.7774503299772, -122.432960854316) | |||
186216 | 186216 | 250997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | |||
186169 | 186169 | 236818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 46 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997100.45954 | 2106270.27738 | 37.7632501136112 | -122.453204378701 | (37.7632501136112, -122.453204378701) | |||
186163 | 186163 | 196226 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011518.54509 | 2109697.48607 | 37.77347626865829 | -122.40357785554501 | (37.7734762686583, -122.403577855545) | |||
186140 | 186140 | 212998 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1627 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993678.65574 | 2104395.17492 | 37.7579048572517 | -122.464902986481 | (37.7579048572517, -122.464902986481) | |||
186103 | 186103 | 236871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 170 Ashbury Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999698.028519999 | 2106707.13098 | 37.7645981407253 | -122.44425167177299 | (37.7645981407253, -122.444251671773) | |||
186094 | 186094 | 120730 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 614 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989435.18429 | 2111138.07749 | 37.776173447272896 | -122.480071994932 | (37.7761734472729, -122.480071994932) | |||
186060 | 186060 | 135702 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 398 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997660.5036 | 2115171.08155 | 37.7877214966006 | -122.451909554601 | (37.7877214966006, -122.451909554601) | |||
186054 | 186054 | 236996 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 726 Eugenia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008178.945040001 | 2097681.02688 | 37.7402947007467 | -122.414279688066 | (37.7402947007467, -122.414279688066) | |||
186028 | 186028 | 235695 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 451 Lily St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004373.813159999 | 2109952.00813 | 37.773773440623 | -122.428310668716 | (37.773773440623, -122.428310668716) | |||
185985 | 185985 | 235673 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 31 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005825.68256 | 2108893.89791 | 37.770950170134604 | -122.423213186338 | (37.7709501701346, -122.423213186338) | |||
185984 | 185984 | 50509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 812 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47144 | 6003323.52841 | 2089782.3870599999 | 37.7183328750409 | -122.43050432831001 | (37.7183328750409, -122.43050432831) | |
185969 | 185969 | 196231 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010957.08191 | 2109733.0709599997 | 37.7735425981523 | -122.40552255492399 | (37.7735425981523, -122.405522554924) | |||
185962 | 185962 | 213076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1926 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993819.28319 | 2102383.76961 | 37.7523901631981 | -122.464270614697 | (37.7523901631981, -122.464270614697) | |||
185940 | 185940 | 196285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2209 25th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012134.59471 | 2101859.1570900003 | 37.7519883551004 | -122.400896021442 | (37.7519883551004, -122.400896021442) | ||||
185938 | 185938 | 201942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013661.36989 | 2092347.25444 | 37.7259556950922 | -122.394950034125 | (37.7259556950922, -122.394950034125) | |||
185936 | 185936 | 236620 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3031 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008725.435 | 2102707.5720900004 | 37.7541271596615 | -122.412745405998 | (37.7541271596615, -122.412745405998) | |||
185926 | 185926 | 236557 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2437 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008239.41087 | 2104223.5225400003 | 37.758262323360704 | -122.41453346683998 | (37.7582623233607, -122.41453346684) | |||
185910 | 185910 | 80235 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1820 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | 6 | 6004189.43733 | 2119092.90581 | 37.7988616164221 | -122.429600505158 | (37.7988616164221, -122.429600505158) | ||
185893 | 185893 | 236608 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 315 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006534.89896 | 2104278.64963 | 37.7583177827548 | -122.420432337784 | (37.7583177827548, -122.420432337784) | |||
185885 | 185885 | 201972 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 19 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013746.1142 | 2092220.9433400002 | 37.725613582194796 | -122.39464823513501 | (37.7256135821948, -122.394648235135) | |||
185836 | 185836 | 67660 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 37 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 6 | Permit Number 31261 | 6014167.43331 | 2093890.7896900002 | 37.7302220581813 | -122.39330855826701 | (37.7302220581813, -122.393308558267) | |
185803 | 185803 | 236801 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 190 Saint Germain Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997418.2682300005 | 2104137.67772 | 37.757412742825295 | -122.451951323594 | (37.7574127428253, -122.451951323594) | |||
185772 | 185772 | 236885 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 19 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999769.574580001 | 2107737.24411 | 37.7674306553375 | -122.44407823752701 | (37.7674306553375, -122.444078237527) | |||
185757 | 185757 | 200053 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1555 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015307.2832 | 2094192.9021 | 37.7311148594787 | -122.38938900173001 | (37.7311148594787, -122.38938900173) | |||
185730 | 185730 | 235741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1306 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009508.71232 | 2101497.0814099996 | 37.750847354624 | -122.409951183604 | (37.750847354624, -122.409951183604) | |||
185728 | 185728 | 51437 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 535 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 2 | Permit Number 47757 | 5983145.9728 | 2112126.6615400002 | 37.7785203841092 | -122.501900888351 | (37.7785203841092, -122.501900888351) | ||
185688 | 185688 | 214285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 209 Edna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.83895 | 2093556.15177 | 37.728433460428 | -122.44665409012501 | (37.728433460428, -122.446654090125) | |||
185685 | 185685 | 236759 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004655.95554 | 2096917.75381 | 37.7380004006851 | -122.42640645410101 | (37.7380004006851, -122.426406454101) | |||
185640 | 185640 | 78231 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 924 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 8 | 6008861.56541 | 2090881.2509400002 | 37.7216622938669 | -122.411439180279 | (37.7216622938669, -122.411439180279) | ||
185634 | 185634 | 235925 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010207.4018 | 2104043.5827200003 | 37.75787861412971 | -122.407714575087 | (37.7578786141297, -122.407714575087) | |||
185561 | 185561 | 244471 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 677 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003352.2123 | 2109628.4539 | 37.772827181112206 | -122.431821439624 | (37.7728271811122, -122.431821439624) | |||
185524 | 185524 | 236355 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1604 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003956.0360900005 | 2098892.33757 | 37.7433825652603 | -122.42896716120701 | (37.7433825652603, -122.428967161207) | |||
185521 | 185521 | 40682 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 282 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41665 | 6005246.74366 | 2093787.5354799998 | 37.729438897979605 | -122.424141255239 | (37.7294388979796, -122.424141255239) | |
185491 | 185491 | 73430 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 657 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 8 | 6001050.4616 | 2111002.9975 | 37.776470583651 | -122.439882012858 | (37.776470583651, -122.439882012858) | ||
185482 | 185482 | 49363 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875@ EVANS Marin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | 3 | Permit Number 46338 | 6014150.899019999 | 2100527.8780900002 | 37.748445208788 | -122.39383011827 | (37.748445208788, -122.39383011827) | ||
185452 | 185452 | 202274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 56 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012930.694630001 | 2093286.6475400003 | 37.7284944200689 | -122.397541802039 | (37.7284944200689, -122.397541802039) | |||
185434 | 185434 | 140865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 14 WOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998530.5033 | 2113712.8825 | 37.783767456922604 | -122.448794462714 | (37.7837674569226, -122.448794462714) | |||
185410 | 185410 | 178754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 27 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008327.5198 | 2086871.77855 | 37.7106231499219 | -122.41300188991801 | (37.7106231499219, -122.413001889918) | |||
185387 | 185387 | 246142 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 625 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997538.0449 | 2108317.2701 | 37.768895704242 | -122.451838603981 | (37.768895704242, -122.451838603981) | |||
185374 | 185374 | 213008 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992807.17084 | 2104103.4911 | 37.757053683090795 | -122.46789570631901 | (37.7570536830908, -122.467895706319) | |||
185327 | 185327 | 218062 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5992127.15532 | 2095365.65932 | 37.7330225434591 | -122.46961135920401 | (37.7330225434591, -122.469611359204) | |||
185316 | 185316 | 212523 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997152.58172 | 2099268.39938 | 37.7440276912283 | -122.452518778745 | (37.7440276912283, -122.452518778745) | |||
185312 | 185312 | 178780 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1726 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998049.19765 | 2088646.54217 | 37.7149139107276 | -122.448653629286 | (37.7149139107276, -122.448653629286) | |||
185253 | 185253 | 38724 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 439 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45328 | 5984981.48092 | 2112906.9180099997 | 37.7807703956275 | -122.49560882850099 | (37.7807703956275, -122.495608828501) | |
185197 | 185197 | 237476 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4145 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6001564.84544 | 2103483.5512099997 | 37.755853304012106 | -122.437563995588 | (37.7558533040121, -122.437563995588) | |||
185190 | 185190 | 248612 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997643.278 | 2107552.7781 | 37.7668026311269 | -122.45141946492201 | (37.7668026311269, -122.451419464922) | |||
185177 | 185177 | 135806 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008809.714930001 | 2119549.2222700003 | 37.8003750720026 | -122.41364506887399 | (37.8003750720026, -122.413645068874) | |||
185095 | 185095 | 45589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1758 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44325 | 5985669.1963 | 2103253.8848 | 37.7543061263725 | -122.49251862163 | (37.7543061263725, -122.49251862163) | |
185069 | 185069 | 135772 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2362 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6002252.135869999 | 2117781.82005 | 37.795151832939204 | -122.43621031625901 | (37.7951518329392, -122.436210316259) | |||
185040 | 185040 | 178792 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 717 Avalon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004484.77031 | 2092222.52485 | 37.725098673538106 | -122.426664070312 | (37.7250986735381, -122.426664070312) | |||
185018 | 185018 | 118428 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5400 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5981858.846609999 | 2111695.90062 | 37.7772619476301 | -122.50632151854099 | (37.7772619476301, -122.506321518541) | |||
184988 | 184988 | 218036 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 130 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992665.92158 | 2098223.44631 | 37.7409004327985 | -122.467956512189 | (37.7409004327985, -122.467956512189) | |||
184983 | 184983 | 72002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1987 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987538.0362 | 2101772.9771 | 37.7503490431313 | -122.485947089116 | (37.7503490431313, -122.485947089116) | ||
184977 | 184977 | 212941 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 936 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992791.49418 | 2106651.11011 | 37.7640478716417 | -122.468135238971 | (37.7640478716417, -122.468135238971) | |||
184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
184964 | 184964 | 212529 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996323.43261 | 2094932.05089 | 37.7320735950078 | -122.45507248909901 | (37.7320735950078, -122.455072489099) | |||
184914 | 184914 | 235966 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010525.19647 | 2099961.42773 | 37.7466877032867 | -122.406327881639 | (37.7466877032867, -122.406327881639) | |||
184905 | 184905 | 30305 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | 9 | Permit Number 7 | 5996194.44946 | 2113622.43964 | 37.7833852609546 | -122.456869738263 | (37.7833852609546, -122.456869738263) | ||
184831 | 184831 | 217925 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992952.1579 | 2103933.69165 | 37.7565958292516 | -122.46738194343901 | (37.7565958292516, -122.467381943439) | |||
184803 | 184803 | 121966 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 26 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5991179.292640001 | 2114937.5267 | 37.7867068686376 | -122.47431602898001 | (37.7867068686376, -122.47431602898) | ||||
184793 | 184793 | 237622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002063.389330001 | 2104036.40099 | 37.7573996289108 | -122.43587942692 | (37.7573996289108, -122.43587942692) |
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");