trees
183 rows where qSpecies_id = 119 sorted by DBH descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24987 | 249981 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 224 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011659.45074 | 2120118.51197 | 37.8020978133144 | -122.403823874987 | (37.8020978133144, -122.403823874987) | 3 | 1 | 10 | 308 | 23 | |||
54915 | 246770 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 99 Waltham St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | 2 | 7 | 7 | 28859 | 2 | ||||
69086 | 61497 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 137 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1984 12:00:00 AM | 9 | Permit Number 21447 | 5989576.46395 | 2114470.47527 | 37.7853314889271 | -122.479827181582 | (37.7853314889271, -122.479827181582) | 11 | 6 | 2 | 55 | 26 | |
80510 | 224127 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 950 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999802.03186 | 2102082.04496 | 37.7519047262434 | -122.443559684852 | (37.7519047262434, -122.443559684852) | 2 | 5 | 5 | 63 | 38 | |||
88203 | 224119 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 410 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003252.6682 | 2099235.68131 | 37.7442854692919 | -122.431423731321 | (37.7442854692919, -122.431423731321) | 2 | 7 | 5 | 63 | 22 | |||
107585 | 191709 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3535 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013020.36677 | 2089365.26266 | 37.7177320820479 | -122.39695697201 | (37.7177320820479, -122.39695697201) | 10 | 3 | 8 | 58 | 1 | ||||
120318 | 247873 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.408421037503 | (37.7423635938187, -122.408421037503) | 10 | 7 | 7 | 28859 | 2 | ||||
123750 | 191692 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 764 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012093.5937 | 2104845.22166 | 37.7601851458373 | -122.401247624904 | (37.7601851458373, -122.401247624904) | 10 | 3 | 8 | 28856 | 29 | ||||
135986 | 88782 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 166 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51699 | 5999327.15741 | 2092949.02389 | 37.7268005308142 | -122.444545520761 | (37.7268005308142, -122.444545520761) | 9 | 7 | 6 | 28861 | 25 | |
149641 | 224132 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 310 Liberty St | 26 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004003.01868 | 2103934.91108 | 37.7572309538551 | -122.429164182884 | (37.7572309538551, -122.429164182884) | 2 | 4 | 5 | 28862 | 3 | |||
165069 | 126562 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 8 Codman Pl | 1 | Back Yard : Yard | Tree | Private 2 | 9 | 6009829.32931 | 2117256.53261 | 37.7941371098806 | -122.409954843859 | (37.7941371098806, -122.409954843859) | 3 | 1 | 10 | 28857 | 21 | ||||
190243 | 224129 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 26 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999702.07185 | 2101445.78437 | 37.7501520078164 | -122.443859651015 | (37.7501520078164, -122.443859651015) | 2 | 5 | 5 | 63 | 38 | |||
12159 | 207734 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 301 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000042.84201 | 2094939.48464 | 37.7323066857905 | -122.442214249597 | (37.7323066857905, -122.442214249597) | 9 | 7 | 4 | 63 | 40 | |||
14087 | 72881 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 130 Alpha St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010899.06821 | 2088108.56402 | 37.7141631333099 | -122.404200991296 | (37.7141631333099, -122.404200991296) | 9 | 7 | 8 | 309 | 39 | |||
17085 | 73562 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015449.23036 | 2096256.56638 | 37.7367891335144 | -122.389042293172 | (37.7367891335144, -122.389042293172) | 10 | 3 | 8 | 58 | 1 | |||
37765 | 224120 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1350 Noe St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6003219.3903 | 2100351.64414 | 37.7473477571063 | -122.431618456154 | (37.7473477571063, -122.431618456154) | 2 | 4 | 5 | 63 | 22 | ||||
59884 | 207731 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 32 Malta Dr | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999573.25493 | 2096045.34694 | 37.7353163497697 | -122.443917140176 | (37.7353163497697, -122.443917140176) | 9 | 7 | 4 | 63 | 40 | |||
71753 | 224115 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 8 | 6004680.7613 | 2096547.43611 | 37.7369849941684 | -122.426294330213 | (37.7369849941684, -122.426294330213) | 2 | 7 | 5 | 63 | 7 | ||||
107967 | 176290 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 324 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002773.32683 | 2086530.28935 | 37.7093721434675 | -122.432174023131 | (37.7093721434675, -122.432174023131) | 9 | 7 | 6 | 28861 | 5 | |||
115439 | 207722 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 300 Louisburg St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997412.90563 | 2090249.05124 | 37.7192776245304 | -122.450968397868 | (37.7192776245304, -122.450968397868) | 9 | 8 | 6 | 28861 | 24 | |||
117152 | 126569 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2745 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6006516.40415 | 2120646.68987 | 37.8032593947653 | -122.421658842186 | (37.8032593947653, -122.421658842186) | 5 | 9 | 1 | 28858 | 32 | ||||
132651 | 207707 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1254 18th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990519.64263 | 2106849.66281 | 37.7644615768749 | -122.476007325895 | (37.7644615768749, -122.476007325895) | 11 | 8 | 3 | 56 | 12 | |||
135280 | 187568 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 138 Alpha St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6010896.54149 | 2088103.23155 | 37.7141483502397 | -122.404209349584 | (37.7141483502397, -122.404209349584) | 9 | 7 | 8 | 309 | 39 | |||
154304 | 191694 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2250 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012110.05032 | 2101893.72392 | 37.7520818989832 | -122.400983328513 | (37.7520818989832, -122.400983328513) | 10 | 3 | 8 | 28856 | 29 | |||
187997 | 246764 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 70 Waltham St | 8 | Front Yard : Yard | Tree | Private 2 | 8 | 6009279.96949 | 2098891.64841 | 37.7436805888792 | -122.410558236772 | (37.7436805888792, -122.410558236772) | 2 | 7 | 7 | 28859 | 2 | ||||
188172 | 176283 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 9 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6009206.42472 | 2086339.23376 | 37.7092101890802 | -122.40992661864 | (37.7092101890802, -122.40992661864) | 9 | 7 | 8 | 309 | 39 | |||
2236 | 71359 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015449.34332 | 2096256.73769 | 37.7367896101585 | -122.389041914574 | (37.7367896101585, -122.389041914574) | 10 | 3 | 8 | 58 | 1 | |||
8877 | 191703 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | 6013259.66608 | 2096346.42133 | 37.7369142408999 | -122.396618925818 | (37.7369142408999, -122.396618925818) | 10 | 3 | 8 | 58 | 1 | |||
9793 | 126563 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006819.81222 | 2117673.20836 | 37.7951120685147 | -122.420397705787 | (37.7951120685147, -122.420397705787) | 13 | 9 | 10 | 28858 | 32 | |||
19239 | 224123 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 601X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008526.38321 | 2098121.40646 | 37.7415233967761 | -122.413109512687 | (37.7415233967761, -122.413109512687) | 10 | 7 | 7 | 28859 | 2 | ||||
22081 | 111169 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1469 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007081.20428 | 2117722.03099 | 37.7952608496747 | -122.419496712817 | (37.7952608496747, -122.419496712817) | 5 | 1 | 10 | 28858 | 32 | |||
33980 | 126570 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 94 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008053.53116 | 2119101.30283 | 37.7991027057905 | -122.416230031603 | (37.7991027057905, -122.416230031603) | 5 | 1 | 10 | 308 | 32 | ||||
36602 | 126561 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 8 Codman Pl | 2 | Back Yard : Yard | Tree | Private 2 | 7 | 6009832.93804 | 2117260.06639 | 37.7941470150322 | -122.40994260679 | (37.7941470150322, -122.40994260679) | 3 | 1 | 10 | 28857 | 21 | ||||
56150 | 224116 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 400 Prospect Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6006205.79839 | 2097605.42741 | 37.7399760871276 | -122.421096686769 | (37.7399760871276, -122.421096686769) | 2 | 7 | 7 | 28859 | 2 | ||||
63491 | 65002 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1628 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 7 | Permit Number 26041 | 6007789.57951 | 2087924.39296 | 37.7134831981768 | -122.414935588817 | (37.7134831981768, -122.414935588817) | 9 | 7 | 8 | 309 | 39 | ||
70351 | 224117 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2818 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009831.98095 | 2102814.76339 | 37.7544835286044 | -122.408926245167 | (37.7544835286044, -122.408926245167) | 2 | 4 | 7 | 28859 | 19 | |||
83068 | 207712 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 579 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997579.44084 | 2094367.86788 | 37.7305964594534 | -122.450689553205 | (37.7305964594534, -122.450689553205) | 9 | 7 | 4 | 28861 | 40 | ||||
84988 | 176279 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 671 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6001065.40936 | 2089903.80776 | 37.7185380904529 | -122.43831837391 | (37.7185380904529, -122.43831837391) | 9 | 7 | 6 | 28861 | 5 | ||||
111643 | 123640 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 345 Arguello Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5995501.56716 | 2113883.85045 | 37.7840632140396 | -122.459285759007 | (37.7840632140396, -122.459285759007) | 11 | 6 | 2 | 54 | 11 | |||
118144 | 201358 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 245 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013008.61874 | 2092664.02794 | 37.7267891723748 | -122.39722877051 | (37.7267891723748, -122.39722877051) | 10 | 3 | 8 | 58 | 1 | |||
123058 | 126564 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006833.89403 | 2117675.37487 | 37.7951188107324 | -122.420349134325 | (37.7951188107324, -122.420349134325) | 13 | 9 | 10 | 28858 | 32 | |||
136327 | 191691 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2301 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010894.94565 | 2105057.58809 | 37.7607013108401 | -122.405408158461 | (37.7607013108401, -122.405408158461) | 10 | 3 | 8 | 28856 | 29 | ||||
138423 | 118733 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 706 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5982303.90559 | 2110925.66237 | 37.7751732905824 | -122.504724857451 | (37.7751732905824, -122.504724857451) | 11 | 6 | 2 | 55 | 26 | |||
148321 | 191696 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 22nd St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | 6012930.9536 | 2103804.38992 | 37.7573739307682 | -122.398278546439 | (37.7573739307682, -122.398278546439) | 10 | 3 | 8 | 28856 | 29 | ||||
171515 | 61499 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 154 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | 7 | Permit Number 21452 | 5989629.6033 | 2114330.31946 | 37.7849497475064 | -122.47963307901 | (37.7849497475064, -122.47963307901) | 11 | 6 | 2 | 55 | 26 | |
183711 | 191687 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6015123.17396 | 2105339.16037 | 37.7617099499859 | -122.390804173874 | (37.7617099499859, -122.390804173874) | 10 | 3 | 8 | 28856 | 29 | |||
184069 | 218344 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 385 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993369.33927 | 2100022.3312 | 37.745880311731 | -122.465655034675 | (37.745880311731, -122.465655034675) | 1 | 8 | 4 | 29491 | 40 | |||
9086 | 19838 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
11577 | 224121 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008290.10508 | 2096093.22608 | 37.7359411906366 | -122.413783055452 | (37.7359411906366, -122.413783055452) | 2 | 7 | 7 | 28859 | 2 | |||
11967 | 19792 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY19 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
17176 | 62603 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 792 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 6 | Permit Number 22911 | 5984491.42084 | 2110500.08946 | 37.7741332293959 | -122.497126446837 | (37.7741332293959, -122.497126446837) | 11 | 6 | 2 | 55 | 26 | |
17475 | 176274 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 775 London St | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6 | 6000713.86512 | 2089358.37648 | 37.7170204575094 | -122.439494437135 | (37.7170204575094, -122.439494437135) | 9 | 7 | 6 | 28861 | 5 | ||||
37110 | 224114 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 6 | 6004687.50549 | 2096549.18122 | 37.736990167061 | -122.42627113673 | (37.736990167061, -122.42627113673) | 2 | 7 | 5 | 63 | 7 | ||||
51320 | 191705 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 Armstrong Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013900.77828 | 2092879.68746 | 37.7274309582526 | -122.394159667654 | (37.7274309582526, -122.394159667654) | 10 | 3 | 8 | 58 | 1 | ||||
74386 | 249863 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 233 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011630.03083 | 2120434.01589 | 37.8029624665125 | -122.403947897788 | (37.8029624665125, -122.403947897788) | 3 | 1 | 10 | 308 | 23 | |||
76419 | 224128 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 18 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999679.40978 | 2101490.53022 | 37.7502735763867 | -122.443941232111 | (37.7502735763867, -122.443941232111) | 2 | 5 | 5 | 63 | 38 | |||
80883 | 191686 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1301 Minnesota St | 14 | Front Yard : Yard | Tree | Private 2 | 6 | 6015385.37717 | 2102357.37277 | 37.7535371423304 | -122.389689042427 | (37.7535371423304, -122.389689042427) | 10 | 3 | 8 | 28856 | 29 | ||||
93520 | 126572 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1001 Vallejo St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6008680.36365 | 2118649.32289 | 37.7978969073709 | -122.414028979559 | (37.7978969073709, -122.414028979559) | 5 | 1 | 10 | 308 | 21 | ||||
118049 | 191688 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800 19th St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6014977.94549 | 2105331.22601 | 37.7616801050661 | -122.39130591015 | (37.7616801050661, -122.39130591015) | 10 | 3 | 8 | 28856 | 29 | |||
121776 | 143060 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 444 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010718.0238 | 2120346.7181 | 37.8026717731778 | -122.407097773383 | (37.8026717731778, -122.407097773383) | 3 | 1 | 10 | 308 | 23 | |||
146526 | 176286 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 901 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5998666.60141 | 2089601.12997 | 37.7175702751322 | -122.446588269645 | (37.7175702751322, -122.446588269645) | 9 | 7 | 6 | 28861 | 25 | |||
153174 | 191704 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 4ft | 6013263.69136 | 2096352.02038 | 37.7369298387513 | -122.396605400918 | (37.7369298387513, -122.396605400918) | 10 | 3 | 8 | 58 | 1 | |||
158130 | 191693 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2212 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012143.16846 | 2101895.7398 | 37.7520892815067 | -122.400868941954 | (37.7520892815067, -122.400868941954) | 10 | 3 | 8 | 28856 | 29 | |||
163446 | 224131 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1340 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009255.1331 | 2101276.97976 | 37.7502287892492 | -122.410812544378 | (37.7502287892492, -122.410812544378) | 2 | 4 | 7 | 28859 | 19 | |||
30972 | 126565 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006864.87455 | 2117678.32819 | 37.795128665521 | -122.420242146478 | (37.795128665521, -122.420242146478) | 13 | 9 | 10 | 28858 | 32 | |||
43478 | 32329 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1884 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 5 | Permit Number 36893 | 5993786.54543 | 2102682.50055 | 37.7532085147622 | -122.464405513896 | (37.7532085147622, -122.464405513896) | 1 | 8 | 4 | 56 | 12 | ||
62136 | 183678 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3623 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5984470.6439 | 2106306.3709 | 37.7626172515097 | -122.496888732826 | (37.7626172515097, -122.496888732826) | 1 | 8 | 3 | 56 | 35 | |||
65564 | 120404 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 527 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5988748.3356 | 2111702.11927 | 37.7776822169597 | -122.482489301184 | (37.7776822169597, -122.482489301184) | 11 | 6 | 2 | 55 | 26 | |||
71542 | 224112 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6004737.84332 | 2096628.18536 | 37.7372099397936 | -122.426102718871 | (37.7372099397936, -122.426102718871) | 2 | 7 | 5 | 63 | 7 | ||||
87091 | 224118 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1525 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009611.07907 | 2100364.72243 | 37.7477438841853 | -122.409517278718 | (37.7477438841853, -122.409517278718) | 2 | 7 | 7 | 28859 | 2 | |||
96190 | 176280 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 600 Blanken Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6013180.81524 | 2086857.67381 | 37.7108556687339 | -122.396226720696 | (37.7108556687339, -122.396226720696) | 10 | 3 | 8 | 309 | 1 | |||
109212 | 176272 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 179 Niagara Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 5999311.03211 | 2089604.94508 | 37.7176175399043 | -122.444361048235 | (37.7176175399043, -122.444361048235) | 9 | 7 | 6 | 28861 | 25 | |||
116467 | 207721 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 228 Montana St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | 9 | 8 | 6 | 28861 | 24 | ||||
116477 | 207719 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 126 Brighton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5996251.42646 | 2090752.11635 | 37.7205923605284 | -122.455019501973 | (37.7205923605284, -122.455019501973) | 9 | 8 | 6 | 28861 | 24 | |||
119596 | 126566 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006877.84584 | 2117681.84008 | 37.7951390391788 | -122.420197513099 | (37.7951390391788, -122.420197513099) | 13 | 9 | 10 | 28858 | 32 | |||
124641 | 248210 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 69 Fair Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007064.668 | 2099422.3589 | 37.7450133544796 | -122.418255851634 | (37.7450133544796, -122.418255851634) | 2 | 7 | 7 | 28859 | 2 | |||
148176 | 176275 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 23 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999165.78727 | 2086612.07538 | 37.7093915094837 | -122.444648098339 | (37.7093915094837, -122.444648098339) | 9 | 7 | 6 | 28861 | 5 | |||
162017 | 224125 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1745 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008033.82801 | 2108179.59599 | 37.7691132329216 | -122.415524547646 | (37.7691132329216, -122.415524547646) | 8 | 4 | 7 | 28853 | 19 | |||
165212 | 207723 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 301 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5991929.88427 | 2090544.15077 | 37.7197724720092 | -122.469942439216 | (37.7197724720092, -122.469942439216) | 9 | 8 | 6 | 64 | 24 | |||
169656 | 57922 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 539 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 5 | Permit Number 16880 | 5999313.15008 | 2086900.51859 | 37.7101919177852 | -122.444159502961 | (37.7101919177852, -122.444159502961) | 9 | 7 | 6 | 28861 | 5 | ||
9830 | 224122 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008272.03754 | 2096094.48518 | 37.7359436331948 | -122.413845611379 | (37.7359436331948, -122.413845611379) | 2 | 7 | 7 | 28859 | 2 | |||
34549 | 191699 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 50 Quint St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 6ft | 6015737.97927 | 2099766.71571 | 37.7464432855229 | -122.388288861864 | (37.7464432855229, -122.388288861864) | 10 | 3 | 8 | 58 | 1 | |||
35044 | 191685 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1301 Minnesota St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | 6015385.02289 | 2102351.05831 | 37.7535197845136 | -122.389689826618 | (37.7535197845136, -122.389689826618) | 10 | 3 | 8 | 28856 | 29 | ||||
35709 | 176284 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 251 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 5993742.60383 | 2086796.45358 | 37.7095868089467 | -122.463404735741 | (37.7095868089467, -122.463404735741) | 9 | 8 | 6 | 28861 | 25 | |||
75825 | 126568 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2745 Larkin St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006520.94056 | 2120654.06544 | 37.8032799020007 | -122.421643667929 | (37.8032799020007, -122.421643667929) | 5 | 9 | 1 | 28858 | 32 | ||||
84688 | 224113 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 69 | Front Yard : Yard | Tree | Private 2 | 4 | 6004690.02185 | 2096554.43933 | 37.7370047468799 | -122.426262810788 | (37.7370047468799, -122.426262810788) | 2 | 7 | 5 | 63 | 7 | ||||
87106 | 191695 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 950x Kansas St | 4 | Median : Yard | Tree | DPW 1 | 4 | 6011603.94241 | 2103847.92507 | 37.7574194607598 | -122.402870964129 | (37.7574194607598, -122.402870964129) | 10 | 3 | 8 | 28856 | 29 | ||||
89041 | 224124 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008668.58024 | 2101297.73586 | 37.7502528748804 | -122.412842355611 | (37.7502528748804, -122.412842355611) | 2 | 4 | 7 | 28859 | 19 | |||
89861 | 224111 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004733.53405 | 2096634.51546 | 37.7372270772601 | -122.426118068508 | (37.7372270772601, -122.426118068508) | 2 | 7 | 5 | 63 | 7 | ||||
113035 | 176287 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1565 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006970.59339 | 2091697.77071 | 37.723798037137 | -122.418033639041 | (37.723798037137, -122.418033639041) | 9 | 7 | 7 | 309 | 28 | |||
126650 | 247967 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 16 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6010333.49571 | 2098927.49611 | 37.7438380268983 | -122.40691790615 | (37.7438380268983, -122.40691790615) | 2 | 7 | 7 | 28859 | 2 | ||||
154126 | 183573 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2587 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988295.3826 | 2097727.4025 | 37.7392850696685 | -122.483031684036 | (37.7392850696685, -122.483031684036) | 1 | 8 | 3 | 29491 | 35 | |||
167227 | 207733 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 500 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998757.70005 | 2094996.74516 | 37.7323905826432 | -122.446661380942 | (37.7323905826432, -122.446661380942) | 9 | 7 | 4 | 59 | 40 | ||||
180879 | 207727 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 378 Victoria St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993265.77465 | 2089711.08498 | 37.717562206406 | -122.465264296326 | (37.717562206406, -122.465264296326) | 9 | 8 | 6 | 64 | 24 | |||
188891 | 111509 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800x BOSWORTH ST | 4 | Front Yard : Yard | Tree | DPW 1 | 4 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
58793 | 18564 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700X Quesada Ave | 19 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014511.59225 | 2095170.64304 | 37.7337553901961 | -122.392208220649 | (37.7337553901961, -122.392208220649) | 10 | 3 | 8 | 58 | 1 | |||
90526 | 7445 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2548 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008209.4393 | 2103591.66563 | 37.7565257046152 | -122.414592409312 | (37.7565257046152, -122.414592409312) | 2 | 4 | 7 | 28859 | 19 | |||
9092 | 207725 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 380 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992234.50872 | 2090438.58266 | 37.7195002121526 | -122.468881791362 | (37.7195002121526, -122.468881791362) | 9 | 8 | 6 | 64 | 24 | |||
9550 | 20003 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY46 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
9946 | 247879 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 8 | Side Yard : Yard | Tree | Private 2 | 3 | 6009924.14803 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) | 10 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );