trees
494 rows where qSpecies_id = 243 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
7239 | 117920 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 727 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983191.607 | 2110832.41366 | 37.7749694365706 | -122.501647249063 | (37.7749694365706, -122.501647249063) | 11 | 6 | 2 | 55 | 26 | |||
10501 | 136602 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3698 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6002136.39741 | 2121144.63129 | 37.8043786541109 | -122.436851639901 | (37.8043786541109, -122.436851639901) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
17702 | 241027 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 336 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000616.7191 | 2101813.33629 | 37.7512133463326 | -122.440723116081 | (37.7512133463326, -122.440723116081) | 2 | 4 | 5 | 28862 | 22 | |||
19969 | 106456 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2343 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5988548.8369 | 2099368.6206 | 37.743806169615 | -122.48227557587 | (37.743806169615, -122.48227557587) | 1 | 8 | 3 | 29491 | 35 | ||||
22802 | 215228 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 469 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5995237.23604 | 2098198.29542 | 37.7409795263953 | -122.459064099442 | (37.7409795263953, -122.459064099442) | 1 | 8 | 4 | 59 | 40 | |||
24220 | 179638 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 286 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998314.38547 | 2088719.36109 | 37.7151290150634 | -122.447742271601 | (37.7151290150634, -122.447742271601) | 9 | 7 | 6 | 28861 | 25 | |||
25328 | 241047 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 156 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005501.90776 | 2099064.47249 | 37.7439425892855 | -122.423634161688 | (37.7439425892855, -122.423634161688) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||||
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 | ||||
26471 | 179720 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6004978.66043 | 2094360.05268 | 37.730995762948 | -122.42510876568 | (37.730995762948, -122.42510876568) | 9 | 7 | 6 | 28861 | 5 | |||
26649 | 136624 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6006955.61886 | 2120188.67307 | 37.8020265537335 | -122.42010639829 | (37.8020265537335, -122.42010639829) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
28381 | 136612 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1697 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006706.3991 | 2116349.10339 | 37.7914700147761 | -122.420696089151 | (37.7914700147761, -122.420696089151) | 13 | 9 | 10 | 28858 | 21 | |||
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 | |||
31815 | 179630 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 290 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998313.80825 | 2088717.96768 | 37.7151251560878 | -122.447744166462 | (37.7151251560878, -122.447744166462) | 9 | 7 | 6 | 28861 | 25 | |||
32437 | 215229 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000677.32217 | 2094383.25488 | 37.7308155477923 | -122.439980842666 | (37.7308155477923, -122.439980842666) | 9 | 7 | 4 | 63 | 40 | |||
32605 | 179683 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 443 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6004745.82241 | 2092849.57746 | 37.7268351771866 | -122.425806252864 | (37.7268351771866, -122.425806252864) | 9 | 7 | 6 | 28861 | 5 | |||
33418 | 138663 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1722 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999590.4442 | 2114811.9884 | 37.7868458713434 | -122.44520652592 | (37.7868458713434, -122.44520652592) | 15 | 6 | 1 | 29490 | 31 | |||
35926 | 183756 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2279 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5987914.4572 | 2099809.712 | 37.7449803690211 | -122.484501430655 | (37.7449803690211, -122.484501430655) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
38361 | 215265 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 215 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001400.43873 | 2095135.77818 | 37.732922941738 | -122.437534787422 | (37.732922941738, -122.437534787422) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
39363 | 215200 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1201 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992335.9791 | 2098407.62605 | 37.7413870847351 | -122.469110721894 | (37.7413870847351, -122.469110721894) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
41588 | 215191 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1762 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993759.89754 | 2103496.87888 | 37.7554430521829 | -122.46455679518 | (37.7554430521829, -122.46455679518) | 1 | 8 | 4 | 56 | 12 | |||
42214 | 114819 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
46073 | 241023 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000036.33975 | 2101035.65516 | 37.7490449531781 | -122.442674291501 | (37.7490449531781, -122.442674291501) | 2 | 4 | 5 | 28862 | 22 | |||
48868 | 179640 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000461.77381 | 2090733.06087 | 37.7207806794643 | -122.440464330785 | (37.7207806794643, -122.440464330785) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
49845 | 215250 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 520 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5992758.1847 | 2090664.52836 | 37.7201508455634 | -122.467088069255 | (37.7201508455634, -122.467088069255) | 9 | 8 | 6 | 64 | 24 | |||
50470 | 218334 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 5993385.37112 | 2099847.32805 | 37.7454007221823 | -122.465586887647 | (37.7454007221823, -122.465586887647) | 1 | 8 | 4 | 29491 | 40 | |||
50822 | 179642 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001010.15104 | 2091331.02147 | 37.7224537539105 | -122.438611586159 | (37.7224537539105, -122.438611586159) | 9 | 7 | 6 | 28861 | 25 | |||
51738 | 215231 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 218 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6000116.88517 | 2094489.86017 | 37.7310763413011 | -122.441926006083 | (37.7310763413011, -122.441926006083) | 9 | 7 | 4 | 63 | 40 | |||
52812 | 179687 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6005637.05769 | 2094231.72899 | 37.7306805856367 | -122.422823456132 | (37.7306805856367, -122.422823456132) | 9 | 7 | 6 | 28861 | 5 | |||
53931 | 107421 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 171 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6004473.29404 | 2094351.78772 | 37.7309445078671 | -122.426855314741 | (37.7309445078671, -122.426855314741) | 9 | 7 | 6 | 28861 | 5 | ||||
56345 | 179632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5999581.03215 | 2090102.74199 | 37.7189997781048 | -122.443463521241 | (37.7189997781048, -122.443463521241) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
59836 | 215264 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2339 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5992605.31115 | 2099537.9854 | 37.7445063230134 | -122.468261685453 | (37.7445063230134, -122.468261685453) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
62461 | 241040 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 414 Eureka St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 6001479.48323 | 2103277.44524 | 37.7552825330657 | -122.437844443779 | (37.7552825330657, -122.437844443779) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
63580 | 215214 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 135 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 8ft | 5993392.86665 | 2095839.1505 | 37.7343957048025 | -122.465269879313 | (37.7343957048025, -122.465269879313) | 9 | 8 | 4 | 59 | 40 | |||
64042 | 215216 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 133 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 8ft | 5993391.28977 | 2095902.66034 | 37.7345699961108 | -122.465279942742 | (37.7345699961108, -122.465279942742) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
64441 | 215269 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 374 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5999594.91909 | 2094984.6499 | 37.7324051606602 | -122.443766060368 | (37.7324051606602, -122.443766060368) | 9 | 7 | 4 | 63 | 40 | ||||
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 | |||
66976 | 179686 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 122 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004194.37911 | 2094283.51005 | 37.7307412583927 | -122.427814706995 | (37.7307412583927, -122.427814706995) | 9 | 7 | 6 | 28861 | 5 | |||
67636 | 215240 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995902.13017 | 2090713.19411 | 37.7204654445931 | -122.456224088976 | (37.7204654445931, -122.456224088976) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
73005 | 49014 | Permitted Site 7 | Syzygium paniculatum :: Brush Cherry 243 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
74294 | 215227 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 123 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998457.66218 | 2098063.55011 | 37.7407941536181 | -122.447919396661 | (37.7407941536181, -122.447919396661) | 9 | 7 | 4 | 59 | 40 | |||
76109 | 120010 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 758 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5986965.57983 | 2110744.12081 | 37.7749479533293 | -122.488585949642 | (37.7749479533293, -122.488585949642) | 11 | 6 | 2 | 55 | 26 | |||
77192 | 182263 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1446 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984974.4693 | 2105337.6794 | 37.7599870046454 | -122.49507477448 | (37.7599870046454, -122.49507477448) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
81380 | 215206 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 160 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 8ft | 5993391.84031 | 2095665.55314 | 37.7339189903578 | -122.465260822253 | (37.7339189903578, -122.465260822253) | 9 | 8 | 4 | 59 | 40 | |||
84701 | 215271 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 320 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6000123.05752 | 2094800.74897 | 37.7319303213134 | -122.441926972846 | (37.7319303213134, -122.441926972846) | 9 | 7 | 4 | 63 | 40 | |||
87193 | 241016 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 42 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998455.64477 | 2106908.99141 | 37.7650814399822 | -122.448563264508 | (37.7650814399822, -122.448563264508) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
87703 | 245196 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 141 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001304.6046 | 2109213.22 | 37.7715707670273 | -122.438874572714 | (37.7715707670273, -122.438874572714) | 15 | 5 | 11 | 29492 | 9 | |||
90095 | 120001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 773 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986923.31758 | 2110672.03772 | 37.7747475672882 | -122.488726842297 | (37.7747475672882, -122.488726842297) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
91005 | 136619 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6006670.13205 | 2119511.58433 | 37.8001513503665 | -122.42104621681 | (37.8001513503665, -122.42104621681) | 5 | 9 | 1 | 28858 | 32 | |||
92917 | 215244 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 290 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5991718.94325 | 2090452.86708 | 37.7195096334551 | -122.470664935645 | (37.7195096334551, -122.470664935645) | 9 | 8 | 6 | 64 | 24 | |||
93809 | 215201 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 8ft | 5993358.68485 | 2095957.83636 | 37.7347196153991 | -122.465396674726 | (37.7347196153991, -122.465396674726) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
97469 | 179648 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001194.88831 | 2089176.29641 | 37.7165478709616 | -122.437818741162 | (37.7165478709616, -122.437818741162) | 9 | 7 | 6 | 28861 | 5 | |||
98440 | 215211 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 165 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 8ft | 5993424.83233 | 2095670.36736 | 37.7339341115572 | -122.465147109273 | (37.7339341115572, -122.465147109273) | 9 | 8 | 4 | 59 | 40 | |||
98884 | 43333 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 355 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 1 | Permit Number 43090 | 6003660.20851 | 2091489.47516 | 37.723039229671 | -122.429462239795 | (37.723039229671, -122.429462239795) | 9 | 7 | 6 | 28861 | 5 | |
101419 | 215270 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 549 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 5998461.49971 | 2094954.96465 | 37.732258938999 | -122.447682403734 | (37.732258938999, -122.447682403734) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
108058 | 136604 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 1 | Side Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | 13 | 9 | 1 | 57 | 17 | |||
108072 | 215225 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 39 | 5995372.41973 | 2092668.03741 | 37.7258025558202 | -122.458196526156 | (37.7258025558202, -122.458196526156) | 9 | 7 | 4 | 28861 | 40 | ||||
110001 | 136611 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1630 Bay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 1ft | 6002977.37772 | 2120668.13454 | 37.8031180797974 | -122.433907279317 | (37.8031180797974, -122.433907279317) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
110254 | 138682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1825 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001513.5804 | 2114720.8868 | 37.7867053138938 | -122.438546405155 | (37.7867053138938, -122.438546405155) | 13 | 6 | 1 | 29490 | 27 | |||
110633 | 136585 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6002071.0497 | 2118131.41015 | 37.7961014261857 | -122.436861939849 | (37.7961014261857, -122.436861939849) | 13 | 9 | 1 | 57 | 17 | |||
111968 | 120218 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 366 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5988110.64493 | 2113522.23122 | 37.7826426136883 | -122.484828820519 | (37.7826426136883, -122.484828820519) | 11 | 6 | 2 | 55 | 26 | |||
112482 | 15466 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2458 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006917.684 | 2104048.5382 | 37.7577075136236 | -122.419092174143 | (37.7577075136236, -122.419092174143) | 2 | 4 | 7 | 28859 | 19 | |||
113066 | 60783 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 5 | Permit Number 20453 | 5998776.2822 | 2112393.1221 | 37.7801577900357 | -122.447849117584 | (37.7801577900357, -122.447849117584) | 15 | 6 | 2 | 54 | 16 | |
117280 | 241015 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 211 13th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6006837.66171 | 2108488.60883 | 37.7698944011251 | -122.419683954356 | (37.7698944011251, -122.419683954356) | 8 | 4 | 7 | 28853 | 19 | |||
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 | ||||
118771 | 179794 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 640 Rolph St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6002828.72839 | 2087264.39121 | 37.7113909685913 | -122.432034933064 | (37.7113909685913, -122.432034933064) | 9 | 7 | 6 | 28861 | 5 | |||
119651 | 215208 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 170 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 8ft | 5993433.56613 | 2095587.28686 | 37.7337064967398 | -122.465110881879 | (37.7337064967398, -122.465110881879) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
120116 | 116009 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777954 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | |
120579 | 138530 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1650 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001636.2077 | 2114181.5211 | 37.7852313286636 | -122.438083494179 | (37.7852313286636, -122.438083494179) | 13 | 6 | 11 | 29490 | 13 | |||
123001 | 179644 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 900 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6001616.89073 | 2088831.6058 | 37.7156254147599 | -122.436335438935 | (37.7156254147599, -122.436335438935) | 9 | 7 | 6 | 28861 | 5 | |||
124036 | 136589 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3160 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999030.62414 | 2119679.22674 | 37.8001780449472 | -122.447493842871 | (37.8001780449472, -122.447493842871) | 13 | 9 | 1 | 57 | 17 | |||
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 |
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) );