trees
494 rows where qSpecies_id = 243 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159110 | 241024 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001778.75794 | 2099104.03201 | 37.7438403462637 | -122.436510768958 | (37.7438403462637, -122.436510768958) | 2 | 7 | 5 | 63 | 22 | |||
178251 | 241025 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001786.88467 | 2099119.61673 | 37.7438836000387 | -122.436483783902 | (37.7438836000387, -122.436483783902) | 2 | 7 | 5 | 63 | 22 | |||
60095 | 215238 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 De Montfort Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995012.54401 | 2091916.70112 | 37.7237188814963 | -122.459386194316 | (37.7237188814963, -122.459386194316) | 9 | 8 | 4 | 28861 | 24 | |||
130954 | 215237 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 De Montfort Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995021.72102 | 2091916.50896 | 37.7237188815105 | -122.459354457259 | (37.7237188815105, -122.459354457259) | 9 | 8 | 4 | 28861 | 24 | |||
62986 | 141667 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 EWING TER | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998723.4884 | 2112384.3231 | 37.7801306125765 | -122.448031120952 | (37.7801306125765, -122.448031120952) | 15 | 6 | 2 | 54 | 16 | |||
150970 | 141666 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 EWING TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998741.7631 | 2112389.0611 | 37.7801446665071 | -122.447968241937 | (37.7801446665071, -122.447968241937) | 15 | 6 | 2 | 54 | 16 | |||
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 | |
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 | |||
2950 | 19885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
15870 | 19880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
6530 | 20001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
93746 | 215202 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 5993358.65821 | 2095928.85229 | 37.7346400308107 | -122.465394662057 | (37.7346400308107, -122.465394662057) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
181680 | 112452 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004875.37651 | 2091205.89933 | 37.7223293183158 | -122.42524147682 | (37.7223293183158, -122.42524147682) | 9 | 7 | 6 | 28861 | 5 | |||
192062 | 179719 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6004873.15059 | 2091207.68365 | 37.7223340919162 | -122.425249298216 | (37.7223340919162, -122.425249298216) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
52219 | 136618 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1075 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6006192.10858 | 2120703.43748 | 37.8033969172965 | -122.422785114443 | (37.8033969172965, -122.422785114443) | 5 | 9 | 1 | 28858 | 32 | |||
174836 | 136617 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.8033855300671 | -122.422870825248 | (37.8033855300671, -122.422870825248) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |||
168432 | 215230 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 110 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6000656.28267 | 2094383.33572 | 37.7308145720257 | -122.440053585198 | (37.7308145720257, -122.440053585198) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
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 | |||
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 | |||
34112 | 179641 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000468.15764 | 2090746.71388 | 37.72081853103 | -122.440443242589 | (37.72081853103, -122.440443242589) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | ||||
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 | |||
173403 | 59077 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1116 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | 6 | Permit Number 24969 | 5992117.03655 | 2111383.31137 | 37.7770022506148 | -122.470812695486 | (37.7770022506148, -122.470812695486) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
184779 | 179677 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1179 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003439.24777 | 2094263.07878 | 37.7306424121193 | -122.430423856102 | (37.7306424121193, -122.430423856102) | 9 | 7 | 6 | 28861 | 25 | |||
59168 | 179676 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1183 Alemany Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6003413.3537 | 2094255.00486 | 37.7306187761143 | -122.430512799925 | (37.7306187761143, -122.430512799925) | 9 | 7 | 6 | 28861 | 25 | |||
114702 | 179675 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1183 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6003399.47661 | 2094250.78207 | 37.7306063951513 | -122.430560473899 | (37.7306063951513, -122.430560473899) | 9 | 7 | 6 | 28861 | 25 | |||
36253 | 16409 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | TR | 6001094.97043 | 2087182.82135 | 37.7110685499383 | -122.438021394384 | (37.7110685499383, -122.438021394384) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
44118 | 179637 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 120 Farragut Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997385.09042 | 2087337.68892 | 37.7112821038472 | -122.450854733483 | (37.7112821038472, -122.450854733483) | 9 | 7 | 6 | 28861 | 25 | |||
75341 | 215204 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 120 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 5993362.71827 | 2095845.00098 | 37.734410030101 | -122.465374536105 | (37.734410030101, -122.465374536105) | 9 | 8 | 4 | 59 | 40 | |||
178207 | 215203 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 120 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 5993362.10241 | 2095871.10021 | 37.7344816565847 | -122.465378560574 | (37.7344816565847, -122.465378560574) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
106609 | 186774 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984836.1288 | 2106787.9137 | 37.7639608421308 | -122.495660191684 | (37.7639608421308, -122.495660191684) | 1 | 8 | 3 | 56 | 35 | |||
139085 | 186773 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984840.0098 | 2106777.241 | 37.7639317651664 | -122.495645981391 | (37.7639317651664, -122.495645981391) | 1 | 8 | 3 | 56 | 35 | |||
149301 | 186775 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984844.3759 | 2106784.0328 | 37.7639506692175 | -122.495631381575 | (37.7639506692175, -122.495631381575) | 1 | 8 | 3 | 56 | 35 | |||
180069 | 186776 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984864.7511 | 2106787.9137 | 37.7639625182145 | -122.495561197148 | (37.7639625182145, -122.495561197148) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
161904 | 215236 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1209 Capitol Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995030.61507 | 2091933.03172 | 37.7237647604077 | -122.459324908221 | (37.7237647604077, -122.459324908221) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
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 | |||
81133 | 215222 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 123 Ortega St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5993571.89199 | 2102535.20203 | 37.7527916952033 | -122.465137125003 | (37.7527916952033, -122.465137125003) | 1 | 8 | 4 | 29491 | 12 | |||
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 | |||
126012 | 181764 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1230 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5984924.827 | 2106794.9057 | 37.7639852339774 | -122.495353931274 | (37.7639852339774, -122.495353931274) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
120960 | 215205 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 130 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 8ft | 5993367.47996 | 2095754.56333 | 37.7341619853887 | -122.465351506265 | (37.7341619853887, -122.465351506265) | 9 | 8 | 4 | 59 | 40 | |||
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 | |
128428 | 241018 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1312 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997804.09627 | 2106075.19943 | 37.7627547823317 | -122.45075667768 | (37.7627547823317, -122.45075667768) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
71495 | 215218 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 133 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 8ft | 5993390.45214 | 2095959.7776 | 37.7347267776093 | -122.465286986206 | (37.7347267776093, -122.465286986206) | 9 | 8 | 4 | 59 | 40 | |||
150158 | 215217 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 133 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5993392.21356 | 2095932.78503 | 37.7346527642991 | -122.465278936386 | (37.7346527642991, -122.465278936386) | 9 | 8 | 4 | 59 | 40 | |||
61513 | 215194 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1338 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991837.99672 | 2098448.19702 | 37.7414696955783 | -122.47083551005 | (37.7414696955783, -122.47083551005) | 1 | 8 | 4 | 29491 | 40 | |||
164644 | 215195 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1338 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991851.77667 | 2098448.73773 | 37.7414719771425 | -122.470787903551 | (37.7414719771425, -122.470787903551) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
175618 | 215215 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 135 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 8ft | 5993391.65148 | 2095878.30563 | 37.7345031449868 | -122.465276923713 | (37.7345031449868, -122.465276923713) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
136258 | 179684 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 141 Lisbon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6003403.73924 | 2092580.98204 | 37.7260217403927 | -122.430426643075 | (37.7260217403927, -122.430426643075) | 9 | 7 | 6 | 28861 | 5 | |||
133513 | 215189 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1417 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5991114.02824 | 2105768.56149 | 37.7615276079382 | -122.473872651923 | (37.7615276079382, -122.473872651923) | 1 | 8 | 4 | 56 | 12 | |||
104523 | 215267 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 144 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6000534.40963 | 2095247.93227 | 37.7331816146194 | -122.440536906955 | (37.7331816146194, -122.440536906955) | 9 | 7 | 5 | 63 | 40 | |||
152495 | 215266 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 144 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6000556.38371 | 2095246.8523 | 37.7331799005214 | -122.440460859392 | (37.7331799005214, -122.440460859392) | 9 | 7 | 5 | 63 | 40 | |||
31356 | 106089 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 1446 36TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x6 | 5984998.6 | 2105346.4 | 37.7600123616364 | -122.494991962302 | (37.7600123616364, -122.494991962302) | 1 | 8 | 3 | 56 | 35 | |||
167536 | 106088 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 1446 36TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x10 | 5984998.6 | 2105346.4 | 37.7600123616364 | -122.494991962302 | (37.7600123616364, -122.494991962302) | 1 | 8 | 3 | 56 | 35 | |||
72321 | 182264 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1446 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5984975.2043 | 2105354.9525 | 37.7600344747925 | -122.495073506222 | (37.7600344747925, -122.495073506222) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
159946 | 136603 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1490 Jefferson St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002078.64435 | 2121585.74714 | 37.8055865587436 | -122.437083100219 | (37.8055865587436, -122.437083100219) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );