Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 81 | 81 | 221366 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.750060130381605 | -122.439391477336 | (37.7500601303816, -122.439391477336) | |
| 1091 | 1091 | 110107 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4130 MORAGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430.4 | 2103553.9 | 37.7548811373619 | -122.507199448976 | (37.7548811373619, -122.507199448976) | |
| 1162 | 1162 | 251437 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3377 Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999965.0 | 2104239.0 | 37.7578364910366 | -122.443151017453 | (37.7578364910366, -122.443151017453) | ||||
| 1503 | 1503 | 220995 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 610 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001157.49823 | 2100904.8155400003 | 37.748749547471206 | -122.438787950406 | (37.7487495474712, -122.438787950406) | |
| 1792 | 1792 | 200049 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015007.7446 | 2094143.437 | 37.7309624265756 | -122.390421112537 | (37.7309624265756, -122.390421112537) | |||
| 1803 | 1803 | 200050 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.39047892232401 | (37.730993203361, -122.390478922324) | |||
| 1806 | 1806 | 200048 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015017.0879999995 | 2094135.7424 | 37.7309418170544 | -122.39038827315399 | (37.7309418170544, -122.390388273154) | |||
| 1895 | 1895 | 222302 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 151 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6007412.8768 | 2100213.34589 | 37.7472048215433 | -122.41710784185499 | (37.7472048215433, -122.417107841855) | |||
| 2935 | 2935 | 246004 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999001.0122 | 2108580.4285 | 37.7697019524613 | -122.44679725758199 | (37.7697019524613, -122.446797257582) | |||
| 3004 | 3004 | 246005 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998995.5612 | 2108615.5567 | 37.7697980941931 | -122.446818640382 | (37.7697980941931, -122.446818640382) | |||
| 3006 | 3006 | 246006 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998992.533 | 2108633.4236 | 37.7698469791765 | -122.446830400622 | (37.7698469791765, -122.446830400622) | |||
| 3036 | 3036 | 182177 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 3038 | 3038 | 182175 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988757.0 | 2104389.0 | 37.757602901925104 | -122.481923487166 | (37.7576029019251, -122.481923487166) | |||
| 3041 | 3041 | 182178 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 3042 | 3042 | 182176 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 9716 | 9716 | 138189 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003405.7885 | 2115073.4289 | 37.7877807602684 | -122.43202500502701 | (37.7877807602684, -122.432025005027) | |||
| 10623 | 10623 | 97764 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001442.97937 | 2088937.5583900001 | 37.715906453794 | -122.43694413518601 | (37.715906453794, -122.436944135186) | |||
| 11516 | 11516 | 112475 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988753.5421 | 2104412.2034 | 37.7576664111078 | -122.48193714554199 | (37.7576664111078, -122.481937145542) | |||
| 11941 | 11941 | 116686 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002102.67453 | 2092656.42028 | 37.7261550900614 | -122.43492972844 | (37.7261550900614, -122.43492972844) | |||
| 12255 | 12255 | 97766 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001498.9346199995 | 2088909.8627799999 | 37.71583358803421 | -122.436748746672 | (37.7158335880342, -122.436748746672) | |||
| 12804 | 12804 | 113544 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 182 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6005841.47064 | 2092905.54198 | 37.7270506988092 | -122.42202259277398 | (37.7270506988092, -122.422022592774) | |||
| 13667 | 13667 | 109904 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 224 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | |
| 14668 | 14668 | 105550 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.727583366960204 | -122.382776791229 | (37.7275833669602, -122.382776791229) | |||
| 15035 | 15035 | 108029 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1308 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6017326.2062 | 2092992.2495 | 37.727929830314295 | -122.382325662572 | (37.7279298303143, -122.382325662572) | |||
| 15053 | 15053 | 100251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 540 Delancey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6015234.41692 | 2113622.27838 | 37.7844597292764 | -122.390998376191 | (37.7844597292764, -122.390998376191) | |||
| 15440 | 15440 | 122718 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 472 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6014329.5757 | 2104932.99379 | 37.760550641114 | -122.393520505067 | (37.760550641114, -122.393520505067) | |||
| 16440 | 16440 | 105549 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.72755294661221 | -122.38272576976802 | (37.7275529466122, -122.382725769768) | |||
| 18186 | 18186 | 105551 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6017214.0 | 2092838.0 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | |||
| 18741 | 18741 | 112413 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005169.0 | 2110996.0 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | ||||
| 19503 | 19503 | 113857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011184.0 | 2102716.0 | 37.754287987368706 | -122.40424363426001 | (37.7542879873687, -122.40424363426) | ||||
| 22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
| 23374 | 23374 | 189044 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007758.60706 | 2109046.4903599997 | 37.771478047011705 | -122.416537939674 | (37.7714780470117, -122.416537939674) | |||
| 23383 | 23383 | 220866 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004888.252669999 | 2102494.31533 | 37.753325487792104 | -122.426000149411 | (37.7533254877921, -122.426000149411) | |||
| 23406 | 23406 | 205700 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 455 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993494.37195 | 2099449.4133900004 | 37.744314435578396 | -122.465181086546 | (37.7443144355784, -122.465181086546) | |||
| 23430 | 23430 | 220933 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 155 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006212.833769999 | 2096779.64339 | 37.737709065310995 | -122.421013744088 | (37.737709065311, -122.421013744088) | |||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 23609 | 23609 | 125847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008754.651330001 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) | |||
| 23617 | 23617 | 205782 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Hearst Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998547.56823 | 2094367.17005 | 37.730649912448605 | -122.447342555315 | (37.7306499124486, -122.447342555315) | |||
| 23641 | 23641 | 222492 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 265 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002907.41416 | 2097886.83375 | 37.740562273319505 | -122.43252121989599 | (37.7405622733195, -122.432521219896) | |||
| 23673 | 23673 | 222238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.45260686101801 | (37.7651059905631, -122.452606861018) | |||
| 23720 | 23720 | 188872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.757608911948104 | -122.40080490573798 | (37.7576089119481, -122.400804905738) | |||
| 23812 | 23812 | 220970 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000907.15737 | 2097980.81519 | 37.740706690970995 | -122.43944405351601 | (37.740706690971, -122.439444053516) | |||
| 23858 | 23858 | 222304 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 159 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007445.403080001 | 2100226.12885 | 37.747241750408605 | -122.416996273782 | (37.7472417504086, -122.416996273782) | |||
| 23906 | 23906 | 199914 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196002 | (37.7277258082427, -122.38303422196) | |||
| 23921 | 23921 | 102246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 337 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x6 | 6013795.01675 | 2105505.95048 | 37.7620941385477 | -122.395409453676 | (37.7620941385477, -122.395409453676) | |||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 23987 | 23987 | 175686 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.68798 | 2092672.56295 | 37.726397462770706 | -122.42283496838199 | (37.7263974627707, -122.422834968382) | |||
| 24048 | 24048 | 113755 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001200.73843 | 2089055.6919999998 | 37.7162170508648 | -122.43778988730499 | (37.7162170508648, -122.437789887305) | |||
| 24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 24103 | 24103 | 122254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1751 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990004.74374 | 2113334.11556 | 37.7822362348945 | -122.47826236215 | (37.7822362348945, -122.47826236215) | |||
| 24105 | 24105 | 205695 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2236 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990740.52284 | 2100154.10993 | 37.7460901613437 | -122.47475463951 | (37.7460901613437, -122.47475463951) | |||
| 24139 | 24139 | 188877 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 711 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011296.96428 | 2105014.49573 | 37.7606054583887 | -122.40401471650299 | (37.7606054583887, -122.404014716503) | |||
| 24185 | 24185 | 220918 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3590 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008482.3827 | 2098155.73861 | 37.7416151950936 | -122.41326407916999 | (37.7416151950936, -122.41326407917) | |||
| 24237 | 24237 | 222185 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1266 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003207.46719 | 2100851.7918599998 | 37.7487203698443 | -122.431695388655 | (37.7487203698443, -122.431695388655) | |||
| 24324 | 24324 | 138190 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003409.3754 | 2115058.633 | 37.7877403378272 | -122.432011538078 | (37.7877403378272, -122.432011538078) | |||
| 24442 | 24442 | 205788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201 Hearst Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000020.87413 | 2094345.53232 | 37.7306745790527 | -122.442247574877 | (37.7306745790527, -122.442247574877) | |||
| 24448 | 24448 | 220803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006506.67533 | 2105838.44875 | 37.7625990368337 | -122.42064067382401 | (37.7625990368337, -122.420640673824) | |||
| 24561 | 24561 | 220882 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 599 Belvedere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998626.62137 | 2105762.24598 | 37.7619425398344 | -122.44788933414 | (37.7619425398344, -122.44788933414) | |||
| 24616 | 24616 | 222318 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 838 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009101.97358 | 2104063.21002 | 37.7578705625017 | -122.41153901044301 | (37.7578705625017, -122.411539010443) | |||
| 24743 | 24743 | 204401 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994301.112480001 | 2105797.04761 | 37.761789906893604 | -122.462851987244 | (37.7617899068936, -122.462851987244) | |||
| 24774 | 24774 | 143056 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 EDITH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010306.5322 | 2120406.926 | 37.8028140529926 | -122.40852599821699 | (37.8028140529926, -122.408525998217) | |||
| 24882 | 24882 | 220794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2406 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6011347.91317 | 2102325.1902900003 | 37.753224067640296 | -122.403649282384 | (37.7532240676403, -122.403649282384) | |||
| 24915 | 24915 | 222484 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 59 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002447.270769999 | 2096535.4200900001 | 37.7368254993903 | -122.434015637735 | (37.7368254993903, -122.434015637735) | |||
| 24935 | 24935 | 175691 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007522.85958 | 2091386.22385 | 37.722973663691 | -122.41610248796499 | (37.722973663691, -122.416102487965) | |||
| 24943 | 24943 | 175677 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 165 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004417.90024 | 2094349.92502 | 37.7309362610921 | -122.427046687756 | (37.7309362610921, -122.427046687756) | |||
| 25061 | 25061 | 222360 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 498 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003186.117380001 | 2102736.4547200003 | 37.7538939996264 | -122.43190377055599 | (37.7538939996264, -122.431903770556) | |||
| 25079 | 25079 | 204442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.743367092409294 | -122.472569777984 | (37.7433670924093, -122.472569777984) | |||
| 25111 | 25111 | 222282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 322 Elsie St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.19555 | 2097095.06945 | 37.7385859402852 | -122.42037449518699 | (37.7385859402852, -122.420374495187) | |||
| 25148 | 25148 | 220775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2800 Mariposa St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6009066.85397 | 2105930.68426 | 37.762996251197706 | -122.411792424993 | (37.7629962511977, -122.411792424993) | |||
| 25149 | 25149 | 220954 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3339 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006068.29873 | 2103732.65961 | 37.75679231583621 | -122.42200726293001 | (37.7567923158362, -122.42200726293) | |||
| 25152 | 25152 | 222160 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000360.36109 | 2101597.05955 | 37.7506049001065 | -122.44159410859899 | (37.7506049001065, -122.441594108599) | |||
| 25230 | 25230 | 188862 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2145 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011298.33693 | 2105542.34604 | 37.7620548939477 | -122.404047117302 | (37.7620548939477, -122.404047117302) | |||
| 25239 | 25239 | 183737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1014 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989684.0603 | 2099734.5492 | 37.744876881917 | -122.47837703617901 | (37.744876881917, -122.478377036179) | |||
| 25241 | 25241 | 205846 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994462.98595 | 2090252.1993200001 | 37.7191169462637 | -122.46116531412301 | (37.7191169462637, -122.461165314123) | |||
| 25282 | 25282 | 125851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1359 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007069.22573 | 2118411.6669099997 | 37.797153742719296 | -122.41958711357901 | (37.7971537427193, -122.419587113579) | |||
| 25287 | 25287 | 188860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011271.15548 | 2105473.51141 | 37.7618643707515 | -122.40413628328899 | (37.7618643707515, -122.404136283289) | |||
| 25569 | 25569 | 222200 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000609.51746 | 2102650.2071599998 | 37.753510781406604 | -122.44080804535801 | (37.7535107814066, -122.440808045358) | |||
| 25695 | 25695 | 114253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990028.62528 | 2111858.48615 | 37.778185952947 | -122.478071825887 | (37.778185952947, -122.478071825887) | |||
| 25762 | 25762 | 220852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1395 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003936.80464 | 2100186.5973 | 37.7469352146856 | -122.429125922127 | (37.7469352146856, -122.429125922127) | |||
| 25769 | 25769 | 175689 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.28407 | 2091377.76414 | 37.7229489970823 | -122.416190298655 | (37.7229489970823, -122.416190298655) | |||
| 25775 | 25775 | 188897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 837 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012777.55941 | 2103554.0520599997 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | |||
| 25778 | 25778 | 220791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011142.88889 | 2102704.62469 | 37.7542544559807 | -122.404385006975 | (37.7542544559807, -122.404385006975) | |||
| 25790 | 25790 | 222210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6002911.44026 | 2096221.9598 | 37.735991140781294 | -122.43238841969601 | (37.7359911407813, -122.432388419696) | ||||
| 25822 | 25822 | 217692 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5992741.6623 | 2097644.2084 | 37.739314365266 | -122.467652516069 | (37.739314365266, -122.467652516069) | |||
| 25836 | 25836 | 222165 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000303.115259999 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | |||
| 25851 | 25851 | 118062 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 440 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5984715.49156 | 2112889.6967 | 37.780707531386795 | -122.49652772957899 | (37.7807075313868, -122.496527729579) | |||
| 25911 | 25911 | 205719 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 141 Taraval St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993232.44961 | 2099151.4105700003 | 37.7434810877719 | -122.466065100337 | (37.7434810877719, -122.466065100337) | |||
| 25912 | 25912 | 205736 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1469 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995878.81817 | 2093821.3570700001 | 37.7289983803529 | -122.456529318894 | (37.7289983803529, -122.456529318894) | |||
| 26005 | 26005 | 222217 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002025.85337 | 2096457.93156 | 37.736588808613206 | -122.43546711921302 | (37.7365888086132, -122.435467119213) | |||
| 26120 | 26120 | 125878 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011759.18652 | 2117854.8104 | 37.7958878075263 | -122.403319400277 | (37.7958878075263, -122.403319400277) | |||
| 26136 | 26136 | 188896 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 851 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012778.37681 | 2103525.2873 | 37.7565990757928 | -122.398786633697 | (37.7565990757928, -122.398786633697) | |||
| 26171 | 26171 | 189043 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 70 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010322.24625 | 2111201.84362 | 37.7775399884207 | -122.407822145684 | (37.7775399884207, -122.407822145684) | |||
| 26223 | 26223 | 175637 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011646.28852 | 2089340.4245799999 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | |||
| 26248 | 26248 | 205848 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 438 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994034.73412 | 2089295.68258 | 37.7164659256424 | -122.462576258696 | (37.7164659256424, -122.462576258696) | |||
| 26267 | 26267 | 204461 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 376 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993925.03451 | 2099657.87207 | 37.7449116357803 | -122.46370708514 | (37.7449116357803, -122.46370708514) | |||
| 26358 | 26358 | 188851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 397 08th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.40864614951299 | (37.7739661716411, -122.408646149513) | |||
| 26473 | 26473 | 138043 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1511 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005359.99 | 2115008.8327 | 37.787713990640995 | -122.42525923232701 | (37.787713990641, -122.425259232327) | |||
| 26733 | 26733 | 188939 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2225 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.745022760504206 | -122.400588763562 | (37.7450227605042, -122.400588763562) |
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");