trees
494 rows where qSpecies_id = 243
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49651 | 136601 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1900 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000030.07826 | 2121297.63981 | 37.8046788379311 | -122.444151713048 | (37.8046788379311, -122.444151713048) | 13 | 9 | 1 | 57 | 17 | |||
49845 | 215250 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 520 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5992758.1847 | 2090664.52836 | 37.7201508455634 | -122.467088069255 | (37.7201508455634, -122.467088069255) | 9 | 8 | 6 | 64 | 24 | |||
50470 | 218334 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 5993385.37112 | 2099847.32805 | 37.7454007221823 | -122.465586887647 | (37.7454007221823, -122.465586887647) | 1 | 8 | 4 | 29491 | 40 | |||
50773 | 119519 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986356.00779 | 2110632.67523 | 37.7746063664364 | -122.490686358973 | (37.7746063664364, -122.490686358973) | 11 | 6 | 2 | 55 | 26 | |||
50822 | 179642 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001010.15104 | 2091331.02147 | 37.7224537539105 | -122.438611586159 | (37.7224537539105, -122.438611586159) | 9 | 7 | 6 | 28861 | 25 | |||
51201 | 179728 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6004946.07219 | 2094358.65382 | 37.7309900810101 | -122.4252213293 | (37.7309900810101, -122.4252213293) | 9 | 7 | 6 | 28861 | 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 | |||
51738 | 215231 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 218 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6000116.88517 | 2094489.86017 | 37.7310763413011 | -122.441926006083 | (37.7310763413011, -122.441926006083) | 9 | 7 | 4 | 63 | 40 | |||
51759 | 114834 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
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 | |||
52812 | 179687 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6005637.05769 | 2094231.72899 | 37.7306805856367 | -122.422823456132 | (37.7306805856367, -122.422823456132) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
53302 | 187374 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2200 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985054.3016 | 2099973.6311 | 37.7452634762418 | -122.49440326645 | (37.7452634762418, -122.49440326645) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
53673 | 179643 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001011.57815 | 2091346.43493 | 37.7224961569611 | -122.43860775684 | (37.7224961569611, -122.43860775684) | 9 | 7 | 6 | 28861 | 25 | |||
53931 | 107421 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 171 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6004473.29404 | 2094351.78772 | 37.7309445078671 | -122.426855314741 | (37.7309445078671, -122.426855314741) | 9 | 7 | 6 | 28861 | 5 | ||||
54191 | 215255 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 4 | : | Tree | Private 2 | 10 | Width 0ft | 5991357.82029 | 2093790.09293 | 37.7286519390174 | -122.472156320955 | (37.7286519390174, -122.472156320955) | 9 | 8 | 4 | 64 | 40 | |||
54262 | 179733 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6004930.36809 | 2094360.71906 | 37.7309948645031 | -122.425275767962 | (37.7309948645031, -122.425275767962) | 9 | 7 | 6 | 28861 | 5 | |||
54266 | 11706 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 23 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991285.17012 | 2092766.35209 | 37.7258367975107 | -122.472332875884 | (37.7258367975107, -122.472332875884) | 9 | 8 | 4 | 64 | 40 | ||
54834 | 114822 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
54934 | 215261 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 67 | : | Tree | Private 2 | 2 | Width 0ft | 5991310.9639 | 2093247.25826 | 37.7271587388628 | -122.472278750178 | (37.7271587388628, -122.472278750178) | 9 | 8 | 4 | 64 | 40 | |||
55198 | 136607 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 4 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6002552.02607 | 2121667.51893 | 37.8058379785924 | -122.435450751546 | (37.8058379785924, -122.435450751546) | 13 | 9 | 1 | 57 | 17 | |||
55212 | 179731 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004933.37032 | 2094357.82613 | 37.7309870907725 | -122.425265182959 | (37.7309870907725, -122.425265182959) | 9 | 7 | 6 | 28861 | 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 | |||
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 | |||
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 | |||
57176 | 179746 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6004890.51437 | 2094358.27232 | 37.7309858946676 | -122.425413375028 | (37.7309858946676, -122.425413375028) | 9 | 7 | 6 | 28861 | 5 | |||
57655 | 179693 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 452 Pioche St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005528.42595 | 2093233.45059 | 37.7279334031803 | -122.423128082618 | (37.7279334031803, -122.423128082618) | 9 | 7 | 7 | 309 | 5 | |||
57970 | 241020 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | 6008973.83234 | 2096817.19459 | 37.7379674243488 | -122.411470260845 | (37.7379674243488, -122.411470260845) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
59476 | 215247 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992441.17613 | 2089717.25616 | 37.7175315629099 | -122.468114980839 | (37.7175315629099, -122.468114980839) | 9 | 8 | 6 | 64 | 24 | |||
59836 | 215264 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2339 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5992605.31115 | 2099537.9854 | 37.7445063230134 | -122.468261685453 | (37.7445063230134, -122.468261685453) | 1 | 8 | 4 | 29491 | 40 | |||
59878 | 179712 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 81 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008198.62587 | 2093898.01777 | 37.7299084861863 | -122.413944094353 | (37.7299084861863, -122.413944094353) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
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 | |||
60830 | 179647 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001184.8946 | 2089159.50887 | 37.7165012078479 | -122.43785208261 | (37.7165012078479, -122.43785208261) | 9 | 7 | 6 | 28861 | 5 | |||
61036 | 179682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.7264783171962 | -122.44073930839 | (37.7264783171962, -122.44073930839) | 9 | 7 | 6 | 28861 | 25 | |||
61277 | 215209 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 170 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5993450.93036 | 2095568.66163 | 37.7336563577529 | -122.465049496831 | (37.7336563577529, -122.465049496831) | 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 | |||
61799 | 114838 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 20 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
62491 | 179785 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6004765.43097 | 2094369.55773 | 37.7310098139557 | -122.425846612625 | (37.7310098139557, -122.425846612625) | 9 | 7 | 6 | 28861 | 5 | ||||
62675 | 179707 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Dunsmuir St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 2ft | 6008087.26111 | 2094229.35305 | 37.7308120062462 | -122.414352531355 | (37.7308120062462, -122.414352531355) | 9 | 3 | 7 | 309 | 28 | |||
62698 | 249782 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.8048533324903 | -122.407973043817 | (37.8048533324903, -122.407973043817) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
63574 | 15994 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 236 Moncada Way | 7 | 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 | |||
63580 | 215214 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 135 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 8ft | 5993392.86665 | 2095839.1505 | 37.7343957048025 | -122.465269879313 | (37.7343957048025, -122.465269879313) | 9 | 8 | 4 | 59 | 40 | |||
64042 | 215216 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 133 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 8ft | 5993391.28977 | 2095902.66034 | 37.7345699961108 | -122.465279942742 | (37.7345699961108, -122.465279942742) | 9 | 8 | 4 | 59 | 40 | |||
64047 | 136628 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6007442.68945 | 2119347.67651 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | 5 | 1 | 1 | 28858 | 32 | |||
64370 | 122249 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1600 Clement St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990532.83595 | 2113421.55221 | 37.7825069529614 | -122.476441807648 | (37.7825069529614, -122.476441807648) | 11 | 6 | 2 | 55 | 26 | |||
64441 | 215269 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 374 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5999594.91909 | 2094984.6499 | 37.7324051606602 | -122.443766060368 | (37.7324051606602, -122.443766060368) | 9 | 7 | 4 | 63 | 40 | ||||
64480 | 136608 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 5 | Side Yard : Yard | Tree | Private 2 | 14 | Width 4ft | 6002554.72948 | 2121670.19367 | 37.8058454762555 | -122.435441587454 | (37.8058454762555, -122.435441587454) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||||
66085 | 179654 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002647.12563 | 2090489.8461 | 37.7202370599795 | -122.432892880025 | (37.7202370599795, -122.432892880025) | 9 | 7 | 6 | 28861 | 5 | |||
66160 | 215233 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 381 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998173.02333 | 2094066.33321 | 37.7298024758896 | -122.448615749812 | (37.7298024758896, -122.448615749812) | 9 | 7 | 4 | 28861 | 40 | |||
66308 | 179786 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6004760.18002 | 2094369.44832 | 37.7310092167964 | -122.425864758274 | (37.7310092167964, -122.425864758274) | 9 | 7 | 6 | 28861 | 5 | ||||
66976 | 179686 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 122 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004194.37911 | 2094283.51005 | 37.7307412583927 | -122.427814706995 | (37.7307412583927, -122.427814706995) | 9 | 7 | 6 | 28861 | 5 | |||
67636 | 215240 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995902.13017 | 2090713.19411 | 37.7204654445931 | -122.456224088976 | (37.7204654445931, -122.456224088976) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
69756 | 179735 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.425302986837 | (37.7309858946841, -122.425302986837) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
72318 | 179757 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004862.37214 | 2094361.68258 | 37.7309936684225 | -122.425510910124 | (37.7309936684225, -122.425510910124) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
73005 | 49014 | Permitted Site 7 | Syzygium paniculatum :: Brush Cherry 243 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
74294 | 215227 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 123 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998457.66218 | 2098063.55011 | 37.7407941536181 | -122.447919396661 | (37.7407941536181, -122.447919396661) | 9 | 7 | 4 | 59 | 40 | |||
74338 | 179762 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6004847.12334 | 2094364.61005 | 37.7310008449997 | -122.425563836098 | (37.7310008449997, -122.425563836098) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
75858 | 241028 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 683 Duncan St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6002098.89319 | 2099701.56162 | 37.7454992087268 | -122.435446553535 | (37.7454992087268, -122.435446553535) | 2 | 7 | 5 | 63 | 22 | |||
76109 | 120010 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 758 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5986965.57983 | 2110744.12081 | 37.7749479533293 | -122.488585949642 | (37.7749479533293, -122.488585949642) | 11 | 6 | 2 | 55 | 26 | |||
77192 | 182263 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1446 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984974.4693 | 2105337.6794 | 37.7599870046454 | -122.49507477448 | (37.7599870046454, -122.49507477448) | 1 | 8 | 3 | 56 | 35 | |||
77777 | 11682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991292.04747 | 2092854.58417 | 37.7260794588728 | -122.472315530658 | (37.7260794588728, -122.472315530658) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
78247 | 215263 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 70 | : | Tree | Private 2 | 12 | Width 0ft | 5991309.89761 | 2093234.85711 | 37.7271246266868 | -122.472281532683 | (37.7271246266868, -122.472281532683) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
79343 | 136600 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2298 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999337.17722 | 2120854.21997 | 37.8034217736525 | -122.44651763509 | (37.8034217736525, -122.44651763509) | 13 | 9 | 1 | 57 | 17 | |||
79603 | 241031 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 683 Duncan St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6002114.87421 | 2099702.55561 | 37.7455028455972 | -122.435391364845 | (37.7455028455972, -122.435391364845) | 2 | 7 | 5 | 63 | 22 | |||
79733 | 179646 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6001175.91542 | 2089143.93183 | 37.7164579261785 | -122.437882003961 | (37.7164579261785, -122.437882003961) | 9 | 7 | 6 | 28861 | 5 | |||
79817 | 179744 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004895.55112 | 2094358.6043 | 37.730987090783 | -122.425395985741 | (37.730987090783, -122.425395985741) | 9 | 7 | 6 | 28861 | 5 | |||
79852 | 114825 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
80003 | 136587 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 1ft | 6002061.91311 | 2118175.42459 | 37.7962217590896 | -122.436896706732 | (37.7962217590896, -122.436896706732) | 13 | 9 | 1 | 57 | 17 | |||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
81066 | 215219 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 450 Wildwood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5995190.90463 | 2093339.70409 | 37.7276363589212 | -122.458872613985 | (37.7276363589212, -122.458872613985) | 9 | 7 | 4 | 28861 | 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 | |||
81380 | 215206 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 160 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 8ft | 5993391.84031 | 2095665.55314 | 37.7339189903578 | -122.465260822253 | (37.7339189903578, -122.465260822253) | 9 | 8 | 4 | 59 | 40 | |||
82001 | 179783 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6004773.76056 | 2094370.47533 | 37.7310128042003 | -122.425817881095 | (37.7310128042003, -122.425817881095) | 9 | 7 | 6 | 28861 | 5 | ||||
82960 | 215243 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 284 Thrift St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 5994231.73056 | 2089665.25289 | 37.7174920206045 | -122.461922130513 | (37.7174920206045, -122.461922130513) | 9 | 8 | 6 | 28861 | 24 | ||||
83517 | 179651 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002715.97514 | 2090599.35086 | 37.7205416405563 | -122.432662708433 | (37.7205416405563, -122.432662708433) | 9 | 7 | 6 | 28861 | 5 | |||
83662 | 136620 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6006670.95016 | 2119505.50719 | 37.800134710195 | -122.421042954093 | (37.800134710195, -122.421042954093) | 13 | 9 | 1 | 28858 | 32 | |||
84400 | 179726 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004958.10458 | 2094358.84188 | 37.730991277129 | -122.425179744649 | (37.730991277129, -122.425179744649) | 9 | 7 | 6 | 28861 | 5 | |||
84414 | 241029 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 683 Duncan St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6002103.95616 | 2099701.98684 | 37.7455006638242 | -122.435429077017 | (37.7455006638242, -122.435429077017) | 2 | 7 | 5 | 63 | 22 | |||
84701 | 215271 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 320 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6000123.05752 | 2094800.74897 | 37.7319303213134 | -122.441926972846 | (37.7319303213134, -122.441926972846) | 9 | 7 | 4 | 63 | 40 | |||
84945 | 179689 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6005644.40282 | 2094230.12153 | 37.7306765863412 | -122.42279794866 | (37.7306765863412, -122.42279794866) | 9 | 7 | 6 | 28861 | 5 | |||
85082 | 141561 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Loyola Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998458.6357 | 2110769.1871 | 37.7756807239054 | -122.448830991825 | (37.7756807239054, -122.448830991825) | 15 | 6 | 2 | 29492 | 16 | |||
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 |
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) );