Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78574 | 78574 | 109626 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 117 JUDSON AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999286.5 | 2093444.4 | 37.728158398345705 | -122.44472166307101 | (37.7281583983457, -122.444721663071) | |||||
| 2713 | 2713 | 109887 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1024 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6009193.94635 | 2118049.36414 | 37.796278400188704 | -122.412209406439 | (37.7962784001887, -122.412209406439) | ||||
| 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) | ||||
| 15545 | 15545 | 17442 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 1944 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6013068.40824 | 2096637.6125599998 | 37.73770314508 | -122.39730060745501 | (37.73770314508, -122.397300607455) | |||
| 16066 | 16066 | 22498 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 6404 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 3 | 3X3 | 6013069.4059 | 2090221.21293 | 37.720085079934705 | -122.39684744087799 | (37.7200850799347, -122.396847440878) | ||
| 16686 | 16686 | 19817 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 21420 | 21420 | 7445 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 2548 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008209.4393 | 2103591.6656299997 | 37.7565257046152 | -122.41459240931201 | (37.7565257046152, -122.414592409312) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 29901 | 29901 | 191709 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 3535 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013020.366769999 | 2089365.2626599998 | 37.717732082047895 | -122.39695697201 | (37.7177320820479, -122.39695697201) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 37671 | 37671 | 176274 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 775 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6000713.865119999 | 2089358.3764799999 | 37.7170204575094 | -122.439494437135 | (37.7170204575094, -122.439494437135) | ||||
| 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) | |||
| 41072 | 41072 | 32329 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 1884 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 5 | Permit Number 36893 | 5993786.54543 | 2102682.50055 | 37.7532085147622 | -122.46440551389601 | (37.7532085147622, -122.464405513896) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 61536 | 61536 | 246754 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1838 Alabama St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009313.62627 | 2099009.8875700003 | 37.7440071345341 | -122.410450206611 | (37.7440071345341, -122.410450206611) | ||||
| 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) | |||
| 64078 | 64078 | 247873 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 388 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.40842103750299 | (37.7423635938187, -122.408421037503) | ||||
| 64704 | 64704 | 191708 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 979 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6013251.209530001 | 2089459.918 | 37.7180048338374 | -122.396165676526 | (37.7180048338374, -122.396165676526) | ||||
| 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) | |||
| 70263 | 70263 | 48553 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 378 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 3 | Permit Number 45869 | 5990302.44703 | 2112853.20794 | 37.780933073312504 | -122.477197298017 | (37.7809330733125, -122.477197298017) | ||
| 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) | |||
| 73220 | 73220 | 246771 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1850 Alabama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6009333.37029 | 2098874.50038 | 37.743636497837 | -122.410372378408 | (37.743636497837, -122.410372378408) | ||||
| 74925 | 74925 | 61499 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 154 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | 7 | Permit Number 21452 | 5989629.6033 | 2114330.31946 | 37.7849497475064 | -122.47963307901001 | (37.7849497475064, -122.47963307901) | |
| 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) | |||
| 75891 | 75891 | 61497 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 137 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1984 12:00:00 AM | 9 | Permit Number 21447 | 5989576.46395 | 2114470.4752700003 | 37.7853314889271 | -122.479827181582 | (37.7853314889271, -122.479827181582) | |
| 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) | ||
| 94834 | 94834 | 99679 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 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) | |||
| 133319 | 133319 | 54637 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 1747 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10460 | 6012648.74415 | 2095666.1739599998 | 37.7350124040996 | -122.39868344459299 | (37.7350124040996, -122.398683444593) | ||
| 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) | |||
| 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) | ||||
| 138223 | 138223 | 57922 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 539 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 5 | Permit Number 16880 | 5999313.15008 | 2086900.5185900002 | 37.7101919177852 | -122.444159502961 | (37.7101919177852, -122.444159502961) | ||
| 141580 | 141580 | 109627 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 500 CIRCULAR AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999334.0 | 2093430.0 | 37.728121569817 | -122.444556419888 | (37.728121569817, -122.444556419888) | ||||
| 150484 | 150484 | 88782 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 166 Havelock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51699 | 5999327.1574099995 | 2092949.02389 | 37.7268005308142 | -122.444545520761 | (37.7268005308142, -122.444545520761) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 165090 | 165090 | 73562 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1620 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 8 | 6015449.230359999 | 2096256.56638 | 37.7367891335144 | -122.389042293172 | (37.7367891335144, -122.389042293172) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 174539 | 174539 | 207721 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 228 Montana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | ||||
| 177598 | 177598 | 65002 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 1628 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1989 12:00:00 AM | 7 | Permit Number 26041 | 6007789.57951 | 2087924.3929599999 | 37.713483198176796 | -122.414935588817 | (37.7134831981768, -122.414935588817) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 184764 | 184764 | 126562 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6009829.32931 | 2117256.5326099996 | 37.7941371098806 | -122.40995484385901 | (37.7941371098806, -122.409954843859) | ||||
| 185039 | 185039 | 224123 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 523 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008526.38321 | 2098121.4064599997 | 37.7415233967761 | -122.413109512687 | (37.7415233967761, -122.413109512687) | ||||
| 186390 | 186390 | 62603 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 792 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 6 | Permit Number 22911 | 5984491.42084 | 2110500.08946 | 37.7741332293959 | -122.497126446837 | (37.7741332293959, -122.497126446837) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 41649 | 41649 | 73939 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1450 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | 5988330.9539 | 2099688.5183 | 37.744671848150894 | -122.483052396761 | (37.7446718481509, -122.483052396761) | ||
| 42410 | 42410 | 126571 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1013 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6008640.83285 | 2118637.5271099997 | 37.7978622987641 | -122.414164932777 | (37.7978622987641, -122.414164932777) | ||||
| 45069 | 45069 | 126561 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6009832.93804 | 2117260.0663900003 | 37.7941470150322 | -122.40994260678998 | (37.7941470150322, -122.40994260679) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 153224 | 153224 | 176279 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 671 London St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6001065.40936 | 2089903.8077599998 | 37.7185380904529 | -122.43831837391001 | (37.7185380904529, -122.43831837391) | ||||
| 153997 | 153997 | 111169 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 1469 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6007081.20428 | 2117722.0309900003 | 37.795260849674705 | -122.41949671281701 | (37.7952608496747, -122.419496712817) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 179174 | 179174 | 71359 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1620 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015449.34332 | 2096256.73769 | 37.7367896101585 | -122.389041914574 | (37.7367896101585, -122.389041914574) | ||
| 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) |
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");