trees
195 rows where qSpecies_id = 98 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162759 | 215704 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 62 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5993453.70426 | 2099223.1321 | 37.7436907791226 | -122.465305272128 | (37.7436907791226, -122.465305272128) | 1 | 8 | 4 | 29491 | 40 | |||
174689 | 215697 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 18 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5993786.94355 | 2099253.5291 | 37.7437934538112 | -122.464155226295 | (37.7437934538112, -122.464155226295) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
28820 | 215776 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6000590.33355 | 2095867.8379 | 37.7348869154046 | -122.440388006217 | (37.7348869154046, -122.440388006217) | 9 | 7 | 4 | 63 | 40 | |||
64170 | 215773 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6000584.07141 | 2095871.02296 | 37.7348953042758 | -122.440409884922 | (37.7348953042758, -122.440409884922) | 9 | 7 | 4 | 63 | 40 | |||
66685 | 198701 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1200 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017953.40415 | 2093964.00554 | 37.7306327066323 | -122.380224903656 | (37.7306327066323, -122.380224903656) | 10 | 3 | 8 | 58 | 1 | |||
133957 | 215770 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000577.40993 | 2095873.4525 | 37.7349015959229 | -122.440433090118 | (37.7349015959229, -122.440433090118) | 9 | 7 | 4 | 63 | 40 | |||
143849 | 198702 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1200 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017881.52246 | 2093947.06532 | 37.7305822258668 | -122.380472235202 | (37.7305822258668, -122.380472235202) | 10 | 3 | 8 | 58 | 1 | |||
181428 | 215765 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000567.86167 | 2095875.36939 | 37.7349063155722 | -122.440466239146 | (37.7349063155722, -122.440466239146) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
50980 | 215706 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5993386.77345 | 2099220.62033 | 37.7436800223286 | -122.465536518409 | (37.7436800223286, -122.465536518409) | 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 | |||
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 | |||
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 | |||
78143 | 215698 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 20 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5993762.54541 | 2099249.76761 | 37.7437817194667 | -122.464239315609 | (37.7437817194667, -122.464239315609) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
125741 | 215703 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 56 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5993487.40433 | 2099227.05398 | 37.7437034910307 | -122.465189031156 | (37.7437034910307, -122.465189031156) | 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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
59560 | 180594 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 222 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 6006226.36725 | 2093441.03912 | 37.7285427577377 | -122.420730007995 | (37.7285427577377, -122.420730007995) | 9 | 7 | 7 | 309 | 5 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
48866 | 29913 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
158768 | 215699 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 22 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 5993719.19331 | 2099246.04801 | 37.7437690075397 | -122.464388945713 | (37.7437690075397, -122.464388945713) | 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 | |||
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 | |||
186093 | 215771 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 8ft | 6000578.22769 | 2095871.70651 | 37.734896848405 | -122.440430137662 | (37.734896848405, -122.440430137662) | 9 | 7 | 4 | 63 | 40 | |||
22845 | 215763 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000560.6488 | 2095878.95607 | 37.7349157530474 | -122.440491433659 | (37.7349157530474, -122.440491433659) | 9 | 7 | 4 | 63 | 40 | |||
66629 | 198700 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1333 Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017887.42567 | 2094613.59232 | 37.7324127041689 | -122.38049813569 | (37.7324127041689, -122.38049813569) | 10 | 3 | 8 | 58 | 1 | |||
108492 | 215769 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000576.07621 | 2095873.86239 | 37.7349026454429 | -122.440437730631 | (37.7349026454429, -122.440437730631) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||||
193258 | 198699 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1333 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017863.74543 | 2094622.4827 | 37.7324358086644 | -122.380580622414 | (37.7324358086644, -122.380580622414) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
167056 | 215745 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 10ft | 6000472.43959 | 2095925.27887 | 37.7350379214503 | -122.440799724826 | (37.7350379214503, -122.440799724826) | 9 | 7 | 4 | 63 | 40 | |||
181225 | 215757 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6000510.50193 | 2095892.79039 | 37.73495088328 | -122.44066580051 | (37.73495088328, -122.44066580051) | 9 | 7 | 4 | 63 | 40 | ||||
12992 | 198697 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1335 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017534.83349 | 2094839.70643 | 37.7330141060212 | -122.381732862609 | (37.7330141060212, -122.381732862609) | 10 | 3 | 8 | 58 | 1 | |||
72923 | 198698 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1335 Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017550.68289 | 2094824.53865 | 37.7329733334465 | -122.381677011992 | (37.7329733334465, -122.381677011992) | 10 | 3 | 8 | 58 | 1 | |||
77716 | 215768 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6000574.55456 | 2095874.46679 | 37.7349042183411 | -122.440443034827 | (37.7349042183411, -122.440443034827) | 9 | 7 | 4 | 63 | 40 | |||
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 | |
34047 | 215741 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000462.15679 | 2095947.26146 | 37.735097694886 | -122.440836852437 | (37.735097694886, -122.440836852437) | 9 | 7 | 4 | 63 | 40 | |||
101031 | 215764 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6000563.68419 | 2095877.36552 | 37.7349115586084 | -122.440480825239 | (37.7349115586084, -122.440480825239) | 9 | 7 | 4 | 63 | 40 | |||
121378 | 215754 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000486.86029 | 2095899.39146 | 37.7349676619301 | -122.440748011123 | (37.7349676619301, -122.440748011123) | 9 | 7 | 4 | 63 | 40 | ||||
145053 | 215759 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000518.68875 | 2095889.94729 | 37.7349435430019 | -122.440637292001 | (37.7349435430019, -122.440637292001) | 9 | 7 | 4 | 63 | 40 | ||||
5289 | 198707 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1601 Bay Shore Blvd | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012032.42562 | 2091390.57869 | 37.7232381462018 | -122.400514050588 | (37.7232381462018, -122.400514050588) | 10 | 3 | 8 | 58 | 1 | |||
27306 | 215749 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000479.23488 | 2095910.81601 | 37.7349985968107 | -122.440775194031 | (37.7349985968107, -122.440775194031) | 9 | 7 | 4 | 63 | 40 | ||||
61872 | 242804 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 517 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003295.69623 | 2096166.76652 | 37.7358613739981 | -122.431055955391 | (37.7358613739981, -122.431055955391) | 2 | 7 | 5 | 63 | 7 | |||
71110 | 215777 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6000591.54294 | 2095870.67707 | 37.7348947799641 | -122.440384028497 | (37.7348947799641, -122.440384028497) | 9 | 7 | 4 | 63 | 40 | |||
101485 | 215751 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000480.34135 | 2095908.69261 | 37.7349928294638 | -122.440771216316 | (37.7349928294638, -122.440771216316) | 9 | 7 | 4 | 63 | 40 | ||||
127475 | 215740 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6000610.74849 | 2095862.83143 | 37.7348743311859 | -122.440317065893 | (37.7348743311859, -122.440317065893) | 9 | 7 | 4 | 63 | 40 | |||
138258 | 215758 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000517.64958 | 2095895.31545 | 37.734958223539 | -122.440641269687 | (37.734958223539, -122.440641269687) | 9 | 7 | 4 | 63 | 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 | |||
149205 | 26591 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1645 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 6 | 3X3 | 6012131.0656 | 2091075.31629 | 37.722378000425 | -122.400150938517 | (37.722378000425, -122.400150938517) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
51388 | 215775 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6000589.79404 | 2095869.56764 | 37.734891634148 | -122.4403899955 | (37.734891634148, -122.4403899955) | 9 | 7 | 4 | 63 | 40 | |||
118250 | 215742 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000463.99438 | 2095943.40434 | 37.73508720879 | -122.440830222646 | (37.73508720879, -122.440830222646) | 9 | 7 | 4 | 63 | 40 | |||
4936 | 215744 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6000469.85899 | 2095930.29743 | 37.7350515542757 | -122.440809006739 | (37.7350515542757, -122.440809006739) | 9 | 7 | 4 | 63 | 40 | |||
125837 | 215772 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6000580.44136 | 2095871.67109 | 37.7348968771961 | -122.44042248171 | (37.7348968771961, -122.44042248171) | 9 | 7 | 4 | 63 | 40 | |||
8808 | 198709 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1575 Bay Shore Blvd | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6011880.53852 | 2091897.11167 | 37.7246205103096 | -122.401074672678 | (37.7246205103096, -122.401074672678) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
76779 | 215778 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6000596.9829 | 2095864.83543 | 37.734879049926 | -122.440364801892 | (37.734879049926, -122.440364801892) | 9 | 7 | 4 | 63 | 40 | |||
97864 | 215652 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2398 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992666.59083 | 2099178.09213 | 37.7435216867765 | -122.468023621394 | (37.7435216867765, -122.468023621394) | 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) );