trees
484 rows where qSpecies_id = 56 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134451 | 247927 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 12 | Side Yard : Yard | Tree | Private 2 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.406956112045 | (37.7433135063186, -122.406956112045) | 10 | 7 | 7 | 28859 | 2 | ||||
139243 | 106810 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3500X MISSION ST | 10 | Median : Cutout | Tree | DPW 1 | 11 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
139286 | 4843 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.7398006689526 | -122.419974789699 | (37.7398006689526, -122.419974789699) | 2 | 7 | 7 | 28859 | 2 | |||
142651 | 247929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 37 | 6010384.75611 | 2098766.60945 | 37.7433991352743 | -122.406729322823 | (37.7433991352743, -122.406729322823) | 10 | 7 | 7 | 28859 | 2 | ||||
144422 | 247935 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 31 | 6010295.56922 | 2098768.42696 | 37.7433991352522 | -122.407037837932 | (37.7433991352522, -122.407037837932) | 2 | 7 | 7 | 28859 | 2 | ||||
158886 | 247820 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009707.55977 | 2096850.28614 | 37.7380994142676 | -122.408935726717 | (37.7380994142676, -122.408935726717) | 10 | 7 | 7 | 28859 | 2 | ||||
163874 | 246763 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 7 | Front Yard : Yard | Tree | Private 2 | 27 | 6009290.72604 | 2098884.53398 | 37.7436616572582 | -122.410520540796 | (37.7436616572582, -122.410520540796) | 2 | 7 | 7 | 28859 | 2 | ||||
165894 | 247821 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009717.95526 | 2096849.33319 | 37.7380973799798 | -122.40889971695 | (37.7380973799798, -122.40889971695) | 10 | 7 | 7 | 28859 | 2 | ||||
167287 | 247819 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009694.17454 | 2096850.55921 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | 10 | 7 | 7 | 28859 | 2 | ||||
170504 | 246760 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 4 | Front Yard : Yard | Tree | Private 2 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | 2 | 7 | 7 | 28859 | 2 | ||||
175457 | 247851 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 152 Chapman St | 3 | Side Yard : Yard | Tree | Private 2 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | 10 | 7 | 7 | 28859 | 2 | ||||
179161 | 247926 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 11 | Side Yard : Yard | Tree | Private 2 | 27 | 6010312.05046 | 2098736.31721 | 37.7433118911276 | -122.406978587005 | (37.7433118911276, -122.406978587005) | 10 | 7 | 7 | 28859 | 2 | ||||
188383 | 247937 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1149 Esmeralda Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.407242153126 | (37.7433393564296, -122.407242153126) | 10 | 7 | 7 | 28859 | 2 | ||||
189842 | 106811 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3500X MISSION ST | 17 | Median : Cutout | Tree | DPW 1 | 20 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
190524 | 247925 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 10 | Side Yard : Yard | Tree | Private 2 | 25 | 6010304.27631 | 2098731.76841 | 37.7432989660778 | -122.407005147582 | (37.7432989660778, -122.407005147582) | 10 | 7 | 7 | 28859 | 2 | ||||
191735 | 247932 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 6010369.90614 | 2098762.79338 | 37.7433878262904 | -122.406780401602 | (37.7433878262904, -122.406780401602) | 10 | 7 | 7 | 28859 | 2 | ||||
23740 | 255978 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
30833 | 258289 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
43919 | 113860 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
73242 | 224246 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 483 Valley St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 55 | 6002830.24391 | 2099168.61142 | 37.7440773607828 | -122.432879592517 | (37.7440773607828, -122.432879592517) | 2 | 7 | 5 | 63 | 22 | ||||
82626 | 258290 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 7 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
85519 | 113859 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
87214 | 224248 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055214 | (37.7487943903519, -122.43643055214) | 2 | 4 | 5 | 28862 | 22 | |||
94300 | 113861 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
104555 | 258287 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
118601 | 113862 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
128772 | 258286 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
134246 | 258292 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
145770 | 258288 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
147696 | 258285 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
159425 | 258291 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 8 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
164475 | 224249 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 500x 27th St | 14 | Median : Cutout | Tree | DPW 1 | 48 | Width 4ft | 6002852.0087 | 2100065.56768 | 37.7465414276517 | -122.432868400457 | (37.7465414276517, -122.432868400457) | 2 | 7 | 5 | 63 | 22 | |||
104435 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 267 Green St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | 3 | 1 | 10 | 308 | 23 | ||||
153947 | 249920 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 358 Greenwich St | 5 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | 3 | 1 | 10 | 308 | 23 | |||
14982 | 26911 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Caine Ave | 7 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997609.86555 | 2089654.44991 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | 9 | 8 | 6 | 28861 | 24 | |||
98944 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 301X Sargent St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5993018 | 2089140 | 37.7159798527116 | -122.466079257059 | (37.7159798527116, -122.466079257059) | 9 | 8 | 6 | 64 | 24 | ||||
124476 | 118438 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 5201 Anza St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5982520.38622 | 2111663.82262 | 37.7772127952946 | -122.504030702291 | (37.7772127952946, -122.504030702291) | 11 | 6 | 2 | 55 | 26 | |||
141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 11 | 6 | 2 | 55 | 26 | ||||
2730 | 138025 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.426921423586 | (37.7876073348692, -122.426921423586) | 13 | 9 | 11 | 28858 | 27 | |||
2985 | 138087 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | 13 | 9 | 11 | 28858 | 27 | |||
4739 | 138026 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 57 | Width 0ft | 6004881.8597 | 2114953.842 | 37.7875359766764 | -122.426909554358 | (37.7875359766764, -122.426909554358) | 13 | 9 | 11 | 28858 | 27 | |||
5001 | 138027 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | 13 | 9 | 11 | 28858 | 27 | |||
6626 | 138028 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | 13 | 9 | 11 | 28858 | 27 | |||
13887 | 2618 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
18571 | 138024 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248 | (37.7877405482561, -122.42694291248) | 13 | 9 | 11 | 28858 | 27 | |||
28953 | 2619 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.426928979241 | (37.7877373561683, -122.426928979241) | 13 | 9 | 11 | 28858 | 27 | |||
40122 | 2614 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
47435 | 2617 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
146647 | 17957 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | 13 | 6 | 1 | 29490 | 27 | |||
146721 | 2615 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
165250 | 2616 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
776 | 113502 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x MANSELL ST | 8 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | |||
973 | 176338 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | 10 | 7 | 8 | 309 | 28 | |||
22979 | 176339 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | 10 | 3 | 8 | 309 | 28 | |||
26442 | 176342 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.7210039820195 | -122.402451970878 | (37.7210039820195, -122.402451970878) | 10 | 7 | 8 | 309 | 28 | |||
46802 | 176341 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 500x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | 10 | 3 | 8 | 309 | 28 | |||
47155 | 176337 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 59 | Width 0ft | 6011478.9031 | 2090656.66454 | 37.7211920833183 | -122.402375903539 | (37.7211920833183, -122.402375903539) | 10 | 3 | 8 | 309 | 28 | |||
89575 | 113506 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 39 | 3x3 | 6011135.08211 | 2090555.53588 | 37.7208952054249 | -122.403557288932 | (37.7208952054249, -122.403557288932) | 10 | 3 | 7 | 309 | 28 | |||
179253 | 30154 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 410X Mansell St | 23 | Median : Cutout | Tree | DPW 1 | 24 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
179774 | 176340 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x Mansell St | 15 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011135.84107 | 2090535.25569 | 37.720839562572 | -122.403553239308 | (37.720839562572, -122.403553239308) | 10 | 7 | 7 | 309 | 28 | |||
44889 | 191727 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | 10 | 3 | 8 | 28856 | 29 | ||||
65425 | 191724 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 5 | Median : Yard | Tree | DPW 1 | 43 | 6011608.52294 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | 10 | 3 | 8 | 28856 | 29 | ||||
103215 | 3751 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 990 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.7560772927341 | -122.399959384248 | (37.7560772927341, -122.399959384248) | 10 | 3 | 8 | 28856 | 29 | |||
110057 | 191738 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011311.04969 | 2104026.19787 | 37.757892599481 | -122.403896453867 | (37.757892599481, -122.403896453867) | 10 | 3 | 8 | 28856 | 29 | ||||
126653 | 191723 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x Carolina St | 30 | Median : Yard | Tree | DPW 1 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.399816899747 | (37.7560429683291, -122.399816899747) | 10 | 3 | 8 | 28856 | 29 | ||||
162813 | 191721 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1150x Tennessee St | 7 | Median : Yard | Tree | DPW 1 | 50 | 6015559.12531 | 2103608.85918 | 37.7569830917109 | -122.389175557402 | (37.7569830917109, -122.389175557402) | 10 | 3 | 8 | 28856 | 29 | ||||
181513 | 191726 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 700 Missouri St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | 10 | 3 | 8 | 28856 | 29 | ||||
184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
185421 | 191728 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201018 | (37.754962860065, -122.39634201018) | 10 | 3 | 8 | 28856 | 29 | ||||
187675 | 191725 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 6 | Median : Yard | Tree | DPW 1 | 46 | 6011608.2265 | 2103816.01851 | 37.7573320916147 | -122.402853903992 | (37.7573320916147, -122.402853903992) | 10 | 3 | 8 | 28856 | 29 | ||||
18104 | 260417 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 335 Corbett Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5999565 | 2105069 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | 15 | 5 | 5 | 28862 | 3 | ||||
23508 | 224254 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190 Storrie St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6000752.12131 | 2105271.59361 | 37.7607165903087 | -122.440502889194 | (37.7607165903087, -122.440502889194) | 15 | 4 | 5 | 28862 | 3 | |||
23924 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 4 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
37863 | 224257 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.7679085577502 | -122.439611299541 | (37.7679085577502, -122.439611299541) | 15 | 5 | 5 | 29492 | 3 | |||
42249 | 224253 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 755 Sanchez St | 6 | Front Yard : Yard | Tree | Private 2 | 28 | Width 3ft | 6003620.82081 | 2103873.1752 | 37.7570397984623 | -122.430481566473 | (37.7570397984623, -122.430481566473) | 2 | 4 | 5 | 28862 | 3 | |||
44584 | 116530 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 745X SANCHEZ ST | 7 | Median : Yard | Tree | DPW 1 | 45 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
91988 | 224256 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6001050.21768 | 2107873.33716 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | 15 | 5 | 5 | 29492 | 3 | |||
110371 | 112189 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 12 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
112183 | 224260 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6001102.84855 | 2107909.89342 | 37.7679806761809 | -122.439479012854 | (37.7679806761809, -122.439479012854) | 15 | 5 | 5 | 29492 | 3 | |||
114012 | 112188 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 45 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
131738 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 3 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
134306 | 224258 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6001075.26018 | 2107893.83056 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | 15 | 5 | 5 | 29492 | 3 | |||
144814 | 224259 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 3ft | 6001093.91519 | 2107903.07464 | 37.7679614450866 | -122.43950942342 | (37.7679614450866, -122.43950942342) | 15 | 5 | 5 | 29492 | 3 | |||
151892 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 1 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
175631 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 2 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
185364 | 224261 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 6001117.5941 | 2107921.40745 | 37.7680131300332 | -122.439428835199 | (37.7680131300332, -122.439428835199) | 15 | 5 | 5 | 29492 | 3 | |||
187949 | 224255 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999122.55283 | 2104753.13218 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | 2 | 5 | 5 | 28862 | 3 | |||
140170 | 253136 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5 | 5999298 | 2114593 | 37.7862278895056 | -122.446202552789 | (37.7862278895056, -122.446202552789) | 15 | 6 | 1 | 29490 | 31 | ||||
45655 | 121204 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 52 | 6008473.20212 | 2119153.5676 | 37.7992698007193 | -122.41478152415 | (37.7992698007193, -122.41478152415) | 5 | 1 | 10 | 308 | 32 | ||||
93652 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010511 | 2109243 | 37.7721720235673 | -122.407031076357 | (37.7721720235673, -122.407031076357) | 14 | 2 | 9 | 28853 | 34 | ||||
104699 | 114731 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 934 BRANNAN ST | Back Yard : Yard | Tree | Private 2 | Dept of Real Estate | 10x10 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
66615 | 185931 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985001.315 | 2101504.3546 | 37.749463324704 | -122.494699314147 | (37.749463324704, -122.494699314147) | 1 | 8 | 3 | 29491 | 35 | |||
79539 | 95436 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2675 25th Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
103049 | 185917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.7492338700088 | -122.494681880668 | (37.7492338700088, -122.494681880668) | 1 | 8 | 3 | 29491 | 35 | |||
128096 | 256447 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 31 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
152308 | 256445 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
171148 | 256446 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 3001 Sunset Blvd | 30 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
192427 | 185929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | 1 | 8 | 3 | 29491 | 35 | |||
11646 | 23200 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 520X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | 7 | 9 | 9 | 28852 | 36 |
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) );