Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3068 | 3068 | 253294 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
| 3072 | 3072 | 253293 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
| 3403 | 3403 | 19880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 4106 | 4106 | 20001 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 4757 | 4757 | 179682 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.726478317196204 | -122.44073930839 | (37.7264783171962, -122.44073930839) | |||
| 10613 | 10613 | 16409 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001094.970430001 | 2087182.82135 | 37.7110685499383 | -122.43802139438401 | (37.7110685499383, -122.438021394384) | |||
| 14604 | 14604 | 19885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14849 | 14849 | 107038 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1641 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015261.1717 | 2096333.2205 | 37.7369891837982 | -122.38969785212099 | (37.7369891837982, -122.389697852121) | |||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 17582 | 17582 | 15466 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 2458 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006917.683999999 | 2104048.5382 | 37.7577075136236 | -122.419092174143 | (37.7577075136236, -122.419092174143) | |||
| 17812 | 17812 | 11706 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991285.17012 | 2092766.3520900002 | 37.7258367975107 | -122.47233287588399 | (37.7258367975107, -122.472332875884) | ||
| 19253 | 19253 | 11682 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991292.04747 | 2092854.5841700002 | 37.726079458872796 | -122.472315530658 | (37.7260794588728, -122.472315530658) | ||
| 19340 | 19340 | 15469 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 2460 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6006920.5729 | 2104029.0381 | 37.7576541335378 | -122.419080799991 | (37.7576541335378, -122.419080799991) | |||
| 20454 | 20454 | 11707 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991285.0756 | 2092761.86788 | 37.7258244795155 | -122.47233287588399 | (37.7258244795155, -122.472332875884) | ||
| 20821 | 20821 | 11704 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991287.4864300005 | 2092781.25675 | 37.7258778560565 | -122.472325954681 | (37.7258778560565, -122.472325954681) | ||
| 20881 | 20881 | 24296 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 320 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6006596.85891 | 2097923.1306 | 37.74087046649571 | -122.419767095772 | (37.7408704664957, -122.419767095772) | |||
| 21531 | 21531 | 29579 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991348.44459 | 2093803.51532 | 37.7286882509598 | -122.472189710993 | (37.7286882509598, -122.472189710993) | ||
| 22042 | 22042 | 11684 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 2X2 | 5991290.8523 | 2092837.83415 | 37.7260333983166 | -122.472318441749 | (37.7260333983166, -122.472318441749) | |||
| 22085 | 22085 | 11660 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991300.569019999 | 2093059.05917 | 37.726641389479795 | -122.472300971514 | (37.7266413894798, -122.472300971514) | ||
| 22299 | 22299 | 179788 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6004749.24947 | 2094369.67329 | 37.731009216793296 | -122.425902563064 | (37.7310092167933, -122.425902563064) | ||||
| 23282 | 23282 | 19344 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 526 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 5992574.47288 | 2089868.5056099999 | 37.717954554544605 | -122.467665232592 | (37.7179545545446, -122.467665232592) | |||
| 23596 | 23596 | 179735 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.42530298683701 | (37.7309858946841, -122.425302986837) | |||
| 24023 | 24023 | 179712 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 81 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008198.62587 | 2093898.01777 | 37.7299084861863 | -122.41394409435301 | (37.7299084861863, -122.413944094353) | |||
| 24307 | 24307 | 215245 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 318 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992229.521269999 | 2090002.05617 | 37.7183013286233 | -122.468867281705 | (37.7183013286233, -122.468867281705) | |||
| 24504 | 24504 | 241043 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 300 Virginia Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6006909.48713 | 2098350.81017 | 37.742062385665605 | -122.418716463718 | (37.7420623856656, -122.418716463718) | |||
| 24644 | 24644 | 215240 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995902.13017 | 2090713.1941099998 | 37.7204654445931 | -122.456224088976 | (37.7204654445931, -122.456224088976) | |||
| 24895 | 24895 | 179744 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6004895.55112 | 2094358.6043 | 37.730987090783 | -122.425395985741 | (37.730987090783, -122.425395985741) | |||
| 24973 | 24973 | 179783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004773.760559999 | 2094370.4753299998 | 37.7310128042003 | -122.42581788109501 | (37.7310128042003, -122.425817881095) | ||||
| 25245 | 25245 | 179675 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1183 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003399.47661 | 2094250.7820700002 | 37.7306063951513 | -122.430560473899 | (37.7306063951513, -122.430560473899) | |||
| 25266 | 25266 | 215207 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993414.72395 | 2095618.6966 | 37.7337916535606 | -122.465178304956 | (37.7337916535606, -122.465178304956) | |||
| 25772 | 25772 | 179691 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6005621.06817 | 2093204.8072799998 | 37.72785998252721 | -122.422805780863 | (37.7278599825272, -122.422805780863) | |||
| 27049 | 27049 | 215254 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991351.0324800005 | 2093792.6407400002 | 37.7286585418478 | -122.472179972231 | (37.7286585418478, -122.472179972231) | |||
| 27129 | 27129 | 136601 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1900 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000030.07826 | 2121297.6398099996 | 37.80467883793111 | -122.444151713048 | (37.8046788379311, -122.444151713048) | |||
| 27498 | 27498 | 179751 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6004881.94818 | 2094356.48865 | 37.7309805131181 | -122.42544286291901 | (37.7309805131181, -122.425442862919) | |||
| 27665 | 27665 | 215220 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2020 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5993507.89159 | 2101745.37647 | 37.7506193459188 | -122.465301081296 | (37.7506193459188, -122.465301081296) | |||
| 28326 | 28326 | 215253 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991347.53031 | 2093798.3248599998 | 37.7286739463434 | -122.47219249348998 | (37.7286739463434, -122.47219249349) | |||
| 28334 | 28334 | 186775 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984844.3759 | 2106784.0328 | 37.7639506692175 | -122.495631381575 | (37.7639506692175, -122.495631381575) | |||
| 28522 | 28522 | 179728 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6004946.07219 | 2094358.6538200001 | 37.730990081010106 | -122.4252213293 | (37.7309900810101, -122.4252213293) | |||
| 28657 | 28657 | 119518 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 774 31st Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5986356.81834 | 2110650.14553 | 37.774654382283295 | -122.490684840834 | (37.7746543822833, -122.490684840834) | |||
| 29016 | 29016 | 179696 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1317 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007086.79477 | 2092691.09915 | 37.72653204271771 | -122.417702322507 | (37.7265320427177, -122.417702322507) | |||
| 29456 | 29456 | 179778 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 6004787.32766 | 2094370.8495200002 | 37.731014598327796 | -122.42577100392799 | (37.7310145983278, -122.425771003928) | |||
| 29834 | 29834 | 215244 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 290 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5991718.94325 | 2090452.86708 | 37.7195096334551 | -122.470664935645 | (37.7195096334551, -122.470664935645) | |||
| 30069 | 30069 | 215263 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991309.897609999 | 2093234.8571099997 | 37.727124626686795 | -122.47228153268298 | (37.7271246266868, -122.472281532683) | |||
| 30201 | 30201 | 58736 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 222 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1979 12:00:00 AM | 13 | Permit Number 17973 | 5996179.66894 | 2115408.17618 | 37.7882875667675 | -122.45705008391 | (37.7882875667675, -122.45705008391) | ||
| 30258 | 30258 | 179786 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004760.18002 | 2094369.44832 | 37.7310092167964 | -122.425864758274 | (37.7310092167964, -122.425864758274) | ||||
| 30400 | 30400 | 179785 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004765.43097 | 2094369.55773 | 37.7310098139557 | -122.42584661262501 | (37.7310098139557, -122.425846612625) | ||||
| 30458 | 30458 | 179736 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6004921.59693 | 2094359.59302 | 37.730991277113795 | -122.425306011263 | (37.7309912771138, -122.425306011263) | |||
| 30499 | 30499 | 136628 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 35 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6007442.68945 | 2119347.6765099997 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | |||
| 30506 | 30506 | 181764 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1230 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984924.8270000005 | 2106794.9057 | 37.7639852339774 | -122.495353931274 | (37.7639852339774, -122.495353931274) | |||
| 30523 | 30523 | 103548 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 551 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989061.72146 | 2111564.53658 | 37.7773226790144 | -122.48139512711398 | (37.7773226790144, -122.481395127114) | |||
| 30557 | 30557 | 215212 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993408.7609 | 2095708.9649099999 | 37.7340391640776 | -122.465205475246 | (37.7340391640776, -122.465205475246) | |||
| 30862 | 30862 | 179685 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.42880497658899 | (37.7255988638766, -122.428804976589) | |||
| 31260 | 31260 | 179729 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6004942.13253 | 2094358.51707 | 37.730989482957895 | -122.42523493965099 | (37.7309894829579, -122.425234939651) | |||
| 31790 | 31790 | 215217 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5993392.21356 | 2095932.78503 | 37.7346527642991 | -122.465278936386 | (37.7346527642991, -122.465278936386) | |||
| 32097 | 32097 | 179664 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 325 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6012585.69681 | 2086923.17392 | 37.711002386816 | -122.398288194338 | (37.711002386816, -122.398288194338) | |||
| 33080 | 33080 | 215260 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991332.77888 | 2093518.51077 | 37.7279047930719 | -122.472223101042 | (37.7279047930719, -122.472223101042) | |||
| 33171 | 33171 | 179639 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 286 Foote Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998303.30516 | 2088729.74058 | 37.7151568814675 | -122.447781316552 | (37.7151568814675, -122.447781316552) | |||
| 33407 | 33407 | 179702 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1142 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007383.5399400005 | 2093322.51563 | 37.7282824705509 | -122.41672119542801 | (37.7282824705509, -122.416721195428) | |||
| 33570 | 33570 | 179741 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004901.636469999 | 2094356.73695 | 37.7309823072691 | -122.42537481481101 | (37.7309823072691, -122.425374814811) | |||
| 33659 | 33659 | 179635 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 9 Moneta Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997908.32309 | 2088048.3986 | 37.7132634892865 | -122.44909748427601 | (37.7132634892865, -122.449097484276) | ||||
| 33665 | 33665 | 179793 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 629 Hamilton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6009759.65206 | 2091562.25484 | 37.7235825209091 | -122.408382730001 | (37.7235825209091, -122.408382730001) | |||
| 33866 | 33866 | 179632 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5999581.03215 | 2090102.7419900002 | 37.718999778104795 | -122.443463521241 | (37.7189997781048, -122.443463521241) | |||
| 34055 | 34055 | 179782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6004777.69099 | 2094370.17663 | 37.7310122061496 | -122.425804271672 | (37.7310122061496, -122.425804271672) | ||||
| 34179 | 34179 | 197887 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1493 Kansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 6011776.638040001 | 2101418.39447 | 37.7507581436897 | -122.40210291074699 | (37.7507581436897, -122.402102910747) | |||
| 34250 | 34250 | 241035 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 683 Duncan St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002140.9869099995 | 2099704.66458 | 37.745510119292 | -122.435301222178 | (37.745510119292, -122.435301222178) | |||
| 34396 | 34396 | 179657 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 570 Edinburgh St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002562.8789099995 | 2090358.04011 | 37.7198703712871 | -122.433174679891 | (37.7198703712871, -122.433174679891) | |||
| 34648 | 34648 | 215261 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991310.9639 | 2093247.2582599998 | 37.7271587388628 | -122.47227875017799 | (37.7271587388628, -122.472278750178) | |||
| 34816 | 34816 | 215255 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991357.82029 | 2093790.0929299998 | 37.7286519390174 | -122.47215632095501 | (37.7286519390174, -122.472156320955) | |||
| 35170 | 35170 | 179653 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 570 Edinburgh St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6002670.92192 | 2090527.15665 | 37.7203408561316 | -122.43281328822201 | (37.7203408561316, -122.432813288222) | |||
| 35245 | 35245 | 179766 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6004833.3420400005 | 2094364.4580400002 | 37.7309996489081 | -122.425611469595 | (37.7309996489081, -122.425611469595) | |||
| 35447 | 35447 | 215218 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993390.45214 | 2095959.7776 | 37.734726777609296 | -122.465286986206 | (37.7347267776093, -122.465286986206) | |||
| 35558 | 35558 | 241016 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 42 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998455.64477 | 2106908.99141 | 37.765081439982204 | -122.448563264508 | (37.7650814399822, -122.448563264508) | |||
| 36107 | 36107 | 215203 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5993362.10241 | 2095871.1002099998 | 37.7344816565847 | -122.465378560574 | (37.7344816565847, -122.465378560574) | |||
| 36629 | 36629 | 138530 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1650 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001636.2077 | 2114181.5211 | 37.7852313286636 | -122.438083494179 | (37.7852313286636, -122.438083494179) | |||
| 37251 | 37251 | 136604 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | |||
| 38234 | 38234 | 179776 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6004793.39482 | 2094368.1113 | 37.7310074226383 | -122.42574983389 | (37.7310074226383, -122.42574983389) | |||
| 38381 | 38381 | 136611 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1630 Bay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6002977.377719999 | 2120668.13454 | 37.80311807979739 | -122.433907279317 | (37.8031180797974, -122.433907279317) | |||
| 39424 | 39424 | 215233 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 381 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998173.02333 | 2094066.3332099998 | 37.7298024758896 | -122.44861574981199 | (37.7298024758896, -122.448615749812) | |||
| 39898 | 39898 | 136590 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3160 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999027.50225 | 2119697.94121 | 37.8002292514403 | -122.44750599361299 | (37.8002292514403, -122.447505993613) | |||
| 39951 | 39951 | 179747 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6004888.75202 | 2094357.6554900003 | 37.730984101417704 | -122.42541942389299 | (37.7309841014177, -122.425419423893) | |||
| 40064 | 40064 | 136617 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.803385530067104 | -122.422870825248 | (37.8033855300671, -122.422870825248) | |||
| 40224 | 40224 | 215216 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993391.28977 | 2095902.6603400002 | 37.7345699961108 | -122.465279942742 | (37.7345699961108, -122.465279942742) | |||
| 40447 | 40447 | 179644 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 900 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6001616.89073 | 2088831.6058 | 37.7156254147599 | -122.43633543893499 | (37.7156254147599, -122.436335438935) | |||
| 40633 | 40633 | 179692 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6005640.05215 | 2093208.69537 | 37.7278717294828 | -122.42274042892299 | (37.7278717294828, -122.422740428923) | |||
| 40688 | 40688 | 136600 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999337.17722 | 2120854.21997 | 37.8034217736525 | -122.44651763508999 | (37.8034217736525, -122.44651763509) | |||
| 41037 | 41037 | 179678 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 242 San Juan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6000584.20911 | 2092761.60072 | 37.726357558039204 | -122.440186503209 | (37.7263575580392, -122.440186503209) | |||
| 41368 | 41368 | 197881 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.75240923331361 | -122.38875758671101 | (37.7524092333136, -122.388757586711) | |||
| 41419 | 41419 | 179718 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 27 Dartmouth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008335.51902 | 2094191.8954200002 | 37.7307230983942 | -122.413491613054 | (37.7307230983942, -122.413491613054) | |||
| 41557 | 41557 | 179652 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 570 Edinburgh St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6002692.5092 | 2090562.9633099998 | 37.72044039759779 | -122.43274122465 | (37.7204403975978, -122.43274122465) | |||
| 41580 | 41580 | 197879 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015633.716580001 | 2101939.6096099997 | 37.752403820278396 | -122.388801060829 | (37.7524038202784, -122.388801060829) | |||
| 41842 | 41842 | 215278 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 179 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998891.37241 | 2093762.8360400002 | 37.72901019295671 | -122.446110523694 | (37.7290101929567, -122.446110523694) | |||
| 41966 | 41966 | 215270 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 549 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 5998461.49971 | 2094954.96465 | 37.732258938999 | -122.44768240373399 | (37.732258938999, -122.447682403734) | |||
| 42211 | 42211 | 215277 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 179 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998891.614440001 | 2093764.99238 | 37.729016127582895 | -122.446109842022 | (37.7290161275829, -122.446109842022) | |||
| 42308 | 42308 | 241032 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 683 Duncan St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002120.19766 | 2099702.7104700003 | 37.7455035731345 | -122.435372968292 | (37.7455035731345, -122.435372968292) | |||
| 42366 | 42366 | 179640 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1101 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000461.77381 | 2090733.0608700002 | 37.7207806794643 | -122.440464330785 | (37.7207806794643, -122.440464330785) | |||
| 42763 | 42763 | 241020 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 2ft | 6008973.83234 | 2096817.1945900002 | 37.737967424348795 | -122.411470260845 | (37.7379674243488, -122.411470260845) | |||
| 42808 | 42808 | 179717 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 17 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6008127.64953 | 2094206.23587 | 37.7307508001883 | -122.414211266754 | (37.7307508001883, -122.414211266754) | |||
| 42877 | 42877 | 179665 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 325 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6012591.22281 | 2086940.79015 | 37.7110510653234 | -122.398270330217 | (37.7110510653234, -122.398270330217) | |||
| 43138 | 43138 | 179648 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 786 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 6001194.88831 | 2089176.29641 | 37.7165478709616 | -122.43781874116199 | (37.7165478709616, -122.437818741162) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");