Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23535 | 23535 | 207712 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 579 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997579.44084 | 2094367.86788 | 37.730596459453395 | -122.450689553205 | (37.7305964594534, -122.450689553205) | ||||
25243 | 25243 | 126568 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2745 Larkin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6006520.94056 | 2120654.06544 | 37.8032799020007 | -122.421643667929 | (37.8032799020007, -122.421643667929) | ||||
27037 | 27037 | 207730 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 740 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5998158.00142 | 2095945.9651099998 | 37.7349626400957 | -122.44880301654 | (37.7349626400957, -122.44880301654) | |||
29285 | 29285 | 207725 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 380 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5992234.508719999 | 2090438.5826599998 | 37.7195002121526 | -122.468881791362 | (37.7195002121526, -122.468881791362) | |||
34006 | 34006 | 207717 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1180 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5995974.63238 | 2091762.70234 | 37.723351307004705 | -122.456049310222 | (37.7233513070047, -122.456049310222) | |||
34794 | 34794 | 224120 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1350 Noe St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6003219.3903 | 2100351.64414 | 37.7473477571063 | -122.431618456154 | (37.7473477571063, -122.431618456154) | ||||
35240 | 35240 | 207714 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 298 Staples Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998133.74364 | 2093826.5868 | 37.7291419427263 | -122.448734282271 | (37.7291419427263, -122.448734282271) | ||||
35482 | 35482 | 207723 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 301 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5991929.884269999 | 2090544.1507700002 | 37.719772472009204 | -122.469942439216 | (37.7197724720092, -122.469942439216) | |||
36817 | 36817 | 176286 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 901 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5998666.60141 | 2089601.1299700001 | 37.7175702751322 | -122.446588269645 | (37.7175702751322, -122.446588269645) | |||
48398 | 48398 | 224111 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1100 San Jose Ave | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004733.53405 | 2096634.51546 | 37.7372270772601 | -122.42611806850799 | (37.7372270772601, -122.426118068508) | ||||
48766 | 48766 | 191702 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1998 Revere Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6013024.54675 | 2095962.65305 | 37.7358474048249 | -122.397404937794 | (37.7358474048249, -122.397404937794) | ||||
51044 | 51044 | 176285 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | |||
56447 | 56447 | 191691 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2301 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010894.94565 | 2105057.58809 | 37.7607013108401 | -122.405408158461 | (37.7607013108401, -122.405408158461) | ||||
56636 | 56636 | 207715 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 117 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999294.96193 | 2093458.5663400001 | 37.7281977787 | -122.444693427785 | (37.7281977787, -122.444693427785) | ||||
58281 | 58281 | 176277 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 190 Foote Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998652.47444 | 2088356.09646 | 37.7141508908239 | -122.44654757532301 | (37.7141508908239, -122.446547575323) | |||
68300 | 68300 | 224116 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 400 Prospect Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6006205.79839 | 2097605.42741 | 37.7399760871276 | -122.421096686769 | (37.7399760871276, -122.421096686769) | ||||
69216 | 69216 | 207727 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 378 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993265.77465 | 2089711.0849799998 | 37.717562206406 | -122.46526429632601 | (37.717562206406, -122.465264296326) | |||
71579 | 71579 | 248210 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 69 Fair Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007064.668 | 2099422.3589 | 37.7450133544796 | -122.418255851634 | (37.7450133544796, -122.418255851634) | |||
72600 | 72600 | 187568 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 138 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6010896.54149 | 2088103.23155 | 37.714148350239704 | -122.40420934958401 | (37.7141483502397, -122.404209349584) | |||
73834 | 73834 | 207713 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 171 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5999625.5730099995 | 2094046.65577 | 37.7298313962868 | -122.443592725033 | (37.7298313962868, -122.443592725033) | ||||
75558 | 75558 | 191687 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 800 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6015123.17396 | 2105339.16037 | 37.7617099499859 | -122.390804173874 | (37.7617099499859, -122.390804173874) | |||
84522 | 84522 | 113121 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
122151 | 122151 | 207726 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 416 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 5992237.92359 | 2090619.0138400001 | 37.719995829436 | -122.468883110676 | (37.719995829436, -122.468883110676) | |||
135662 | 135662 | 191707 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2187 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6011937.92175 | 2096699.9343299998 | 37.7378112633764 | -122.401213644004 | (37.7378112633764, -122.401213644004) | ||||
141988 | 141988 | 113120 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
148462 | 148462 | 176280 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 600 Blanken Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6013180.81524 | 2086857.6738099998 | 37.7108556687339 | -122.39622672069599 | (37.7108556687339, -122.396226720696) | |||
153779 | 153779 | 207734 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 301 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000042.84201 | 2094939.4846400002 | 37.7323066857905 | -122.442214249597 | (37.7323066857905, -122.442214249597) | |||
157462 | 157462 | 207708 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 916 Ortega St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 1ft | 5991151.901959999 | 2102512.9309 | 37.7525906994144 | -122.473504184373 | (37.7525906994144, -122.473504184373) | |||
161021 | 161021 | 207707 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1254 18th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5990519.642630001 | 2106849.6628099997 | 37.7644615768749 | -122.476007325895 | (37.7644615768749, -122.476007325895) | |||
161098 | 161098 | 207716 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 115 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5999335.92351 | 2093459.52729 | 37.72820275463761 | -122.44455189156601 | (37.7282027546376, -122.444551891566) | |||
162191 | 162191 | 123640 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 345 Arguello Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5995501.56716 | 2113883.85045 | 37.784063214039605 | -122.459285759007 | (37.7840632140396, -122.459285759007) | |||
163114 | 163114 | 126569 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2745 Larkin St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6006516.40415 | 2120646.68987 | 37.8032593947653 | -122.42165884218599 | (37.8032593947653, -122.421658842186) | ||||
165369 | 165369 | 224112 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1100 San Jose Ave | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6004737.84332 | 2096628.1853599998 | 37.7372099397936 | -122.42610271887101 | (37.7372099397936, -122.426102718871) | ||||
165907 | 165907 | 126567 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2843 Larkin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006455.5801099995 | 2121070.56705 | 37.8044198232789 | -122.42189945398998 | (37.8044198232789, -122.42189945399) | |||
167274 | 167274 | 126570 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 94 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008053.53116 | 2119101.30283 | 37.7991027057905 | -122.41623003160299 | (37.7991027057905, -122.416230031603) | ||||
167474 | 167474 | 207709 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 916 Ortega St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 1ft | 5991129.27817 | 2102510.74063 | 37.752583375332605 | -122.47358226082 | (37.7525833753326, -122.47358226082) | |||
169472 | 169472 | 207719 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 126 Brighton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5996251.42646 | 2090752.11635 | 37.7205923605284 | -122.455019501973 | (37.7205923605284, -122.455019501973) | |||
170332 | 170332 | 191688 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 800 19th St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6014977.94549 | 2105331.22601 | 37.761680105066105 | -122.39130591015 | (37.7616801050661, -122.39130591015) | |||
172056 | 172056 | 207733 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 500 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998757.70005 | 2094996.74516 | 37.732390582643205 | -122.446661380942 | (37.7323905826432, -122.446661380942) | ||||
172414 | 172414 | 249620 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2400 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 5997953.57215 | 2111367.44178 | 37.7772944806811 | -122.45062126495199 | (37.7772944806811, -122.450621264952) | |||
175044 | 175044 | 207732 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 400 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6000124.6238 | 2095012.3046900001 | 37.7325112932663 | -122.441936736802 | (37.7325112932663, -122.441936736802) | |||
177554 | 177554 | 191692 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 764 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012093.5937 | 2104845.22166 | 37.7601851458373 | -122.401247624904 | (37.7601851458373, -122.401247624904) | ||||
177778 | 177778 | 176281 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 600 Blanken Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6013188.37125 | 2086854.32403 | 37.710846891333105 | -122.39620037057101 | (37.7108468913331, -122.396200370571) | |||
179929 | 179929 | 207728 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 3802 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5990564.76109 | 2090542.95021 | 37.7196901687566 | -122.47466105158199 | (37.7196901687566, -122.474661051582) | |||
180825 | 180825 | 224130 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 840 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6002416.06064 | 2103301.09689 | 37.7554006877977 | -122.434607174889 | (37.7554006877977, -122.434607174889) |
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");