trees
195 rows where qSpecies_id = 98
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97863 | 215710 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 98 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993269.60879 | 2099210.26077 | 37.743644819253 | -122.465940889564 | (37.743644819253, -122.465940889564) | 1 | 8 | 4 | 29491 | 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 | |||
| 100570 | 215753 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000483.505 | 2095904.04385 | 37.7349802452242 | -122.44075994513 | (37.7349802452242, -122.44075994513) | 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 105266 | 215673 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 101 Cortes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5993241.36697 | 2099320.1384 | 37.7439448861475 | -122.466046524827 | (37.7439448861475, -122.466046524827) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 111330 | 215774 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6000585.93673 | 2095868.50192 | 37.7348884882982 | -122.440403255128 | (37.7348884882982, -122.440403255128) | 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 | |||
| 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 | ||||
| 122055 | 215672 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 151 Cortes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993245.32929 | 2099284.45627 | 37.7438471406431 | -122.466030231813 | (37.7438471406431, -122.466030231813) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 127590 | 215766 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000570.32165 | 2095873.79044 | 37.7349021202175 | -122.440457620949 | (37.7349021202175, -122.440457620949) | 9 | 7 | 4 | 63 | 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 | |||
| 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 | |||
| 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 | |||
| 133791 | 215695 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 240 Montalvo Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993846.95203 | 2099318.15435 | 37.7439743569352 | -122.463952422873 | (37.7439743569352, -122.463952422873) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 137258 | 198708 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1601 Bay Shore Blvd | 4 | : | Tree | Private 2 | 0 | Width 3ft | 6012024.53747 | 2091412.02554 | 37.723296594957 | -122.40054282439 | (37.723296594957, -122.40054282439) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||
| 143984 | 215702 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 50 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5993521.10439 | 2099230.9759 | 37.7437162029334 | -122.465072790183 | (37.7437162029334, -122.465072790183) | 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 | |||
| 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 | ||||
| 146093 | 85389 | Permitted Site 7 | Ulmus spp :: Elm Spp 98 | 300 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49659 | 5992136 | 2097371 | 37.738529215445 | -122.469726723041 | (37.738529215445, -122.469726723041) | 1 | 8 | 4 | 59 | 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 | ||
| 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 | |||
| 150477 | 198703 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1751 Bay Shore Blvd | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012274.16667 | 2090622.31625 | 37.7211421322749 | -122.399624478112 | (37.7211421322749, -122.399624478112) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 150959 | 215653 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2348 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5992661.56559 | 2099277.36627 | 37.7437939781139 | -122.468048216973 | (37.7437939781139, -122.468048216973) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 157344 | 215709 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 98 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993297.50718 | 2099210.38702 | 37.7436467752768 | -122.465844433682 | (37.7436467752768, -122.465844433682) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 158737 | 215752 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6000481.62782 | 2095905.99262 | 37.7349854891864 | -122.440766574932 | (37.7349854891864, -122.440766574932) | 9 | 7 | 4 | 63 | 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 | |||
| 159424 | 215750 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000479.78996 | 2095909.84974 | 37.7349959752708 | -122.440773205638 | (37.7349959752708, -122.440773205638) | 9 | 7 | 4 | 63 | 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 | |||
| 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 | |||
| 161512 | 215473 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 80 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 5992586.31488 | 2096252.67544 | 37.7354845949313 | -122.468088438245 | (37.7354845949313, -122.468088438245) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 171001 | 215655 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2348 12th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5992658.55199 | 2099364.68475 | 37.7440335584079 | -122.468064987503 | (37.7440335584079, -122.468064987503) | 1 | 8 | 4 | 29491 | 40 | |||
| 171015 | 215717 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 198 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992710.76585 | 2099162.99792 | 37.7434827928969 | -122.467869778873 | (37.7434827928969, -122.467869778873) | 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 | |||
| 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 | |||
| 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 | |||
| 173674 | 215701 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 38 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5993601.93948 | 2099231.41525 | 37.7437220701321 | -122.464793315966 | (37.7437220701321, -122.464793315966) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 178204 | 215714 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 170 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992837.34003 | 2099175.81646 | 37.743525297563 | -122.46743305279 | (37.743525297563, -122.46743305279) | 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 | ||||
| 180414 | 215756 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000507.98466 | 2095900.86283 | 37.734972904964 | -122.440675082413 | (37.734972904964, -122.440675082413) | 9 | 7 | 4 | 63 | 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 187844 | 215761 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000556.80733 | 2095878.65384 | 37.7349147044535 | -122.440504693264 | (37.7349147044535, -122.440504693264) | 9 | 7 | 4 | 63 | 40 | |||
| 187864 | 198705 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1675 Bay Shore Blvd | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6012153.96731 | 2091001.00573 | 37.7221752356765 | -122.400066556037 | (37.7221752356765, -122.400066556037) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 192266 | 215711 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 120 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993106.31705 | 2099196.4779 | 37.7435975535962 | -122.466504506383 | (37.7435975535962, -122.466504506383) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 194216 | 215654 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2348 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5992660.75686 | 2099331.15305 | 37.7439416162244 | -122.468054925011 | (37.7439416162244, -122.468054925011) | 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) );