3,965 rows where qSpecies_id = 70 sorted by Location descending

View and edit SQL

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)
1343 23590 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3251X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
47583 23589 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3251X Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
147188 23591 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3251X Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
83442 125010 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3798 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002028.21188 2121824.07702 37.8062380824907 -122.437274704375 (37.8062380824907, -122.437274704375) 13 9 1 57 17
49910 125009 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3798 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002030.9344 2121803.5229 37.8061818011087 -122.437263809985 (37.8061818011087, -122.437263809985) 13 9 1 57 17
56112 112489 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3   6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
151507 112490 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3 Permit Number 774532 6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
20469 114842 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
86140 114841 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
6497 125008 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3790 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6002036.5769 2121760.24067 37.8060632803659 -122.437241182151 (37.8060632803659, -122.437241182151) 13 9 1 57 17
86798 125007 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3776 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002040.03571 2121740.15377 37.8060083236955 -122.437227773241 (37.8060083236955, -122.437227773241) 13 9 1 57 17
103347 125006 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3776 Fillmore St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   6002042.33893 2121722.74316 37.8059606497147 -122.43721855519 (37.8059606497147, -122.43721855519) 13 9 1 57 17
178672 124849 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 170 Retiro Way 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001917.78024 2121717.54489 37.8059392953167 -122.437649236947 (37.8059392953167, -122.437649236947) 13 9 1 57 17
182066 30341 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3789 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/1956 12:00:00 AM 10   Permit Number 27 6001954.75028 2121707.36831 37.8059134550954 -122.437520567314 (37.8059134550954, -122.437520567314) 13 9 1 57 17
61199 125005 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3768 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002044.39034 2121704.85565 37.8059116519779 -122.43721017441 (37.8059116519779, -122.43721017441) 13 9 1 57 17
69030 124848 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 170 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001909.64403 2121706.81926 37.8059093829805 -122.4376766249 (37.8059093829805, -122.4376766249) 13 9 1 57 17
173107 124847 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 170 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001902.65662 2121695.37415 37.8058775604571 -122.437699985677 (37.8058775604571, -122.437699985677) 13 9 1 57 17
64037 125004 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3768 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002047.18275 2121687.67631 37.8058646408085 -122.437199280038 (37.8058646408085, -122.437199280038) 13 9 1 57 17
186532 30342 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3789 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     13   Permit Number 27 6001955.91401 2121688.85818 37.8058626973628 -122.437515213673 (37.8058626973628, -122.437515213673) 13 9 1 57 17
122556 98759 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 143 - 147 RETIRO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2           6001834.3 2121687.2 37.805851229479 -122.437935958007 (37.805851229479, -122.437935958007) 13 9 1 57 17
37590 30343 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3789 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     7   Permit Number 27 6001958.22163 2121669.55401 37.8058098244409 -122.437505844543 (37.8058098244409, -122.437505844543) 13 9 1 57 17
161863 98758 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 141 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768795 6001830.6 2121663 37.8057845723141 -122.437947027917 (37.8057845723141, -122.437947027917) 13 9 1 57 17
183060 4749 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1255 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.8057730322633 -122.418261164826 (37.8057730322633, -122.418261164826) 5 1 1 308 32
166002 30344 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3789 Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2     13   Permit Number 27 6001962.41405 2121647.90005 37.8057506067757 -122.437489784432 (37.8057506067757, -122.437489784432) 13 9 1 57 17
24417 125274 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1255 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007531.27909 2121531.59091 37.8057462837276 -122.418209601296 (37.8057462837276, -122.418209601296) 5 1 1 308 32
63703 86887 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 56 Casa Way   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49816 6001536.6 2121651.4 37.8057359986938 -122.438963625045 (37.8057359986938, -122.438963625045) 13 9 1 57 17
38058 125020 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1430 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002377.05102 2121615.30854 37.8056846837514 -122.4360525401 (37.8056846837514, -122.4360525401) 13 9 1 57 17
156107 98789 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 133 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6001814.61015 2121625.31821 37.805680198848 -122.437999662255 (37.805680198848, -122.437999662255) 13 9 1 57 17
49678 125021 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1430 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002357.9608 2121612.45473 37.8056757633955 -122.436118400137 (37.8056757633955, -122.436118400137) 13 9 1 57 17
140162 125022 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1432 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002347.61136 2121611.58572 37.8056727893385 -122.436154153595 (37.8056727893385, -122.436154153595) 13 9 1 57 17
177689 125023 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1436 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002327.23032 2121607.6758 37.8056608957886 -122.436224405044 (37.8056608957886, -122.436224405044) 13 9 1 57 17
58780 125024 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1436 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002311.60856 2121606.01355 37.8056554441143 -122.436278347281 (37.8056554441143, -122.436278347281) 13 9 1 57 17
6575 125025 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1442 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002295.97534 2121603.81012 37.8056485058273 -122.436332290414 (37.8056485058273, -122.436332290414) 13 9 1 57 17
128277 125026 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1448 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002274.88822 2121600.81722 37.8056390899449 -122.436405050972 (37.8056390899449, -122.436405050972) 13 9 1 57 17
52811 125027 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1448 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002258.73025 2121599.52736 37.8056346302032 -122.436460875479 (37.8056346302032, -122.436460875479) 13 9 1 57 17
14540 125028 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1454 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002238.36811 2121596.51915 37.8056252134011 -122.436531126017 (37.8056252134011, -122.436531126017) 13 9 1 57 17
124652 124850 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 127 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001799.83316 2121605.38559 37.8056246288293 -122.438049371377 (37.8056246288293, -122.438049371377) 13 9 1 57 17
28116 125029 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1460 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002224.17314 2121593.74459 37.8056167885575 -122.436580050938 (37.8056167885575, -122.436580050938) 13 9 1 57 17
164247 105787 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 67- 69 CASA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 9x3 Permit Number 773990 6001454.5 2121609.5 37.8056162809509 -122.439244738513 (37.8056162809509, -122.439244738513) 13 9 1 57 17
82748 27434 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1275 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/03/2015 12:00:00 AM 70 3X3   6007539.61625 2121483.94928 37.8056159411906 -122.418177369469 (37.8056159411906, -122.418177369469) 5 1 1 308 32
141453 27435 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1275 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/03/2015 12:00:00 AM 15 3X3   6007539.61625 2121483.94928 37.8056159411906 -122.418177369469 (37.8056159411906, -122.418177369469) 5 1 1 308 32
44160 125030 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1460 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002217.62841 2121592.79721 37.8056138153882 -122.436602632017 (37.8056138153882, -122.436602632017) 13 9 1 57 17
185074 125031 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1460 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002203.82941 2121591.63903 37.8056098511681 -122.436650302387 (37.8056098511681, -122.436650302387) 13 9 1 57 17
19351 125032 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1490 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002182.39111 2121589.19488 37.8056019218535 -122.436724317478 (37.8056019218535, -122.436724317478) 13 9 1 57 17
95763 124982 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3851 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6000554.81839 2121621.59531 37.8055982544063 -122.44235907463 (37.8055982544063, -122.44235907463) 13 9 1 57 17
104514 87964 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 393 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50997 6008895 2121449 37.8055961756376 -122.413484381593 (37.8055961756376, -122.413484381593) 3 1 10 308 23
105134 87963 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 393 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50997 6008895 2121449 37.8055961756376 -122.413484381593 (37.8055961756376, -122.413484381593) 3 1 10 308 23
64900 124820 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 290 Cervantes Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6000687.14631 2121612.80249 37.8055816529379 -122.44190050493 (37.8055816529379, -122.44190050493) 13 9 1 57 17
142936 124846 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 120 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001825.64723 2121584.78063 37.8055695210879 -122.437958561455 (37.8055695210879, -122.437958561455) 13 9 1 57 17
153920 125017 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 159 Marina Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 2ft   6002727.11559 2121565.16212 37.8055668761666 -122.434837503846 (37.8055668761666, -122.434837503846) 13 9 1 57 17
46412 125041 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1431 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002357.41951 2121568.78695 37.8055558324875 -122.436117146515 (37.8055558324875, -122.436117146515) 13 9 1 57 17
76824 125040 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1431 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002342.1489 2121566.576 37.8055488942277 -122.436169834191 (37.8055488942277, -122.436169834191) 13 9 1 57 17
144026 124821 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 290 Cervantes Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6000708.00341 2121598.0387 37.8055423039982 -122.441827265924 (37.8055423039982, -122.441827265924) 13 9 1 57 17
27228 124845 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 120 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001817.73408 2121573.58628 37.8055383343822 -122.437985143623 (37.8055383343822, -122.437985143623) 13 9 1 57 17
64043 125039 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1449 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6002279.25009 2121557.58939 37.8055206456272 -122.43638686036 (37.8055206456272, -122.43638686036) 13 9 1 57 17
73268 124854 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Casa Way 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6001534.02589 2121572.74926 37.8055198982766 -122.438966893034 (37.8055198982766, -122.438966893034) 13 9 1 57 17
62044 125038 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1455 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002263.62804 2121555.92749 37.8055151948229 -122.436440803513 (37.8055151948229, -122.436440803513) 13 9 1 57 17
104681 124844 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 104 Retiro Way 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001807.9499 2121561.96756 37.8055058760609 -122.438018170296 (37.8055058760609, -122.438018170296) 13 9 1 57 17
110321 125037 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1455 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6002241.99373 2121552.76546 37.8055052833934 -122.436515445436 (37.8055052833934, -122.436515445436) 13 9 1 57 17
91337 49320 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 595 Marina Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46320 6000116.71946789 2121594.09727993 37.8054977726587 -122.443873196152 (37.8054977726587, -122.443873196152) 13 9 1 57 17
104922 49319 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 595 Marina Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46320 6000116.71946789 2121594.09727993 37.8054977726587 -122.443873196152 (37.8054977726587, -122.443873196152) 13 9 1 57 17
181398 49321 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 595 Marina Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46320 6000116.71946789 2121594.09727993 37.8054977726587 -122.443873196152 (37.8054977726587, -122.443873196152) 13 9 1 57 17
179600 125036 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6002218.17053 2121548.92654 37.8054933889687 -122.4365976138 (37.8054933889687, -122.4365976138) 13 9 1 57 17
177840 125003 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3763 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001976.7392 2121552.51271 37.8054895129033 -122.43743337535 (37.8054895129033, -122.43743337535) 13 9 1 57 17
60876 125035 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1467 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002202.71085 2121546.35864 37.8054854596596 -122.436650930122 (37.8054854596596, -122.436650930122) 13 9 1 57 17
75101 124983 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3851 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000562.86837 2121578.96302 37.8054816564034 -122.442328154142 (37.8054816564034, -122.442328154142) 13 9 1 57 17
103291 125034 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1467 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002193.98471 2121545.09547 37.8054814954333 -122.436681037594 (37.8054814954333, -122.436681037594) 13 9 1 57 17
168254 124843 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 104 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001801.68917 2121551.89814 37.8054778720718 -122.438039114634 (37.8054778720718, -122.438039114634) 13 9 1 57 17
92788 125033 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1499 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002182.69611 2121542.62172 37.8054740616425 -122.436719926078 (37.8054740616425, -122.436719926078) 13 9 1 57 17
135698 125046 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005409.57031 2121471.02637 37.8054603352986 -122.425547782301 (37.8054603352986, -122.425547782301) 13 1 1 28858 17
54120 124991 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 299 Cervantes Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6000675.70773 2121565.63023 37.8054514787685 -122.441936701718 (37.8054514787685, -122.441936701718) 13 9 1 57 17
96079 124822 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 290 Cervantes Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6000755.21927 2121561.65274 37.8054450881704 -122.441661256459 (37.8054450881704, -122.441661256459) 13 9 1 57 17
122918 124842 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 104 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001792.10412 2121538.65269 37.8054409584916 -122.438071335542 (37.8054409584916, -122.438071335542) 13 9 1 57 17
127895 124992 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 299 Cervantes Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000700.1379 2121549.14085 37.8054075954408 -122.441850973845 (37.8054075954408, -122.441850973845) 13 9 1 57 17
38870 124841 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Retiro Way 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001779.40776 2121521.29923 37.8053925884559 -122.438114029041 (37.8053925884559, -122.438114029041) 13 9 1 57 17
43856 111715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2390x MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
120470 124851 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6001720.86764 2121511.30588 37.8053618199485 -122.438315898058 (37.8053618199485, -122.438315898058) 13 9 1 57 17
75091 125018 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 137 Marina Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 2ft   6002823.9951 2121486.12437 37.8053553592351 -122.434496584369 (37.8053553592351, -122.434496584369) 13 9 1 57 17
74577 49310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@ Taylor Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46313 6008403.82866353 2121370.35158903 37.8053526360585 -122.415178583983 (37.8053526360585, -122.415178583983) 5 1 10 308 23
70903 125015 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 675 Marina Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5999793.58079 2121546.81135 37.8053495010477 -122.444988056449 (37.8053495010477, -122.444988056449) 13 9 1 57 17
188642 124852 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Casa Way 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6001698.45973 2121506.59633 37.805347614252 -122.438393105776 (37.805347614252, -122.438393105776) 13 9 1 57 17
62189 124823 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 250 Cervantes Blvd 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6000834.31444 2121522.83872 37.8053430214345 -122.441384750901 (37.8053430214345, -122.441384750901) 13 9 1 57 17
61549 124993 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 259 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000738.67207 2121522.9779 37.8053379546353 -122.4417157428 (37.8053379546353, -122.4417157428) 13 9 1 57 17
115062 124840 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001764.3271 2121501.21341 37.805336580469 -122.43816477779 (37.805336580469, -122.43816477779) 13 9 1 57 17
74425 125047 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6005418.05896 2121421.58215 37.8053250538732 -122.425514885098 (37.8053250538732, -122.425514885098) 13 1 1 28858 17
101468 125019 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 135 Marina Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 2ft   6002839.24225 2121472.84536 37.8053197640715 -122.434442869665 (37.8053197640715, -122.434442869665) 13 9 1 57 17
32979 125014 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 691 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5999712.95085 2121535.70639 37.8053144077071 -122.445266286916 (37.8053144077071, -122.445266286916) 13 9 1 57 17
38606 125013 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 691 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999680.43429 2121532.52371 37.8053038127916 -122.445378585257 (37.8053038127916, -122.445378585257) 13 9 1 57 17
41680 124839 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001764.30069 2121488.69691 37.8053022119874 -122.438163971998 (37.8053022119874, -122.438163971998) 13 9 1 57 17
148946 50822 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 240 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM 14   Permit Number 47343 6000834.36183 2121507.8753 37.8053019385925 -122.441383512537 (37.8053019385925, -122.441383512537) 13 9 1 57 17
63951 23585 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3205X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005442.50763 2121408.51694 37.8052905615414 -122.42542934689 (37.8052905615414, -122.42542934689) 13 1 1 28858 17
22904 95659 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@Cervantes Marina Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000674 2121505 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064) 13 9 1 57 17
124560 95658 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@Cervantes Marina Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000674 2121505 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064) 13 9 1 57 17
60280 124994 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 251 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6000770.74081 2121498.43749 37.8052724003766 -122.441603002893 (37.8052724003766, -122.441603002893) 13 9 1 57 17
92681 115442 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 3 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
95648 115441 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 2 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
137554 115443 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 4 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
150284 115440 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
156023 115444 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 5 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
95552 124824 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000864.53681 2121488.01218 37.805249118725 -122.441277662361 (37.805249118725, -122.441277662361) 13 9 1 57 17

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);