trees
332 rows where qSpecies_id = 121 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193731 | 192258 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009238.32682 | 2108428.66995 | 37.7698647621884 | -122.411375838327 | (37.7698647621884, -122.411375838327) | 8 | 2 | 9 | 28853 | 34 | |||
193605 | 192254 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009288.06087 | 2108377.07949 | 37.7697258960749 | -122.411200163874 | (37.7697258960749, -122.411200163874) | 8 | 2 | 9 | 28853 | 34 | |||
193366 | 33475 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432 | 2098629 | 37.7427993369958 | -122.420387207052 | (37.7427993369958, -122.420387207052) | 2 | 7 | 7 | 28859 | 2 | ||
192001 | 192232 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009598.46663 | 2108528.55316 | 37.7701592110077 | -122.410137170609 | (37.7701592110077, -122.410137170609) | 8 | 2 | 9 | 28853 | 34 | |||
191589 | 192290 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009249.88348 | 2108971.40543 | 37.7713556357827 | -122.411374211455 | (37.7713556357827, -122.411374211455) | 8 | 2 | 9 | 28853 | 34 | |||
190745 | 225802 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 372 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001775.08554 | 2103686.11524 | 37.7564214471208 | -122.436851418666 | (37.7564214471208, -122.436851418666) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
190161 | 252991 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005528 | 2099293 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | 2 | 7 | 5 | 28859 | 22 | ||||
188185 | 51033 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.45041 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | 9 | 7 | 6 | 28861 | 5 | ||
188068 | 225380 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3200 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008095.36431 | 2100612.74929 | 37.7483398640139 | -122.414776107534 | (37.7483398640139, -122.414776107534) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
186776 | 33478 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
184710 | 225815 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 6001846.90883 | 2108236.07795 | 37.768918616038 | -122.436928749563 | (37.768918616038, -122.436928749563) | 15 | 5 | 5 | 29492 | 3 | |||
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 | |||
184049 | 45643 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.405311739446 | (37.797501231757, -122.405311739446) | 3 | 1 | 10 | 308 | 23 | ||
182488 | 192333 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007912.34938 | 2110528.44514 | 37.7755557890086 | -122.416111106161 | (37.7755557890086, -122.416111106161) | 8 | 2 | 9 | 28853 | 34 | |||
182398 | 244215 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | 15 | 5 | 11 | 29492 | 9 | |||
182350 | 192222 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009520.50113 | 2108752.11009 | 37.7707686761527 | -122.410422641486 | (37.7707686761527, -122.410422641486) | 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 | |||
181729 | 218974 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5995324.88397 | 2091369.23318 | 37.7222336187729 | -122.458266889107 | (37.7222336187729, -122.458266889107) | 9 | 8 | 4 | 28861 | 24 | |||
180942 | 33477 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
179954 | 192318 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011708.94846 | 2107685.56864 | 37.7679626349073 | -122.402777697245 | (37.7679626349073, -122.402777697245) | 8 | 2 | 8 | 28853 | 20 | |||
179894 | 192217 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009459.54264 | 2108818.21129 | 37.7709467572235 | -122.410638167623 | (37.7709467572235, -122.410638167623) | 8 | 2 | 9 | 28853 | 34 | |||
179230 | 192340 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007835.15686 | 2110517.07341 | 37.7755202244095 | -122.416377328869 | (37.7755202244095, -122.416377328869) | 8 | 2 | 9 | 28853 | 34 | |||
178750 | 192305 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.7630615959319 | -122.40882459747 | (37.7630615959319, -122.40882459747) | 8 | 4 | 8 | 28859 | 19 | |||
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 | |||
178081 | 192291 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009258.26702 | 2108978.96062 | 37.77137685078 | -122.41134574611 | (37.77137685078, -122.41134574611) | 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 | |||
177007 | 192344 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007890.6883 | 2110458.72798 | 37.7753631443241 | -122.416181098592 | (37.7753631443241, -122.416181098592) | 8 | 2 | 9 | 28853 | 34 | |||
176861 | 225808 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 67 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6003135.12439 | 2107389.88672 | 37.766668315309 | -122.432412455892 | (37.766668315309, -122.432412455892) | 15 | 5 | 5 | 28862 | 3 | |||
175898 | 192288 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009225.94574 | 2108950.58791 | 37.7712971330939 | -122.411455542555 | (37.7712971330939, -122.411455542555) | 8 | 2 | 9 | 28853 | 34 | |||
175702 | 192274 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.7707635329468 | -122.412138720645 | (37.7707635329468, -122.412138720645) | 8 | 2 | 9 | 28853 | 34 | |||
175112 | 192331 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007941.72194 | 2110498.34035 | 37.7754747798714 | -122.416007366674 | (37.7754747798714, -122.416007366674) | 8 | 2 | 9 | 28853 | 34 | |||
174707 | 192296 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.7623960949381 | -122.406134800806 | (37.7623960949381, -122.406134800806) | 8 | 4 | 8 | 28859 | 19 | |||
174490 | 225781 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3271 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007691.06747 | 2105574.75784 | 37.7619416827748 | -122.416525598274 | (37.7619416827748, -122.416525598274) | 2 | 4 | 7 | 28859 | 19 | |||
171708 | 56058 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49940 | 6009112.81160157 | 2103362.97509043 | 37.7559484836074 | -122.411452058073 | (37.7559484836074, -122.411452058073) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
171528 | 120475 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2153 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5988722.30623 | 2114650.77246 | 37.7857768742694 | -122.482795491067 | (37.7857768742694, -122.482795491067) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
169616 | 192238 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009506.6298 | 2108441.21994 | 37.7699142662622 | -122.410448666999 | (37.7699142662622, -122.410448666999) | 8 | 2 | 9 | 28853 | 34 | |||
169573 | 192237 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009520.06866 | 2108454.52562 | 37.7699515539505 | -122.410403121719 | (37.7699515539505, -122.410403121719) | 8 | 2 | 9 | 28853 | 34 | |||
169276 | 192335 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007868.48614 | 2110574.31829 | 37.7756792794093 | -122.416266089906 | (37.7756792794093, -122.416266089906) | 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 | |||
167486 | 192244 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009411.93836 | 2108352.3057 | 37.7696648195127 | -122.410769923705 | (37.7696648195127, -122.410769923705) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
165702 | 192210 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009362.83863 | 2108918.5244 | 37.7712167714597 | -122.410979757131 | (37.7712167714597, -122.410979757131) | 8 | 2 | 9 | 28853 | 34 | |||
165605 | 192342 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007873.4377 | 2110478.31059 | 37.7754159435306 | -122.416242159861 | (37.7754159435306, -122.416242159861) | 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 | |||
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 | |||
164502 | 30523 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | 7 | 10 | 9 | 28852 | 36 | |
163051 | 128817 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 215 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008554.10037 | 2112777.08556 | 37.7817660825767 | -122.414050241334 | (37.7817660825767, -122.414050241334) | 7 | 10 | 9 | 28852 | 36 | |||
162965 | 192292 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009264.77057 | 2108986.55422 | 37.7713980657949 | -122.411323786465 | (37.7713980657949, -122.411323786465) | 8 | 2 | 9 | 28853 | 34 | |||
162930 | 192247 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009385.61181 | 2108329.66334 | 37.7696011726904 | -122.410859387372 | (37.7696011726904, -122.410859387372) | 8 | 2 | 9 | 28853 | 34 | |||
162422 | 115825 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998362 | 2109233 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | 15 | 5 | 11 | 29492 | 9 | ||||
161506 | 33474 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
161016 | 192278 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009081.35576 | 2108813.05858 | 37.7709113985732 | -122.411945967131 | (37.7709113985732, -122.411945967131) | 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 | |||
160093 | 192299 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011852.11136 | 2102354.12957 | 37.7533316805221 | -122.401907686797 | (37.7533316805221, -122.401907686797) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
159728 | 225788 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4436 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001105.5651 | 2101159.8137 | 37.7494467567732 | -122.43898580666 | (37.7494467567732, -122.43898580666) | 2 | 4 | 5 | 28862 | 22 | |||
159309 | 128827 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1048 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011178.99904 | 2118580.19305 | 37.7978471119154 | -122.405378078855 | (37.7978471119154, -122.405378078855) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||
159188 | 68672 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
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 | |||
158683 | 2680 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2085 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2015 12:00:00 AM | 19 | 3X3 | 6003616.3325 | 2114868.6836 | 37.7872305155325 | -122.43128194219 | (37.7872305155325, -122.43128194219) | 13 | 9 | 11 | 29490 | 27 | ||
158671 | 225809 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002900.20105 | 2107141.3628 | 37.7659726051812 | -122.433207255136 | (37.7659726051812, -122.433207255136) | 15 | 5 | 5 | 28862 | 3 | |||
158413 | 45645 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.47957 | 2118401.58307 | 37.7973579490636 | -122.40528770509 | (37.7973579490636, -122.40528770509) | 3 | 1 | 10 | 308 | 23 | ||
158333 | 192295 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6010700.61238 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | 8 | 4 | 8 | 28859 | 19 | |||
158018 | 192355 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 2 | : | Tree | Private 2 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.396233670642 | (37.7375943028269, -122.396233670642) | 10 | 3 | 8 | 58 | 1 | |||
157708 | 23281 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 843X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006558.15172 | 2113495.8441 | 37.7836273122865 | -122.421006348959 | (37.7836273122865, -122.421006348959) | 7 | 9 | 9 | 28858 | 36 | |||
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 | |||
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 | |||
156867 | 14546 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 815 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.7736546990505 | -122.44626515618 | (37.7736546990505, -122.44626515618) | 15 | 5 | 11 | 29492 | 16 | |||
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 | |||
156488 | 59101 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 654 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18403 | 5993502.53489 | 2111016.0685 | 37.7760739276641 | -122.465993175595 | (37.7760739276641, -122.465993175595) | 11 | 6 | 2 | 54 | 11 | ||
156453 | 192294 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) | 8 | 4 | 8 | 28859 | 19 | |||
156154 | 192341 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007845.73397 | 2110504.26388 | 37.7754856472738 | -122.416339832511 | (37.7754856472738, -122.416339832511) | 8 | 2 | 9 | 28853 | 34 | |||
155664 | 192337 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 59 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007660.20523 | 2110795.54136 | 37.7762749912264 | -122.417002265066 | (37.7762749912264, -122.417002265066) | 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 | |||
154444 | 128809 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | 13 | 9 | 1 | 57 | 27 | |||
154257 | 192306 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3600 03rd St | 4 | : | Tree | Private 2 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.7439501813693 | -122.387678797737 | (37.7439501813693, -122.387678797737) | 10 | 3 | 8 | 58 | 1 | |||
154127 | 16624 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 143 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6002878.48419 | 2107471.64141 | 37.7668782377669 | -122.4333059719 | (37.7668782377669, -122.4333059719) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
152221 | 120476 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2153 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5988709.31254 | 2114650.77812 | 37.7857761337969 | -122.482840445446 | (37.7857761337969, -122.482840445446) | 11 | 6 | 2 | 55 | 26 | |||
152013 | 192257 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009251.00501 | 2108416.23569 | 37.7698313316731 | -122.411331106053 | (37.7698313316731, -122.411331106053) | 8 | 2 | 9 | 28853 | 34 | |||
151521 | 192354 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6013388.36583 | 2096606.99697 | 37.7376368893361 | -122.39619220742 | (37.7376368893361, -122.39619220742) | 10 | 3 | 8 | 58 | 1 | |||
150760 | 116066 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 40 MALTA DR | Median : Cutout | Tree | DPW 1 | 10 | 5999623 | 2096071 | 37.7353896244756 | -122.443746996044 | (37.7353896244756, -122.443746996044) | 9 | 7 | 4 | 63 | 40 | |||||
150506 | 192308 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011941.9905 | 2107419.77079 | 37.7672458230764 | -122.401952938871 | (37.7672458230764, -122.401952938871) | 8 | 3 | 8 | 28853 | 20 | |||
149903 | 23269 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 843X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006584.63661 | 2113380.90993 | 37.7833132240722 | -122.420906558402 | (37.7833132240722, -122.420906558402) | 7 | 9 | 9 | 28858 | 36 | |||
149251 | 192261 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009200.74359 | 2108465.02744 | 37.7699624834008 | -122.41150840741 | (37.7699624834008, -122.41150840741) | 8 | 2 | 9 | 28853 | 34 | |||
148986 | 2681 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | 13 | 9 | 11 | 29490 | 27 | ||
147637 | 192209 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009355.45651 | 2108925.4652 | 37.7712354153226 | -122.411005782604 | (37.7712354153226, -122.411005782604) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
145418 | 33476 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
144420 | 192334 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007885.81479 | 2110555.97346 | 37.7756298832558 | -122.416204846094 | (37.7756298832558, -122.416204846094) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );