trees
484 rows where qSpecies_id = 56 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44214 | 208933 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 405 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 10ft | 5992936.60702 | 2096064.26617 | 37.7349874937845 | -122.466863664131 | (37.7349874937845, -122.466863664131) | 1 | 8 | 4 | 59 | 40 | |||
| 44574 | 208991 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 45 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5993638.39674 | 2097082.374 | 37.7378234437858 | -122.464511248112 | (37.7378234437858, -122.464511248112) | 1 | 8 | 4 | 59 | 40 | |||
| 44584 | 116530 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 745X SANCHEZ ST | 7 | Median : Yard | Tree | DPW 1 | 45 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
| 44889 | 191727 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | 10 | 3 | 8 | 28856 | 29 | ||||
| 45573 | 208969 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 30 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 6ft | 5993545.78483 | 2097101.19005 | 37.7378697687758 | -122.464832815983 | (37.7378697687758, -122.464832815983) | 1 | 8 | 4 | 59 | 40 | |||
| 45615 | 251302 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Cashmere St | 1 | Back Yard : Yard | Tree | Health Dept 13 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
| 45655 | 121204 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 52 | 6008473.20212 | 2119153.5676 | 37.7992698007193 | -122.41478152415 | (37.7992698007193, -122.41478152415) | 5 | 1 | 10 | 308 | 32 | ||||
| 46802 | 176341 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 500x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | 10 | 3 | 8 | 309 | 28 | |||
| 47155 | 176337 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 59 | Width 0ft | 6011478.9031 | 2090656.66454 | 37.7211920833183 | -122.402375903539 | (37.7211920833183, -122.402375903539) | 10 | 3 | 8 | 309 | 28 | |||
| 47282 | 207782 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 260 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 10ft | 5993076.07579 | 2096352.69881 | 37.7357875063795 | -122.466402431535 | (37.7357875063795, -122.466402431535) | 1 | 8 | 4 | 59 | 40 | |||
| 47520 | 209045 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300 Melrose Ave | 3 | Side Yard : Yard | Tree | Private 2 | 88 | 5998032.35629 | 2095523.65591 | 37.7337958938523 | -122.449206999226 | (37.7337958938523, -122.449206999226) | 9 | 7 | 4 | 59 | 40 | ||||
| 47849 | 209028 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 5 | Front Yard : Yard | Tree | Private 2 | 29 | 6000760.3597 | 2095574.56127 | 37.7340913256606 | -122.439779148088 | (37.7340913256606, -122.439779148088) | 9 | 7 | 5 | 63 | 40 | ||||
| 49183 | 208959 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 601 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 8ft | 5993493.92403 | 2096119.04846 | 37.7351700624345 | -122.46494081468 | (37.7351700624345, -122.46494081468) | 1 | 8 | 4 | 59 | 40 | |||
| 49989 | 207806 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 35 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5993241.00806 | 2097448.11917 | 37.7388047723291 | -122.465911770435 | (37.7388047723291, -122.465911770435) | 1 | 8 | 4 | 59 | 40 | |||
| 50310 | 176345 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | 9 | 7 | 8 | 309 | 18 | ||||
| 51052 | 207773 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 80 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 58 | Width 10ft | 5993272.22832 | 2097088.94625 | 37.7378203744176 | -122.465777737259 | (37.7378203744176, -122.465777737259) | 1 | 8 | 4 | 59 | 40 | |||
| 51225 | 254298 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 140 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5991388 | 2095260 | 37.73268968153 | -122.472159089582 | (37.73268968153, -122.472159089582) | 1 | 8 | 4 | 64 | 40 | ||||
| 51387 | 224267 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 3 | Front Yard : Yard | Tree | Private 2 | 26 | 6011260.20343 | 2103721.90369 | 37.7570542343818 | -122.40405088815 | (37.7570542343818, -122.40405088815) | 10 | 4 | 8 | 28859 | 19 | ||||
| 51836 | 209018 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 3 | : Yard | Tree | Private 2 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | 9 | 7 | 5 | 63 | 40 | ||||
| 52709 | 191734 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 7 | Front Yard : Yard | Tree | Private 2 | 22 | 6009976.80194 | 2107534.39117 | 37.7674506697311 | -122.408758358812 | (37.7674506697311, -122.408758358812) | 8 | 4 | 8 | 28853 | 19 | ||||
| 53008 | 209014 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.439676364596 | (37.733789492485, -122.439676364596) | 9 | 7 | 5 | 63 | 40 | ||||
| 55299 | 208919 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 10ft | 5992247.91507 | 2096042.07051 | 37.734886777798 | -122.469243079632 | (37.734886777798, -122.469243079632) | 1 | 8 | 4 | 59 | 40 | |||
| 56734 | 173683 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
| 56798 | 208958 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 625 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 8ft | 5993531.51586 | 2096121.15742 | 37.7351780205546 | -122.464811000239 | (37.7351780205546, -122.464811000239) | 1 | 8 | 4 | 59 | 40 | |||
| 56919 | 208997 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5993343.64638 | 2097250.7379 | 37.7382687332076 | -122.465542562746 | (37.7382687332076, -122.465542562746) | 1 | 8 | 4 | 59 | 40 | |||
| 57886 | 209012 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 410 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6000789.00569 | 2095372.0781 | 37.7335369844496 | -122.439665598801 | (37.7335369844496, -122.439665598801) | 9 | 7 | 5 | 63 | 40 | ||||
| 58428 | 209046 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.7322909323756 | -122.442419949729 | (37.7322909323756, -122.442419949729) | 9 | 7 | 4 | 63 | 40 | |||
| 59460 | 207755 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.461131260407 | (37.7604304368423, -122.461131260407) | 15 | 5 | 4 | 56 | 12 | ||||
| 59512 | 207781 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 256 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993074.74882 | 2096403.4667 | 37.7359268257591 | -122.466410707985 | (37.7359268257591, -122.466410707985) | 1 | 8 | 4 | 59 | 40 | |||
| 59596 | 224230 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 9 | 6004850.15407 | 2096702.70071 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | 2 | 7 | 5 | 63 | 7 | ||||
| 61418 | 224219 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 7 | 6004118.53569 | 2095824.97349 | 37.7349694794509 | -122.428186723249 | (37.7349694794509, -122.428186723249) | 2 | 7 | 5 | 28861 | 2 | ||||
| 61500 | 208994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 21 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5993511.28023 | 2097168.00802 | 37.7380512447772 | -122.464956965598 | (37.7380512447772, -122.464956965598) | 1 | 8 | 4 | 59 | 40 | |||
| 62369 | 209003 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 96 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 3ft | 5994450.97172 | 2101378.39351 | 37.7496660456507 | -122.462013248027 | (37.7496660456507, -122.462013248027) | 1 | 8 | 4 | 29491 | 40 | |||
| 62726 | 207808 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 15 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5993219.05388 | 2097526.21938 | 37.7390179494069 | -122.465993350619 | (37.7390179494069, -122.465993350619) | 1 | 8 | 4 | 59 | 40 | |||
| 63658 | 209035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 427 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 32 | 6000759.78323 | 2095371.55913 | 37.7335338961641 | -122.439766591781 | (37.7335338961641, -122.439766591781) | 9 | 7 | 5 | 63 | 40 | ||||
| 63828 | 247922 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 24 | 6010270.94858 | 2098720.09099 | 37.7432650373678 | -122.40711956383 | (37.7432650373678, -122.40711956383) | 10 | 7 | 7 | 28859 | 2 | ||||
| 64352 | 209010 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 408 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 41 | 6000785.06362 | 2095352.20634 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | 9 | 7 | 5 | 63 | 40 | ||||
| 64704 | 224244 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 38 | Front Yard : Yard | Tree | Private 2 | 23 | 6004777.47133 | 2096641.46229 | 37.7372486349267 | -122.425966651467 | (37.7372486349267, -122.425966651467) | 2 | 7 | 5 | 63 | 7 | ||||
| 64758 | 191722 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014479.64038 | 2101959.5389 | 37.7523945096015 | -122.392793471535 | (37.7523945096015, -122.392793471535) | 10 | 3 | 8 | 28856 | 1 | ||||
| 65072 | 224234 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 24 | Front Yard : Yard | Tree | Private 2 | 13 | 6004836.88053 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | 2 | 7 | 5 | 63 | 7 | ||||
| 65313 | 114042 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 LINARES AVE | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5994258 | 2102054 | 37.7515099774588 | -122.462729551044 | (37.7515099774588, -122.462729551044) | 1 | 8 | 4 | 29491 | 40 | ||||
| 65378 | 208922 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 201 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5992403.02946 | 2096048.00133 | 37.7349120244605 | -122.468707231169 | (37.7349120244605, -122.468707231169) | 1 | 8 | 4 | 59 | 40 | |||
| 65425 | 191724 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 5 | Median : Yard | Tree | DPW 1 | 43 | 6011608.52294 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | 10 | 3 | 8 | 28856 | 29 | ||||
| 65949 | 207807 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 25 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 10ft | 5993231.15579 | 2097483.74028 | 37.7389020106052 | -122.465948422302 | (37.7389020106052, -122.465948422302) | 1 | 8 | 4 | 59 | 40 | |||
| 66487 | 207756 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | 15 | 5 | 4 | 56 | 12 | ||||
| 66557 | 13410 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 364 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
| 66615 | 185931 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985001.315 | 2101504.3546 | 37.749463324704 | -122.494699314147 | (37.749463324704, -122.494699314147) | 1 | 8 | 3 | 29491 | 35 | |||
| 66814 | 114041 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 LINARES AVE | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5994258 | 2102054 | 37.7515099774588 | -122.462729551044 | (37.7515099774588, -122.462729551044) | 1 | 8 | 4 | 29491 | 40 | ||||
| 67100 | 247923 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.407058269637 | (37.7432925026595, -122.407058269637) | 10 | 7 | 7 | 28859 | 2 | ||||
| 68807 | 43994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | 8 | 4 | 8 | 28853 | 19 | ||
| 69473 | 224239 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 37 | 6004801.05123 | 2096666.83115 | 37.7373196246961 | -122.425886930149 | (37.7373196246961, -122.425886930149) | 2 | 7 | 5 | 63 | 7 | ||||
| 70219 | 111551 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 29 | Front Yard : Yard | Tree | DPW 1 | 27 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 71078 | 247924 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 9 | Side Yard : Yard | Tree | Private 2 | 23 | 6010297.69523 | 2098727.78354 | 37.7432876562154 | -122.407027622545 | (37.7432876562154, -122.407027622545) | 10 | 7 | 7 | 28859 | 2 | ||||
| 71372 | 208972 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 136 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 6ft | 5994281.63654 | 2096550.25213 | 37.7363994284866 | -122.462248690521 | (37.7363994284866, -122.462248690521) | 9 | 8 | 4 | 59 | 40 | |||
| 73242 | 224246 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 483 Valley St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 55 | 6002830.24391 | 2099168.61142 | 37.7440773607828 | -122.432879592517 | (37.7440773607828, -122.432879592517) | 2 | 7 | 5 | 63 | 22 | ||||
| 73374 | 207800 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 10ft | 5993292.57138 | 2096874.95335 | 37.7372339768612 | -122.465691859205 | (37.7372339768612, -122.465691859205) | 1 | 8 | 4 | 59 | 40 | |||
| 74892 | 209034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 3 | Front Yard : Yard | Tree | Private 2 | 30 | 6000740.95615 | 2095584.22378 | 37.7341167521787 | -122.439846924607 | (37.7341167521787, -122.439846924607) | 9 | 7 | 5 | 63 | 40 | ||||
| 75560 | 207778 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.466005173107 | (37.7369852648432, -122.466005173107) | 1 | 8 | 4 | 59 | 40 | |||
| 75661 | 176344 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008453.92432 | 2088393.60062 | 37.7148088537086 | -122.412672519523 | (37.7148088537086, -122.412672519523) | 9 | 7 | 8 | 309 | 18 | ||||
| 76221 | 224266 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6011271.09407 | 2103721.28577 | 37.7570531461907 | -122.404013180481 | (37.7570531461907, -122.404013180481) | 10 | 4 | 8 | 28859 | 19 | ||||
| 76480 | 208928 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 335 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 44 | Width 10ft | 5992778.53612 | 2096059.14942 | 37.7349643200549 | -122.467409794552 | (37.7349643200549, -122.467409794552) | 1 | 8 | 4 | 59 | 40 | |||
| 77234 | 207754 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5993663.75343 | 2106217.17575 | 37.7629067380829 | -122.4650868556 | (37.7629067380829, -122.4650868556) | 1 | 8 | 11 | 56 | 12 | |||
| 77703 | 224237 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | 2 | 7 | 5 | 63 | 7 | ||||
| 77709 | 209026 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 6000767.091 | 2095571.91906 | 37.7340844539158 | -122.439755686569 | (37.7340844539158, -122.439755686569) | 9 | 7 | 5 | 63 | 40 | ||||
| 77856 | 254300 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 140 Junipero Serra Blvd | 3 | Median : Cutout | Tree | Private 2 | 3x3 | 5991388 | 2095260 | 37.73268968153 | -122.472159089582 | (37.73268968153, -122.472159089582) | 1 | 8 | 4 | 64 | 40 | ||||
| 77868 | 207784 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 270 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 10ft | 5993081.21532 | 2096255.53806 | 37.7355210237716 | -122.466377603044 | (37.7355210237716, -122.466377603044) | 1 | 8 | 4 | 59 | 40 | |||
| 78408 | 254301 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 140 Junipero Serra Blvd | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 5991388 | 2095260 | 37.73268968153 | -122.472159089582 | (37.73268968153, -122.472159089582) | 1 | 8 | 4 | 64 | 40 | ||||
| 78464 | 224232 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 22 | Front Yard : Yard | Tree | Private 2 | 6 | 6004847.66693 | 2096700.74316 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | 2 | 7 | 5 | 63 | 7 | ||||
| 78746 | 224242 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 5 | 6004773.22407 | 2096631.25513 | 37.7372203683314 | -122.425980609816 | (37.7372203683314, -122.425980609816) | 2 | 7 | 5 | 63 | 7 | ||||
| 79003 | 208937 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 64 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5991925.34536 | 2095973.96809 | 37.7346811406131 | -122.470353347532 | (37.7346811406131, -122.470353347532) | 9 | 8 | 4 | 59 | 40 | |||
| 79769 | 207767 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 20 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5993205.66214 | 2097402.75145 | 37.7386781648646 | -122.466030683288 | (37.7386781648646, -122.466030683288) | 1 | 8 | 4 | 59 | 40 | |||
| 80047 | 254287 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
| 80068 | 207790 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 265 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 10ft | 5993131.48438 | 2096255.50329 | 37.735523828762 | -122.466203802777 | (37.735523828762, -122.466203802777) | 1 | 8 | 4 | 59 | 40 | |||
| 80374 | 248219 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Fair Ave | 2 | Side Yard : Yard | Tree | Private 2 | 38 | 6007128.32554 | 2099340.74379 | 37.7447928407342 | -122.418029950029 | (37.7447928407342, -122.418029950029) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80518 | 207797 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 145 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 10ft | 5993240.65413 | 2096747.66446 | 37.7368814785997 | -122.465862113458 | (37.7368814785997, -122.465862113458) | 1 | 8 | 4 | 59 | 40 | |||
| 81100 | 207787 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 292 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 5993086.25016 | 2096104.57414 | 37.7351068050182 | -122.466349227661 | (37.7351068050182, -122.466349227661) | 1 | 8 | 4 | 59 | 40 | |||
| 81221 | 208950 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 440 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5992985.54967 | 2096006.72468 | 37.7348323238367 | -122.466690272156 | (37.7348323238367, -122.466690272156) | 9 | 8 | 4 | 59 | 40 | |||
| 81662 | 209017 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 1 | : Yard | Tree | Private 2 | 25 | 6000774.79116 | 2095519.58157 | 37.7339411856303 | -122.439725313784 | (37.7339411856303, -122.439725313784) | 9 | 7 | 5 | 63 | 40 | ||||
| 82650 | 209042 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 7 | Front Yard : Yard | Tree | Private 2 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | 9 | 7 | 5 | 63 | 40 | ||||
| 82743 | 209039 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6000750.66308 | 2095345.51302 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | 9 | 7 | 5 | 63 | 40 | ||||
| 82917 | 254315 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5991374 | 2095037 | 37.73207656946 | -122.472191241156 | (37.73207656946, -122.472191241156) | 1 | 8 | 4 | 64 | 40 | ||||
| 82973 | 126581 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 556 Pine St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | 5 | 1 | 10 | 28857 | 6 | |||
| 83967 | 176343 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 76 | 6008484.74111 | 2088383.42134 | 37.7147826330863 | -122.412565284366 | (37.7147826330863, -122.412565284366) | 9 | 7 | 8 | 309 | 18 | ||||
| 84225 | 209038 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6000746.77902 | 2095349.32051 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) | 9 | 7 | 5 | 63 | 40 | ||||
| 84733 | 253848 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 230 Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 10X10 | 5991365 | 2094903 | 37.7317081183109 | -122.472212591573 | (37.7317081183109, -122.472212591573) | 1 | 8 | 4 | 64 | 40 | ||||
| 84756 | 208946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 10ft | 5992719.83793 | 2096001.79663 | 37.7348034547201 | -122.467608563598 | (37.7348034547201, -122.467608563598) | 9 | 8 | 4 | 59 | 40 | |||
| 85322 | 208931 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 435 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 10ft | 5993027.44059 | 2096068.92828 | 37.7350055368649 | -122.466549961711 | (37.7350055368649, -122.466549961711) | 1 | 8 | 4 | 59 | 40 | |||
| 85357 | 208926 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 10ft | 5992668.30531 | 2096054.89965 | 37.7349462868375 | -122.467790589077 | (37.7349462868375, -122.467790589077) | 1 | 8 | 4 | 59 | 40 | |||
| 86597 | 208949 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 402 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5992933.73617 | 2096006.17085 | 37.7348278128415 | -122.466869367631 | (37.7348278128415, -122.466869367631) | 9 | 8 | 4 | 59 | 40 | |||
| 87214 | 224248 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055214 | (37.7487943903519, -122.43643055214) | 2 | 4 | 5 | 28862 | 22 | |||
| 87323 | 173856 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | ||||
| 87775 | 246757 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 1 | Front Yard : Yard | Tree | Private 2 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161979 | (37.7436943673943, -122.41112161979) | 2 | 7 | 7 | 28859 | 2 | ||||
| 88934 | 247919 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 22 | 6010242.48982 | 2098715.37522 | 37.7432504962209 | -122.40721763491 | (37.7432504962209, -122.40721763491) | 10 | 7 | 7 | 28859 | 2 | ||||
| 89376 | 209032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6000749.17916 | 2095580.79962 | 37.7341078183059 | -122.439818249733 | (37.7341078183059, -122.439818249733) | 9 | 7 | 5 | 63 | 40 | ||||
| 89483 | 224222 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6004869.89816 | 2096730.73115 | 37.7374989702074 | -122.425653440952 | (37.7374989702074, -122.425653440952) | 2 | 7 | 5 | 63 | 7 | ||||
| 89575 | 113506 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 39 | 3x3 | 6011135.08211 | 2090555.53588 | 37.7208952054249 | -122.403557288932 | (37.7208952054249, -122.403557288932) | 10 | 3 | 7 | 309 | 28 | |||
| 90994 | 113367 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 6X Christopher Dr | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | 1 | 5 | 4 | 63 | 12 | ||||
| 91634 | 208930 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 435 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 55 | Width 10ft | 5993068.37064 | 2096069.711 | 37.7350100478567 | -122.466408510055 | (37.7350100478567, -122.466408510055) | 1 | 8 | 4 | 59 | 40 | |||
| 91970 | 208996 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | 1 | 8 | 4 | 59 | 40 | |||
| 91988 | 224256 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6001050.21768 | 2107873.33716 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | 15 | 5 | 5 | 29492 | 3 |
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) );