trees
563 rows where qSpecies_id = 52 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194069 | 9286 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 194035 | 122180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.473055677376 | (37.784578471021, -122.473055677376) | 11 | 6 | 2 | 54 | 26 | |||
| 193210 | 11297 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
| 193103 | 251668 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995349 | 2100852 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | 1 | 5 | 4 | 63 | 40 | ||||
| 192976 | 253204 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2253 09th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5993186 | 2100608 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | 1 | 8 | 4 | 29491 | 40 | ||||
| 192906 | 61359 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | 5 | 1 | 10 | 28857 | 21 | ||
| 192628 | 121081 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 5 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 192066 | 12002 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1230X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | |||
| 191134 | 224200 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 10 | 6003533.27125 | 2095632.51189 | 37.7344078915187 | -122.430196462512 | (37.7344078915187, -122.430196462512) | 2 | 7 | 5 | 63 | 7 | ||||
| 190488 | 65550 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | 9 | 7 | 4 | 59 | 40 | ||
| 190393 | 105665 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 2 | unknown : Yard | Tree | Private 2 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 190209 | 17258 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017303.8717551 | 2094261.0040323 | 37.731412347585 | -122.382491114922 | (37.731412347585, -122.382491114922) | 10 | 3 | 8 | 58 | 1 | |||
| 190104 | 11301 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
| 189550 | 17284 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 90 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016930.7708615 | 2094565.5402989 | 37.7322279266876 | -122.383802203384 | (37.7322279266876, -122.383802203384) | 10 | 3 | 8 | 58 | 1 | |||
| 189365 | 94382 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 189319 | 108502 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2300 33RD AVE | 1 | Back Yard : Yard | Tree | Private 2 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.490655741302 | (37.7441266056665, -122.490655741302) | 1 | 8 | 3 | 29491 | 35 | ||||
| 189275 | 61657 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | 11 | 6 | 2 | 54 | 11 | ||
| 189234 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
| 187911 | 12031 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1250X La Salle Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | |||
| 187820 | 61115 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1106 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20962 | 6007608.55332469 | 2103202.26724843 | 37.7554227286129 | -122.416642908427 | (37.7554227286129, -122.416642908427) | 2 | 4 | 7 | 28859 | 19 | ||
| 186855 | 17260 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 29 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2017 12:00:00 AM | 18 | 3X3 | 6017247.6402047 | 2094279.3298336 | 37.7314595602259 | -122.382686794637 | (37.7314595602259, -122.382686794637) | 10 | 3 | 8 | 58 | 1 | ||
| 186774 | 32991 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 186245 | 17283 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 85 OSCEOLA LN | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016889 | 2094526 | 37.7321170477455 | -122.383943863813 | (37.7321170477455, -122.383943863813) | 10 | 3 | 8 | 58 | 1 | |||
| 185978 | 65605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | 9 | 7 | 6 | 28861 | 5 | ||
| 185417 | 10770 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1120X Hudson Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 185356 | 199402 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 20 | Median : Yard | Tree | DPW 1 | 26 | 6016663.61896 | 2095979.59061 | 37.7360958551344 | -122.384824290234 | (37.7360958551344, -122.384824290234) | 10 | 3 | 8 | 58 | 1 | ||||
| 184937 | 61435 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.443874903825 | (37.7589393153031, -122.443874903825) | 2 | 4 | 5 | 28862 | 3 | |
| 184426 | 32990 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 184342 | 139748 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.7838090228042 | -122.427648355277 | (37.7838090228042, -122.427648355277) | 7 | 9 | 11 | 28858 | 41 | |||
| 184159 | 55768 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2006 12:00:00 AM | Permit Number 48893 | 6004070.72244185 | 2102685.02755706 | 37.7538029009663 | -122.428840933443 | (37.7538029009663, -122.428840933443) | 2 | 4 | 5 | 28862 | 22 | ||
| 184155 | 176320 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | 9 | 3 | 8 | 309 | 18 | |||
| 184078 | 17271 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 50 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017109.92307 | 2094398.11739 | 37.7317781181305 | -122.383171178612 | (37.7317781181305, -122.383171178612) | 10 | 3 | 8 | 58 | 1 | |||
| 184072 | 176332 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 40 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | 9 | 3 | 8 | 309 | 18 | |||
| 183936 | 224217 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 115 | Front Yard : Yard | Tree | Private 2 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.4252127345 | (37.7379539516063, -122.4252127345) | 2 | 7 | 5 | 63 | 7 | ||||
| 183906 | 106586 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 7 | Median : Yard | Tree | DPW 1 | 11 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 183690 | 63265 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | 15 | 5 | 11 | 29490 | 41 | |
| 183646 | 99975 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
| 183570 | 107711 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1798X 31st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | ||||
| 183178 | 11637 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
| 182920 | 12073 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1225X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.382433536417 | (37.7317765554235, -122.382433536417) | 10 | 3 | 8 | 58 | 1 | |||
| 182743 | 224452 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 37 | 6003256.42422 | 2095477.20657 | 37.7339657739995 | -122.431142531321 | (37.7339657739995, -122.431142531321) | 2 | 7 | 5 | 63 | 7 | ||||
| 182225 | 63123 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | 2 | 7 | 7 | 28859 | 2 | ||
| 181933 | 112581 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 274X SAN MARCOS AVE | 2 | Median : Cutout | Tree | Private 2 | 3x20 | 5993121 | 2100271 | 37.7465487656332 | -122.466531821158 | (37.7465487656332, -122.466531821158) | 1 | 8 | 4 | 29491 | 40 | ||||
| 181750 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 181652 | 176319 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.408303262296 | (37.7196313144016, -122.408303262296) | 9 | 3 | 8 | 309 | 18 | |||
| 181464 | 11367 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679 | -122.38258247713 | (37.730452470679, -122.38258247713) | 10 | 3 | 8 | 58 | 1 | |||
| 180688 | 32992 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
| 180018 | 24063 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 179964 | 68255 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | 10 | 3 | 7 | 309 | 28 | ||
| 179797 | 224203 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 11 | 6003487.06732 | 2095623.97616 | 37.7343818372555 | -122.430355595758 | (37.7343818372555, -122.430355595758) | 2 | 7 | 5 | 63 | 7 | ||||
| 179282 | 224214 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 25 | 6005180.62218 | 2097351.71746 | 37.7392216116736 | -122.424623281961 | (37.7392216116736, -122.424623281961) | 2 | 7 | 5 | 28859 | 7 | ||||
| 178473 | 32831 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4259 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37188 | 6001527.35157379 | 2101718.97801883 | 37.7510060780925 | -122.437567299188 | (37.7510060780925, -122.437567299188) | 2 | 4 | 5 | 28862 | 22 | ||
| 178439 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 198X JENNINGS ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | |||||
| 178181 | 109851 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 3250x 22ND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
| 177890 | 66846 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | 15 | 5 | 11 | 29492 | 16 | |
| 177594 | 224201 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 9 | 6003522.52197 | 2095626.54462 | 37.7343908979074 | -122.430233200698 | (37.7343908979074, -122.430233200698) | 2 | 7 | 5 | 63 | 7 | ||||
| 176103 | 26776 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 800X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 175943 | 217802 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2x Sloat Blvd | 2 | Median : Yard | Tree | DPW 1 | 15 | 5991046.80022 | 2095992.48375 | 37.7346811451245 | -122.47339209648 | (37.7346811451245, -122.47339209648) | 1 | 8 | 4 | 64 | 40 | ||||
| 175807 | 11270 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1176X Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/1990 12:00:00 AM | 24 | 3X3 | 6017716.362196 | 2093961.1645628 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | 10 | 3 | 8 | 58 | 1 | ||
| 175420 | 64980 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.423455890647 | (37.744768585112, -122.423455890647) | 2 | 7 | 5 | 28859 | 22 | ||
| 175141 | 11333 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1279 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | |||
| 174359 | 107852 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | 9 | 8 | 4 | 59 | 40 | ||||
| 174333 | 53071 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 530@ CAPITOL Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | 9 | 8 | 6 | 28861 | 24 | ||
| 173951 | 224205 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 30 | 6005328.89296 | 2097313.98871 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | 2 | 7 | 5 | 28859 | 2 | ||||
| 173405 | 63699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | 1 | 8 | 4 | 56 | 12 | ||
| 173299 | 10769 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 173225 | 1855 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2500 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6010837.5147418 | 2086759.4488697 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | 9 | 7 | 8 | 309 | 39 | |||
| 172792 | 112970 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1409 MCKINNON AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016184 | 2095282 | 37.7341538729229 | -122.386433919032 | (37.7341538729229, -122.386433919032) | 10 | 3 | 8 | 58 | 1 | |||||
| 172701 | 176298 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6011748.91192 | 2090731.58234 | 37.7214128614948 | -122.401447817564 | (37.7214128614948, -122.401447817564) | 10 | 7 | 8 | 309 | 28 | |||
| 172256 | 110178 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 321 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | 2 | 4 | 5 | 28859 | 19 | ||||
| 172039 | 11346 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.7306777467756 | -122.382320962891 | (37.7306777467756, -122.382320962891) | 10 | 3 | 8 | 58 | 1 | |||
| 170920 | 111238 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 48X OAKHURST LN | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994967 | 2104000 | 37.7568940069608 | -122.460418748436 | (37.7568940069608, -122.460418748436) | 1 | 5 | 4 | 63 | 12 | ||||
| 170649 | 106581 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 4 | Median : Yard | Tree | DPW 1 | 9 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 170630 | 11315 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1216X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017561.7867095 | 2093983.7658262 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | 10 | 3 | 8 | 58 | 1 | |||
| 170435 | 66751 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | 15 | 5 | 5 | 29492 | 9 | ||
| 170367 | 68260 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | 10 | 3 | 7 | 309 | 28 | ||
| 170148 | 176331 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 36 | Median : Cutout | Tree | DPW 1 | 27 | Width 0ft | 6009160.31915 | 2089943.19891 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | 9 | 3 | 8 | 309 | 18 | |||
| 169388 | 104432 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1601X PORTOLA DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
| 168968 | 113893 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 5x STORRIE ST | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | 60 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
| 168866 | 60707 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1059 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20357 | 6009209.04775492 | 2102998.94986664 | 37.754954349681 | -122.4110935285 | (37.754954349681, -122.4110935285) | 2 | 4 | 7 | 28859 | 19 | ||
| 168673 | 12010 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1230X La Salle Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | |||
| 168410 | 17278 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 75 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6016964.0762842 | 2094462.847211 | 37.731947792828 | -122.383679910748 | (37.731947792828, -122.383679910748) | 10 | 3 | 8 | 58 | 1 | |||
| 167497 | 51287 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.7741148873605 | -122.479912367003 | (37.7741148873605, -122.479912367003) | 11 | 6 | 2 | 55 | 26 | ||
| 167346 | 88605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2719 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 52923 | 5991770.2 | 2096974.3 | 37.737418827963 | -122.470962580807 | (37.737418827963, -122.470962580807) | 1 | 8 | 4 | 29491 | 40 | ||
| 167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 166500 | 109495 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 342 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004048.2 | 2103384.6 | 37.7557224873033 | -122.428968694341 | (37.7557224873033, -122.428968694341) | 2 | 4 | 5 | 28862 | 22 | ||||
| 165943 | 24065 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 165498 | 75663 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.7695031998873 | -122.429523817606 | (37.7695031998873, -122.429523817606) | 7 | 9 | 5 | 29492 | 10 | |||
| 164338 | 32593 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.1581728 | 2105866.8789552 | 37.7614725555795 | -122.493191928821 | (37.7614725555795, -122.493191928821) | 1 | 8 | 3 | 56 | 35 | |
| 164204 | 106592 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 9 | Median : Yard | Tree | DPW 1 | 34 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 162723 | 114914 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6017974 | 2095171 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | 10 | 3 | 8 | 58 | 1 | |||
| 162457 | 224213 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 20 | 6005183.17697 | 2097360.09127 | 37.7392447485499 | -122.424615044148 | (37.7392447485499, -122.424615044148) | 2 | 7 | 5 | 28859 | 7 | ||||
| 162446 | 176315 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 600x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.407259215964 | (37.7198648386596, -122.407259215964) | 9 | 7 | 8 | 309 | 18 | |||
| 161363 | 254812 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2595 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997881 | 2089586 | 37.7174838262402 | -122.449302633722 | (37.7174838262402, -122.449302633722) | 9 | 8 | 6 | 28861 | 24 | ||||
| 160795 | 113501 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 200x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 17 | 3x3 | 6011166.56458 | 2090559.11661 | 37.7209067958818 | -122.403448714702 | (37.7209067958818, -122.403448714702) | 10 | 7 | 7 | 309 | 28 | |||
| 160685 | 14900 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 170 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016995.24275 | 2098361.00599 | 37.7426530781013 | -122.383843483695 | (37.7426530781013, -122.383843483695) | 10 | 3 | 8 | 58 | 1 | |||
| 160662 | 117457 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 90 NAVY RD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018168 | 2093528 | 37.7294473579848 | -122.379452729346 | (37.7294473579848, -122.379452729346) | 10 | 3 | 8 | 58 | 1 | ||||
| 160479 | 224199 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 16 | 6005272.32245 | 2097108.71152 | 37.7385595505918 | -122.424288944593 | (37.7385595505918, -122.424288944593) | 2 | 7 | 5 | 28859 | 2 | ||||
| 160353 | 11332 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1279 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | |||
| 160280 | 191716 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 561 Rhode Island St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.402263453208 | (37.7626970962079, -122.402263453208) | 8 | 3 | 8 | 28856 | 29 |
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) );