trees
494 rows where qSpecies_id = 243 sorted by Police Districts
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 | |||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 44306 | 136626 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006933.58689 | 2120186.44007 | 37.8020191811091 | -122.420182480954 | (37.8020191811091, -122.420182480954) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 87445 | 136625 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006949.37366 | 2120187.56184 | 37.8020231507021 | -122.420127930783 | (37.8020231507021, -122.420127930783) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 170614 | 136627 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6006926.93981 | 2120185.95678 | 37.8020174795836 | -122.420205448732 | (37.8020174795836, -122.420205448732) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 47988 | 241042 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 414 Eureka St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 6001480.46567 | 2103259.11131 | 37.7552322483814 | -122.437839733137 | (37.7552322483814, -122.437839733137) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 79340 | 241041 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 414 Eureka St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6001479.97445 | 2103268.27828 | 37.7552573907374 | -122.437842088457 | (37.7552573907374, -122.437842088457) | 2 | 4 | 5 | 28862 | 22 | |||
| 87023 | 246330 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1735 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6006778.1145 | 2108370.5185 | 37.7695667985634 | -122.419881546362 | (37.7695667985634, -122.419881546362) | 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 | |||
| 91262 | 241048 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 584 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001829.41799 | 2102418.84341 | 37.7529449108818 | -122.436572814083 | (37.7529449108818, -122.436572814083) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 |
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) );