Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
182683 | 182683 | 191698 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 602 Arthur Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015659.044530001 | 2099869.60737 | 37.7467214305684 | -122.38856899259 | (37.7467214305684, -122.38856899259) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
27406 | 27406 | 111563 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1498x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6011720.06091 | 2101415.9054400004 | 37.750748151322604 | -122.40229838558001 | (37.7507481513226, -122.40229838558) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||
36917 | 36917 | 191685 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1301 Minnesota St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015385.022890001 | 2102351.0583099998 | 37.7535197845136 | -122.38968982661801 | (37.7535197845136, -122.389689826618) | ||||
55102 | 55102 | 191686 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1301 Minnesota St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015385.377169999 | 2102357.3727700002 | 37.7535371423304 | -122.38968904242701 | (37.7535371423304, -122.389689042427) | ||||
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) | |||
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) | ||||
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) | |||
67780 | 67780 | 191690 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 900x Carolina St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012468.62754 | 2103498.74867 | 37.756508943061206 | -122.39985600137399 | (37.7565089430612, -122.399856001374) | ||||
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) | |||
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) | |||
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) | |||
41768 | 41768 | 191697 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1700 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6012906.9277800005 | 2103803.94978 | 37.7573713838993 | -122.398361606903 | (37.7573713838993, -122.398361606903) | ||||
34441 | 34441 | 191696 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1700 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012930.9536 | 2103804.38992 | 37.7573739307682 | -122.398278546439 | (37.7573739307682, -122.398278546439) | ||||
64747 | 64747 | 191695 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 950x Kansas St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6011603.94241 | 2103847.92507 | 37.7574194607598 | -122.40287096412901 | (37.7574194607598, -122.402870964129) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
38723 | 38723 | 191689 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 01st St | 27 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014402.09171 | 2105890.67407 | 37.7631842517621 | -122.393336722306 | (37.7631842517621, -122.393336722306) | ||||
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) | ||||
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) | ||
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) | |||
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |
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) | |
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
47316 | 47316 | 126572 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1001 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008680.36365 | 2118649.32289 | 37.7978969073709 | -122.414028979559 | (37.7978969073709, -122.414028979559) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) |
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");