trees
332 rows where qSpecies_id = 121 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19419 | 75860 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.403375665477 | (37.7983698131588, -122.403375665477) | 3 | 1 | 10 | 308 | 23 | |||
81705 | 128826 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 600 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6011941.77038 | 2115192.79079 | 37.7885887308418 | -122.40250034183 | (37.7885887308418, -122.40250034183) | 4 | 2 | 10 | 28854 | 6 | |||
90851 | 225381 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1643 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006512.20492 | 2107283.08365 | 37.7665659760752 | -122.42072411023 | (37.7665659760752, -122.42072411023) | 8 | 4 | 7 | 28853 | 19 | |||
95732 | 218966 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 255 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992657.85366 | 2095112.02317 | 37.7323567798226 | -122.467758171218 | (37.7323567798226, -122.467758171218) | 9 | 8 | 4 | 59 | 40 | |||
99226 | 192267 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009086.59307 | 2108586.06933 | 37.7702884327847 | -122.41191180819 | (37.7702884327847, -122.41191180819) | 8 | 2 | 9 | 28853 | 34 | |||
112757 | 128823 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 600 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6012017.65592 | 2115254.86265 | 37.7887634016623 | -122.402242153673 | (37.7887634016623, -122.402242153673) | 4 | 2 | 10 | 28854 | 6 | |||
118187 | 83898 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 661 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50511 | 6001665.34461 | 2093208.93849 | 37.7276473387373 | -122.436481078764 | (37.7276473387373, -122.436481078764) | 9 | 7 | 6 | 28861 | 25 | |
122216 | 225796 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008035.82851 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | 2 | 4 | 7 | 28859 | 19 | |||
142928 | 192253 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009298.19676 | 2108366.80418 | 37.7696982508936 | -122.411164378061 | (37.7696982508936, -122.411164378061) | 8 | 2 | 9 | 28853 | 34 | |||
170226 | 192260 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009216.21335 | 2108451.13104 | 37.7699251948176 | -122.411453915683 | (37.7699251948176, -122.411453915683) | 8 | 2 | 9 | 28853 | 34 | |||
182206 | 192297 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010694.42792 | 2105749.21353 | 37.7625891451824 | -122.406150390541 | (37.7625891451824, -122.406150390541) | 8 | 4 | 8 | 28859 | 19 | |||
184103 | 192246 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009392.32174 | 2108335.84797 | 37.7696185304883 | -122.410836614725 | (37.7696185304883, -122.410836614725) | 8 | 2 | 9 | 28853 | 34 | |||
3372 | 218976 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.7324476131567 | -122.440070159711 | (37.7324476131567, -122.440070159711) | 9 | 7 | 5 | 63 | 40 | |||
25433 | 192235 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009557.26279 | 2108491.22918 | 37.7700544184084 | -122.410277059238 | (37.7700544184084, -122.410277059238) | 8 | 2 | 9 | 28853 | 34 | |||
30062 | 225797 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008067.53952 | 2103885.77224 | 37.7573252810462 | -122.415103967973 | (37.7573252810462, -122.415103967973) | 2 | 4 | 7 | 28859 | 19 | |||
42273 | 128812 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008015.3478 | 2113733.84894 | 37.7843628498196 | -122.415981852889 | (37.7843628498196, -122.415981852889) | 7 | 10 | 9 | 28858 | 36 | |||
47320 | 192323 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011703.78174 | 2107812.61007 | 37.7683111734485 | -122.402804504224 | (37.7683111734485, -122.402804504224) | 8 | 2 | 8 | 28853 | 20 | |||
57736 | 192221 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009500.9778 | 2108774.75194 | 37.7708297509354 | -122.410491772396 | (37.7708297509354, -122.410491772396) | 8 | 2 | 9 | 28853 | 34 | |||
65001 | 192239 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009494.20262 | 2108431.40539 | 37.7698866211063 | -122.410490959396 | (37.7698866211063, -122.410490959396) | 8 | 2 | 9 | 28853 | 34 | |||
69577 | 225386 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.7515688798154 | -122.426364089745 | (37.7515688798154, -122.426364089745) | 2 | 4 | 5 | 28862 | 22 | |||
75554 | 192301 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011807.32161 | 2102351.9134 | 37.7533230956061 | -122.402062424168 | (37.7533230956061, -122.402062424168) | 10 | 3 | 8 | 28856 | 29 | |||
98196 | 192219 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009481.18587 | 2108795.76031 | 37.7708863254615 | -122.410561717149 | (37.7708863254615, -122.410561717149) | 8 | 2 | 9 | 28853 | 34 | |||
116023 | 109481 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011927.99782 | 2118783.50855 | 37.7984472160146 | -122.402800624568 | (37.7984472160146, -122.402800624568) | 3 | 1 | 10 | 308 | 23 | |||
126526 | 192271 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009005.79575 | 2108670.84067 | 37.7705166618411 | -122.412197279106 | (37.7705166618411, -122.412197279106) | 8 | 2 | 9 | 28853 | 34 | |||
129094 | 192224 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009548.42342 | 2108726.25306 | 37.7706992440089 | -122.410324231382 | (37.7706992440089, -122.410324231382) | 8 | 2 | 9 | 28853 | 34 | |||
132688 | 192201 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 326 10th St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6008912.07141 | 2109388.51463 | 37.7724819673877 | -122.412572213639 | (37.7724819673877, -122.412572213639) | 8 | 2 | 9 | 28853 | 34 | |||
143197 | 192282 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009136.75178 | 2108866.01281 | 37.7710599063301 | -122.411758092481 | (37.7710599063301, -122.411758092481) | 8 | 2 | 9 | 28853 | 34 | |||
157266 | 225795 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3000X 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008004.64414 | 2103879.46579 | 37.7573044302625 | -122.415321039155 | (37.7573044302625, -122.415321039155) | 2 | 4 | 7 | 28859 | 19 | |||
159995 | 192264 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009152.13248 | 2108514.01976 | 37.7700942781534 | -122.411680015143 | (37.7700942781534, -122.411680015143) | 8 | 2 | 9 | 28853 | 34 | |||
1120 | 57868 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1977 12:00:00 AM | 7 | Permit Number 16812 | 6008032.73051 | 2113659.88131 | 37.7841607298832 | -122.415916474888 | (37.7841607298832, -122.415916474888) | 7 | 10 | 9 | 28858 | 36 | |
13105 | 75815 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011743.63854 | 2118757.50225 | 37.7983655135139 | -122.403436737532 | (37.7983655135139, -122.403436737532) | 3 | 1 | 10 | 308 | 23 | |||
21105 | 192200 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 326 10th St | 0 | : | Tree | Private 2 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808589 | (37.7725617219648, -122.41268808589) | 8 | 2 | 9 | 28853 | 34 | |||
22122 | 128808 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001383.33039 | 2116587.25055 | 37.7918224564007 | -122.439130852904 | (37.7918224564007, -122.439130852904) | 13 | 6 | 1 | 29490 | 27 | |||
23414 | 192211 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009388.56894 | 2108888.96567 | 37.7711370528685 | -122.410888666597 | (37.7711370528685, -122.410888666597) | 8 | 2 | 9 | 28853 | 34 | |||
29361 | 192269 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009063.69289 | 2108616.03922 | 37.7703694383326 | -122.411993138384 | (37.7703694383326, -122.411993138384) | 8 | 2 | 9 | 28853 | 34 | |||
34528 | 192263 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009170.52832 | 2108493.74189 | 37.7700396317537 | -122.411614950978 | (37.7700396317537, -122.411614950978) | 8 | 2 | 9 | 28853 | 34 | |||
35717 | 192245 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009401.17079 | 2108343.15985 | 37.7696391033908 | -122.410806522516 | (37.7696391033908, -122.410806522516) | 8 | 2 | 9 | 28853 | 34 | |||
44475 | 192298 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011908.73866 | 2102359.42769 | 37.7533493881837 | -122.401712229047 | (37.7533493881837, -122.401712229047) | 10 | 3 | 8 | 28856 | 29 | |||
47020 | 192203 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009293.32816 | 2108991.82453 | 37.7714141384687 | -122.411225376349 | (37.7714141384687, -122.411225376349) | 8 | 2 | 9 | 28853 | 34 | |||
61981 | 225382 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.7615997596391 | -122.424263576509 | (37.7615997596391, -122.424263576509) | 8 | 4 | 5 | 28859 | 19 | |||
93967 | 225389 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 811 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998617.86055 | 2107510.18613 | 37.7667414427907 | -122.448045492407 | (37.7667414427907, -122.448045492407) | 15 | 5 | 11 | 29492 | 9 | |||
105313 | 192304 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2599 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009910.49486 | 2105936.61453 | 37.7630598260768 | -122.40887496583 | (37.7630598260768, -122.40887496583) | 8 | 4 | 8 | 28859 | 19 | |||
106025 | 109474 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012029.14391 | 2118799.20085 | 37.7984959502925 | -122.402451729872 | (37.7984959502925, -122.402451729872) | 3 | 1 | 10 | 308 | 23 | |||
112762 | 109478 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011984.93585 | 2118790.70315 | 37.7984701496397 | -122.402604106489 | (37.7984701496397, -122.402604106489) | 3 | 1 | 10 | 308 | 23 | |||
117180 | 225799 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3965 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004086.71679 | 2101282.70984 | 37.7499533700549 | -122.428685663533 | (37.7499533700549, -122.428685663533) | 2 | 4 | 5 | 28862 | 22 | |||
119989 | 128825 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 600 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011989.53481 | 2115248.11567 | 37.7887433063148 | -122.402338974684 | (37.7887433063148, -122.402338974684) | 4 | 2 | 10 | 28854 | 6 | |||
120062 | 192266 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009132.08177 | 2108533.86309 | 37.7701476385359 | -122.411750772897 | (37.7701476385359, -122.411750772897) | 8 | 2 | 9 | 28853 | 34 | |||
122169 | 248136 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 226 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010037.88024 | 2099520.31318 | 37.7454492271162 | -122.407981876971 | (37.7454492271162, -122.407981876971) | 2 | 7 | 7 | 28859 | 2 | |||
143617 | 192228 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009630.58485 | 2108639.11434 | 37.770464586603 | -122.410033879882 | (37.770464586603, -122.410033879882) | 8 | 2 | 9 | 28853 | 34 | |||
164598 | 225792 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3291 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007807.81913 | 2105426.09185 | 37.7615400455603 | -122.416111269835 | (37.7615400455603, -122.416111269835) | 2 | 4 | 7 | 28859 | 19 | |||
166785 | 218973 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 550 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5997760.19795 | 2094413.18303 | 37.7307312291661 | -122.450067916609 | (37.7307312291661, -122.450067916609) | 9 | 7 | 4 | 59 | 40 | |||
171666 | 192199 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 326 10th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008867.1222 | 2109432.51416 | 37.7726002570339 | -122.412730809104 | (37.7726002570339, -122.412730809104) | 8 | 2 | 9 | 28853 | 34 | |||
178696 | 192198 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 313 10th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008924.99319 | 2109468.55838 | 37.7727024739698 | -122.412533174959 | (37.7727024739698, -122.412533174959) | 8 | 2 | 9 | 28853 | 34 | |||
190525 | 192265 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009141.52204 | 2108524.0703 | 37.7701212793892 | -122.411717426925 | (37.7701212793892, -122.411717426925) | 8 | 2 | 9 | 28853 | 34 | |||
5203 | 192229 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009648.37032 | 2108577.40653 | 37.7702961480689 | -122.409968002743 | (37.7702961480689, -122.409968002743) | 8 | 2 | 9 | 28853 | 34 | |||
6269 | 192348 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 170 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008297.90047 | 2110029.55008 | 37.774207611721 | -122.414742072711 | (37.774207611721, -122.414742072711) | 8 | 2 | 9 | 28853 | 34 | |||
12339 | 29010 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 113 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008095.19014 | 2110335.08748 | 37.7750351534761 | -122.415464921674 | (37.7750351534761, -122.415464921674) | 8 | 2 | 9 | 28853 | 34 | ||
16299 | 192212 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009404.47018 | 2108873.18774 | 37.7710946219563 | -122.410832548904 | (37.7710946219563, -122.410832548904) | 8 | 2 | 9 | 28853 | 34 | |||
23260 | 218969 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.7503932752257 | -122.464965376055 | (37.7503932752257, -122.464965376055) | 1 | 8 | 4 | 29491 | 40 | |||
27677 | 192259 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009225.68237 | 2108442.74281 | 37.7699026937941 | -122.411420569714 | (37.7699026937941, -122.411420569714) | 8 | 2 | 9 | 28853 | 34 | |||
29516 | 192234 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009571.19084 | 2108505.46163 | 37.7700942781462 | -122.410229887119 | (37.7700942781462, -122.410229887119) | 8 | 2 | 9 | 28853 | 34 | |||
38697 | 29008 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 123 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008118.46736 | 2110307.2661 | 37.7749600708805 | -122.415382430453 | (37.7749600708805, -122.415382430453) | 8 | 2 | 9 | 28853 | 34 | ||
40347 | 120307 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988691.32321 | 2114547.33744 | 37.7854910683194 | -122.482895098939 | (37.7854910683194, -122.482895098939) | 11 | 6 | 2 | 55 | 26 | |||
48385 | 192214 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009421.09589 | 2108858.33176 | 37.7710547630982 | -122.41077399042 | (37.7710547630982, -122.41077399042) | 8 | 2 | 9 | 28853 | 34 | |||
65660 | 192328 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 237 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008484.68025 | 2109928.45568 | 37.7739405229657 | -122.414088812365 | (37.7739405229657, -122.414088812365) | 8 | 2 | 9 | 28853 | 34 | |||
69237 | 29004 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 151 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008239.15145 | 2110183.90276 | 37.7746281266267 | -122.414956223744 | (37.7746281266267, -122.414956223744) | 8 | 2 | 9 | 28853 | 34 | ||
75640 | 29006 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 135 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008170.1889 | 2110256.9147 | 37.7748247247234 | -122.415199949027 | (37.7748247247234, -122.415199949027) | 8 | 2 | 9 | 28853 | 34 | ||
75720 | 192248 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009375.77946 | 2108320.26422 | 37.7695748135605 | -122.410892733326 | (37.7695748135605, -122.410892733326) | 8 | 2 | 9 | 28853 | 34 | |||
83193 | 225794 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3291 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007798.59434 | 2105543.95905 | 37.7618631629681 | -122.416151522586 | (37.7618631629681, -122.416151522586) | 2 | 4 | 7 | 28859 | 19 | |||
83713 | 109479 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011964.26444 | 2118788.1652 | 37.7984620269439 | -122.402675457803 | (37.7984620269439, -122.402675457803) | 3 | 1 | 10 | 308 | 23 | |||
99276 | 120304 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988688.31832 | 2114612.78374 | 37.7856705904605 | -122.482910293069 | (37.7856705904605, -122.482910293069) | 11 | 6 | 2 | 55 | 26 | |||
100088 | 192252 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009308.54371 | 2108355.35398 | 37.7696673915621 | -122.411127779219 | (37.7696673915621, -122.411127779219) | 8 | 2 | 9 | 28853 | 34 | |||
104301 | 192223 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009532.03276 | 2108741.10416 | 37.77073910287 | -122.410381975954 | (37.77073910287, -122.410381975954) | 8 | 2 | 9 | 28853 | 34 | |||
105541 | 29018 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 128 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008069.48566 | 2110276.86185 | 37.774873834897 | -122.41554971607 | (37.774873834897, -122.41554971607) | 8 | 2 | 9 | 28853 | 34 | ||
107795 | 187490 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6006575.29647 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | 9 | 7 | 8 | 309 | 39 | ||||
111034 | 29034 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 358 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009078.53506 | 2109215.83285 | 37.7720171644901 | -122.411984191933 | (37.7720171644901, -122.411984191933) | 8 | 2 | 9 | 28853 | 34 | ||
123217 | 225791 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 920 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999226.76064 | 2106974.09226 | 37.765304251518 | -122.445900856638 | (37.765304251518, -122.445900856638) | 15 | 5 | 5 | 29492 | 9 | |||
143205 | 120306 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | 11 | 6 | 2 | 55 | 26 | |||
156846 | 192241 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009464.70125 | 2108402.97416 | 37.7698069016093 | -122.410590996386 | (37.7698069016093, -122.410590996386) | 8 | 2 | 9 | 28853 | 34 | |||
157447 | 225786 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 94 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005786.79673 | 2103464.50998 | 37.7560401588409 | -122.422961744009 | (37.7560401588409, -122.422961744009) | 2 | 4 | 5 | 28859 | 19 | |||
158780 | 192226 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009587.30245 | 2108684.25048 | 37.7705860940019 | -122.410186781721 | (37.7705860940019, -122.410186781721) | 8 | 2 | 9 | 28853 | 34 | |||
159131 | 225790 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 920 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999222.99784 | 2106999.85397 | 37.7653747718527 | -122.445915724224 | (37.7653747718527, -122.445915724224) | 15 | 5 | 5 | 29492 | 9 | |||
159204 | 29033 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009042.97746 | 2109247.69972 | 37.772102668444 | -122.412109441391 | (37.772102668444, -122.412109441391) | 8 | 2 | 9 | 28853 | 34 | ||
160377 | 192286 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009200.74698 | 2108925.5815 | 37.7712270578992 | -122.411540939462 | (37.7712270578992, -122.411540939462) | 8 | 2 | 9 | 28853 | 34 | |||
167897 | 192236 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009533.94871 | 2108466.41752 | 37.7699849844405 | -122.410355950479 | (37.7699849844405, -122.410355950479) | 8 | 2 | 9 | 28853 | 34 | |||
178063 | 192231 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009620.79732 | 2108551.27729 | 37.7702228578355 | -122.410061533137 | (37.7702228578355, -122.410061533137) | 8 | 2 | 9 | 28853 | 34 | |||
187332 | 192279 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009094.04176 | 2108824.03792 | 37.7709422570085 | -122.411902861747 | (37.7709422570085, -122.411902861747) | 8 | 2 | 9 | 28853 | 34 | |||
32745 | 192256 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009265.04555 | 2108401.4321 | 37.7697914719171 | -122.41128149407 | (37.7697914719171, -122.41128149407) | 8 | 2 | 9 | 28853 | 34 | |||
82145 | 192347 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 134 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.05736 | 2110213.22091 | 37.7747021030553 | -122.415359893447 | (37.7747021030553, -122.415359893447) | 8 | 2 | 9 | 28853 | 34 | |||
82641 | 64058 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3700 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1987 12:00:00 AM | 5 | Permit Number 24817 | 5987163.87734 | 2111884.56933 | 37.7780908722437 | -122.487983819675 | (37.7780908722437, -122.487983819675) | 11 | 6 | 2 | 55 | 26 | ||
92827 | 225782 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3271 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007716.52666 | 2105576.00343 | 37.761946534627 | -122.416437632899 | (37.761946534627, -122.416437632899) | 2 | 4 | 7 | 28859 | 19 | |||
113940 | 225785 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 96 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005776.35688 | 2103464.45432 | 37.7560394169139 | -122.422997844584 | (37.7560394169139, -122.422997844584) | 2 | 4 | 5 | 28859 | 19 | |||
115188 | 192202 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 10th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009124.54034 | 2109165.9585 | 37.7718828021889 | -122.411821530666 | (37.7718828021889, -122.411821530666) | 8 | 2 | 9 | 28853 | 34 | |||
120094 | 120305 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988689.97406 | 2114597.66035 | 37.7856291622608 | -122.482903455976 | (37.7856291622608, -122.482903455976) | 11 | 6 | 2 | 55 | 26 | |||
130918 | 225784 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005770.92499 | 2103464.55154 | 37.7560393773435 | -122.423016636805 | (37.7560393773435, -122.423016636805) | 2 | 4 | 5 | 28859 | 19 | |||
139978 | 225793 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3291 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007803.17898 | 2105505.53039 | 37.7617579045332 | -122.416132944404 | (37.7617579045332, -122.416132944404) | 2 | 4 | 7 | 28859 | 19 | |||
147416 | 192242 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009444.52854 | 2108382.31309 | 37.7697490401119 | -122.410659314273 | (37.7697490401119, -122.410659314273) | 8 | 2 | 9 | 28853 | 34 | |||
154010 | 192243 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009432.09679 | 2108372.2648 | 37.7697207528275 | -122.410701605796 | (37.7697207528275, -122.410701605796) | 8 | 2 | 9 | 28853 | 34 | |||
154855 | 192197 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 315 10th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6008969.56374 | 2109417.5428 | 37.77256489838 | -122.412375393416 | (37.77256489838, -122.412375393416) | 8 | 2 | 9 | 28853 | 34 | |||
164524 | 225787 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 46 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004400.60318 | 2095343.96322 | 37.7336646890731 | -122.42717726484 | (37.7336646890731, -122.42717726484) | 2 | 7 | 5 | 28861 | 25 |
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) );