trees
494 rows where qSpecies_id = 243 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194466 | 265098 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194464 | 265097 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194463 | 265099 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194453 | 265096 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194141 | 141558 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5998461.482 | 2110747.8394 | 37.77562227139 | -122.448819607803 | (37.77562227139, -122.448819607803) | 15 | 6 | 2 | 29492 | 16 | |||
| 193909 | 179652 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6002692.5092 | 2090562.96331 | 37.7204403975978 | -122.43274122465 | (37.7204403975978, -122.43274122465) | 9 | 7 | 6 | 28861 | 5 | |||
| 193630 | 179766 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6004833.34204 | 2094364.45804 | 37.7309996489081 | -122.425611469595 | (37.7309996489081, -122.425611469595) | 9 | 7 | 6 | 28861 | 5 | |||
| 193197 | 179745 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6004892.21375 | 2094355.84181 | 37.7309793170417 | -122.425407327082 | (37.7309793170417, -122.425407327082) | 9 | 7 | 6 | 28861 | 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 | |||
| 192454 | 179670 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 300x Winding Way | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6001487.80324 | 2086473.73507 | 37.7091438874604 | -122.436612949055 | (37.7091438874604, -122.436612949055) | 9 | 7 | 6 | 28861 | 5 | |||
| 192428 | 215221 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1992 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993500.77479 | 2101935.78141 | 37.7511417387208 | -122.465339521014 | (37.7511417387208, -122.465339521014) | 1 | 8 | 4 | 29491 | 12 | |||
| 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 | |||
| 191753 | 179722 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004969.27594 | 2094359.70074 | 37.7309942664601 | -122.425141184436 | (37.7309942664601, -122.425141184436) | 9 | 7 | 6 | 28861 | 5 | |||
| 191245 | 215198 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992537.09615 | 2098513.66333 | 37.7416898549923 | -122.468423048099 | (37.7416898549923, -122.468423048099) | 1 | 8 | 4 | 59 | 40 | |||
| 191226 | 15998 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 236 Moncada Way | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | 9 | 8 | 4 | 59 | 40 | |||
| 191117 | 179772 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6004808.00576 | 2094366.06815 | 37.7310026382465 | -122.425699176002 | (37.7310026382465, -122.425699176002) | 9 | 7 | 6 | 28861 | 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 | |||
| 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 | |||
| 189136 | 215199 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992542.93884 | 2098523.05362 | 37.7417159758263 | -122.468403529221 | (37.7417159758263, -122.468403529221) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 188466 | 179788 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6004749.24947 | 2094369.67329 | 37.7310092167933 | -122.425902563064 | (37.7310092167933, -122.425902563064) | 9 | 7 | 6 | 28861 | 5 | ||||
| 188045 | 114839 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 21 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 187375 | 136621 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6006671.45973 | 2119496.74342 | 37.8001106758244 | -122.421040568183 | (37.8001106758244, -122.421040568183) | 13 | 9 | 1 | 28858 | 32 | |||
| 187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 186742 | 215274 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 179 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998891.68338 | 2093773.04721 | 37.7290382481968 | -122.446110182837 | (37.7290382481968, -122.446110182837) | 9 | 7 | 4 | 28861 | 40 | |||
| 186099 | 179795 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 433 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002164.81137 | 2087709.16432 | 37.7125745555472 | -122.434361376687 | (37.7125745555472, -122.434361376687) | 9 | 7 | 6 | 28861 | 5 | |||
| 185973 | 215197 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992535.60295 | 2098504.61357 | 37.7416649203974 | -122.468427552786 | (37.7416649203974, -122.468427552786) | 1 | 8 | 4 | 59 | 40 | |||
| 185638 | 119518 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5986356.81834 | 2110650.14553 | 37.7746543822833 | -122.490684840834 | (37.7746543822833, -122.490684840834) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 184740 | 179655 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6002626.5609 | 2090458.35615 | 37.7201494291437 | -122.432961716828 | (37.7201494291437, -122.432961716828) | 9 | 7 | 6 | 28861 | 5 | |||
| 184718 | 179691 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 425 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6005621.06817 | 2093204.80728 | 37.7278599825272 | -122.422805780863 | (37.7278599825272, -122.422805780863) | 9 | 7 | 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 | |||
| 184221 | 179674 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 31 Camellia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6003165.85678 | 2093941.30056 | 37.729743391347 | -122.431346048804 | (37.729743391347, -122.431346048804) | 9 | 7 | 6 | 28861 | 25 | |||
| 184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 184182 | 241045 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 313 Virginia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6006931.5072 | 2098259.45718 | 37.7418127905307 | -122.418633848399 | (37.7418127905307, -122.418633848399) | 2 | 7 | 7 | 28859 | 2 | |||
| 183820 | 179771 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6004812.59198 | 2094365.75596 | 37.7310020401985 | -122.425683298443 | (37.7310020401985, -122.425683298443) | 9 | 7 | 6 | 28861 | 5 | |||
| 183157 | 215275 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 179 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998891.54397 | 2093771.08493 | 37.7290328522742 | -122.446110523698 | (37.7290328522742, -122.446110523698) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 182265 | 114835 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 17 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 182055 | 114829 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 181727 | 179765 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 6004837.08963 | 2094365.90524 | 37.7310038343548 | -122.425598616496 | (37.7310038343548, -122.425598616496) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 181469 | 11660 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991300.56902 | 2093059.05917 | 37.7266413894798 | -122.472300971514 | (37.7266413894798, -122.472300971514) | 9 | 8 | 4 | 64 | 40 | ||
| 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 | |||||
| 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 | |||
| 180252 | 241019 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6008974.79401 | 2096823.76777 | 37.7379855268132 | -122.411467400123 | (37.7379855268132, -122.411467400123) | 10 | 7 | 7 | 28859 | 2 | |||
| 180212 | 141562 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Loyola Ter | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998458.1613 | 2110776.3029 | 37.7757002349295 | -122.448833145551 | (37.7757002349295, -122.448833145551) | 15 | 6 | 2 | 29492 | 16 | |||
| 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 | |||
| 179996 | 58736 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 222 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1979 12:00:00 AM | 13 | Permit Number 17973 | 5996179.66894 | 2115408.17618 | 37.7882875667675 | -122.45705008391 | (37.7882875667675, -122.45705008391) | 11 | 6 | 1 | 54 | 31 | ||
| 179505 | 179756 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004864.30812 | 2094360.11842 | 37.7309894829744 | -122.425504105834 | (37.7309894829744, -122.425504105834) | 9 | 7 | 6 | 28861 | 5 | |||
| 179257 | 179635 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 9 Moneta Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997908.32309 | 2088048.3986 | 37.7132634892865 | -122.449097484276 | (37.7132634892865, -122.449097484276) | 9 | 7 | 6 | 28861 | 25 | ||||
| 179206 | 114833 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 15 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 178919 | 136592 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3751 Broderick St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999587.94478 | 2121442.35116 | 37.8050509432145 | -122.445692167157 | (37.8050509432145, -122.445692167157) | 13 | 9 | 1 | 57 | 17 | |||
| 178799 | 114836 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 18 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 178668 | 215277 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 179 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998891.61444 | 2093764.99238 | 37.7290161275829 | -122.446109842022 | (37.7290161275829, -122.446109842022) | 9 | 7 | 4 | 28861 | 40 | |||
| 178639 | 179775 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6004797.54841 | 2094368.02582 | 37.7310074226448 | -122.425735468137 | (37.7310074226448, -122.425735468137) | 9 | 7 | 6 | 28861 | 5 | |||
| 178275 | 215235 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 381 Flood Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998190.87613 | 2094065.96143 | 37.7298024758798 | -122.448554004172 | (37.7298024758798, -122.448554004172) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 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 | |||
| 178115 | 215268 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 441 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6000072.9793 | 2095175.00854 | 37.7329550970048 | -122.442126958714 | (37.7329550970048, -122.442126958714) | 9 | 7 | 4 | 63 | 40 | |||
| 177744 | 179639 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 286 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998303.30516 | 2088729.74058 | 37.7151568814675 | -122.447781316552 | (37.7151568814675, -122.447781316552) | 9 | 7 | 6 | 28861 | 25 | |||
| 175975 | 215249 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5992441.12756 | 2089702.71282 | 37.717491627621 | -122.468114091393 | (37.717491627621, -122.468114091393) | 9 | 8 | 6 | 64 | 24 | |||
| 175652 | 241037 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1548 Noe St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6003281.94941 | 2099246.09898 | 37.7443157332832 | -122.431323226696 | (37.7443157332832, -122.431323226696) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 175281 | 183187 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2466 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5985214.3495 | 2098428.6608 | 37.7410307702747 | -122.493736028931 | (37.7410307702747, -122.493736028931) | 1 | 8 | 3 | 29491 | 35 | |||
| 175068 | 179730 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004936.64946 | 2094357.75866 | 37.7309870907696 | -122.425253841613 | (37.7309870907696, -122.425253841613) | 9 | 7 | 6 | 28861 | 5 | |||
| 174952 | 179685 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.428804976589 | (37.7255988638766, -122.428804976589) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 174765 | 179789 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6004745.29663 | 2094368.88342 | 37.7310068245956 | -122.425916172505 | (37.7310068245956, -122.425916172505) | 9 | 7 | 6 | 28861 | 5 | ||||
| 173993 | 136595 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3801 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000087.86823 | 2121359.44111 | 37.804851824321 | -122.443956168945 | (37.804851824321, -122.443956168945) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 172995 | 183731 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2271 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5987911.47 | 2099859.2137 | 37.7451161136106 | -122.484515389918 | (37.7451161136106, -122.484515389918) | 1 | 8 | 3 | 29491 | 35 | |||
| 172489 | 136588 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3130 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999060.51104 | 2119533.48952 | 37.7997795976177 | -122.447379927554 | (37.7997795976177, -122.447379927554) | 13 | 9 | 1 | 57 | 17 | |||
| 171454 | 179767 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6004828.96528 | 2094364.3303 | 37.7309990508516 | -122.425626591714 | (37.7309990508516, -122.425626591714) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 171116 | 11684 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 24 | 2X2 | 5991290.8523 | 2092837.83415 | 37.7260333983166 | -122.472318441749 | (37.7260333983166, -122.472318441749) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 170579 | 256058 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 1983 21st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5989689 | 2101877 | 37.7507597758645 | -122.478516596828 | (37.7507597758645, -122.478516596828) | 1 | 8 | 3 | 29491 | 35 | ||||
| 170109 | 179721 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004972.55508 | 2094359.63328 | 37.7309942664727 | -122.42512984309 | (37.7309942664727, -122.42512984309) | 9 | 7 | 6 | 28861 | 5 | |||
| 169373 | 241017 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 833 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999113.42542 | 2107452.79441 | 37.7666121751429 | -122.446327294483 | (37.7666121751429, -122.446327294483) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||||
| 168914 | 215248 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992441.33528 | 2089712.58876 | 37.717518756553 | -122.468114091406 | (37.717518756553, -122.468114091406) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 167959 | 215280 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 179 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998891.37293 | 2093758.12057 | 37.72899724541 | -122.446110182852 | (37.72899724541, -122.446110182852) | 9 | 7 | 4 | 28861 | 40 | |||
| 167878 | 29579 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991348.44459 | 2093803.51532 | 37.7286882509598 | -122.472189710993 | (37.7286882509598, -122.472189710993) | 9 | 8 | 4 | 64 | 40 | ||
| 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 | |||
| 167069 | 179673 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009280.11553 | 2087236.74684 | 37.7116787066663 | -122.40973523929 | (37.7116787066663, -122.40973523929) | 9 | 7 | 8 | 309 | 39 | |||
| 167035 | 241030 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 683 Duncan St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6002109.55625 | 2099702.6656 | 37.7455028455847 | -122.435409761357 | (37.7455028455847, -122.435409761357) | 2 | 7 | 5 | 63 | 22 | |||
| 167017 | 19344 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 526 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 5992574.47288 | 2089868.50561 | 37.7179545545446 | -122.467665232592 | (37.7179545545446, -122.467665232592) | 9 | 8 | 6 | 64 | 24 | |||
| 166340 | 179634 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 256 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999057.74482 | 2088126.56922 | 37.7135438016737 | -122.445130318423 | (37.7135438016737, -122.445130318423) | 9 | 7 | 6 | 28861 | 25 | |||
| 165876 | 179768 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6004827.00692 | 2094364.80622 | 37.7310002469633 | -122.425633395959 | (37.7310002469633, -122.425633395959) | 9 | 7 | 6 | 28861 | 5 | |||
| 165620 | 139522 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 715 CENTRAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999600.0854 | 2110958.1291 | 37.7762647192657 | -122.444896033282 | (37.7762647192657, -122.444896033282) | 15 | 5 | 11 | 29492 | 16 | |||
| 165582 | 179653 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002670.92192 | 2090527.15665 | 37.7203408561316 | -122.432813288222 | (37.7203408561316, -122.432813288222) | 9 | 7 | 6 | 28861 | 5 | |||
| 165463 | 179672 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6009276.50354 | 2087227.45755 | 37.7116529977608 | -122.409747068083 | (37.7116529977608, -122.409747068083) | 9 | 7 | 8 | 309 | 39 | |||
| 165036 | 241039 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 408 Eureka St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 6001479.32408 | 2103282.80695 | 37.7552972459781 | -122.437845378173 | (37.7552972459781, -122.437845378173) | 2 | 4 | 5 | 28862 | 22 | |||
| 164912 | 15992 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 236 Moncada Way | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | 9 | 8 | 4 | 59 | 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 |
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) );