trees
494 rows where qSpecies_id = 243 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2950 | 19885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
6530 | 20001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
15870 | 19880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
65096 | 197886 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 1 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | 10 | 3 | 8 | 28856 | 1 | |||
192762 | 197885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6015684.08537 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | 10 | 3 | 8 | 28856 | 1 | |||
59176 | 197884 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6015678.84769 | 2101942.94964 | 37.7524154925876 | -122.388645221797 | (37.7524154925876, -122.388645221797) | 10 | 3 | 8 | 28856 | 1 | |||
180820 | 197883 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.7524147605401 | -122.388669977447 | (37.7524147605401, -122.388669977447) | 10 | 3 | 8 | 28856 | 1 | |||
157902 | 197882 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.7524095732464 | -122.388743532098 | (37.7524095732464, -122.388743532098) | 10 | 3 | 8 | 28856 | 1 | |||
51547 | 197881 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.7524092333136 | -122.388757586711 | (37.7524092333136, -122.388757586711) | 10 | 3 | 8 | 28856 | 1 | |||
67831 | 197880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 10 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6015641.85781 | 2101940.61128 | 37.752407021878 | -122.388772976792 | (37.752407021878, -122.388772976792) | 10 | 3 | 8 | 28856 | 1 | |||
56675 | 197879 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015633.71658 | 2101939.60961 | 37.7524038202784 | -122.388801060829 | (37.7524038202784, -122.388801060829) | 10 | 3 | 8 | 28856 | 1 | |||
152953 | 197878 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 13 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | 10 | 3 | 8 | 28856 | 1 | |||
52884 | 197877 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015625.5144 | 2101938.71923 | 37.7524009208729 | -122.388829363409 | (37.7524009208729, -122.388829363409) | 10 | 3 | 8 | 28856 | 1 | |||
168634 | 107038 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1641 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015261.1717 | 2096333.2205 | 37.7369891837982 | -122.389697852121 | (37.7369891837982, -122.389697852121) | 10 | 3 | 8 | 58 | 1 | |||
44245 | 110874 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
65999 | 110868 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
99283 | 110872 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
181192 | 110873 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
169359 | 197888 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 955 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013536.79803 | 2089586.31829 | 37.7183677903304 | -122.395187363419 | (37.7183677903304, -122.395187363419) | 10 | 3 | 8 | 58 | 1 | ||||
134422 | 179669 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 301 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012620.01263 | 2087029.41964 | 37.7112960280502 | -122.398177039048 | (37.7112960280502, -122.398177039048) | 10 | 3 | 8 | 309 | 1 | |||
168902 | 197889 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1098 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012673.3872 | 2089947.03209 | 37.7193101835929 | -122.398197126321 | (37.7193101835929, -122.398197126321) | 10 | 3 | 8 | 58 | 1 | |||
124480 | 179668 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 301 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012612.99348 | 2087008.97407 | 37.7112394975798 | -122.398199865648 | (37.7112394975798, -122.398199865648) | 10 | 3 | 8 | 309 | 1 | |||
152940 | 179667 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 309 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012610.18411 | 2086997.87945 | 37.7112088774584 | -122.398208797709 | (37.7112088774584, -122.398208797709) | 10 | 3 | 8 | 309 | 1 | |||
44044 | 179666 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 309 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012604.11309 | 2086981.70393 | 37.7111641245081 | -122.398228646659 | (37.7111641245081, -122.398228646659) | 10 | 3 | 8 | 309 | 1 | |||
136823 | 179665 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 325 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6012591.22281 | 2086940.79015 | 37.7110510653234 | -122.398270330217 | (37.7110510653234, -122.398270330217) | 10 | 3 | 8 | 309 | 1 | |||
28719 | 179664 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 325 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6012585.69681 | 2086923.17392 | 37.711002386816 | -122.398288194338 | (37.711002386816, -122.398288194338) | 10 | 3 | 8 | 309 | 1 | |||
37142 | 105552 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 329 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6012582.61187 | 2086912.65676 | 37.7109733369276 | -122.398298119266 | (37.7109733369276, -122.398298119266) | 10 | 3 | 8 | 309 | 1 | ||||
13180 | 179663 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 333 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012567.36741 | 2086868.9308 | 37.7108524248833 | -122.398347742071 | (37.7108524248833, -122.398347742071) | 10 | 3 | 8 | 309 | 1 | |||
129410 | 179662 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 200 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012226.23754 | 2087173.50879 | 37.7116697269483 | -122.399548143633 | (37.7116697269483, -122.399548143633) | 10 | 3 | 8 | 309 | 1 | |||
188996 | 179661 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6012216.37842 | 2087780.43205 | 37.7133356679799 | -122.399624805455 | (37.7133356679799, -122.399624805455) | 10 | 3 | 8 | 309 | 1 | ||||
110486 | 179660 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 3 | Side Yard : Yard | Tree | Private 2 | 8 | 6012212.84494 | 2087789.77212 | 37.7133611169841 | -122.399637673848 | (37.7133611169841, -122.399637673848) | 10 | 3 | 8 | 309 | 1 | ||||
145047 | 179659 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 2 | Side Yard : Yard | Tree | Private 2 | 8 | 6012208.68796 | 2087783.6774 | 37.7133441503725 | -122.399651614248 | (37.7133441503725, -122.399651614248) | 10 | 3 | 8 | 309 | 1 | ||||
26310 | 187552 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Beeman Ln | 1 | Side Yard : Yard | Tree | Private 2 | 35 | 6012028.62057 | 2088183.94027 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | 10 | 7 | 8 | 309 | 39 | ||||
41499 | 197887 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1493 Kansas St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 6011776.63804 | 2101418.39447 | 37.7507581436897 | -122.402102910747 | (37.7507581436897, -122.402102910747) | 10 | 3 | 8 | 28856 | 29 | |||
155877 | 39869 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1305 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 3 | Permit Number 41169 | 6011434.7217 | 2119842.62284 | 37.8013277319434 | -122.404582116778 | (37.8013277319434, -122.404582116778) | 3 | 1 | 10 | 308 | 23 | |
25387 | 249848 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 289 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011433.333 | 2120390.12785 | 37.8028309694274 | -122.404625486584 | (37.8028309694274, -122.404625486584) | 3 | 1 | 10 | 308 | 23 | |||
39423 | 197875 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1022 Harrison St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6011232.56794 | 2110864.16266 | 37.7766637150973 | -122.40464924399 | (37.7766637150973, -122.40464924399) | 14 | 2 | 9 | 28853 | 34 | |||
88858 | 197876 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1022 Harrison St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6011218.09567 | 2110851.71403 | 37.7766287251786 | -122.404698431509 | (37.7766287251786, -122.404698431509) | 14 | 2 | 9 | 28853 | 34 | |||
131204 | 121327 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 405 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010952.0953 | 2119641.7196 | 37.8007491161502 | -122.406238063211 | (37.8007491161502, -122.406238063211) | 3 | 1 | 10 | 308 | 23 | |||
25750 | 253293 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
85746 | 253294 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
4139 | 143087 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 480 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010585.232 | 2119982.0381 | 37.8016630194804 | -122.407531575883 | (37.8016630194804, -122.407531575883) | 3 | 1 | 10 | 308 | 23 | |||
62698 | 249782 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.8048533324903 | -122.407973043817 | (37.8048533324903, -122.407973043817) | 3 | 1 | 10 | 308 | 23 | |||
189350 | 249783 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6010478.38783 | 2121144.55662 | 37.8048490274321 | -122.407983335672 | (37.8048490274321, -122.407983335672) | 3 | 1 | 10 | 308 | 23 | |||
88216 | 136632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 745 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010322.48557 | 2116149.01885 | 37.7911237712979 | -122.408170315501 | (37.7911237712979, -122.408170315501) | 5 | 1 | 10 | 28857 | 21 | |||
171117 | 136631 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 745 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010305.76726 | 2116145.08386 | 37.7911120306413 | -122.408227882917 | (37.7911120306413, -122.408227882917) | 5 | 1 | 10 | 28857 | 21 | |||
52215 | 179790 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6009766.50447 | 2091537.32256 | 37.7235144458085 | -122.408357284583 | (37.7235144458085, -122.408357284583) | 10 | 3 | 7 | 309 | 28 | |||
69886 | 179791 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009764.47245 | 2091543.83169 | 37.7235322047282 | -122.408364767842 | (37.7235322047282, -122.408364767842) | 10 | 3 | 7 | 309 | 28 | |||
33562 | 179792 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009761.92268 | 2091556.81874 | 37.7235677216684 | -122.408374497582 | (37.7235677216684, -122.408374497582) | 10 | 3 | 7 | 309 | 28 | |||
8289 | 179793 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009759.65206 | 2091562.25484 | 37.7235825209091 | -122.408382730001 | (37.7235825209091, -122.408382730001) | 10 | 3 | 7 | 309 | 28 | |||
10511 | 142965 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 111 Pfeiffer St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010321.3688 | 2121130.7743 | 37.8048023922739 | -122.408525746416 | (37.8048023922739, -122.408525746416) | 3 | 1 | 10 | 308 | 23 | |||
142419 | 142964 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010284.5248 | 2121125.6441 | 37.8047862425651 | -122.408652887366 | (37.8047862425651, -122.408652887366) | 3 | 1 | 10 | 308 | 23 | |||
41381 | 142963 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 119 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010263.5377 | 2121122.3795 | 37.8047761033373 | -122.408725285275 | (37.8047761033373, -122.408725285275) | 3 | 1 | 10 | 308 | 23 | |||
143066 | 142968 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 123 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010234.1558 | 2121117.7157 | 37.8047616520024 | -122.408826635586 | (37.8047616520024, -122.408826635586) | 3 | 1 | 10 | 308 | 23 | |||
167069 | 179673 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009280.11553 | 2087236.74684 | 37.7116787066663 | -122.40973523929 | (37.7116787066663, -122.40973523929) | 9 | 7 | 8 | 309 | 39 | |||
165463 | 179672 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6009276.50354 | 2087227.45755 | 37.7116529977608 | -122.409747068083 | (37.7116529977608, -122.409747068083) | 9 | 7 | 8 | 309 | 39 | |||
106726 | 179671 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009275.06023 | 2087222.94519 | 37.71164052686 | -122.409751738267 | (37.71164052686, -122.409751738267) | 9 | 7 | 8 | 309 | 39 | |||
143798 | 241021 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 81 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6009293.69668 | 2097607.83749 | 37.7401562941659 | -122.410420139577 | (37.7401562941659, -122.410420139577) | 10 | 7 | 7 | 28859 | 2 | |||
144903 | 241014 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6009365.12145 | 2107942.64044 | 37.7685373484578 | -122.410902924446 | (37.7685373484578, -122.410902924446) | 8 | 4 | 7 | 28853 | 19 | |||
118338 | 241013 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6009364.37303 | 2107955.02129 | 37.7685713014421 | -122.410906387729 | (37.7685713014421, -122.410906387729) | 8 | 4 | 7 | 28853 | 19 | |||
89478 | 241012 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6009364.22558 | 2107957.61703 | 37.7685784204757 | -122.410907081104 | (37.7685784204757, -122.410907081104) | 8 | 4 | 7 | 28853 | 19 | |||
154014 | 107677 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 305 NEVADA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 3x12 | 6008988.2 | 2096819.7 | 37.7379751095359 | -122.411420761527 | (37.7379751095359, -122.411420761527) | 10 | 7 | 7 | 28859 | 2 | |||
180252 | 241019 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6008974.79401 | 2096823.76777 | 37.7379855268132 | -122.411467400123 | (37.7379855268132, -122.411467400123) | 10 | 7 | 7 | 28859 | 2 | |||
57970 | 241020 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | 6008973.83234 | 2096817.19459 | 37.7379674243488 | -122.411470260845 | (37.7379674243488, -122.411470260845) | 10 | 7 | 7 | 28859 | 2 | |||
38456 | 241046 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2868 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6009024.96675 | 2103353.45753 | 37.7559174229641 | -122.411755183159 | (37.7559174229641, -122.411755183159) | 2 | 4 | 7 | 28859 | 19 | |||
182390 | 179718 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 27 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008335.51902 | 2094191.89542 | 37.7307230983942 | -122.413491613054 | (37.7307230983942, -122.413491613054) | 9 | 3 | 7 | 309 | 28 | |||
59878 | 179712 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 81 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008198.62587 | 2093898.01777 | 37.7299084861863 | -122.413944094353 | (37.7299084861863, -122.413944094353) | 9 | 3 | 7 | 309 | 28 | |||
119758 | 179713 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 73 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008189.2089 | 2093932.70861 | 37.73000321088 | -122.413979103169 | (37.73000321088, -122.413979103169) | 9 | 3 | 7 | 309 | 28 | |||
96860 | 179711 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 78 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008165.87116 | 2093886.12705 | 37.7298739971729 | -122.414056490734 | (37.7298739971729, -122.414056490734) | 9 | 3 | 7 | 309 | 28 | |||
90633 | 179714 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 53 Dunsmuir St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 2ft | 6008166.60456 | 2094034.89601 | 37.7302825259061 | -122.414064475822 | (37.7302825259061, -122.414064475822) | 9 | 3 | 7 | 309 | 28 | |||
130894 | 179715 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 45 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008159.27182 | 2094067.244 | 37.7303709346626 | -122.414092113787 | (37.7303709346626, -122.414092113787) | 9 | 3 | 7 | 309 | 28 | |||
87304 | 179716 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 41 Dunsmuir St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 2ft | 6008151.38796 | 2094098.71861 | 37.7304569143427 | -122.414121595359 | (37.7304569143427, -122.414121595359) | 9 | 3 | 7 | 309 | 28 | |||
56969 | 179710 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 50 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008132.94359 | 2094030.80791 | 37.7302694101893 | -122.414180557601 | (37.7302694101893, -122.414180557601) | 9 | 3 | 7 | 309 | 28 | |||
128885 | 179717 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 17 Dunsmuir St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 2ft | 6008127.64953 | 2094206.23587 | 37.7307508001883 | -122.414211266754 | (37.7307508001883, -122.414211266754) | 9 | 3 | 7 | 309 | 28 | |||
67861 | 179709 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 30 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008109.77059 | 2094131.23737 | 37.7305438661899 | -122.414267772933 | (37.7305438661899, -122.414267772933) | 9 | 3 | 7 | 309 | 28 | |||
60602 | 179708 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 16 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008092.80354 | 2094196.33421 | 37.7307216549786 | -122.414331034869 | (37.7307216549786, -122.414331034869) | 9 | 3 | 7 | 309 | 28 | |||
62675 | 179707 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Dunsmuir St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 2ft | 6008087.26111 | 2094229.35305 | 37.7308120062462 | -122.414352531355 | (37.7308120062462, -122.414352531355) | 9 | 3 | 7 | 309 | 28 | |||
27104 | 136613 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1163 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008339.99161 | 2115873.76917 | 37.7902567978586 | -122.415010210055 | (37.7902567978586, -122.415010210055) | 5 | 1 | 10 | 28858 | 21 | |||
115328 | 136616 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Jackson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6008322.00574 | 2117598.96331 | 37.7949927464615 | -122.415194612455 | (37.7949927464615, -122.415194612455) | 5 | 1 | 10 | 28858 | 21 | |||
106443 | 179706 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 26 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007716.84385 | 2093968.91178 | 37.7300760757541 | -122.415614693872 | (37.7300760757541, -122.415614693872) | 9 | 3 | 7 | 309 | 28 | |||
20828 | 179697 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1100 Felton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007690.32077 | 2092934.09301 | 37.7272331955512 | -122.415633147958 | (37.7272331955512, -122.415633147958) | 9 | 3 | 7 | 309 | 5 | |||
55596 | 179698 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1100 Felton St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007685.78297 | 2092932.61475 | 37.7272288814848 | -122.415648730527 | (37.7272288814848, -122.415648730527) | 9 | 3 | 7 | 309 | 5 | |||
53639 | 179699 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1100 Felton St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007650.85932 | 2092922.10831 | 37.7271980698357 | -122.415768718069 | (37.7271980698357, -122.415768718069) | 9 | 3 | 7 | 309 | 5 | |||
155379 | 136614 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1146 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008130.23973 | 2116469.59662 | 37.7918810049628 | -122.415778145656 | (37.7918810049628, -122.415778145656) | 5 | 1 | 10 | 28858 | 21 | |||
157882 | 179700 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1100 Felton St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6007647.45718 | 2092921.05552 | 37.7271949878437 | -122.415780404758 | (37.7271949878437, -122.415780404758) | 9 | 3 | 7 | 309 | 5 | |||
184966 | 136615 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1152 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6008127.50267 | 2116494.06688 | 37.7919480404173 | -122.415789349395 | (37.7919480404173, -122.415789349395) | 5 | 1 | 10 | 28858 | 21 | |||
78027 | 179705 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 57 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007545.2512 | 2093666.54054 | 37.7292361826969 | -122.416186506207 | (37.7292361826969, -122.416186506207) | 9 | 3 | 7 | 309 | 28 | |||
49458 | 179701 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1142 Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007388.41851 | 2093322.95448 | 37.7282839499293 | -122.416704361037 | (37.7282839499293, -122.416704361037) | 9 | 3 | 7 | 309 | 5 | |||
184319 | 179702 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1142 Silliman St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007383.53994 | 2093322.51563 | 37.7282824705509 | -122.416721195428 | (37.7282824705509, -122.416721195428) | 9 | 3 | 7 | 309 | 5 | |||
191027 | 179703 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1142 Silliman St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007376.61952 | 2093319.2452 | 37.7282731014193 | -122.41674488808 | (37.7282731014193, -122.41674488808) | 9 | 3 | 7 | 309 | 5 | |||
2758 | 179704 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 27 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007379.54871 | 2093756.9583 | 37.7294751316534 | -122.416765758639 | (37.7294751316534, -122.416765758639) | 9 | 3 | 7 | 309 | 28 | |||
110118 | 106728 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 663 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 2x2 | 6007262.56469 | 2091493.39322 | 37.7232532889972 | -122.417009866133 | (37.7232532889972, -122.417009866133) | 9 | 3 | 7 | 309 | 28 | |||
12365 | 261369 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 48 Bache St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
149380 | 179696 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1317 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007086.79477 | 2092691.09915 | 37.7265320427177 | -122.417702322507 | (37.7265320427177, -122.417702322507) | 9 | 3 | 7 | 309 | 28 | |||
117577 | 136630 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6007480.48999 | 2119873.18384 | 37.8011898586792 | -122.418267709195 | (37.8011898586792, -122.418267709195) | 5 | 1 | 1 | 28858 | 32 | ||||
150680 | 136629 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007448.32601 | 2119348.57827 | 37.7997476132167 | -122.418341793545 | (37.7997476132167, -122.418341793545) | 5 | 1 | 1 | 28858 | 32 | |||
64047 | 136628 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6007442.68945 | 2119347.67651 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | 5 | 1 | 1 | 28858 | 32 | |||
184182 | 241045 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 313 Virginia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6006931.5072 | 2098259.45718 | 37.7418127905307 | -122.418633848399 | (37.7418127905307, -122.418633848399) | 2 | 7 | 7 | 28859 | 2 |
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) );