trees
3,965 rows where qSpecies_id = 70 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 175810 | 257902 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5701x 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
| 59067 | 174968 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 479 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010452.97005 | 2092347.52922 | 37.7257775222972 | -122.406041335159 | (37.7257775222972, -122.406041335159) | 10 | 3 | 7 | 309 | 28 | |||
| 83959 | 255873 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990871 | 2092383 | 37.7247602290732 | -122.473736664855 | (37.7247602290732, -122.473736664855) | 9 | 8 | 4 | 64 | 40 | ||||
| 13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
| 26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 50973 | 43163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.26694 | 37.7260364164322 | -122.422690190993 | (37.7260364164322, -122.422690190993) | 9 | 7 | 7 | 309 | 5 | |
| 45252 | 256859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991007 | 2092571 | 37.7252843060575 | -122.473280239218 | (37.7252843060575, -122.473280239218) | 9 | 8 | 4 | 64 | 40 | ||||
| 82829 | 203988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 665 Faxon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 5994873.24978 | 2092595.62975 | 37.7255750462432 | -122.459916865398 | (37.7255750462432, -122.459916865398) | 9 | 7 | 4 | 28861 | 40 | |||
| 121507 | 256861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 372 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991087 | 2092598 | 37.7253630733191 | -122.473005657757 | (37.7253630733191, -122.473005657757) | 9 | 8 | 4 | 64 | 40 | ||||
| 181764 | 256860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 364 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991048 | 2092612 | 37.7253992558166 | -122.473141496308 | (37.7253992558166, -122.473141496308) | 9 | 8 | 4 | 64 | 40 | ||||
| 72460 | 203989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 665 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 3ft | 5994872.64121 | 2092622.44176 | 37.725648630558 | -122.45992091054 | (37.725648630558, -122.45992091054) | 9 | 7 | 4 | 28861 | 40 | |||
| 175196 | 256319 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 375 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x10 | 5991086 | 2092667 | 37.7255524722344 | -122.473014144078 | (37.7255524722344, -122.473014144078) | 9 | 8 | 4 | 64 | 40 | ||||
| 70659 | 4806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 79364 | 4807 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 121684 | 4809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 136229 | 4808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 3 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
| 44421 | 113145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
| 186930 | 113144 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
| 172105 | 113265 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 BROADMOOR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991046 | 2092853 | 37.7260608659296 | -122.473165978042 | (37.7260608659296, -122.473165978042) | 9 | 8 | 4 | 64 | 40 | ||||
| 48793 | 294 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
| 5478 | 175059 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005473.36477 | 2092951.58695 | 37.7271563601569 | -122.423298402505 | (37.7271563601569, -122.423298402505) | 9 | 7 | 6 | 28861 | 5 | |||
| 25220 | 203990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995096.59699 | 2093007.77703 | 37.7267195459651 | -122.459174609041 | (37.7267195459651, -122.459174609041) | 9 | 7 | 4 | 28861 | 40 | |||
| 114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
| 1031 | 203993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Eastwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5995660.26957 | 2093014.24924 | 37.7267697065318 | -122.457226490416 | (37.7267697065318, -122.457226490416) | 9 | 7 | 4 | 28861 | 40 | |||
| 23841 | 203991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995098.20375 | 2093017.11176 | 37.7267452692552 | -122.45916973021 | (37.7267452692552, -122.45916973021) | 9 | 7 | 4 | 28861 | 40 | |||
| 134936 | 187750 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6018189.80767 | 2093163.42935 | 37.7284475204377 | -122.379352023493 | (37.7284475204377, -122.379352023493) | 10 | 3 | 8 | 58 | 1 | ||||
| 179210 | 112417 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 98X BROADMOOR DR | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | |||
| 135252 | 254189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 187x Stonecrest Dr | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5990830 | 2093201 | 37.7270038779971 | -122.473938047356 | (37.7270038779971, -122.473938047356) | 9 | 8 | 4 | 64 | 40 | |||||
| 159130 | 187751 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6018129.37329 | 2093209.50833 | 37.7285707113551 | -122.379564150189 | (37.7285707113551, -122.379564150189) | 10 | 3 | 8 | 58 | 1 | ||||
| 183618 | 203902 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5002 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5990623.07246 | 2093226.54081 | 37.7270620185855 | -122.474655248248 | (37.7270620185855, -122.474655248248) | 9 | 8 | 4 | 64 | 40 | |||
| 193975 | 203903 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5002 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990622.28371 | 2093237.14363 | 37.727091085566 | -122.474658748425 | (37.727091085566, -122.474658748425) | 9 | 8 | 4 | 64 | 40 | |||
| 193027 | 187752 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6018083.61672 | 2093238.62842 | 37.7286481456935 | -122.379724357202 | (37.7286481456935, -122.379724357202) | 10 | 3 | 8 | 58 | 1 | ||||
| 52910 | 203779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 788 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 5994915.16771 | 2093240.53783 | 37.7273482188287 | -122.459818653129 | (37.7273482188287, -122.459818653129) | 9 | 7 | 4 | 28861 | 40 | |||
| 113147 | 187753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6018088.91826 | 2093246.2132 | 37.7286692644523 | -122.379706556009 | (37.7286692644523, -122.379706556009) | 10 | 3 | 8 | 58 | 1 | ||||
| 71865 | 187756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6018040.44211 | 2093268.12413 | 37.7287267536225 | -122.379875664545 | (37.7287267536225, -122.379875664545) | 10 | 3 | 8 | 58 | 1 | ||||
| 82358 | 187755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | 10 | 3 | 8 | 58 | 1 | ||||
| 180967 | 187754 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.379859346358 | (37.728760777668, -122.379859346358) | 10 | 3 | 8 | 58 | 1 | ||||
| 51410 | 187757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6017577.45499 | 2093289.42876 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | 10 | 3 | 8 | 58 | 1 | ||||
| 176169 | 187758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.381538779893 | (37.7287884075452, -122.381538779893) | 10 | 3 | 8 | 58 | 1 | ||||
| 113579 | 203904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357 | (37.7272777533559, -122.47464379357) | 9 | 8 | 4 | 64 | 40 | |||
| 180202 | 187759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6017547.84189 | 2093311.88395 | 37.7288197237472 | -122.381581673978 | (37.7288197237472, -122.381581673978) | 10 | 3 | 8 | 58 | 1 | ||||
| 5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
| 62455 | 187749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6018386.68976 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | 10 | 3 | 8 | 58 | 1 | ||||
| 103385 | 187760 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6017527.04391 | 2093321.80664 | 37.7288458211654 | -122.381654264546 | (37.7288458211654, -122.381654264546) | 10 | 3 | 8 | 58 | 1 | ||||
| 54987 | 187761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6017511.07328 | 2093334.48306 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | 10 | 3 | 8 | 58 | 1 | ||||
| 182690 | 201544 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601 Innes Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6020625.62552 | 2093377.92947 | 37.7291705267859 | -122.370946000964 | (37.7291705267859, -122.370946000964) | 10 | 3 | 8 | 58 | 1 | ||||
| 125378 | 187762 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 135 Reardon Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6018971.39793 | 2093438.50754 | 37.7292459043613 | -122.376669068821 | (37.7292459043613, -122.376669068821) | 10 | 3 | 8 | 58 | 1 | ||||
| 44642 | 187763 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 135 Reardon Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6018954.68397 | 2093453.67115 | 37.7292866202724 | -122.376727902495 | (37.7292866202724, -122.376727902495) | 10 | 3 | 8 | 58 | 1 | ||||
| 194496 | 265137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Broadmoor Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x6 | 5991049 | 2093460 | 37.7277277099678 | -122.47319985648 | (37.7277277099678, -122.47319985648) | 9 | 8 | 4 | 64 | 40 | ||||
| 41461 | 203906 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990638.47075 | 2093500.44016 | 37.727814969685 | -122.47462199853 | (37.727814969685, -122.47462199853) | 9 | 8 | 4 | 64 | 40 | |||
| 4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
| 121059 | 187765 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | 10 | 3 | 8 | 58 | 1 | ||||
| 144674 | 187764 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6019412.69298 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | 10 | 3 | 8 | 58 | 1 | ||||
| 63689 | 27070 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 801 Silver Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2000 12:00:00 AM | 6 | 4x15 | 6006926.95376 | 2093626.25966 | 37.7290907946921 | -122.418321164017 | (37.7290907946921, -122.418321164017) | 9 | 3 | 7 | 309 | 28 | ||
| 46279 | 254187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 128 Stonecrest Dr | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990776 | 2093635 | 37.7281924051657 | -122.474156376051 | (37.7281924051657, -122.474156376051) | 9 | 8 | 4 | 64 | 40 | |||||
| 56494 | 254186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990762 | 2093642 | 37.7282108143844 | -122.474205284655 | (37.7282108143844, -122.474205284655) | 9 | 8 | 4 | 64 | 40 | ||||
| 91816 | 175060 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.7292089332358 | -122.422256493849 | (37.7292089332358, -122.422256493849) | 9 | 7 | 6 | 28861 | 5 | |||
| 171691 | 29584 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.37809 | 37.728407659786 | -122.472191102253 | (37.728407659786, -122.472191102253) | 9 | 8 | 4 | 64 | 40 | ||
| 133418 | 29972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.472207797253 | (37.7284219643784, -122.472207797253) | 9 | 8 | 4 | 64 | 40 | ||
| 5779 | 175064 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007788.38725 | 2093731.97467 | 37.7294295189361 | -122.415350591757 | (37.7294295189361, -122.415350591757) | 9 | 3 | 7 | 309 | 28 | |||
| 78865 | 203995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 5995937.30914 | 2093745.22314 | 37.7287926928137 | -122.45632160966 | (37.7287926928137, -122.45632160966) | 9 | 7 | 4 | 28861 | 40 | |||
| 127467 | 175057 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 7 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001277.13267 | 2093748.87897 | 37.7291078242617 | -122.437861786319 | (37.7291078242617, -122.437861786319) | 9 | 7 | 6 | 28861 | 25 | |||
| 118510 | 201561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Jerrold Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 6019745.83299 | 2093765.29662 | 37.7301858218198 | -122.374014373583 | (37.7301858218198, -122.374014373583) | 10 | 3 | 8 | 58 | 1 | |||
| 127915 | 175062 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 39 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007558.51768 | 2093776.48674 | 37.7295388171405 | -122.41614842621 | (37.7295388171405, -122.41614842621) | 9 | 3 | 7 | 309 | 28 | |||
| 109757 | 175061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007438.23768 | 2093801.40772 | 37.7296004809653 | -122.416566012029 | (37.7296004809653, -122.416566012029) | 9 | 3 | 7 | 309 | 28 | |||
| 3768 | 262321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990975 | 2093805 | 37.7286707085155 | -122.473480827138 | (37.7286707085155, -122.473480827138) | 9 | 8 | 4 | 64 | 40 | ||||
| 57232 | 100838 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
| 159964 | 100837 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
| 32815 | 253627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 5991061 | 2093828 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | 9 | 8 | 4 | 64 | 40 | ||||
| 97954 | 203853 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 366 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5997667.53367 | 2093836.2933 | 37.7291419238547 | -122.450346700167 | (37.7291419238547, -122.450346700167) | 9 | 7 | 4 | 28861 | 40 | ||||
| 108549 | 203852 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 366 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5997653.19535 | 2093836.43462 | 37.7291414912794 | -122.450396278864 | (37.7291414912794, -122.450396278864) | 9 | 7 | 4 | 28861 | 40 | ||||
| 145350 | 107354 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 34 Princeton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029479 | (37.7297306299075, -122.41634029479) | 9 | 3 | 7 | 309 | 28 | ||||
| 127087 | 100123 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
| 126175 | 175065 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6008350.82377 | 2093981.22418 | 37.7301454998159 | -122.413423808678 | (37.7301454998159, -122.413423808678) | 9 | 3 | 7 | 309 | 28 | |||
| 24797 | 203992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 402 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995690.08771 | 2093990.03586 | 37.7294506943798 | -122.457193967347 | (37.7294506943798, -122.457193967347) | 9 | 7 | 4 | 28861 | 40 | |||
| 130399 | 175063 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 14 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007701.39295 | 2094021.24058 | 37.7302188907855 | -122.415671813399 | (37.7302188907855, -122.415671813399) | 9 | 3 | 7 | 309 | 28 | |||
| 64841 | 175066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Thornton Ave | 1 | Side Yard : Yard | Tree | Private 2 | 8 | 6010981.07617 | 2094029.55145 | 37.7304255280198 | -122.404334038786 | (37.7304255280198, -122.404334038786) | 10 | 3 | 7 | 309 | 28 | ||||
| 37625 | 175067 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Thornton Ave | 2 | Side Yard : Yard | Tree | Private 2 | 26 | 6010979.40226 | 2094033.66945 | 37.7304367416449 | -122.404340115499 | (37.7304367416449, -122.404340115499) | 10 | 3 | 7 | 309 | 28 | ||||
| 162299 | 203781 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 8ft | 5995760.05053 | 2094044.54603 | 37.7296043840153 | -122.456956041797 | (37.7296043840153, -122.456956041797) | 9 | 7 | 4 | 28861 | 40 | |||
| 74908 | 203780 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5995711.83898 | 2094094.29693 | 37.7297382193253 | -122.457126310455 | (37.7297382193253, -122.457126310455) | 9 | 7 | 4 | 28861 | 40 | |||
| 47940 | 97971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | 9 | 3 | 7 | 309 | 28 | |||
| 110893 | 97972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.26524 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | 9 | 3 | 7 | 309 | 28 | |
| 175583 | 203994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Northwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 3ft | 5995717.02889 | 2094139.11586 | 37.7298615793487 | -122.457111609219 | (37.7298615793487, -122.457111609219) | 9 | 7 | 4 | 28861 | 40 | |||
| 25538 | 97980 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 10 | Front Yard : Yard | Tree | Private 2 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | |||
| 190854 | 97981 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 11 | Front Yard : Yard | Tree | Private 2 | 3x105 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | ||||
| 123051 | 97973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 3x105 | Permit Number 767976 | 6008571.29393 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | 9 | 3 | 7 | 309 | 28 | ||
| 38725 | 97974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | 9 | 3 | 7 | 309 | 28 | |
| 39911 | 97975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.7306665633988 | -122.412698416414 | (37.7306665633988, -122.412698416414) | 9 | 3 | 7 | 309 | 28 | ||
| 103927 | 97976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.50101 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | 9 | 3 | 7 | 309 | 28 | |
| 178478 | 97977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008560.78342 | 2094185.68429 | 37.7307186899072 | -122.412712397273 | (37.7307186899072, -122.412712397273) | 9 | 3 | 7 | 309 | 28 | ||
| 158637 | 97978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.53631 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | 9 | 3 | 7 | 309 | 28 | |
| 25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
| 112205 | 74759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 62581 | 175058 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1132x Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | 9 | 7 | 6 | 28861 | 25 | |||
| 66047 | 203851 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5998148.5387 | 2094357.88923 | 37.7306016197611 | -122.448721386881 | (37.7306016197611, -122.448721386881) | 9 | 7 | 4 | 28861 | 40 | |||
| 130312 | 203850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 615 Hearst Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 5997392.45328 | 2094384.93243 | 37.7306326095115 | -122.451337224252 | (37.7306326095115, -122.451337224252) | 9 | 7 | 4 | 28861 | 40 | |||
| 66720 | 203849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 615 Hearst Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5997371.26354 | 2094385.62259 | 37.7306332911786 | -122.451410529785 | (37.7306332911786, -122.451410529785) | 9 | 7 | 4 | 28861 | 40 | |||
| 156355 | 36261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256484 | 37.7307369236006 | -122.472799488507 | (37.7307369236006, -122.472799488507) | 9 | 8 | 4 | 64 | 40 | ||
| 104694 | 203830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 990 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5995335.27016 | 2094553.61244 | 37.730977754916 | -122.45846137649 | (37.730977754916, -122.45846137649) | 9 | 7 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );