Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
371 | 371 | 8188 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | ||
10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
16814 | 16814 | 105175 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.735287354242395 | -122.390027366589 | (37.7352873542424, -122.390027366589) | |||
23746 | 23746 | 188514 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013990.927619999 | 2106981.7626099996 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | |||
24187 | 24187 | 142264 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.775809585078896 | -122.427435282317 | (37.7758095850789, -122.427435282317) | |||
29829 | 29829 | 115807 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | |||
31248 | 31248 | 220041 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000667.40596 | 2102598.56375 | 37.7533722777334 | -122.440604151054 | (37.7533722777334, -122.440604151054) | |||
32234 | 32234 | 220023 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 89 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001002.01011 | 2101166.3716 | 37.749458870636396 | -122.439344371761 | (37.7494588706364, -122.439344371761) | |||
33978 | 33978 | 203629 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | |||
38222 | 38222 | 103892 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999308.7043 | 2110849.4957 | 37.7759498061666 | -122.44589618201 | (37.7759498061666, -122.44589618201) | |||
42523 | 42523 | 220064 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002590.76073 | 2102413.7777400003 | 37.7529742368948 | -122.43393958746701 | (37.7529742368948, -122.433939587467) | |||
44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
45030 | 45030 | 220037 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4263 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002187.26734 | 2100592.3557700003 | 37.74795013829029 | -122.43520467366301 | (37.7479501382903, -122.435204673663) | |||
47055 | 47055 | 40817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.785958067470204 | -122.43822613537901 | (37.7859580674702, -122.438226135379) | |
47147 | 47147 | 73391 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 10 | 6001816.88591 | 2094039.23102 | 37.72993574283429 | -122.43601658701999 | (37.7299357428343, -122.43601658702) | ||
50765 | 50765 | 244169 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1752 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998187.9203 | 2108956.9743 | 37.7706893684237 | -122.449636842472 | (37.7706893684237, -122.449636842472) | |||
54361 | 54361 | 203635 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.44938890058201 | (37.7299264906077, -122.449388900582) | |||
55582 | 55582 | 220093 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003963.29373 | 2098007.80301 | 37.7409542473406 | -122.428879018678 | (37.7409542473406, -122.428879018678) | |||
56688 | 56688 | 122010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.775009640229605 | -122.473370979732 | (37.7750096402296, -122.473370979732) | |||
59933 | 59933 | 220069 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1047 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003827.33604 | 2102174.6628400004 | 37.7523877808826 | -122.42964622220501 | (37.7523877808826, -122.429646222205) | |||
60100 | 60100 | 83227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.39716301566901 | (37.7601232913798, -122.397163015669) | ||
69574 | 69574 | 245838 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | |||
70342 | 70342 | 220043 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000611.236219999 | 2102612.95968 | 37.753408606731 | -122.440799429852 | (37.753408606731, -122.440799429852) | |||
74967 | 74967 | 124761 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.41696742351101 | (37.8013029241584, -122.416967423511) | |||
75193 | 75193 | 139501 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | |||
88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
89457 | 89457 | 113028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 WINFIELD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x5 | 6007142.0 | 2098801.0 | 37.7433115947954 | -122.417944411944 | (37.7433115947954, -122.417944411944) | |||
90165 | 90165 | 111781 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 399x EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006811.0 | 2098022.0 | 37.7411540008274 | -122.419033684979 | (37.7411540008274, -122.419033684979) | |||
100029 | 100029 | 19281 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
118711 | 118711 | 116614 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 299X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | |||
125899 | 125899 | 98340 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
135076 | 135076 | 220039 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001009.04844 | 2102577.7533400003 | 37.7533345862464 | -122.439421190941 | (37.7533345862464, -122.439421190941) | |||
135969 | 135969 | 32347 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.764498837803394 | -122.494459352499 | (37.7644988378034, -122.494459352499) | |
136032 | 136032 | 188517 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2000 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012457.67401 | 2102853.6351799998 | 37.7547369917341 | -122.399848584652 | (37.7547369917341, -122.399848584652) | |||
137990 | 137990 | 70572 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 421 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 10 | 5999717.91 | 2110099.0732 | 37.773912694204 | -122.44442669475401 | (37.773912694204, -122.444426694754) | ||
141333 | 141333 | 113369 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x9 | 6009304.0 | 2096928.0 | 37.7382901856605 | -122.41033652541401 | (37.7382901856605, -122.410336525414) | |||
146931 | 146931 | 220695 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3706 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004965.60953 | 2102543.32238 | 37.7534644213631 | -122.425736121051 | (37.7534644213631, -122.425736121051) | |||
148631 | 148631 | 60312 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 545 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 10 | Permit Number 19882 | 5999669.64 | 2110412.2941 | 37.774769964844 | -122.444616185093 | (37.774769964844, -122.444616185093) | ||
149197 | 149197 | 203647 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993596.72892 | 2093377.0999599998 | 37.7276472749004 | -122.46438636913099 | (37.7276472749004, -122.464386369131) | |||
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) | |||
153681 | 153681 | 44451 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.710372910849706 | -122.43278970978001 | (37.7103729108497, -122.43278970978) | |
157540 | 157540 | 124754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003727.74275 | 2117577.1894400003 | 37.794673696686104 | -122.431089877801 | (37.7946736966861, -122.431089877801) | |||
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) | |||
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) | |||
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
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");