trees
3,965 rows where qSpecies_id = 70 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47175 | 24120 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016647.77235 | 2095170.83896 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | 10 | 3 | 8 | 58 | 1 | |||
161067 | 97228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 8 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016642.6726 | 2094934.52661 | 37.7332251597992 | -122.384823929606 | (37.7332251597992, -122.384823929606) | 10 | 3 | 8 | 58 | 1 | |||
87940 | 6594 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6016699.98802 | 2097810.08527 | 37.7411240357598 | -122.384826027706 | (37.7411240357598, -122.384826027706) | 10 | 3 | 8 | 58 | 1 | ||
140312 | 97227 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 7 | Median : Cutout | Tree | DPW 1 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.7332348257283 | -122.384838105605 | (37.7332348257283, -122.384838105605) | 10 | 3 | 8 | 58 | 1 | |||
82895 | 6793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
131456 | 97230 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 10 | Median : Cutout | Tree | DPW 1 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770275 | (37.7331822459561, -122.38487770275) | 10 | 3 | 8 | 58 | 1 | |||
22625 | 188658 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | 10 | 3 | 8 | 58 | 1 | ||||
43206 | 187735 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 299x Cashmere St | 23 | Median : Yard | Tree | DPW 1 | 21 | 6016637.03713 | 2096003.63788 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | 10 | 3 | 8 | 58 | 1 | ||||
23652 | 6630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6016668.82436 | 2097716.7125 | 37.7408659294107 | -122.384927277883 | (37.7408659294107, -122.384927277883) | 10 | 3 | 8 | 58 | 1 | |||
40170 | 24108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016610.88324 | 2095264.18914 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | 10 | 3 | 8 | 58 | 1 | |||
11658 | 6629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575 | (37.7408992492988, -122.38498513575) | 10 | 3 | 8 | 58 | 1 | ||
10167 | 16529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
64669 | 16531 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
105352 | 16532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
126225 | 16533 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
49272 | 6597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016636.56192 | 2097857.72926 | 37.7412513482773 | -122.385048653076 | (37.7412513482773, -122.385048653076) | 10 | 3 | 8 | 58 | 1 | |||
37307 | 1710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.7337466658568 | -122.385057651709 | (37.7337466658568, -122.385057651709) | 10 | 3 | 8 | 58 | 1 | |||
153137 | 187740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 140 Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6016597.29681 | 2096080.68726 | 37.7363697778376 | -122.385060636549 | (37.7363697778376, -122.385060636549) | 10 | 3 | 8 | 58 | 1 | |||
59890 | 188662 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 13 | Median : Yard | Tree | DPW 1 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.385064653831 | (37.7449879810223, -122.385064653831) | 10 | 3 | 8 | 58 | 1 | ||||
31471 | 6631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | ||
41490 | 6632 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
56232 | 6621 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
40300 | 6598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016617.02929 | 2097872.24997 | 37.7412901387305 | -122.385117202121 | (37.7412901387305, -122.385117202121) | 10 | 3 | 8 | 58 | 1 | |||
185673 | 6599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016599.42357 | 2097883.10943 | 37.7413189826895 | -122.38517883355 | (37.7413189826895, -122.38517883355) | 10 | 3 | 8 | 58 | 1 | |||
163831 | 3830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016559.2919121 | 2096123.3914367 | 37.7364849325959 | -122.385195011272 | (37.7364849325959, -122.385195011272) | 10 | 3 | 8 | 58 | 1 | |||
188868 | 6600 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016583.15277 | 2097897.02108 | 37.7413562811582 | -122.385236061921 | (37.7413562811582, -122.385236061921) | 10 | 3 | 8 | 58 | 1 | ||
177454 | 6622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/1998 12:00:00 AM | 17 | 3x3 | 6016518.67204 | 2097829.13318 | 37.7411663074672 | -122.385454286011 | (37.7411663074672, -122.385454286011) | 10 | 3 | 8 | 58 | 1 | ||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
125759 | 188670 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6016501.05956 | 2097495.23618 | 37.7402485196493 | -122.385491920814 | (37.7402485196493, -122.385491920814) | 10 | 3 | 8 | 58 | 1 | |||
131789 | 188669 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6016481.22908 | 2097508.47417 | 37.7402837712823 | -122.385561409649 | (37.7402837712823, -122.385561409649) | 10 | 3 | 8 | 58 | 1 | |||
158853 | 96630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6016481.76683 | 2097857.04453 | 37.7412409044377 | -122.385583836944 | (37.7412409044377, -122.385583836944) | 10 | 3 | 8 | 58 | 1 | |||
119352 | 200611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 51 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | 10 | 3 | 8 | 58 | 1 | |||
5095 | 200603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 52 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.385609317623 | (37.733790555057, -122.385609317623) | 10 | 3 | 8 | 58 | 1 | |||
72267 | 200610 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 50 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.7338361346818 | -122.385618942498 | (37.7338361346818, -122.385618942498) | 10 | 3 | 8 | 58 | 1 | |||
53567 | 188668 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 4 | : | Tree | Private 2 | 20 | Width 3ft | 6016461.41384 | 2097522.46714 | 37.7403210967391 | -122.38563089846 | (37.7403210967391, -122.38563089846) | 10 | 3 | 8 | 58 | 1 | |||
60668 | 200609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 49 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | 10 | 3 | 8 | 58 | 1 | |||
101719 | 200607 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 48 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.7338946990483 | -122.385657689133 | (37.7338946990483, -122.385657689133) | 10 | 3 | 8 | 58 | 1 | |||
81655 | 188698 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 2 | : | Tree | Private 2 | 16 | Width 4ft | 6016460.57689 | 2097987.87635 | 37.7415989695148 | -122.385666221144 | (37.7415989695148, -122.385666221144) | 10 | 3 | 8 | 58 | 1 | |||
96442 | 200606 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 47 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6016400.6473 | 2095190.9605 | 37.7339158869669 | -122.385678551006 | (37.7339158869669, -122.385678551006) | 10 | 3 | 8 | 58 | 1 | |||
150030 | 200605 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 46 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016398.6886 | 2095199.7747 | 37.7339399806144 | -122.385685937001 | (37.7339399806144, -122.385685937001) | 10 | 3 | 8 | 58 | 1 | |||
184694 | 200602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 45 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016396.2402 | 2095212.996 | 37.7339761481789 | -122.385695323117 | (37.7339761481789, -122.385695323117) | 10 | 3 | 8 | 58 | 1 | |||
12630 | 24191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
38350 | 24195 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
69170 | 24189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
76219 | 24174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
85556 | 24193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
104714 | 24182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
161053 | 24169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x6 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
119805 | 24133 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | |||
122528 | 24131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | |||
136644 | 24132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | ||
97745 | 104425 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101x WHITNEY YOUNG CIR | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6016394 | 2096049 | 37.7362715234519 | -122.385761317359 | (37.7362715234519, -122.385761317359) | 10 | 3 | 8 | 58 | 1 | |||
148592 | 188699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 4 | : | Tree | Private 2 | 20 | Width 4ft | 6016428.50781 | 2098012.06788 | 37.7416636199942 | -122.385778791959 | (37.7416636199942, -122.385778791959) | 10 | 3 | 8 | 58 | 1 | |||
56156 | 187741 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6016390.28523 | 2096223.19416 | 37.7367496199859 | -122.385786298601 | (37.7367496199859, -122.385786298601) | 10 | 3 | 8 | 58 | 1 | |||
93098 | 200574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 44 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016364.4111 | 2095326.6015 | 37.734286324847 | -122.385813282871 | (37.734286324847, -122.385813282871) | 10 | 3 | 8 | 58 | 1 | |||
72380 | 24224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016378.0406117 | 2096157.2731291 | 37.7365679365277 | -122.385824040568 | (37.7365679365277, -122.385824040568) | 10 | 3 | 8 | 58 | 1 | ||
44010 | 8228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
113411 | 8226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
151275 | 8227 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
163516 | 8234 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
172912 | 8235 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
192327 | 8238 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6X3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
192645 | 8247 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
4954 | 24213 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35242 | 24203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35467 | 24214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
39608 | 24202 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
57732 | 24215 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
104543 | 24216 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3.5x3.5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
125868 | 24210 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
161485 | 24208 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x6 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
171234 | 24212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2002 12:00:00 AM | 9 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | ||
172644 | 24201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
160018 | 24148 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | |||
166691 | 24142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | |||
31144 | 187736 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 15 | 6016350.44721 | 2096194.42304 | 37.7366684157019 | -122.385922032401 | (37.7366684157019, -122.385922032401) | 10 | 3 | 8 | 58 | 1 | ||||
151230 | 188700 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 6 | : | Tree | Private 2 | 17 | Width 4ft | 6016385.13466 | 2098043.91296 | 37.7417486598831 | -122.385930982422 | (37.7417486598831, -122.385930982422) | 10 | 3 | 8 | 58 | 1 | |||
45493 | 200568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 40 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016324.0126 | 2095472.2809 | 37.7346840956345 | -122.385963106208 | (37.7346840956345, -122.385963106208) | 10 | 3 | 8 | 58 | 1 | |||
34893 | 200562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 38 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016315.2256 | 2095489.7997 | 37.7347317124513 | -122.385994706933 | (37.7347317124513, -122.385994706933) | 10 | 3 | 8 | 58 | 1 | |||
157221 | 200560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 37 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016311.7963 | 2095496.5134 | 37.7347499571366 | -122.386007031154 | (37.7347499571366, -122.386007031154) | 10 | 3 | 8 | 58 | 1 | |||
29679 | 187742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6016301.16013 | 2096254.5278 | 37.7368307235506 | -122.38609662946 | (37.7368307235506, -122.38609662946) | 10 | 3 | 8 | 58 | 1 | |||
3157 | 187766 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6016303.05185 | 2097377.33964 | 37.7399138423363 | -122.38616834141 | (37.7399138423363, -122.38616834141) | 10 | 3 | 8 | 58 | 1 | |||
155772 | 6824 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
67366 | 200556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 32 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.386181017716 | (37.734917146653, -122.386181017716) | 10 | 3 | 8 | 58 | 1 | |||
27962 | 110465 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 9 | 3x3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
92568 | 6832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
164393 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 Fairfax Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||||
38820 | 16539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016303.7553 | 2098109.62008 | 37.7419245742859 | -122.38621694766 | (37.7419245742859, -122.38621694766) | 10 | 3 | 8 | 58 | 1 | |||
159607 | 200555 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 31 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016252.4072 | 2095574.3949 | 37.7349605171331 | -122.386217789361 | (37.7349605171331, -122.386217789361) | 10 | 3 | 8 | 58 | 1 | |||
13821 | 187767 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6016274.41454 | 2097399.64045 | 37.7399734907733 | -122.386268912575 | (37.7399734907733, -122.386268912575) | 10 | 3 | 8 | 58 | 1 | |||
29316 | 200553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 29 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016224.313 | 2095613.1578 | 37.7350653972301 | -122.386317623483 | (37.7350653972301, -122.386317623483) | 10 | 3 | 8 | 58 | 1 | |||
78663 | 200554 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 30 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6016223.9574 | 2095601.7778 | 37.7350341303539 | -122.386318059776 | (37.7350341303539, -122.386318059776) | 10 | 3 | 8 | 58 | 1 | |||
100332 | 6639 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X6 | 6016272.53001 | 2098019.7733 | 37.7416761450143 | -122.386318652968 | (37.7416761450143, -122.386318652968) | 10 | 3 | 8 | 58 | 1 | |||
157779 | 6635 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 08:50:00 AM | 3 | 3X3 | 6016265.44572 | 2098016.26019 | 37.7416661065968 | -122.386342903418 | (37.7416661065968, -122.386342903418) | 10 | 3 | 8 | 58 | 1 | ||
29769 | 200551 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 27 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016216.4893 | 2095621.6927 | 37.735088399287 | -122.38634526793 | (37.735088399287, -122.38634526793) | 10 | 3 | 8 | 58 | 1 | |||
67985 | 187772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1427x Innes Ave | 15 | Median : Yard | Tree | DPW 1 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | 10 | 3 | 8 | 58 | 1 | ||||
95510 | 200552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 28 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6016213.9999 | 2095615.2915 | 37.7350706850821 | -122.386353428604 | (37.7350706850821, -122.386353428604) | 10 | 3 | 8 | 58 | 1 |
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) );