Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
6851 | 6851 | 20056 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
8970 | 8970 | 10634 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.43021469913201 | (37.7760227838468, -122.430214699132) | ||
19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
31523 | 31523 | 188515 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6014455.23285 | 2101981.54762 | 37.752453585184604 | -122.39287941707799 | (37.7524535851846, -122.392879417078) | ||||
33547 | 33547 | 137666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000398.0082 | 2111639.7629 | 37.7781818179135 | -122.442184748811 | (37.7781818179135, -122.442184748811) | |||
42347 | 42347 | 203665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.728549449599704 | -122.444327421686 | (37.7285494495997, -122.444327421686) | |||
42359 | 42359 | 138339 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | |||
43667 | 43667 | 203624 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.45196580449199 | (37.7449725828299, -122.451965804492) | |||
45531 | 45531 | 220666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Dorland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005487.19676 | 2105743.72088 | 37.7622814268651 | -122.42415994852199 | (37.7622814268651, -122.424159948522) | |||
48501 | 48501 | 188519 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | ||||
54358 | 54358 | 219993 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Prospect Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6006993.27252 | 2098944.7494 | 37.7436979269164 | -122.418468865069 | (37.7436979269164, -122.418468865069) | ||||
61990 | 61990 | 140718 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002160.0013 | 2110449.3533 | 37.7750135114472 | -122.436004179308 | (37.7750135114472, -122.436004179308) | |||
64061 | 64061 | 32346 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
66468 | 66468 | 203632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | |||
69010 | 69010 | 188521 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013271.447919999 | 2104826.1277799997 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | |||
69034 | 69034 | 220048 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997746.6978 | 2105897.5577 | 37.7622637372081 | -122.450942387687 | (37.7622637372081, -122.450942387687) | |||
70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
70549 | 70549 | 40816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | ||
82962 | 82962 | 29220 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1902X 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
84795 | 84795 | 49477 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145001 | (37.7976666140298, -122.39835845145) | |||
92174 | 92174 | 50672 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
94988 | 94988 | 117034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
95511 | 95511 | 49584 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | ||
99251 | 99251 | 19283 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
101744 | 101744 | 39506 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
102717 | 102717 | 42112 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
103294 | 103294 | 43707 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
108504 | 108504 | 85500 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
113556 | 113556 | 45337 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | ||
121928 | 121928 | 43149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | |||
127101 | 127101 | 36920 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
129705 | 129705 | 220028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | |||
130794 | 130794 | 188513 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.39479799565399 | (37.7659112417232, -122.394797995654) | |||
135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
142538 | 142538 | 23664 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 311 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
145318 | 145318 | 50662 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
148974 | 148974 | 174958 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | |||
149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
151048 | 151048 | 220044 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002160.56118 | 2096968.3315700002 | 37.7379978987733 | -122.43503787010201 | (37.7379978987733, -122.435037870102) | |||
151268 | 151268 | 203651 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993846.97887 | 2094818.6059299998 | 37.731619718855704 | -122.46362583408701 | (37.7316197188557, -122.463625834087) | |||
152716 | 152716 | 40191 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.320719999 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | ||
154629 | 154629 | 113718 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991385.6612 | 2110673.31757 | 37.7750104780928 | -122.473290929077 | (37.7750104780928, -122.473290929077) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |
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) |
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");