Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34558 | 34558 | 188318 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2000 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012048.56124 | 2104706.10168 | 37.759800640718005 | -122.401393594734 | (37.759800640718, -122.401393594734) | |||
| 175314 | 175314 | 222507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.40816009111099 | (37.7518194273238, -122.408160091111) | |||
| 185696 | 185696 | 175790 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 79 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | |||
| 38034 | 38034 | 188335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | |||
| 64408 | 64408 | 188294 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.771037714636705 | -122.415127922313 | (37.7710377146367, -122.415127922313) | |||
| 67719 | 67719 | 222596 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 73 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002296.29369 | 2096683.33913 | 37.73722308157 | -122.43454820456002 | (37.73722308157, -122.43454820456) | |||
| 68710 | 68710 | 188336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.39704756789101 | (37.7613339848017, -122.397047567891) | |||
| 74635 | 74635 | 188296 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6008131.8967699995 | 2108889.4185900004 | 37.7710677511061 | -122.41523558646601 | (37.7710677511061, -122.415235586466) | |||
| 135094 | 135094 | 125879 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998729.9299099995 | 2113444.41319 | 37.7830417124478 | -122.448085187582 | (37.7830417124478, -122.448085187582) | |||
| 135399 | 135399 | 221340 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1370 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6003881.33957 | 2100275.34472 | 37.747175754559706 | -122.42932404278099 | (37.7471757545597, -122.429324042781) | |||
| 146750 | 146750 | 188337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014186.2862599995 | 2095457.7275599998 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | |||
| 150539 | 150539 | 188297 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.771087775398705 | -122.415284140848 | (37.7710877753987, -122.415284140848) | |||
| 161999 | 161999 | 218270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5992782.12061 | 2097251.65776 | 37.73823885594471 | -122.46748409202 | (37.7382388559447, -122.46748409202) | |||
| 174395 | 174395 | 188293 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008175.899180001 | 2108871.2472900003 | 37.771020329842294 | -122.415082093787 | (37.7710203298423, -122.415082093787) | |||
| 175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
| 180450 | 180450 | 218271 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.738216134576795 | -122.467513887457 | (37.7382161345768, -122.467513887457) | |||
| 181394 | 181394 | 125880 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | |||
| 28542 | 28542 | 204628 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.46886055298701 | (37.733067423224, -122.468860552987) | |||
| 29847 | 29847 | 125882 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005138.856380001 | 2116964.61432 | 37.7930715805281 | -122.42616360296302 | (37.7930715805281, -122.426163602963) | |||
| 30100 | 30100 | 188310 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.658530001 | 2106249.7856099997 | 37.764087318611395 | -122.39852032646499 | (37.7640873186114, -122.398520326465) | |||
| 32397 | 32397 | 125884 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008808.31826 | 2115292.9035099996 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | |||
| 33225 | 33225 | 188311 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
| 46851 | 46851 | 125887 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006289.37196 | 2113344.7288599997 | 37.7831972322057 | -122.42192548758301 | (37.7831972322057, -122.421925487583) | |||
| 47450 | 47450 | 125886 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006255.845480001 | 2113363.12878 | 37.7832458630397 | -122.42204278345699 | (37.7832458630397, -122.422042783457) | |||
| 50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
| 53944 | 53944 | 221365 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.43611046183099 | (37.748183708409, -122.436110461831) | |||
| 54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
| 56696 | 56696 | 188309 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012912.6135599995 | 2106204.46931 | 37.763962999012996 | -122.398510384468 | (37.763962999013, -122.398510384468) | |||
| 57424 | 57424 | 125888 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.784407514645096 | -122.415878065725 | (37.7844075146451, -122.415878065725) | |||
| 58207 | 58207 | 204627 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.46892055484301 | (37.7330750773552, -122.468920554843) | |||
| 59966 | 59966 | 188338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343001 | (37.7344825828894, -122.39339227343) | |||
| 61855 | 61855 | 175792 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.728537987719605 | -122.409369173844 | (37.7285379877196, -122.409369173844) | |||
| 62010 | 62010 | 188308 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012915.64836 | 2106174.8089400004 | 37.76388172727871 | -122.398497806527 | (37.7638817272787, -122.398497806527) | |||
| 63601 | 63601 | 125885 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | |||
| 68293 | 68293 | 188331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 612 Texas St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.39528210428101 | (37.7585970807056, -122.395282104281) | |||
| 72456 | 72456 | 188317 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011501.39155 | 2104667.35812 | 37.759663715319704 | -122.403283270917 | (37.7596637153197, -122.403283270917) | |||
| 137747 | 137747 | 204626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992297.08253 | 2095382.05199 | 37.7330773733083 | -122.46902507404499 | (37.7330773733083, -122.469025074045) | |||
| 152106 | 152106 | 204613 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991174.12963 | 2105607.5581900002 | 37.7610890166517 | -122.47365304285401 | (37.7610890166517, -122.473653042854) | |||
| 155530 | 155530 | 221343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | |||
| 158669 | 158669 | 175791 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009517.433730001 | 2093353.53583 | 37.7284874341444 | -122.409346391343 | (37.7284874341444, -122.409346391343) | |||
| 158902 | 158902 | 188314 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 209 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6012920.39435 | 2106015.17263 | 37.7634436657274 | -122.39847018924999 | (37.7634436657274, -122.39847018925) | |||
| 159078 | 159078 | 175794 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009502.30517 | 2093401.60497 | 37.7286185741876 | -122.409402082759 | (37.7286185741876, -122.409402082759) | |||
| 161577 | 161577 | 188334 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013355.939119999 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | |||
| 175592 | 175592 | 125889 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.42257363436501 | (37.781778500422, -122.422573634365) | |||
| 176001 | 176001 | 175793 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | |||
| 179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
| 182888 | 182888 | 221350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.753290200197895 | -122.413127394812 | (37.7532902001979, -122.413127394812) | |||
| 185920 | 185920 | 204625 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992281.41366 | 2095382.3817200002 | 37.733077373320896 | -122.469079268988 | (37.7330773733209, -122.469079268988) | |||
| 2817 | 2817 | 253222 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 2839 | 2839 | 253221 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
| 23457 | 23457 | 221362 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | |||
| 24046 | 24046 | 222589 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4384 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000100.50643 | 2105785.88471 | 37.762091580878604 | -122.44279345615601 | (37.7620915808786, -122.442793456156) | |||
| 24143 | 24143 | 221342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 211 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | |||
| 24896 | 24896 | 204623 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1880 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993786.05175 | 2102711.73048 | 37.7532887441949 | -122.46440934321801 | (37.7532887441949, -122.464409343218) | |||
| 25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
| 25555 | 25555 | 175783 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.729062833884605 | -122.419916279827 | (37.7290628338846, -122.419916279827) | |||
| 25966 | 25966 | 204670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999483.78605 | 2094717.6896400002 | 37.7316658109241 | -122.44413109610001 | (37.7316658109241, -122.4441310961) | |||
| 26495 | 26495 | 188354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017148.15295 | 2095467.55143 | 37.73471668451 | -122.383113415457 | (37.73471668451, -122.383113415457) | |||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
| 27101 | 27101 | 124082 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993384.863369999 | 2110069.41246 | 37.773467874758296 | -122.466331413768 | (37.7734678747583, -122.466331413768) | |||
| 27115 | 27115 | 175782 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.729089224484795 | -122.419690364741 | (37.7290892244848, -122.419690364741) | |||
| 27371 | 27371 | 222562 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007642.65731 | 2100277.00661 | 37.747392543349704 | -122.416317784757 | (37.7473925433497, -122.416317784757) | |||
| 28362 | 28362 | 222576 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | |||
| 28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
| 28539 | 28539 | 188302 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | |||
| 29109 | 29109 | 222592 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 352 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003592.38415 | 2108668.4276900003 | 37.7702047958459 | -122.43092212997699 | (37.7702047958459, -122.430922129977) | |||
| 29365 | 29365 | 222548 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007220.93745 | 2097850.24968 | 37.740705488567706 | -122.417604094958 | (37.7407054885677, -122.417604094958) | |||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 31017 | 31017 | 222574 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 382 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003928.91308 | 2102165.887 | 37.752369435600706 | -122.429294326484 | (37.7523694356007, -122.429294326484) | |||
| 31738 | 31738 | 221360 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999311.904680001 | 2104005.96159 | 37.757159364222495 | -122.44539292943399 | (37.7571593642225, -122.445392929434) | |||
| 31785 | 31785 | 124081 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993396.8995199995 | 2110067.15404 | 37.7734623682136 | -122.46628961516399 | (37.7734623682136, -122.466289615164) | |||
| 32947 | 32947 | 222552 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007202.63127 | 2097897.94559 | 37.740835420825206 | -122.417670770702 | (37.7408354208252, -122.417670770702) | |||
| 34214 | 34214 | 188320 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | |||
| 34236 | 34236 | 188300 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791001 | (37.7728541761188, -122.41480452791) | |||
| 34992 | 34992 | 222570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.43643417821698 | (37.7496020939667, -122.436434178217) | |||
| 35460 | 35460 | 188321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.29279 | 2103681.1367599997 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | |||
| 37998 | 37998 | 221341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 217 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.42543747867201 | (37.7469275767478, -122.425437478672) | |||
| 38265 | 38265 | 222573 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.43015298120301 | (37.7514688410299, -122.430152981203) | |||
| 38282 | 38282 | 188358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017132.819619999 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | |||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 38900 | 38900 | 222499 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 301 Webster St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004137.32896 | 2109855.92191 | 37.7734962273111 | -122.429121852705 | (37.7734962273111, -122.429121852705) | |||
| 39326 | 39326 | 221354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.41400939143601 | (37.7572740646699, -122.414009391436) | |||
| 39974 | 39974 | 188355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017230.94644 | 2095282.0098400002 | 37.7342117988404 | -122.38281425956998 | (37.7342117988404, -122.38281425957) | |||
| 40334 | 40334 | 222553 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007213.79342 | 2097921.72013 | 37.740901328538996 | -122.417633860722 | (37.740901328539, -122.417633860722) | |||
| 41275 | 41275 | 188305 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | |||
| 41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
| 43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) | |||
| 44147 | 44147 | 188289 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009413.38466 | 2109546.86827 | 37.772944891630104 | -122.41084930056101 | (37.7729448916301, -122.410849300561) | |||
| 44455 | 44455 | 222555 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.743700669854796 | -122.419652282953 | (37.7437006698548, -122.419652282953) | |||
| 45314 | 45314 | 221329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 92 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010301.696169999 | 2100286.438 | 37.7475676053645 | -122.407123632349 | (37.7475676053645, -122.407123632349) | |||
| 45351 | 45351 | 188353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017129.66281 | 2095538.6901900002 | 37.7349109956364 | -122.38318229272899 | (37.7349109956364, -122.383182292729) | |||
| 45511 | 45511 | 221338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005011.955130001 | 2099285.1526 | 37.7445208578632 | -122.425344007646 | (37.7445208578632, -122.425344007646) | |||
| 45649 | 45649 | 221353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3181 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007743.59292 | 2102655.4048200003 | 37.7539287629281 | -122.41613717119199 | (37.7539287629281, -122.416137171192) | |||
| 46013 | 46013 | 221321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | |||
| 46539 | 46539 | 221335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1641 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010542.34793 | 2100138.1982400003 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | |||
| 47784 | 47784 | 221322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005240.85494 | 2105024.4327599998 | 37.760292519512205 | -122.42496077502899 | (37.7602925195122, -122.424960775029) |
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");