Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25376 | 25376 | 192340 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007835.1568599995 | 2110517.0734099997 | 37.7755202244095 | -122.416377328869 | (37.7755202244095, -122.416377328869) | |||
| 49533 | 49533 | 192344 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007890.6883 | 2110458.72798 | 37.7753631443241 | -122.41618109859199 | (37.7753631443241, -122.416181098592) | |||
| 129868 | 129868 | 192343 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007880.06697 | 2110469.37964 | 37.7753917940266 | -122.416218594918 | (37.7753917940266, -122.416218594918) | |||
| 169012 | 169012 | 192341 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007845.7339699995 | 2110504.26388 | 37.7754856472738 | -122.416339832511 | (37.7754856472738, -122.416339832511) | |||
| 174637 | 174637 | 192342 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007873.4377 | 2110478.3105900004 | 37.775415943530604 | -122.41624215986099 | (37.7754159435306, -122.416242159861) | |||
| 186917 | 186917 | 192345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007899.18679 | 2110450.27855 | 37.775340422048394 | -122.41615110171301 | (37.7753404220484, -122.416151101713) | |||
| 36050 | 36050 | 120307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988691.32321 | 2114547.3374400004 | 37.785491068319395 | -122.482895098939 | (37.7854910683194, -122.482895098939) | |||
| 45941 | 45941 | 120305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988689.97406 | 2114597.66035 | 37.7856291622608 | -122.48290345597601 | (37.7856291622608, -122.482903455976) | |||
| 132924 | 132924 | 120306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | |||
| 174316 | 174316 | 120304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988688.31832 | 2114612.7837400003 | 37.7856705904605 | -122.482910293069 | (37.7856705904605, -122.482910293069) | |||
| 28167 | 28167 | 192309 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011943.7523300005 | 2107376.90821 | 37.767128230416105 | -122.401943831469 | (37.7671282304161, -122.401943831469) | |||
| 64965 | 64965 | 192311 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011948.83417 | 2107324.65535 | 37.766985039447896 | -122.401922580457 | (37.7669850394479, -122.401922580457) | |||
| 71362 | 71362 | 192308 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.9905 | 2107419.77079 | 37.7672458230764 | -122.401952938871 | (37.7672458230764, -122.401952938871) | |||
| 163536 | 163536 | 192307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501001 | (37.7673034192378, -122.40195597501) | |||
| 188995 | 188995 | 192310 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011946.18566 | 2107352.67758 | 37.76706183436821 | -122.40193371137501 | (37.7670618343682, -122.401933711375) | |||
| 179125 | 179125 | 124030 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991790.3652800005 | 2114364.58828 | 37.78516912121479 | -122.47216010553801 | (37.7851691212148, -122.472160105538) | |||
| 40032 | 40032 | 45645 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.4795699995 | 2118401.58307 | 37.7973579490636 | -122.40528770508999 | (37.7973579490636, -122.40528770509) | ||
| 158173 | 158173 | 45643 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.40531173944599 | (37.797501231757, -122.405311739446) | ||
| 164652 | 164652 | 192352 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1040 Palou Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6017850.25276 | 2093091.0077 | 37.728229933050706 | -122.380520862443 | (37.7282299330507, -122.380520862443) | |||
| 54421 | 54421 | 128827 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1048 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011178.99904 | 2118580.19305 | 37.797847111915395 | -122.405378078855 | (37.7978471119154, -122.405378078855) | |||
| 14507 | 14507 | 29010 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 113 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008095.190140001 | 2110335.0874799998 | 37.7750351534761 | -122.415464921674 | (37.7750351534761, -122.415464921674) | ||
| 46407 | 46407 | 192330 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 113 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008064.12185 | 2110370.6241900004 | 37.775130982543004 | -122.41557491054701 | (37.775130982543, -122.415574910547) | |||
| 79400 | 79400 | 41689 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | |||
| 451 | 451 | 192346 | Planning Code 138.1 required 4 | Fraxinus spp :: Ash Spp 83 | 118 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.5452799997 | 37.7750719195804 | -122.41581539288201 | (37.7750719195804, -122.415815392882) | |
| 186614 | 186614 | 247293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1187 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999369.2896 | 2108822.0623 | 37.7703864492561 | -122.445540779928 | (37.7703864492561, -122.445540779928) | |||
| 25322 | 25322 | 192237 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009520.068659999 | 2108454.52562 | 37.7699515539505 | -122.410403121719 | (37.7699515539505, -122.410403121719) | |||
| 34317 | 34317 | 192232 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.466630001 | 2108528.5531599997 | 37.7701592110077 | -122.41013717060899 | (37.7701592110077, -122.410137170609) | |||
| 42094 | 42094 | 192240 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446001 | (37.7698615480128, -122.41052430446) | |||
| 43494 | 43494 | 192247 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009385.61181 | 2108329.66334 | 37.76960117269039 | -122.410859387372 | (37.7696011726904, -122.410859387372) | |||
| 44739 | 44739 | 192244 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.93836 | 2108352.3057 | 37.7696648195127 | -122.410769923705 | (37.7696648195127, -122.410769923705) | |||
| 46347 | 46347 | 192248 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009375.77946 | 2108320.2642200002 | 37.7695748135605 | -122.410892733326 | (37.7695748135605, -122.410892733326) | |||
| 50297 | 50297 | 192239 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009494.20262 | 2108431.40539 | 37.769886621106295 | -122.410490959396 | (37.7698866211063, -122.410490959396) | |||
| 122157 | 122157 | 192238 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009506.6298 | 2108441.21994 | 37.769914266262205 | -122.410448666999 | (37.7699142662622, -122.410448666999) | |||
| 150402 | 150402 | 192229 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009648.37032 | 2108577.40653 | 37.7702961480689 | -122.409968002743 | (37.7702961480689, -122.409968002743) | |||
| 151652 | 151652 | 192231 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009620.79732 | 2108551.27729 | 37.7702228578355 | -122.410061533137 | (37.7702228578355, -122.410061533137) | |||
| 158448 | 158448 | 192243 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009432.09679 | 2108372.2648 | 37.7697207528275 | -122.41070160579599 | (37.7697207528275, -122.410701605796) | |||
| 159958 | 159958 | 192246 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009392.3217400005 | 2108335.84797 | 37.769618530488295 | -122.410836614725 | (37.7696185304883, -122.410836614725) | |||
| 160879 | 160879 | 192245 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009401.17079 | 2108343.15985 | 37.7696391033908 | -122.410806522516 | (37.7696391033908, -122.410806522516) | |||
| 167643 | 167643 | 192230 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009632.52889 | 2108561.57413 | 37.7702517881052 | -122.41002168056299 | (37.7702517881052, -122.410021680563) | |||
| 169637 | 169637 | 192234 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009571.19084 | 2108505.46163 | 37.7700942781462 | -122.410229887119 | (37.7700942781462, -122.410229887119) | |||
| 169673 | 169673 | 192233 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009583.6177 | 2108515.2759 | 37.7701219224206 | -122.41018759559401 | (37.7701219224206, -122.410187595594) | |||
| 176443 | 176443 | 192242 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009444.52854 | 2108382.3130900003 | 37.7697490401119 | -122.41065931427299 | (37.7697490401119, -122.410659314273) | |||
| 178248 | 178248 | 192235 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009557.26279 | 2108491.22918 | 37.7700544184084 | -122.410277059238 | (37.7700544184084, -122.410277059238) | |||
| 181341 | 181341 | 192236 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009533.94871 | 2108466.41752 | 37.7699849844405 | -122.41035595047899 | (37.7699849844405, -122.410355950479) | |||
| 186425 | 186425 | 192241 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009464.70125 | 2108402.9741599998 | 37.7698069016093 | -122.41059099638599 | (37.7698069016093, -122.410590996386) | |||
| 14366 | 14366 | 29008 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 123 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008118.46736 | 2110307.2661 | 37.774960070880496 | -122.415382430453 | (37.7749600708805, -122.415382430453) | ||
| 14608 | 14608 | 29018 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 128 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008069.48566 | 2110276.86185 | 37.774873834897 | -122.41554971607 | (37.774873834897, -122.41554971607) | ||
| 160677 | 160677 | 192347 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 134 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008123.05736 | 2110213.2209099997 | 37.7747021030553 | -122.415359893447 | (37.7747021030553, -122.415359893447) | |||
| 15223 | 15223 | 29006 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008170.1889 | 2110256.9147 | 37.774824724723395 | -122.415199949027 | (37.7748247247234, -122.415199949027) | ||
| 63906 | 63906 | 192329 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008156.7444 | 2110270.8623200003 | 37.774862266002 | -122.41524744403601 | (37.774862266002, -122.415247444036) | |||
| 150960 | 150960 | 218967 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 140 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.46482279396099 | (37.7503985047832, -122.464822793961) | |||
| 34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
| 70126 | 70126 | 192356 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 21141 | 21141 | 16624 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 143 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6002878.48419 | 2107471.6414099997 | 37.7668782377669 | -122.43330597190001 | (37.7668782377669, -122.4333059719) | |||
| 56385 | 56385 | 225807 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002846.79255 | 2107449.48757 | 37.7668156107901 | -122.43341400475799 | (37.7668156107901, -122.433414004758) | |||
| 18965 | 18965 | 16628 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 147 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | 12 | 3X3 | 6002889.82891 | 2107449.635 | 37.766818457119896 | -122.433265159761 | (37.7668184571199, -122.433265159761) | ||
| 24702 | 24702 | 192280 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009110.344190001 | 2108839.3922200003 | 37.7709853309346 | -122.411847556143 | (37.7709853309346, -122.411847556143) | |||
| 32509 | 32509 | 192275 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009036.05094 | 2108770.66843 | 37.7707924632209 | -122.412099681957 | (37.7707924632209, -122.412099681957) | |||
| 35877 | 35877 | 192283 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009158.56943 | 2108886.63938 | 37.7711177659971 | -122.411684081879 | (37.7711177659971, -122.411684081879) | |||
| 36159 | 36159 | 192290 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009249.88348 | 2108971.40543 | 37.771355635782704 | -122.411374211455 | (37.7713556357827, -122.411374211455) | |||
| 38913 | 38913 | 192279 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009094.0417599995 | 2108824.03792 | 37.7709422570085 | -122.411902861747 | (37.7709422570085, -122.411902861747) | |||
| 40753 | 40753 | 192274 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.770763532946795 | -122.412138720645 | (37.7707635329468, -122.412138720645) | |||
| 50544 | 50544 | 192292 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009264.77057 | 2108986.5542200003 | 37.7713980657949 | -122.41132378646499 | (37.7713980657949, -122.411323786465) | |||
| 130852 | 130852 | 192276 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009052.59315 | 2108786.2519900003 | 37.7708361801883 | -122.412043563376 | (37.7708361801883, -122.412043563376) | |||
| 131904 | 131904 | 192291 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009258.26702 | 2108978.96062 | 37.77137685078 | -122.41134574611 | (37.77137685078, -122.41134574611) | |||
| 148715 | 148715 | 192281 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009122.35355 | 2108851.7905099997 | 37.7710200474802 | -122.411806891483 | (37.7710200474802, -122.411806891483) | |||
| 153479 | 153479 | 192286 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009200.74698 | 2108925.5815 | 37.7712270578992 | -122.411540939462 | (37.7712270578992, -122.411540939462) | |||
| 153786 | 153786 | 192287 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009214.87169 | 2108937.93629 | 37.771261773548204 | -122.41149295433998 | (37.7712617735482, -122.41149295434) | |||
| 155337 | 155337 | 192293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009269.83054 | 2108992.53867 | 37.7714147814913 | -122.411306706546 | (37.7714147814913, -122.411306706546) | |||
| 166725 | 166725 | 192284 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009171.26495 | 2108898.08726 | 37.771149911371204 | -122.41164097644699 | (37.7711499113712, -122.411640976447) | |||
| 168681 | 168681 | 192277 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009066.01772 | 2108798.85518 | 37.7708715388111 | -122.411998018109 | (37.7708715388111, -122.411998018109) | |||
| 177223 | 177223 | 192288 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009225.94574 | 2108950.58791 | 37.7712971330939 | -122.411455542555 | (37.7712971330939, -122.411455542555) | |||
| 177737 | 177737 | 192282 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009136.7517800005 | 2108866.0128099998 | 37.7710599063301 | -122.41175809248101 | (37.7710599063301, -122.411758092481) | |||
| 179474 | 179474 | 192289 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009238.64118 | 2108962.03516 | 37.771329276649105 | -122.411412437151 | (37.7713292766491, -122.411412437151) | |||
| 180754 | 180754 | 192285 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009183.75419 | 2108910.9438099996 | 37.771185913038 | -122.411598684054 | (37.771185913038, -122.411598684054) | |||
| 189108 | 189108 | 192278 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009081.35576 | 2108813.05858 | 37.770911398573205 | -122.411945967131 | (37.7709113985732, -122.411945967131) | |||
| 57020 | 57020 | 218969 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.750393275225704 | -122.46496537605499 | (37.7503932752257, -122.464965376055) | |||
| 188474 | 188474 | 218968 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993617.45125 | 2101661.58733 | 37.7503955999976 | -122.464916133678 | (37.7503955999976, -122.464916133678) | |||
| 23985 | 23985 | 192353 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6015367.9403099995 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | |||
| 15761 | 15761 | 29004 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 151 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008239.15145 | 2110183.90276 | 37.7746281266267 | -122.41495622374399 | (37.7746281266267, -122.414956223744) | ||
| 19707 | 19707 | 16635 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 153 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002890.76164 | 2107366.51768 | 37.766590290141394 | -122.43325599389 | (37.7665902901414, -122.43325599389) | |||
| 14010 | 14010 | 29020 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 154 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008187.55893 | 2110147.28508 | 37.774524683913896 | -122.41513210056401 | (37.7745246839139, -122.415132100564) | ||
| 33903 | 33903 | 225779 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999770.51083 | 2107118.5981099997 | 37.765732061717294 | -122.44403054288901 | (37.7657320617173, -122.444030542889) | |||
| 19824 | 19824 | 16637 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002887.79495 | 2107329.82108 | 37.7664893619256 | -122.433263632733 | (37.7664893619256, -122.433263632733) | |||
| 136363 | 136363 | 225813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6002885.55761 | 2107343.69078 | 37.7665273178175 | -122.43327236244 | (37.7665273178175, -122.43327236244) | |||
| 138106 | 138106 | 225814 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002898.26283 | 2107347.8267 | 37.7665393948003 | -122.43322871294501 | (37.7665393948003, -122.433228712945) | |||
| 109753 | 109753 | 985 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001654.0889800005 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | |||
| 173864 | 173864 | 225381 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1643 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006512.204919999 | 2107283.08365 | 37.7665659760752 | -122.42072411023001 | (37.7665659760752, -122.42072411023) | |||
| 55154 | 55154 | 192348 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 170 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008297.90047 | 2110029.55008 | 37.774207611721 | -122.414742072711 | (37.774207611721, -122.414742072711) | |||
| 101611 | 101611 | 96698 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
| 188237 | 188237 | 244215 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | |||
| 84512 | 84512 | 33479 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 94836 | 94836 | 33480 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 112329 | 112329 | 33476 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 141574 | 141574 | 33477 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 143673 | 143673 | 33478 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 13842 | 13842 | 25983 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | |||
| 14443 | 14443 | 25984 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013408.21183 | 2096665.5323700001 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) |
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");