trees
3,965 rows where qSpecies_id = 70 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );