trees
3,965 rows where qSpecies_id = 70 sorted by XCoord descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
152157 | 187720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017189.12097 | 2094942.52157 | 37.7332773204746 | -122.382935246271 | (37.7332773204746, -122.382935246271) | 10 | 3 | 8 | 58 | 1 | |||
140409 | 188696 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 12 | : | Tree | Private 2 | 20 | Width 4ft | 6017175.78475 | 2097338.59897 | 37.7398557335482 | -122.383148069031 | (37.7398557335482, -122.383148069031) | 10 | 3 | 8 | 58 | 1 | |||
173948 | 6569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1303 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017171.79019 | 2097333.44943 | 37.7398413732106 | -122.38316152235 | (37.7398413732106, -122.38316152235) | 10 | 3 | 8 | 58 | 1 | |||
29162 | 188675 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 5 | : | Tree | Private 2 | 21 | Width 4ft | 6017168.99246 | 2097078.35566 | 37.739140782423 | -122.383153445176 | (37.739140782423, -122.383153445176) | 10 | 3 | 8 | 58 | 1 | |||
85871 | 24225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.40196 | 2094982.30239 | 37.7333853506538 | -122.383013103287 | (37.7333853506538, -122.383013103287) | 10 | 3 | 8 | 58 | 1 | ||
101376 | 187719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6017160.21772 | 2094934.24591 | 37.7332530001163 | -122.383034597962 | (37.7332530001163, -122.383034597962) | 10 | 3 | 8 | 58 | 1 | |||
92090 | 188695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 10 | : | Tree | Private 2 | 15 | Width 3ft | 6017144.28131 | 2097363.3609 | 37.739921983914 | -122.383258718941 | (37.739921983914, -122.383258718941) | 10 | 3 | 8 | 58 | 1 | |||
48195 | 24226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.383122261179 | (37.7333610509772, -122.383122261179) | 10 | 3 | 8 | 58 | 1 | |||
144610 | 188568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 24 | : Yard | Tree | Private 2 | 38 | 6017120.70508 | 2102612.37668 | 37.7543334029878 | -122.383705595635 | (37.7543334029878, -122.383705595635) | 10 | 3 | 8 | 28856 | 29 | ||||
19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
153892 | 6491 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017120.02701 | 2097502.66601 | 37.7403031472893 | -122.383352275591 | (37.7403031472893, -122.383352275591) | 10 | 3 | 8 | 58 | 1 | |||
152216 | 188676 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 8 | : | Tree | Private 2 | 19 | Width 4ft | 6017117.52195 | 2097116.26843 | 37.7392420388994 | -122.383334047038 | (37.7392420388994, -122.383334047038) | 10 | 3 | 8 | 58 | 1 | |||
175633 | 6571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017110.8649657 | 2097380.9593528 | 37.7399684589918 | -122.383375484618 | (37.7399684589918, -122.383375484618) | 10 | 3 | 8 | 58 | 1 | |||
157395 | 188569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 26 | : Yard | Tree | Private 2 | 5 | 6017110.36972 | 2102585.17266 | 37.7542581351188 | -122.383739444343 | (37.7542581351188, -122.383739444343) | 10 | 3 | 8 | 28856 | 29 | ||||
103549 | 188694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6017109.80778 | 2097388.18297 | 37.7399882351628 | -122.38337964268 | (37.7399882351628, -122.38337964268) | 10 | 3 | 8 | 58 | 1 | |||
131193 | 24228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6017105.82846 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | 10 | 3 | 8 | 58 | 1 | |||
102039 | 188659 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 3 | Median : Yard | Tree | DPW 1 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | 10 | 3 | 8 | 58 | 1 | ||||
106506 | 6492 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017102.13601 | 2097515.78601 | 37.7403381833964 | -122.383415049232 | (37.7403381833964, -122.383415049232) | 10 | 3 | 8 | 58 | 1 | |||
85436 | 6572 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1327 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017100.6753245 | 2097388.5899931 | 37.7399888480471 | -122.383411247575 | (37.7399888480471, -122.383411247575) | 10 | 3 | 8 | 58 | 1 | |||
158947 | 6731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.47437 | 37.7392827179327 | -122.383402261517 | (37.7392827179327, -122.383402261517) | 10 | 3 | 8 | 58 | 1 | ||
110062 | 6573 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017090.4856833 | 2097396.2206334 | 37.7400092370914 | -122.383447010551 | (37.7400092370914, -122.383447010551) | 10 | 3 | 8 | 58 | 1 | |||
76607 | 188660 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 22 | 6017087.32908 | 2098898.60664 | 37.7441343103446 | -122.383562491039 | (37.7441343103446, -122.383562491039) | 10 | 3 | 8 | 58 | 1 | ||||
149256 | 187776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6017085.14253 | 2097027.72746 | 37.7389971337102 | -122.383439839679 | (37.7389971337102, -122.383439839679) | 10 | 3 | 8 | 58 | 1 | |||
40653 | 6493 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 12 | 3x3 | 6017084.24401 | 2097528.90701 | 37.7403732221604 | -122.38347782646 | (37.7403732221604, -122.38347782646) | 10 | 3 | 8 | 58 | 1 | ||
160704 | 6732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017081.22678 | 2097144.85805 | 37.7393185343335 | -122.383461530425 | (37.7393185343335, -122.383461530425) | 10 | 3 | 8 | 58 | 1 | |||
86464 | 6772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.54071 | 37.7391349889858 | -122.383547704374 | (37.7391349889858, -122.383547704374) | 10 | 3 | 8 | 58 | 1 | ||
143417 | 187775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6017053.32881 | 2096987.93599 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | 10 | 3 | 8 | 58 | 1 | |||
43411 | 6580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | |||
126345 | 6578 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | |||
158606 | 187774 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6017047.63402 | 2096978.70465 | 37.738860453847 | -122.383566116201 | (37.738860453847, -122.383566116201) | 10 | 3 | 8 | 58 | 1 | |||
116777 | 187773 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 3ft | 6017040.80621 | 2097089.42063 | 37.7391640802698 | -122.383597429682 | (37.7391640802698, -122.383597429682) | 10 | 3 | 8 | 58 | 1 | |||
91391 | 6775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017039.80382 | 2097089.47454 | 37.7391641728912 | -122.383600899281 | (37.7391641728912, -122.383600899281) | 10 | 3 | 8 | 58 | 1 | ||
64263 | 6567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2004 12:00:00 AM | 5 | 3X3 | 6017004.85053 | 2097463.70294 | 37.7401897966309 | -122.383747801739 | (37.7401897966309, -122.383747801739) | 10 | 3 | 8 | 58 | 1 | ||
76377 | 187724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6017001.33944 | 2094943.49204 | 37.7332696078935 | -122.383584532495 | (37.7332696078935, -122.383584532495) | 10 | 3 | 8 | 58 | 1 | |||
140578 | 6566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/02/1992 12:00:00 AM | 19 | 3X3 | 6016992.23508 | 2097474.99816 | 37.7402201136747 | -122.383792207542 | (37.7402201136747, -122.383792207542) | 10 | 3 | 8 | 58 | 1 | ||
128771 | 187725 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6016988.86725 | 2094945.03684 | 37.733273160235 | -122.383627760212 | (37.733273160235, -122.383627760212) | 10 | 3 | 8 | 58 | 1 | |||
170737 | 187718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016979.12184 | 2094899.73634 | 37.7331482353903 | -122.383658300306 | (37.7331482353903, -122.383658300306) | 10 | 3 | 8 | 58 | 1 | |||
71055 | 187717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6016962.05106 | 2094901.44283 | 37.7331519774826 | -122.383717437926 | (37.7331519774826, -122.383717437926) | 10 | 3 | 8 | 58 | 1 | |||
28295 | 3742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.7444710828997 | -122.38401932754 | (37.7444710828997, -122.38401932754) | 10 | 3 | 8 | 58 | 1 | |||
67591 | 187716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6016950.63846 | 2094900.99132 | 37.7331501068758 | -122.383756863312 | (37.7331501068758, -122.383756863312) | 10 | 3 | 8 | 58 | 1 | |||
57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 | |||||
155250 | 6502 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016937.53001 | 2097643.41501 | 37.7406795281671 | -122.383993082034 | (37.7406795281671, -122.383993082034) | 10 | 3 | 8 | 58 | 1 | |||
33139 | 188693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 Evans Ave | 2 | : | Tree | Private 2 | 20 | Width 4ft | 6016935.69851 | 2097636.39062 | 37.7406601393594 | -122.383998925709 | (37.7406601393594, -122.383998925709) | 10 | 3 | 8 | 58 | 1 | |||
107088 | 188661 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 8 | Median : Yard | Tree | DPW 1 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | 10 | 3 | 8 | 58 | 1 | ||||
75803 | 6795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016906.37547 | 2097191.59326 | 37.7394371944809 | -122.384069348045 | (37.7394371944809, -122.384069348045) | 10 | 3 | 8 | 58 | 1 | |||
57172 | 6797 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | 10 | 3 | 8 | 58 | 1 | |||
111877 | 187726 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6016892.38136 | 2094959.59167 | 37.7333077913283 | -122.383962354797 | (37.7333077913283, -122.383962354797) | 10 | 3 | 8 | 58 | 1 | |||
78655 | 6794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.45833 | 2097207.36346 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | 10 | 3 | 8 | 58 | 1 | ||
113270 | 187727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6016865.11612 | 2094968.38741 | 37.7333304353331 | -122.384057231462 | (37.7333304353331, -122.384057231462) | 10 | 3 | 8 | 58 | 1 | |||
61212 | 187715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016846.76971 | 2094930.10872 | 37.7332243153459 | -122.384117995955 | (37.7332243153459, -122.384117995955) | 10 | 3 | 8 | 58 | 1 | |||
62386 | 187723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 57 Progress St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6016846.42344 | 2095098.5772 | 37.7336868771302 | -122.384130920999 | (37.7336868771302, -122.384130920999) | 10 | 3 | 8 | 58 | 1 | |||
75999 | 3827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 130 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016793.8666003 | 2095959.0590849 | 37.736046682619 | -122.384372537421 | (37.736046682619, -122.384372537421) | 10 | 3 | 8 | 58 | 1 | |||
156766 | 6776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
173030 | 6777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
162562 | 6789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1390 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
81345 | 187714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6016776.4454 | 2094960.14046 | 37.7333028882004 | -122.384363219486 | (37.7333028882004, -122.384363219486) | 10 | 3 | 8 | 58 | 1 | |||
110379 | 187728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016765.26263 | 2095017.29072 | 37.7334591930792 | -122.384405860861 | (37.7334591930792, -122.384405860861) | 10 | 3 | 8 | 58 | 1 | |||
105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
145665 | 188656 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016757.25377 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | 10 | 3 | 8 | 58 | 1 | ||||
115021 | 187729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016756.98827 | 2095025.70414 | 37.7334818371106 | -122.384435053735 | (37.7334818371106, -122.384435053735) | 10 | 3 | 8 | 58 | 1 | |||
49519 | 188657 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016750.16767 | 2099204.87087 | 37.7449566081772 | -122.384749662688 | (37.7449566081772, -122.384749662688) | 10 | 3 | 8 | 58 | 1 | ||||
175125 | 187730 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016747.91216 | 2095034.61845 | 37.7335058121437 | -122.384467053408 | (37.7335058121437, -122.384467053408) | 10 | 3 | 8 | 58 | 1 | |||
75058 | 187731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016728.56547 | 2095062.09483 | 37.733580186956 | -122.384535854255 | (37.733580186956, -122.384535854255) | 10 | 3 | 8 | 58 | 1 | |||
185107 | 187732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016720.53621 | 2095079.35768 | 37.7336271432802 | -122.384564816022 | (37.7336271432802, -122.384564816022) | 10 | 3 | 8 | 58 | 1 | |||
164474 | 24141 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.7337286308528 | -122.38459886076 | (37.7337286308528, -122.38459886076) | 10 | 3 | 8 | 58 | 1 | |||
33296 | 24143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016705.20951 | 2095147.06572 | 37.7338122084672 | -122.38462252012 | (37.7338122084672, -122.38462252012) | 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 | ||||
162265 | 24144 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.384635938 | (37.7338509755474, -122.384635938) | 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 | ||
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 | |||
166809 | 97222 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | |||
79885 | 187734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6016672.47216 | 2095023.06594 | 37.7334699192814 | -122.384727069019 | (37.7334699192814, -122.384727069019) | 10 | 3 | 8 | 58 | 1 | |||
30744 | 187733 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6016669.55687 | 2095074.42086 | 37.7336107684215 | -122.384740724326 | (37.7336107684215, -122.384740724326) | 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 | |||
163065 | 97223 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | 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 | ||||
28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 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 | |||
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 | |||
39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 |
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) );