Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19809 | 19809 | 108982 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772764 | 5998041.9 | 2106031.7 | 37.7626489535182 | -122.44993106737499 | (37.7626489535182, -122.449931067375) |
| 21440 | 21440 | 2425 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2849 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2000 12:00:00 AM | 3 | 3X3 | 6009873.53551 | 2100800.70668 | 37.7489557035601 | -122.408640465788 | (37.7489557035601, -122.408640465788) | ||
| 25102 | 25102 | 231510 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 279 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006750.80231 | 2102189.77011 | 37.7525943650464 | -122.419537448513 | (37.7525943650464, -122.419537448513) | |||
| 26014 | 26014 | 231498 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011317.42279 | 2101858.91316 | 37.751942069684894 | -122.403721918837 | (37.7519420696849, -122.403721918837) | |||
| 26514 | 26514 | 193470 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 981 Le Conte Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013233.09279 | 2089478.4366400002 | 37.7180546742753 | -122.396229595828 | (37.7180546742753, -122.396229595828) | ||||
| 27784 | 27784 | 177494 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1002x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6001533.96245 | 2088133.73568 | 37.7137045060241 | -122.43657215399901 | (37.7137045060241, -122.436572153999) | ||||
| 27804 | 27804 | 79101 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1001 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52248 | 6008663.84115 | 2118640.6055900003 | 37.7978720438282 | -122.414085535233 | (37.7978720438282, -122.414085535233) | |
| 27855 | 27855 | 58725 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1400 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1979 12:00:00 AM | 2 | Permit Number 17959 | 6011699.30009 | 2101802.15419 | 37.7518075472806 | -122.402397334364 | (37.7518075472806, -122.402397334364) | ||
| 28899 | 28899 | 208910 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 24 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999949.6185800005 | 2095523.7728799998 | 37.733905691199105 | -122.442578479527 | (37.7339056911991, -122.442578479527) | ||||
| 30153 | 30153 | 131035 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999232.47535 | 2117826.58179 | 37.795102710186 | -122.44666199068199 | (37.795102710186, -122.446661990682) | |||
| 34220 | 34220 | 131048 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1100 Filbert St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6007565.19764 | 2119569.36808 | 37.8003604247549 | -122.417953033701 | (37.8003604247549, -122.417953033701) | |||
| 34350 | 34350 | 246430 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 486 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003406.93545 | 2099829.65201 | 37.7459251168641 | -122.43093269070299 | (37.7459251168641, -122.430932690703) | |||
| 34417 | 34417 | 193473 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 65 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6016802.66664 | 2094948.48407 | 37.7332723319411 | -122.384271753034 | (37.7332723319411, -122.384271753034) | |||
| 36705 | 36705 | 193468 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2500 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012783.6506 | 2093584.3740299998 | 37.7293037271707 | -122.39807102245301 | (37.7293037271707, -122.398071022453) | |||
| 36873 | 36873 | 123584 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 72 05th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5994292.89241 | 2115108.24465 | 37.787355503836004 | -122.463556193572 | (37.787355503836, -122.463556193572) | |||
| 36987 | 36987 | 177487 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 38 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000519.82202 | 2088411.27389 | 37.714408881127 | -122.44009727337601 | (37.714408881127, -122.440097273376) | |||
| 37455 | 37455 | 177493 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1373 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007498.34181 | 2091857.43875 | 37.7242661405537 | -122.41622059861099 | (37.7242661405537, -122.416220598611) | |||
| 37876 | 37876 | 131030 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5999236.51727 | 2117760.39538 | 37.7949212107878 | -122.446643240714 | (37.7949212107878, -122.446643240714) | |||
| 40507 | 40507 | 193466 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 201 Williams Ave | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012756.40757 | 2093818.4721400002 | 37.7299449950619 | -122.398181621998 | (37.7299449950619, -122.398181621998) | |||
| 40622 | 40622 | 68964 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 245 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 2 | Permit Number 32954 | 6001096.30206 | 2120017.97021 | 37.80122597455129 | -122.440370118704 | (37.8012259745513, -122.440370118704) | |
| 42192 | 42192 | 131055 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1151 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006685.62477 | 2120091.24888 | 37.8017438356592 | -122.42103378640499 | (37.8017438356592, -122.421033786405) | ||||
| 43598 | 43598 | 231516 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1345 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006281.71313 | 2108835.8462400003 | 37.770816499413705 | -122.42163163768299 | (37.7708164994137, -122.421631637683) | |||
| 44654 | 44654 | 131053 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1200 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6006731.577930001 | 2119798.12659 | 37.80094158644221 | -122.420853944473 | (37.8009415864422, -122.420853944473) | ||||
| 44752 | 44752 | 208895 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1871 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5991217.41058 | 2102692.04372 | 37.7530862897257 | -122.473290708719 | (37.7530862897257, -122.473290708719) | |||
| 46143 | 46143 | 131023 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3398 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999296.06911 | 2120420.27014 | 37.8022279164441 | -122.446628650094 | (37.8022279164441, -122.446628650094) | |||
| 46498 | 46498 | 131043 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1860 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005791.04061 | 2116920.26883 | 37.7929866593525 | -122.423903850404 | (37.7929866593525, -122.423903850404) | |||
| 46901 | 46901 | 177490 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 408 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6003792.56741 | 2092602.3559299998 | 37.7261024464497 | -122.429084011941 | (37.7261024464497, -122.429084011941) | |||
| 47838 | 47838 | 177485 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1797 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5997833.73827 | 2088386.0690900001 | 37.7141863888682 | -122.449379588123 | (37.7141863888682, -122.449379588123) | |||
| 47897 | 47897 | 123585 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 72 05th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5994294.07305 | 2115092.3092400003 | 37.7873118175677 | -122.4635509519 | (37.7873118175677, -122.4635509519) | |||
| 49303 | 49303 | 40941 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1860 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 41801 | 6005809.11262 | 2116921.3354599997 | 37.792990608280896 | -122.423841396081 | (37.7929906082809, -122.423841396081) | |||
| 49455 | 49455 | 208911 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 278 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000243.01828 | 2094970.02212 | 37.732401941082294 | -122.44152438684401 | (37.7324019410823, -122.441524386844) | |||
| 49610 | 49610 | 131039 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6000465.59076 | 2118697.11067 | 37.79756331373971 | -122.442457765333 | (37.7975633137397, -122.442457765333) | |||
| 49690 | 49690 | 131054 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1151 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006682.695180001 | 2120091.0126099996 | 37.8017430217796 | -122.421043907372 | (37.8017430217796, -122.421043907372) | ||||
| 49927 | 49927 | 208905 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 128 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6000628.4729 | 2095243.2553400001 | 37.7331741286648 | -122.44021137037599 | (37.7331741286648, -122.440211370376) | |||
| 51303 | 51303 | 116542 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1002x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001553.5279 | 2088171.08536 | 37.7138081717955 | -122.436507200445 | (37.7138081717955, -122.436507200445) | |||
| 51977 | 51977 | 131049 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1100 Filbert St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6007552.559859999 | 2119566.6351099997 | 37.8003522094455 | -122.417996571701 | (37.8003522094455, -122.417996571701) | |||
| 52290 | 52290 | 193463 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 730 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012091.96354 | 2104972.01768 | 37.7605332086642 | -122.401262173235 | (37.7605332086642, -122.401262173235) | ||||
| 53351 | 53351 | 209301 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 535 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997871.95141 | 2095233.7085400003 | 37.7329905914255 | -122.449740676691 | (37.7329905914255, -122.449740676691) | |||
| 56045 | 56045 | 231513 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 101 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001705.93238 | 2096650.0884900002 | 37.7370982520851 | -122.436586971219 | (37.7370982520851, -122.436586971219) | |||
| 56284 | 56284 | 131028 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999241.842069999 | 2117731.44882 | 37.7948420353895 | -122.44662273254801 | (37.7948420353895, -122.446622732548) | |||
| 57066 | 57066 | 64969 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1654 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51740 | 6005014.41184 | 2119207.33105 | 37.7992224756828 | -122.42675397462 | (37.7992224756828, -122.42675397462) | |
| 57082 | 57082 | 231500 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2974 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6009637.75314 | 2101050.76455 | 37.7496290988195 | -122.409473451155 | (37.7496290988195, -122.409473451155) | |||
| 57201 | 57201 | 193471 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 981 Le Conte Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6013228.480909999 | 2089472.4797 | 37.718038061083796 | -122.39624511993999 | (37.7180380610838, -122.39624511994) | ||||
| 57479 | 57479 | 209303 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 279 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998241.4480099995 | 2093774.0313099998 | 37.72900379607479 | -122.448358157901 | (37.7290037960748, -122.448358157901) | ||||
| 57938 | 57938 | 131029 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5999240.14841 | 2117739.57841 | 37.794864260338706 | -122.446629178021 | (37.7948642603387, -122.446629178021) | |||
| 59960 | 59960 | 231509 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 151 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008668.9523 | 2097865.0106 | 37.7408273925643 | -122.412598435176 | (37.7408273925643, -122.412598435176) | |||
| 60624 | 60624 | 193464 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1 Jack Balestreri Way | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012381.254290001 | 2104808.9270099998 | 37.760101533168395 | -122.400250187717 | (37.7601015331684, -122.400250187717) | ||||
| 61258 | 61258 | 231517 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1345 Stevenson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006280.02993 | 2108851.44344 | 37.7708592306872 | -122.421638567884 | (37.7708592306872, -122.421638567884) | |||
| 62148 | 62148 | 131025 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2399 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999327.24339 | 2120453.53227 | 37.8023210259496 | -122.446523166819 | (37.8023210259496, -122.446523166819) | |||
| 62245 | 62245 | 231505 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1656 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003971.647030001 | 2098592.83904 | 37.7425610948232 | -122.428891834899 | (37.7425610948232, -122.428891834899) | |||
| 63397 | 63397 | 193461 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1301 Minnesota St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015381.88027 | 2102419.9809 | 37.7537088571035 | -122.389705508105 | (37.7537088571035, -122.389705508105) | ||||
| 63502 | 63502 | 231515 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 47 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6003273.20144 | 2097689.33785 | 37.7400407312878 | -122.43124237584101 | (37.7400407312878, -122.431242375841) | |||
| 63692 | 63692 | 208906 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 160 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6000362.37952 | 2095247.6723 | 37.733171103369 | -122.441131641236 | (37.733171103369, -122.441131641236) | |||
| 64859 | 64859 | 177488 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 901 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5998646.2342300005 | 2089574.24227 | 37.7174952842653 | -122.446656735942 | (37.7174952842653, -122.446656735942) | |||
| 65714 | 65714 | 33108 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3033 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2002 12:00:00 AM | 3 | Permit Number 45433 | 6000463.72704 | 2118709.18067 | 37.797596348534896 | -122.442465081294 | (37.7975963485349, -122.442465081294) | |
| 66198 | 66198 | 49652 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1435 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46505 | 5995865.51588119 | 2093595.60711294 | 37.7283777615218 | -122.45655898700501 | (37.7283777615218, -122.456558987005) | ||
| 66568 | 66568 | 33107 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3033 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2002 12:00:00 AM | 3 | Permit Number 45433 | 6000461.9206300005 | 2118716.7377 | 37.797616995175204 | -122.44247187477801 | (37.7976169951752, -122.442471874778) | |
| 67300 | 67300 | 131031 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999236.319019999 | 2117767.1444200003 | 37.794939730532796 | -122.446644412507 | (37.7949397305328, -122.446644412507) | |||
| 67590 | 67590 | 131032 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999235.41218 | 2117772.39106 | 37.794954084610794 | -122.44664792796699 | (37.7949540846108, -122.446647927967) | |||
| 67797 | 67797 | 209302 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 437 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997236.71628 | 2093792.3339900002 | 37.728996556523 | -122.45183289369 | (37.728996556523, -122.45183289369) | |||
| 67900 | 67900 | 231499 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2 Trainor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008309.09071 | 2108245.2203 | 37.7693088903093 | -122.414577071368 | (37.7693088903093, -122.414577071368) | |||
| 67910 | 67910 | 208902 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 10 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994027.4293 | 2100933.67352 | 37.7484205637567 | -122.463445592852 | (37.7484205637567, -122.463445592852) | |||
| 68059 | 68059 | 208912 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 280 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 7ft | 6000214.851969999 | 2094972.0594900001 | 37.7324059304914 | -122.441621910243 | (37.7324059304914, -122.441621910243) | |||
| 68346 | 68346 | 231508 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 675 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001243.5368 | 2102486.94804 | 37.753098598740294 | -122.43860377736 | (37.7530985987403, -122.43860377736) | |||
| 68561 | 68561 | 208896 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2428 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991728.53622 | 2098896.71935 | 37.7426948923565 | -122.471246654027 | (37.7426948923565, -122.471246654027) | |||
| 68978 | 68978 | 131037 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2626 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5999229.87271 | 2117849.2862400003 | 37.7951649018972 | -122.44667263056002 | (37.7951649018972, -122.44667263056) | |||
| 70420 | 70420 | 131047 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1100 Filbert St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6007569.65156 | 2119570.0121 | 37.800362443737 | -122.417937667008 | (37.800362443737, -122.417937667008) | |||
| 71235 | 71235 | 79394 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1001 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52248 | 6008663.010559999 | 2118637.41866 | 37.7978632466564 | -122.414088183737 | (37.7978632466564, -122.414088183737) | |
| 72219 | 72219 | 52164 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2976 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48357 | 6009650.91452488 | 2101053.00211484 | 37.7496359801214 | -122.409428096322 | (37.7496359801214, -122.409428096322) | ||
| 73152 | 73152 | 120751 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 98 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5989612.18123 | 2114795.90448 | 37.7862271008174 | -122.479727432636 | (37.7862271008174, -122.479727432636) | |||
| 75976 | 75976 | 193462 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 763 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6012154.59973 | 2104905.10236 | 37.7603529683261 | -122.401040840157 | (37.7603529683261, -122.401040840157) | |||
| 76279 | 76279 | 131033 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5999233.38677 | 2117813.4097 | 37.7950665951926 | -122.446657888855 | (37.7950665951926, -122.446657888855) | |||
| 80168 | 80168 | 47939 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 278 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45673 | 6000243.93112828 | 2094980.48584366 | 37.7324307240372 | -122.44152198152901 | (37.7324307240372, -122.441521981529) | ||
| 83707 | 83707 | 47694 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 169 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46991 | 6002076.52679692 | 2095073.98846097 | 37.7327916971726 | -122.43519296181499 | (37.7327916971726, -122.435192961815) | ||
| 88554 | 88554 | 39495 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 4120 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40953 | 6003100.36134264 | 2100690.40570429 | 37.7482711695865 | -122.432054236687 | (37.7482711695865, -122.432054236687) | ||
| 102174 | 102174 | 51226 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47593 | 5998582.21605403 | 2106878.18477143 | 37.7650040890386 | -122.448123269006 | (37.7650040890386, -122.448123269006) | ||
| 103666 | 103666 | 51673 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 631 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49826 | 5997240.83261363 | 2094378.6997026 | 37.7306068129583 | -122.451860947717 | (37.7306068129583, -122.451860947717) | ||
| 107960 | 107960 | 66786 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1234 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30059 | 6007019.18147596 | 2119496.46478061 | 37.8001295058435 | -122.419837294536 | (37.8001295058435, -122.419837294536) | ||
| 109502 | 109502 | 208899 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 195 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994397.39556 | 2100720.82338 | 37.7478574397742 | -122.462150832615 | (37.7478574397742, -122.462150832615) | |||
| 109988 | 109988 | 92787 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2031 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2009 12:00:00 AM | 3x3 | Permit Number 53003 | 5993449.2 | 2101650.9 | 37.7503565528165 | -122.465497177391 | (37.7503565528165, -122.465497177391) | ||
| 110595 | 110595 | 45201 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 674 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2001 12:00:00 AM | Permit Number 44045 | 5988831.94298563 | 2110732.19724929 | 37.7750239446504 | -122.482129003401 | (37.7750239446504, -122.482129003401) | |||
| 112149 | 112149 | 42020 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 100 Pinehurst Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.46463338232799 | (37.7283633513404, -122.464633382328) | ||
| 116684 | 116684 | 43567 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 584 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 43229 | 6002801.30355898 | 2098918.62688203 | 37.7433893199654 | -122.432961805539 | (37.7433893199654, -122.432961805539) | ||
| 118369 | 118369 | 49651 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1435 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46505 | 5995865.51588119 | 2093595.60711294 | 37.7283777615218 | -122.45655898700501 | (37.7283777615218, -122.456558987005) | ||
| 119605 | 119605 | 131026 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2399 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999337.89479 | 2120454.53437 | 37.8023243858278 | -122.44648638004601 | (37.8023243858278, -122.446486380046) | |||
| 124362 | 124362 | 177492 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1362 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007661.42088 | 2091474.33514 | 37.7232233883366 | -122.415629744043 | (37.7232233883366, -122.415629744043) | |||
| 131915 | 131915 | 131021 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2898 Green St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5999260.382730001 | 2117722.26456 | 37.794817876897504 | -122.44655791842199 | (37.7948178768975, -122.446557918422) | |||
| 132104 | 132104 | 131046 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1100 Filbert St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6007575.55604 | 2119570.83895 | 37.8003650463583 | -122.417917293756 | (37.8003650463583, -122.417917293756) | |||
| 132767 | 132767 | 193465 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1444 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6012266.74912 | 2101649.90282 | 37.751421158960596 | -122.40042431264601 | (37.7514211589606, -122.400424312646) | ||||
| 134991 | 134991 | 131034 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999232.56058 | 2117822.5330000003 | 37.7950915981541 | -122.446661404324 | (37.7950915981541, -122.446661404324) | |||
| 136893 | 136893 | 208908 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 160 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000359.471030001 | 2095247.4450599998 | 37.7331703137512 | -122.441141680344 | (37.7331703137512, -122.441141680344) | |||
| 137762 | 137762 | 131050 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1100 Filbert St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6007547.47649 | 2119565.99155 | 37.800350156292296 | -122.418014116575 | (37.8003501562923, -122.418014116575) | |||
| 137930 | 137930 | 116541 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1041x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001548.78537 | 2088145.26253 | 37.7137369985308 | -122.436521745206 | (37.7137369985308, -122.436521745206) | |||
| 138069 | 138069 | 34678 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2053 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 2 | Permit Number 41917 | 6003078.7405199995 | 2118893.49634 | 37.798251137739 | -122.433429618792 | (37.798251137739, -122.433429618792) | |
| 143693 | 143693 | 46137 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 503 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44487 | 5997940.5434735 | 2108879.35418866 | 37.770462088013296 | -122.450486922071 | (37.7704620880133, -122.450486922071) | ||
| 145751 | 145751 | 39496 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 4120 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40953 | 6003100.36134264 | 2100690.40570429 | 37.7482711695865 | -122.432054236687 | (37.7482711695865, -122.432054236687) | ||
| 147152 | 147152 | 98815 | Permitted Site 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 290 Napoleon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6011869.690359999 | 2099744.03453 | 37.746165906732394 | -122.40166345343201 | (37.7461659067324, -122.401663453432) | |||
| 149230 | 149230 | 208901 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 195 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994436.94616 | 2100760.3225 | 37.7479681715131 | -122.46201693344999 | (37.7479681715131, -122.46201693345) | |||
| 149786 | 149786 | 131027 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 2600 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999242.5655 | 2117725.53193 | 37.7948258305055 | -122.44661980347401 | (37.7948258305055, -122.446619803474) | |||
| 150772 | 150772 | 83371 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 201 Williams Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012704.86235 | 2093830.28986 | 37.72997457286179 | -122.398360650032 | (37.7299745728618, -122.398360650032) |
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");