195 rows where qSpecies_id = 98 sorted by Supervisor Districts

View and edit SQL

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
19603 119905 Undocumented 4 Ulmus spp :: Elm Spp 98 517 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003302 2096146 37.7358047110715 -122.431032679091 (37.7358047110715, -122.431032679091) 2 7 5 63 7
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
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
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
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
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
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
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
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
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
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
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
15812 243781 DPW Maintained 1 Ulmus spp :: Elm Spp 98 530 Crescent Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007733.67911 2095675.76674 37.7347636749953 -122.415677298363 (37.7347636749953, -122.415677298363) 2 7 7 28859 2
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
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
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
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
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
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
457 198704 DPW Maintained 1 Ulmus spp :: Elm Spp 98 1675 Bay Shore Blvd 2 : Tree Private 2     11 Width 3ft   6012158.49704 2090987.28634 37.7221378175792 -122.400049934761 (37.7221378175792, -122.400049934761) 10 3 8 58 1
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
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
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
14681 198706 DPW Maintained 1 Ulmus spp :: Elm Spp 98 1601 Bay Shore Blvd 1 : Tree Private 2     10 Width 3ft   6012044.34389 2091356.23289 37.7231445043056 -122.400470439786 (37.7231445043056, -122.400470439786) 10 3 8 58 1
30888 198710 Undocumented 4 Ulmus spp :: Elm Spp 98 1575 Bay Shore Blvd 6 : Tree Private 2     10 Width 3ft   6011871.8158 2091922.88545 37.7246907932196 -122.401106636374 (37.7246907932196, -122.401106636374) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);