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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
| 188390 | 188390 | 103890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999343.5617 | 2110855.9257 | 37.7759694515949 | -122.445776064165 | (37.7759694515949, -122.445776064165) | |||
| 188143 | 188143 | 220086 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 77 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001721.7342 | 2105412.03314 | 37.761157366929204 | -122.43715949493601 | (37.7611573669292, -122.437159494936) | |||
| 188075 | 188075 | 220035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.34581 | 2100467.82106 | 37.7476336866458 | -122.433642882219 | (37.7476336866458, -122.433642882219) | |||
| 188012 | 188012 | 138353 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.786407480206705 | -122.43774638091499 | (37.7864074802067, -122.437746380915) | |||
| 187692 | 187692 | 138344 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001758.896000001 | 2114311.2519 | 37.785594512870205 | -122.43766832543301 | (37.7855945128702, -122.437668325433) | |||
| 187683 | 187683 | 188523 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.733359012210606 | -122.382618269437 | (37.7333590122106, -122.382618269437) | |||
| 187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) | |||
| 187109 | 187109 | 142298 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.44159730622299 | (37.775410978082, -122.441597306223) | |||
| 186993 | 186993 | 44745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.42036685635401 | (37.7952406976494, -122.420366856354) | ||
| 186973 | 186973 | 220091 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3076 Merritt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000057.55788 | 2105416.72092 | 37.7610754998513 | -122.442915486985 | (37.7610754998513, -122.442915486985) | |||
| 186671 | 186671 | 73754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.40968430266199 | (37.8025101678048, -122.409684302662) | ||
| 186555 | 186555 | 203630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.731641116434496 | -122.46363957301 | (37.7316411164345, -122.46363957301) | |||
| 186513 | 186513 | 103886 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2013 12:00:00 AM | 11 | 3x3 | Permit Number 770207 | 5999354.6 | 2110868.3 | 37.7760040584969 | -122.44573877005101 | (37.7760040584969, -122.445738770051) | |
| 186338 | 186338 | 220005 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2080 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008062.79185 | 2106290.9953 | 37.7639292034025 | -122.415290650144 | (37.7639292034025, -122.415290650144) | |||
| 185661 | 185661 | 124762 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | |||
| 185639 | 185639 | 40169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.44190053998399 | (37.7782227381789, -122.441900539984) | |
| 185398 | 185398 | 220685 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.774905054848396 | -122.426961200922 | (37.7749050548484, -122.426961200922) | |||
| 185361 | 185361 | 220004 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1142 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008637.13035 | 2101883.29537 | 37.751858924657796 | -122.412992509104 | (37.7518589246578, -122.412992509104) | |||
| 185230 | 185230 | 219990 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | |||
| 185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
| 185093 | 185093 | 220033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 502 28th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002622.25428 | 2099488.24408 | 37.7449431983695 | -122.433621612357 | (37.7449431983695, -122.433621612357) | ||||
| 185029 | 185029 | 220006 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 887 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007588.24314 | 2104555.6978700003 | 37.75913779629921 | -122.41680902861602 | (37.7591377962992, -122.416809028616) | |||
| 184876 | 184876 | 203227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1575 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5993976.11047 | 2104705.81134 | 37.7587749306244 | -122.463896818706 | (37.7587749306244, -122.463896818706) | |||
| 184798 | 184798 | 248081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.40662106962799 | (37.7472540585408, -122.406621069628) | |||
| 184246 | 184246 | 51499 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983133.1181 | 2104773.3328 | 37.758329497976 | -122.501401269082 | (37.758329497976, -122.501401269082) | ||
| 184019 | 184019 | 245165 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000037.7937 | 2109212.4329 | 37.7714964504984 | -122.443256472847 | (37.7714964504984, -122.443256472847) | |||
| 183876 | 183876 | 246998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 33 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004927.947919999 | 2101037.11705 | 37.7493266028416 | -122.42575916347602 | (37.7493266028416, -122.425759163476) | |||
| 183618 | 183618 | 220682 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009643.101369999 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | |||
| 183611 | 183611 | 220078 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003547.22001 | 2104169.9563599997 | 37.7578505193113 | -122.430757284236 | (37.7578505193113, -122.430757284236) | |||
| 183501 | 183501 | 203636 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | |||
| 182704 | 182704 | 32332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 12 | Permit Number 36896 | 6006735.75103 | 2098040.81049 | 37.741201412511295 | -122.419295203505 | (37.7412014125113, -122.419295203505) | ||
| 181456 | 181456 | 50381 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.42171535199499 | (37.8008219271496, -122.421715351995) | |
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 180907 | 180907 | 137667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | |||
| 180724 | 180724 | 220669 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007464.462180001 | 2105680.20341 | 37.7622184653282 | -122.41731681192199 | (37.7622184653282, -122.417316811922) | |||
| 180473 | 180473 | 40818 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | ||
| 180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
| 180377 | 180377 | 31436 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4336 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35011 | 6000994.34179 | 2103320.5787299997 | 37.7553733681958 | -122.439525295576 | (37.7553733681958, -122.439525295576) | |
| 179698 | 179698 | 218406 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5994236.919980001 | 2100511.7669599997 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | |||
| 179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 178755 | 178755 | 220034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 622 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002480.9934 | 2100067.1600599997 | 37.7465247497217 | -122.43415144344699 | (37.7465247497217, -122.434151443447) | |||
| 178617 | 178617 | 188524 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.38248816719299 | (37.7334120182438, -122.382488167193) | |||
| 178540 | 178540 | 220003 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6009365.07591 | 2096886.4272 | 37.738179459299296 | -122.410122419925 | (37.7381794592993, -122.410122419925) | |||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 178198 | 178198 | 220092 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 24 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006394.365680001 | 2110096.52086 | 37.774284361671 | -122.42133150875601 | (37.774284361671, -122.421331508756) | |||
| 177773 | 177773 | 188511 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | ||||
| 177746 | 177746 | 67583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.3331699995 | 2103332.09659 | 37.756006816477104 | -122.40260508405198 | (37.7560068164771, -122.402605084052) | |
| 177028 | 177028 | 220692 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.986740001 | 2100702.91409 | 37.7483660981244 | -122.42835639293999 | (37.7483660981244, -122.42835639294) | |||
| 176862 | 176862 | 38050 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.786021340576205 | -122.441934174319 | (37.7860213405762, -122.441934174319) | |
| 176834 | 176834 | 220059 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.75197131922489 | -122.42173470182101 | (37.7519713192249, -122.421734701821) | |||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 176295 | 176295 | 249709 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2901 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999701.30683 | 2117014.48804 | 37.7928996850292 | -122.44498136009899 | (37.7928996850292, -122.444981360099) | ||||
| 175791 | 175791 | 220665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 215 Webster St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004174.507619999 | 2109590.46036 | 37.7727694393 | -122.42897431622801 | (37.7727694393, -122.428974316228) | |||
| 175760 | 175760 | 220061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.749108169217294 | -122.41935165935101 | (37.7491081692173, -122.419351659351) | |||
| 175370 | 175370 | 103893 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999294.1521 | 2110847.1267 | 37.7759424705585 | -122.445946351246 | (37.7759424705585, -122.445946351246) | |||
| 175294 | 175294 | 141632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999054.1432 | 2110418.5587 | 37.7747520248793 | -122.446745757486 | (37.7747520248793, -122.446745757486) | |||
| 174458 | 174458 | 203224 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Northgate Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994449.32754 | 2093942.03458 | 37.7292475573046 | -122.461479885289 | (37.7292475573046, -122.461479885289) | |||
| 174353 | 174353 | 138350 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001659.5245 | 2114595.4043 | 37.786369071961104 | -122.438032482637 | (37.7863690719611, -122.438032482637) | |||
| 174318 | 174318 | 220076 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4512 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6001006.90228 | 2104666.0365299997 | 37.7590683830131 | -122.43957830609 | (37.7590683830131, -122.43957830609) | |||
| 174105 | 174105 | 220030 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.752897751333705 | -122.435109978657 | (37.7528977513337, -122.435109978657) | |||
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 173679 | 173679 | 30757 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.729837877239795 | -122.390455236274 | (37.7298378772398, -122.390455236274) | |
| 173572 | 173572 | 245839 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.775335978986796 | -122.4261291969 | (37.7753359789868, -122.4261291969) | |||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) | |||
| 172135 | 172135 | 220019 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4326 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001759.60763 | 2100322.6693 | 37.747185348536895 | -122.436664198694 | (37.7471853485369, -122.436664198694) | |||
| 172105 | 172105 | 182147 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989680.1915 | 2103890.3009 | 37.756287254354 | -122.478694280415 | (37.756287254354, -122.478694280415) | |||
| 171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
| 171472 | 171472 | 219996 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 80 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007954.3059 | 2099409.5241799997 | 37.7450281501379 | -122.415178725923 | (37.7450281501379, -122.415178725923) | |||
| 171409 | 171409 | 124759 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.800129911416704 | -122.42253331686199 | (37.8001299114167, -122.422533316862) | |||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 170817 | 170817 | 220681 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3223 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009028.25622 | 2099907.20942 | 37.74645498032329 | -122.41150033867201 | (37.7464549803233, -122.411500338672) | |||
| 170794 | 170794 | 220080 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002959.284990001 | 2103850.36087 | 37.756939658960206 | -122.432767777111 | (37.7569396589602, -122.432767777111) | |||
| 170339 | 170339 | 140104 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1750 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999428.844 | 2110866.7552 | 37.776004055577204 | -122.44548183036301 | (37.7760040555772, -122.445481830363) | |||
| 170043 | 170043 | 203639 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 216 Ralston St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.46884485801701 | (37.7163584485498, -122.468844858017) | |||
| 170022 | 170022 | 220032 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4496 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000063.08667 | 2101692.20447 | 37.7508492036437 | -122.442628935085 | (37.7508492036437, -122.442628935085) | |||
| 169866 | 169866 | 188508 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014332.46782 | 2106283.64375 | 37.764259392178005 | -122.393605035044 | (37.764259392178, -122.393605035044) | ||||
| 169840 | 169840 | 188527 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1427x Innes Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016131.12478 | 2096760.51066 | 37.7382106379019 | -122.386719795784 | (37.7382106379019, -122.386719795784) | ||||
| 169675 | 169675 | 203643 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.47245922253201 | (37.7417056300124, -122.472459222532) | |||
| 168971 | 168971 | 220018 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1129 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001364.34858 | 2100418.37342 | 37.7474256590636 | -122.43803782498999 | (37.7474256590636, -122.43803782499) | |||
| 168792 | 168792 | 83538 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 5 | 6004140.213830001 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | ||
| 168115 | 168115 | 34234 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.41289295806801 | (37.8046933049163, -122.412892958068) | ||
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 167945 | 167945 | 220049 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5997764.73117 | 2105899.6107 | 37.7622704065882 | -122.450880165397 | (37.7622704065882, -122.450880165397) | |||
| 167885 | 167885 | 220009 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006820.56616 | 2101433.2332200003 | 37.750521016743896 | -122.419242531131 | (37.7505210167439, -122.419242531131) | |||
| 167841 | 167841 | 43170 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42979 | 6005800.19112 | 2092023.1560099998 | 37.724625531232796 | -122.42210263603701 | (37.7246255312328, -122.422102636037) | |
| 167511 | 167511 | 103887 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999387.5565 | 2110861.3404 | 37.7759868308232 | -122.44562426468201 | (37.7759868308232, -122.445624264682) | |||
| 167015 | 167015 | 220038 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 500x 27th St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 6002807.79997 | 2100063.2344299997 | 37.7465325135634 | -122.433021102638 | (37.7465325135634, -122.433021102638) | |||
| 166995 | 166995 | 203640 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 216 Ralston St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5992221.60329 | 2089317.4306299998 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | |||
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
| 165790 | 165790 | 55817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50161 | 5982146.8936 | 2105055.9033 | 37.759047387316706 | -122.50483294742399 | (37.7590473873167, -122.504832947424) | |
| 165659 | 165659 | 203641 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 608 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992400.09934 | 2090515.7050700001 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | |||
| 164961 | 164961 | 138533 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | |||
| 163609 | 163609 | 43173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 382 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42982 | 6005820.96717 | 2091946.15603 | 37.7244152778362 | -122.42202534828999 | (37.7244152778362, -122.42202534829) | |
| 162807 | 162807 | 220072 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002632.838880001 | 2105513.14285 | 37.7614867382526 | -122.434015605341 | (37.7614867382526, -122.434015605341) | |||
| 162565 | 162565 | 203221 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2398 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5992664.0139 | 2099193.92326 | 37.7435650062179 | -122.468033683007 | (37.7435650062179, -122.468033683007) |
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");