Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
160633 160633 176276 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 62 Tomaso Ct 7 Front Yard : Yard 7 Tree 1 Private 1     12 Width 8ft   6009192.32266 2086308.3659400002 37.7091246419674 -122.40997318013201 (37.7091246419674, -122.409973180132)
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)
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)
24799 24799 120350 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2122 Lake St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
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)
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)
46503 46503 176289 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 140 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6003155.69301 2086832.03957 37.710222356236 -122.430874024341 (37.710222356236, -122.430874024341)
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)
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)
184746 184746 191699 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 50 Quint St 4 Front Yard : Yard 7 Tree 1 Private 1     4 Width 6ft   6015737.97927 2099766.7157099997 37.7464432855229 -122.388288861864 (37.7464432855229, -122.388288861864)
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)
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)
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)
23748 23748 224117 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2818 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009831.98095 2102814.76339 37.754483528604396 -122.40892624516701 (37.7544835286044, -122.408926245167)
25572 25572 191703 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
32095 32095 224121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
39445 39445 224131 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1340 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.41081254437799 (37.7502287892492, -122.410812544378)
62610 62610 224125 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1745 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008033.82801 2108179.5959900003 37.7691132329216 -122.415524547646 (37.7691132329216, -122.415524547646)
71206 71206 126566 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006877.845840001 2117681.84008 37.79513903917879 -122.420197513099 (37.7951390391788, -122.420197513099)
151773 151773 224122 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6008272.03754 2096094.4851799998 37.73594363319479 -122.41384561137899 (37.7359436331948, -122.413845611379)
154781 154781 126564 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006833.89403 2117675.37487 37.7951188107324 -122.42034913432501 (37.7951188107324, -122.420349134325)
171139 171139 126563 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006819.81222 2117673.20836 37.795112068514705 -122.420397705787 (37.7951120685147, -122.420397705787)
177924 177924 126565 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006864.87455 2117678.3281900003 37.795128665521 -122.420242146478 (37.795128665521, -122.420242146478)
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)
187509 187509 191704 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 4ft   6013263.69136 2096352.02038 37.736929838751294 -122.396605400918 (37.7369298387513, -122.396605400918)
26210 26210 118831 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 662 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
26546 26546 191706 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1499 Rankin St 7 Side Yard : Yard 17 Tree 1 Private 1     1 Width 3ft   6012685.03055 2096691.5436200001 37.7378298766422 -122.39862992054701 (37.7378298766422, -122.398629920547)
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)
33648 33648 224127 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 950 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999802.0318599995 2102082.0449599996 37.7519047262434 -122.443559684852 (37.7519047262434, -122.443559684852)
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)
37208 37208 224118 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1525 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009611.07907 2100364.72243 37.7477438841853 -122.409517278718 (37.7477438841853, -122.409517278718)
49466 49466 224126 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3213 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006857.14128 2103777.70396 37.7569604557817 -122.41928234412902 (37.7569604557817, -122.419282344129)
50631 50631 191693 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2212 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6012143.16846 2101895.7398 37.752089281506706 -122.400868941954 (37.7520892815067, -122.400868941954)
55093 55093 202013 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 7 Wheat St 2 : 4 Tree 1 Private 1     3 Width 3ft   6012149.42791 2091374.5561400002 37.723200675946394 -122.40010846893601 (37.7232006759464, -122.400108468936)
55948 55948 207724 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 132 Ralston St 1 : 4 Tree 1 Private 1     3 Width 3ft   5992208.616230001 2088772.7459099998 37.71492473315389 -122.46885013341999 (37.7149247331539, -122.46885013342)
77276 77276 176283 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 35 Tomaso Ct 9 Side Yard : Yard 17 Tree 1 Private 1     8 Width 3ft   6009206.42472 2086339.2337599997 37.7092101890802 -122.40992661863999 (37.7092101890802, -122.40992661864)
115840 115840 176282 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 35 Tomaso Ct 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 3ft   6009202.48899 2086331.0577900002 37.709187518951296 -122.40993964441401 (37.7091875189513, -122.409939644414)
129729 129729 207722 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Louisburg St 1 : 4 Tree 1 Private 1     8 Width 3ft   5997412.90563 2090249.0512400002 37.7192776245304 -122.45096839786801 (37.7192776245304, -122.450968397868)
135365 135365 224124 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1244 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008668.58024 2101297.73586 37.7502528748804 -122.412842355611 (37.7502528748804, -122.412842355611)
151623 151623 207729 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 10 Mendosa Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993528.0302800005 2101159.3791400003 37.749011508281995 -122.46518888187799 (37.749011508282, -122.465188881878)
154658 154658 207718 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 315 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
154979 154979 224128 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 18 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999679.40978 2101490.53022 37.750273576386704 -122.443941232111 (37.7502735763867, -122.443941232111)
157517 157517 224132 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 310 Liberty St 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6004003.018680001 2103934.91108 37.7572309538551 -122.42916418288401 (37.7572309538551, -122.429164182884)
158863 158863 176275 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 23 Byron Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999165.787269999 2086612.0753799998 37.7093915094837 -122.444648098339 (37.7093915094837, -122.444648098339)
158994 158994 207710 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 641 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
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)
161284 161284 207731 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 32 Malta Dr 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999573.254930001 2096045.34694 37.735316349769704 -122.443917140176 (37.7353163497697, -122.443917140176)
168183 168183 118733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 706 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5982303.905590001 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451)
168654 168654 207720 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 750 Grafton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5994515.7556300005 2090598.91337 37.7200719768186 -122.46100802721901 (37.7200719768186, -122.461008027219)
172227 172227 120404 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 527 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5988748.3356 2111702.11927 37.777682216959704 -122.482489301184 (37.7776822169597, -122.482489301184)
172510 172510 224129 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 26 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999702.07185 2101445.78437 37.7501520078164 -122.44385965101499 (37.7501520078164, -122.443859651015)
57409 57409 176288 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 51 Tulane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6007278.5163199995 2093753.93468 37.7294611462914 -122.41711482421199 (37.7294611462914, -122.417114824212)
154589 154589 201358 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 245 Kalmanovitz St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6013008.61874 2092664.0279400002 37.726789172374794 -122.39722877051001 (37.7267891723748, -122.39722877051)
166383 166383 176290 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 324 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6002773.326830001 2086530.28935 37.7093721434675 -122.43217402313101 (37.7093721434675, -122.432174023131)
173225 173225 191701 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2025 Revere Ave 1 : 4 Tree 1 Private 1     1 Width 2ft   6012750.04967 2096000.3617900002 37.7359356579989 -122.398356633674 (37.7359356579989, -122.398356633674)
180758 180758 191694 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2250 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6012110.050319999 2101893.7239200003 37.7520818989832 -122.400983328513 (37.7520818989832, -122.400983328513)
181257 181257 176287 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1565 Bacon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6006970.59339 2091697.7707099998 37.723798037137 -122.418033639041 (37.723798037137, -122.418033639041)
184788 184788 224119 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 410 Valley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6003252.6682 2099235.68131 37.744285469291896 -122.43142373132099 (37.7442854692919, -122.431423731321)
65151 65151 176278 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 87 Seneca Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 1ft   6000216.84897 2089896.4695599999 37.7184696403425 -122.441250964156 (37.7184696403425, -122.441250964156)
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)
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)
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)
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)
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)
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)
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)
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)
172703 172703 176284 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 251 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5993742.60383 2086796.45358 37.7095868089467 -122.46340473574101 (37.7095868089467, -122.463404735741)
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)
25968 25968 249846 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 289 Greenwich St 3 Side Yard : Yard 17 Tree 1 Private 1     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.40464628970601 (37.8028098362532, -122.404646289706)
34978 34978 249883 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 19 Back Yard : Yard 13 Tree 1 Private 1     14 Width 0ft   6011507.08304 2120427.1107900003 37.802936637067496 -122.40437287690901 (37.8029366370675, -122.404372876909)
35128 35128 249903 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.40506238711399 (37.8028859854681, -122.405062387114)
37182 37182 143060 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 444 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6010718.0238 2120346.7181 37.80267177317779 -122.407097773383 (37.8026717731778, -122.407097773383)
57318 57318 218344 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 385 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
59361 59361 176270 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
63802 63802 183573 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2587 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988295.3826 2097727.4025 37.7392850696685 -122.483031684036 (37.7392850696685, -122.483031684036)
66405 66405 249910 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 308 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6011272.31007 2120413.3018099996 37.8028855987512 -122.40518434418699 (37.8028855987512, -122.405184344187)
72590 72590 249863 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 233 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
73148 73148 183678 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3623 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5984470.6439 2106306.3709 37.7626172515097 -122.49688873282601 (37.7626172515097, -122.496888732826)
133186 133186 249880 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 16 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011523.78476 2120446.01272 37.8029894704488 -122.404316411196 (37.8029894704488, -122.404316411196)
155016 155016 176272 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 179 Niagara Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   5999311.03211 2089604.94508 37.717617539904296 -122.444361048235 (37.7176175399043, -122.444361048235)
155390 155390 176273 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 179 Niagara Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   5999314.98259 2089602.87456 37.717612080124205 -122.444347244552 (37.7176120801242, -122.444347244552)
158045 158045 249890 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 26 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011458.55673 2120431.8571900004 37.8029469576839 -122.40454113827101 (37.8029469576839, -122.404541138271)
158587 158587 249981 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 224 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     9 Width 0ft   6011659.45074 2120118.51197 37.8020978133144 -122.403823874987 (37.8020978133144, -122.403823874987)
160122 160122 181986 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2475 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5985788.161 2098383.3055 37.7409397902725 -122.491748687988 (37.7409397902725, -122.491748687988)
177760 177760 184363 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2251 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
180486 180486 176271 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 2 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998766.3474 2088951.7637599998 37.715792961145205 -122.446196810045 (37.7157929611452, -122.446196810045)
186212 186212 200198 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3125 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   6013701.6232 2090281.2208 37.720285019418505 -122.394666263771 (37.7202850194185, -122.394666263771)
7267 7267 19835 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
8172 8172 19836 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
15209 15209 19838 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60X            
79512 79512 804 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 680X 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
17577 17577 5550 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 951 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1998 12:00:00 AM 18 6   6005117.32575 2102805.17707 37.7541919854752 -122.425230085106 (37.7541919854752, -122.425230085106)
80361 80361 115303 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM   4x4 Permit Number 775645 5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
100949 100949 121598 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
2765 2765 173854 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 240 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6013446.0 2105960.0 37.763321440581 -122.396648407729 (37.763321440581, -122.396648407729)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 70.458ms · Data source: data.sfgov.org