trees
195 rows where qSpecies_id = 98 sorted by Latitude descending
This data as json, CSV (advanced)
PlantDate ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63862 | 102614 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 394 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009930 | 2120930 | 37.8042291902539 | -122.40986594338 | (37.8042291902539, -122.40986594338) | 3 | 1 | 10 | 308 | 23 | ||||
4869 | 102616 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 2000X Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009928.4 | 2120915.8 | 37.8041901109125 | -122.409870477339 | (37.8041901109125, -122.409870477339) | 3 | 1 | 10 | 308 | 23 | |||
189477 | 102617 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 2000X Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009928.4 | 2120915.8 | 37.8041901109125 | -122.409870477339 | (37.8041901109125, -122.409870477339) | 3 | 1 | 10 | 308 | 23 | |||
142281 | 52687 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1616@ BROADWAY Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 4 | Permit Number 48757 | 6008814.72629 | 2118460.06333 | 37.7973847929389 | -122.413550652656 | (37.7973847929389, -122.413550652656) | 3 | 1 | 10 | 308 | 21 | ||
169112 | 52686 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1616@ BROADWAY Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/30/2006 12:00:00 AM | 4 | Permit Number 48757 | 6008816.33221 | 2118445.30792 | 37.7973443684023 | -122.41354405161 | (37.7973443684023, -122.41354405161) | 3 | 1 | 10 | 308 | 21 | |
12264 | 1493 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 312 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5995573.92539 | 2114332.46977 | 37.7852991621023 | -122.459067922044 | (37.7852991621023, -122.459067922044) | 11 | 6 | 1 | 54 | 31 | |||
161092 | 123804 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2200 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 4ft | 5991808.50618 | 2112055.95574 | 37.7788313010119 | -122.471929023833 | (37.7788313010119, -122.471929023833) | 11 | 6 | 2 | 54 | 11 | |||
158123 | 122001 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2250 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5991649.8791 | 2112044.77165 | 37.7787914125342 | -122.472476956605 | (37.7787914125342, -122.472476956605) | 11 | 6 | 2 | 54 | 26 | |||
168928 | 122002 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2250 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 4ft | 5991621.73453 | 2112044.32724 | 37.7787885632642 | -122.472574286372 | (37.7787885632642, -122.472574286372) | 11 | 6 | 2 | 54 | 26 | |||
160556 | 123805 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2201 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5991846.73407 | 2111993.54539 | 37.7786621511806 | -122.471792230155 | (37.7786621511806, -122.471792230155) | 11 | 6 | 2 | 54 | 11 | |||
41015 | 123806 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5991819.84372 | 2111992.27633 | 37.7786571107845 | -122.471885160871 | (37.7786571107845, -122.471885160871) | 11 | 6 | 2 | 54 | 11 | |||
129320 | 123330 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 753 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5994716.4753 | 2110476.43216 | 37.7746621864718 | -122.461754726458 | (37.7746621864718, -122.461754726458) | 11 | 6 | 2 | 54 | 11 | |||
64659 | 123360 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 752 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5994762.63942 | 2110475.46435 | 37.7746621864627 | -122.461594966486 | (37.7746621864627, -122.461594966486) | 11 | 6 | 2 | 54 | 11 | |||
56331 | 118304 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 399X Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5996218 | 2110432 | 37.7746265086244 | -122.45655746947 | (37.7746265086244, -122.45655746947) | 11 | 6 | 2 | 54 | 16 | ||||
58745 | 123328 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 767 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5994719.57081 | 2110383.41996 | 37.7744069778156 | -122.461737273105 | (37.7744069778156, -122.461737273105) | 11 | 6 | 2 | 54 | 11 | |||
172378 | 123368 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 798 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5994767.22383 | 2110333.14495 | 37.7742716789712 | -122.46156878779 | (37.7742716789712, -122.46156878779) | 11 | 6 | 2 | 54 | 11 | |||
167505 | 123522 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2814 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 8ft | 5994634.45147 | 2110226.82378 | 37.7739721059704 | -122.462020356507 | (37.7739721059704, -122.462020356507) | 11 | 6 | 2 | 54 | 11 | |||
12928 | 123523 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2820 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5994606.69117 | 2110222.29586 | 37.7739580752179 | -122.462116054917 | (37.7739580752179, -122.462116054917) | 11 | 6 | 2 | 54 | 11 | |||
35844 | 123524 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2828 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 5994582.70338 | 2110216.80029 | 37.7739416046925 | -122.462198633452 | (37.7739416046925, -122.462198633452) | 11 | 6 | 2 | 54 | 11 | |||
96231 | 242805 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007179.22681 | 2105245.51436 | 37.7610088582918 | -122.418272514273 | (37.7610088582918, -122.418272514273) | 2 | 4 | 7 | 28859 | 19 | |||
9499 | 10082 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005631.67807 | 2105272.56381 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | 2 | 4 | 5 | 28859 | 19 | |||
150786 | 242806 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007179.92075 | 2105235.69355 | 37.7609819316884 | -122.418269417912 | (37.7609819316884, -122.418269417912) | 2 | 4 | 7 | 28859 | 19 | |||
85221 | 242807 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.55989 | 2105223.19925 | 37.760947661217 | -122.418266321527 | (37.760947661217, -122.418266321527) | 2 | 4 | 7 | 28859 | 19 | |||
17230 | 242808 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007180.24018 | 2105207.60423 | 37.7609048229145 | -122.418266321545 | (37.7609048229145, -122.418266321545) | 2 | 4 | 7 | 28859 | 19 | |||
130102 | 242809 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.51421 | 2105199.12934 | 37.760881568258 | -122.418264772906 | (37.760881568258, -122.418264772906) | 2 | 4 | 7 | 28859 | 19 | |||
165885 | 3748 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 900 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012456.16548 | 2103686.28097 | 37.7570231709119 | -122.399912268343 | (37.7570231709119, -122.399912268343) | 10 | 3 | 8 | 28856 | 29 | |||
141140 | 198696 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 900x Carolina St | 5 | Median : Yard | Tree | DPW 1 | 3 | 6012471.20589 | 2103666.47878 | 37.7569696369443 | -122.399858862095 | (37.7569696369443, -122.399858862095) | 10 | 3 | 8 | 28856 | 29 | ||||
71278 | 25187 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3765 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000249.08614 | 2102834.07361 | 37.7539951005144 | -122.442067687981 | (37.7539951005144, -122.442067687981) | 2 | 4 | 5 | 63 | 38 | |||
139376 | 87088 | Permitted Site 7 | Ulmus spp :: Elm Spp 98 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50036 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
80457 | 242810 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3620 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006059.28413 | 2101437.67499 | 37.7504903093996 | -122.421875422335 | (37.7504903093996, -122.421875422335) | 2 | 4 | 5 | 28859 | 19 | |||
171682 | 242797 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3750 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005422.77896 | 2101397.5471 | 37.7503442109259 | -122.4240736541 | (37.7503442109259, -122.4240736541) | 2 | 4 | 5 | 28859 | 19 | |||
73993 | 242798 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3750 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6005399.69435 | 2101395.51192 | 37.7503373194083 | -122.424153337625 | (37.7503373194083, -122.424153337625) | 2 | 4 | 5 | 28859 | 19 | |||
149878 | 242802 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3755 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005401.27831 | 2101358.72982 | 37.7502364136768 | -122.424145244627 | (37.7502364136768, -122.424145244627) | 2 | 4 | 5 | 28859 | 19 | |||
180558 | 242801 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3775 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6005357.61324 | 2101353.89107 | 37.7502206620698 | -122.424295897257 | (37.7502206620698, -122.424295897257) | 2 | 4 | 5 | 28859 | 19 | |||
69075 | 242800 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3775 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6005335.62293 | 2101352.55073 | 37.7502157400659 | -122.424371845882 | (37.7502157400659, -122.424371845882) | 2 | 4 | 5 | 28859 | 19 | |||
79597 | 242799 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3799 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 6005227.89709 | 2101349.02972 | 37.7501999884601 | -122.424744118457 | (37.7501999884601, -122.424744118457) | 2 | 4 | 5 | 28859 | 19 | |||
104475 | 242803 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 6ft | 6005476.43132 | 2101343.24584 | 37.7501981412405 | -122.423884259558 | (37.7501981412405, -122.423884259558) | 2 | 4 | 5 | 28859 | 19 | |||
50751 | 215733 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 376 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 5994195.79933 | 2101387.8256 | 37.7496772494119 | -122.462896321116 | (37.7496772494119, -122.462896321116) | 1 | 8 | 4 | 29491 | 40 | |||
40904 | 215732 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 372 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5994198.34757 | 2101369.80369 | 37.7496279125984 | -122.462886201961 | (37.7496279125984, -122.462886201961) | 1 | 8 | 4 | 29491 | 40 | |||
19487 | 215735 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 51 Sotelo Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 5993894.80081 | 2101261.55452 | 37.749313199351 | -122.463928012577 | (37.749313199351, -122.463928012577) | 1 | 8 | 4 | 29491 | 40 | |||
8147 | 215734 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 51 Sotelo Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5993894.07462 | 2101226.9551 | 37.7492181562944 | -122.463928012569 | (37.7492181562944, -122.463928012569) | 1 | 8 | 4 | 29491 | 40 | |||
85046 | 215736 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 40 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 4ft | 5993926.04845 | 2101160.446 | 37.74903738179 | -122.46381262058 | (37.74903738179, -122.46381262058) | 1 | 8 | 4 | 29491 | 40 | |||
152423 | 215723 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 337 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994187.72813 | 2101011.61319 | 37.7486438006744 | -122.462896940751 | (37.7486438006744, -122.462896940751) | 1 | 8 | 4 | 29491 | 40 | |||
173854 | 215724 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 337 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5994197.80504 | 2100993.48118 | 37.7485945951844 | -122.462860779902 | (37.7485945951844, -122.462860779902) | 1 | 8 | 4 | 29491 | 40 | |||
97113 | 215725 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 337 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5994209.17748 | 2100969.9606 | 37.7485306686533 | -122.462819748344 | (37.7485306686533, -122.462819748344) | 1 | 8 | 4 | 29491 | 40 | |||
92874 | 215731 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 314 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5994301.54352 | 2100886.45873 | 37.7483067132019 | -122.462494294493 | (37.7483067132019, -122.462494294493) | 1 | 8 | 4 | 29491 | 40 | |||
178179 | 215730 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 310 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5994304.44088 | 2100856.56791 | 37.748224807423 | -122.462482107774 | (37.748224807423, -122.462482107774) | 1 | 8 | 4 | 29491 | 40 | |||
41089 | 215729 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 65 Marcela Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5994692.19949 | 2100656.92299 | 37.7476989549588 | -122.461126790771 | (37.7476989549588, -122.461126790771) | 1 | 8 | 4 | 29491 | 40 | |||
21668 | 215728 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 65 Marcela Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 5994684.73982 | 2100649.30829 | 37.7476776176257 | -122.461152033848 | (37.7476776176257, -122.461152033848) | 1 | 8 | 4 | 29491 | 40 | |||
185123 | 215727 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 65 Marcela Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994677.54204 | 2100642.18957 | 37.7476576571947 | -122.461176407263 | (37.7476576571947, -122.461176407263) | 1 | 8 | 4 | 29491 | 40 | |||
151683 | 215726 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 65 Marcela Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 4ft | 5994671.05341 | 2100636.37069 | 37.7476413066028 | -122.46119842269 | (37.7476413066028, -122.46119842269) | 1 | 8 | 4 | 29491 | 40 | |||
86039 | 111416 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 200x SAN MARCOS AVE | 1 | Median : Yard | Tree | Private 2 | 24 | 5993395 | 2100395 | 37.7469050456608 | -122.465593373526 | (37.7469050456608, -122.465593373526) | 1 | 8 | 4 | 29491 | 40 | ||||
101277 | 111417 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 200x SAN MARCOS AVE | 2 | Median : Yard | Tree | Private 2 | 24 | 5993395 | 2100395 | 37.7469050456608 | -122.465593373526 | (37.7469050456608, -122.465593373526) | 1 | 8 | 4 | 29491 | 40 | ||||
165683 | 215738 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 15x San Marcos Ave | 19 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5993371.75539 | 2100358.30231 | 37.7468029424032 | -122.465671084868 | (37.7468029424032, -122.465671084868) | 1 | 8 | 4 | 29491 | 40 | |||
30372 | 215739 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 15x San Marcos Ave | 20 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5993350.77612 | 2100350.23209 | 37.746779573516 | -122.465743042324 | (37.746779573516, -122.465743042324) | 1 | 8 | 4 | 29491 | 40 | |||
55554 | 215737 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 320 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994187.05794 | 2099904.81726 | 37.7456047801357 | -122.46281897493 | (37.7456047801357, -122.46281897493) | 1 | 8 | 4 | 29491 | 40 | |||
94966 | 215722 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 345 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5994125.85996 | 2099775.19806 | 37.7452453534832 | -122.463021183903 | (37.7452453534832, -122.463021183903) | 1 | 8 | 4 | 29491 | 40 | |||
176659 | 215721 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 345 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994111.22171 | 2099760.97057 | 37.7452054451668 | -122.463070768016 | (37.7452054451668, -122.463070768016) | 1 | 8 | 4 | 29491 | 40 | |||
45442 | 215720 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 395 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993868.48914 | 2099530.19239 | 37.7445578011181 | -122.463893341022 | (37.7445578011181, -122.463893341022) | 1 | 8 | 4 | 29491 | 40 | |||
138626 | 215719 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 395 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 5993858.05806 | 2099521.23156 | 37.7445325958077 | -122.463928759001 | (37.7445325958077, -122.463928759001) | 1 | 8 | 4 | 29491 | 40 | |||
77957 | 215718 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 395 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5993835.40464 | 2099503.34719 | 37.7444821843106 | -122.464005791356 | (37.7444821843106, -122.464005791356) | 1 | 8 | 4 | 29491 | 40 | |||
165624 | 106158 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 450 MAGELLAN AVE | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6x6 | 5993514.2 | 2099497.2 | 37.7444467889139 | -122.465115996043 | (37.7444467889139, -122.465115996043) | 1 | 8 | 4 | 29491 | 40 | ||||
179407 | 106157 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 450 MAGELLAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5993514.2 | 2099497.2 | 37.7444467889139 | -122.465115996043 | (37.7444467889139, -122.465115996043) | 1 | 8 | 4 | 29491 | 40 | ||||
152303 | 215689 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 405 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993745.16415 | 2099469.59605 | 37.7443843110814 | -122.464315372153 | (37.7443843110814, -122.464315372153) | 1 | 8 | 4 | 29491 | 40 | |||
125746 | 215688 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 405 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 5993716.40976 | 2099469.40445 | 37.7443821275318 | -122.464414784135 | (37.7443821275318, -122.464414784135) | 1 | 8 | 4 | 29491 | 40 | |||
105883 | 215690 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 200 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993774.81123 | 2099459.27251 | 37.7443576740778 | -122.464212110223 | (37.7443576740778, -122.464212110223) | 1 | 8 | 4 | 29491 | 40 | |||
91928 | 215687 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 429 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 5993617.17383 | 2099459.5589 | 37.7443493733236 | -122.464757203682 | (37.7443493733236, -122.464757203682) | 1 | 8 | 4 | 29491 | 40 | |||
38878 | 215686 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 435 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5993577.16832 | 2099456.02507 | 37.744337363775 | -122.46489527662 | (37.744337363775, -122.46489527662) | 1 | 8 | 4 | 29491 | 40 | |||
110559 | 215685 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 441 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5993549.18726 | 2099454.62454 | 37.7443319049106 | -122.464991926748 | (37.7443319049106, -122.464991926748) | 1 | 8 | 4 | 29491 | 40 | |||
76940 | 215684 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 445 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5993517.17282 | 2099451.32028 | 37.7443209862266 | -122.465102385081 | (37.7443209862266, -122.465102385081) | 1 | 8 | 4 | 29491 | 40 | |||
31209 | 215691 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 200 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993782.03427 | 2099445.58789 | 37.7443205158793 | -122.464186141393 | (37.7443205158793, -122.464186141393) | 1 | 8 | 4 | 29491 | 40 | |||
85978 | 215683 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 459 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5993471.60472 | 2099449.0963 | 37.7443122520064 | -122.465259787134 | (37.7443122520064, -122.465259787134) | 1 | 8 | 4 | 29491 | 40 | |||
66784 | 215682 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 459 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993450.00128 | 2099447.1643 | 37.7443057013639 | -122.465334346328 | (37.7443057013639, -122.465334346328) | 1 | 8 | 4 | 29491 | 40 | |||
171172 | 215681 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 465 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5993417.18845 | 2099443.87726 | 37.7442947835944 | -122.465447566463 | (37.7442947835944, -122.465447566463) | 1 | 8 | 4 | 29491 | 40 | |||
62465 | 215680 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 469 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5993386.03915 | 2099443.73631 | 37.7442926000308 | -122.465555262991 | (37.7442926000308, -122.465555262991) | 1 | 8 | 4 | 29491 | 40 | |||
170026 | 215679 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 475 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993351.61336 | 2099439.68765 | 37.7442794977971 | -122.465674004977 | (37.7442794977971, -122.465674004977) | 1 | 8 | 4 | 29491 | 40 | |||
144978 | 215678 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 485 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993337.59359 | 2099437.59642 | 37.744272947131 | -122.465722330041 | (37.744272947131, -122.465722330041) | 1 | 8 | 4 | 29491 | 40 | |||
83722 | 215677 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 485 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993318.79242 | 2099436.00328 | 37.7442674882658 | -122.465787224201 | (37.7442674882658, -122.465787224201) | 1 | 8 | 4 | 29491 | 40 | |||
66663 | 215676 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 485 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993291.62613 | 2099435.38114 | 37.7442642129331 | -122.465881113442 | (37.7442642129331, -122.465881113442) | 1 | 8 | 4 | 29491 | 40 | |||
192095 | 215668 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 513 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993182.22606 | 2099422.72334 | 37.744223146296 | -122.466258472572 | (37.744223146296, -122.466258472572) | 1 | 8 | 4 | 29491 | 40 | |||
93576 | 215667 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 513 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993150.22931 | 2099421.62704 | 37.7442182899438 | -122.466369029828 | (37.7442182899438, -122.466369029828) | 1 | 8 | 4 | 29491 | 40 | |||
52877 | 215666 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 515 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5993118.78091 | 2099418.45548 | 37.7442077669922 | -122.466477540206 | (37.7442077669922, -122.466477540206) | 1 | 8 | 4 | 29491 | 40 | |||
22367 | 215692 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 200 Montalvo Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5993805.80338 | 2099402.35315 | 37.7442031741333 | -122.464100815518 | (37.7442031741333, -122.464100815518) | 1 | 8 | 4 | 29491 | 40 | |||
189173 | 215675 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 101 Cortes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993235.56164 | 2099408.72436 | 37.7441877858384 | -122.466073034138 | (37.7441877858384, -122.466073034138) | 1 | 8 | 4 | 29491 | 40 | |||
162922 | 215669 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 100 Cortes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2016 12:00:00 AM | 12 | Width 3ft | Permit Number 777819 | 5993202.34131 | 2099405.04852 | 37.7441757763018 | -122.46618763477 | (37.7441757763018, -122.46618763477) | 1 | 8 | 4 | 29491 | 40 | |
62372 | 215665 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 537 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5992989.48009 | 2099407.90643 | 37.7441713399417 | -122.466923863846 | (37.7441713399417, -122.466923863846) | 1 | 8 | 4 | 29491 | 40 | |||
72851 | 215664 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 545 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5992958.94449 | 2099405.89498 | 37.7441640545339 | -122.467029302167 | (37.7441640545339, -122.467029302167) | 1 | 8 | 4 | 29491 | 40 | |||
153464 | 215663 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 551 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5992925.45554 | 2099404.24076 | 37.7441575794167 | -122.467144978385 | (37.7441575794167, -122.467144978385) | 1 | 8 | 4 | 29491 | 40 | |||
73634 | 215662 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 555 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5992890.83757 | 2099400.96676 | 37.7441465915065 | -122.4672644407 | (37.7441465915065, -122.4672644407) | 1 | 8 | 4 | 29491 | 40 | |||
36761 | 215661 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 571 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992826.04093 | 2099395.61373 | 37.7441281527051 | -122.467488102117 | (37.7441281527051, -122.467488102117) | 1 | 8 | 4 | 29491 | 40 | |||
109609 | 215660 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 575 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5992800.45502 | 2099393.57601 | 37.74412108044 | -122.467576423625 | (37.74412108044, -122.467576423625) | 1 | 8 | 4 | 29491 | 40 | |||
188986 | 215659 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 581 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5992760.61494 | 2099390.2279 | 37.7441095870799 | -122.467713937172 | (37.7441095870799, -122.467713937172) | 1 | 8 | 4 | 29491 | 40 | |||
88997 | 215693 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 240 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5993827.24964 | 2099367.71416 | 37.7441093002159 | -122.4640241456 | (37.7441093002159, -122.4640241456) | 1 | 8 | 4 | 29491 | 40 | |||
185142 | 215658 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 585 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5992725.64993 | 2099388.06552 | 37.7441016307792 | -122.467834680137 | (37.7441016307792, -122.467834680137) | 1 | 8 | 4 | 29491 | 40 | |||
141418 | 215657 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 593 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5992700.67645 | 2099384.40519 | 37.7440901383457 | -122.467920765955 | (37.7440901383457, -122.467920765955) | 1 | 8 | 4 | 29491 | 40 | |||
181503 | 215656 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 593 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5992672.51184 | 2099382.74346 | 37.7440839492114 | -122.468018031212 | (37.7440839492114, -122.468018031212) | 1 | 8 | 4 | 29491 | 40 | |||
94545 | 215670 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 100 Cortes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2016 12:00:00 AM | 13 | Width 3ft | Permit Number 777819 | 5993206.76177 | 2099368.37284 | 37.7440753292166 | -122.466169685199 | (37.7440753292166, -122.466169685199) | 1 | 8 | 4 | 29491 | 40 | |
53961 | 215674 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 101 Cortes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993237.46199 | 2099366.13727 | 37.7440709621114 | -122.46606336915 | (37.7440709621114, -122.46606336915) | 1 | 8 | 4 | 29491 | 40 | |||
111001 | 107499 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 581 MAGELLAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992766.8 | 2099370.2 | 37.7440549526848 | -122.467691094516 | (37.7440549526848, -122.467691094516) | 1 | 8 | 4 | 29491 | 40 | |||||
128046 | 215694 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 240 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 5993837.06347 | 2099341.15457 | 37.7440369398614 | -122.463988284241 | (37.7440369398614, -122.463988284241) | 1 | 8 | 4 | 29491 | 40 |
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) );