Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | |||
29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
34184 | 34184 | 129681 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | |||
34507 | 34507 | 129677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012069.97592 | 2116796.7218299997 | 37.792999901879604 | -122.402169577472 | (37.7929999018796, -122.402169577472) | |||
37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
37884 | 37884 | 226699 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 38 Ramona Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6005184.56747 | 2107580.1746400003 | 37.767306799804004 | -122.42533732116001 | (37.767306799804, -122.42533732116) | |||
37891 | 37891 | 227521 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1500 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 5998355.105169999 | 2105264.42447 | 37.7605601235622 | -122.448792539459 | (37.7605601235622, -122.448792539459) | |||
47017 | 47017 | 129614 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824896999 | (37.7854973571526, -122.42115824897) | |||
49510 | 49510 | 129642 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | |||
49847 | 49847 | 129680 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012023.6782599995 | 2116790.52383 | 37.792980299349395 | -122.40232933485001 | (37.7929802993494, -122.40232933485) | |||
51625 | 51625 | 129675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012092.09526 | 2116799.4138599997 | 37.79300852816029 | -122.402093232241 | (37.7930085281603, -122.402093232241) | |||
59724 | 59724 | 227210 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007580.30046 | 2098202.33291 | 37.7416924459422 | -122.416386483043 | (37.7416924459422, -122.416386483043) | |||
60893 | 60893 | 129592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.79392892673889 | -122.42362005315 | (37.7939289267389, -122.42362005315) | |||
61599 | 61599 | 227266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | ||||
66370 | 66370 | 226659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.43221 | 2108111.34467 | 37.768739710290205 | -122.42693902812799 | (37.7687397102902, -122.426939028128) | |||
66714 | 66714 | 227264 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001689.2287 | 2099738.29729 | 37.7455768013454 | -122.436865735887 | (37.7455768013454, -122.436865735887) | ||||
72192 | 72192 | 129625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 54 Glover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 6008038.60532 | 2118409.42437 | 37.7972021406145 | -122.416232651327 | (37.7972021406145, -122.416232651327) | |||
72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
74224 | 74224 | 227312 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6002324.80027 | 2098291.20811 | 37.7416395352327 | -122.43456457759301 | (37.7416395352327, -122.434564577593) | |||
130904 | 130904 | 129591 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.42352338950899 | (37.7939448878875, -122.423523389509) | |||
134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
135533 | 135533 | 129679 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012036.63622 | 2116793.11614 | 37.792988140540004 | -122.40228468169799 | (37.79298814054, -122.402284681698) | |||
136993 | 136993 | 129589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005852.90495 | 2116274.14842 | 37.7912160669044 | -122.423643836609 | (37.7912160669044, -122.423643836609) | |||
146811 | 146811 | 129676 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | |||
152082 | 152082 | 227211 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 3ft | 6009836.16533 | 2099585.28248 | 37.7456163229324 | -122.408683960589 | (37.7456163229324, -122.408683960589) | |||
155845 | 155845 | 129674 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012104.09602 | 2116801.48556 | 37.793014886365796 | -122.402051854416 | (37.7930148863658, -122.402051854416) | |||
157783 | 157783 | 227304 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002725.4323 | 2099066.84867 | 37.7437919986955 | -122.433234737486 | (37.7437919986955, -122.433234737486) | ||||
158841 | 158841 | 177143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | |||
159072 | 159072 | 227265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6001689.18438 | 2099736.15615 | 37.7455709197615 | -122.436865735887 | (37.7455709197615, -122.436865735887) | ||||
165909 | 165909 | 227209 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6007561.8732 | 2098204.30964 | 37.741696837339504 | -122.416450338512 | (37.7416968373395, -122.416450338512) | |||
166303 | 166303 | 227396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 5 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005864.943030001 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | |||
167437 | 167437 | 226661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.99983 | 2108080.69145 | 37.7686555760307 | -122.42693488134199 | (37.7686555760307, -122.426934881342) | |||
180427 | 180427 | 247286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 644 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5997022.454 | 2108829.1148 | 37.7702715542748 | -122.453658952423 | (37.7702715542748, -122.453658952423) | |||
181593 | 181593 | 143365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1735 UNION ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6004681.3503 | 2118768.1568 | 37.7979977794826 | -122.427875172085 | (37.7979977794826, -122.427875172085) | |||
183200 | 183200 | 227303 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.43323551541701 | (37.7437280128274, -122.433235515417) | ||||
183307 | 183307 | 129678 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) | |||
184110 | 184110 | 227208 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 3ft | 6007523.932469999 | 2098207.4852299998 | 37.741703423083294 | -122.416581750143 | (37.7417034230833, -122.416581750143) |
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");