Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77993 | 77993 | 12500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
| 90329 | 90329 | 12501 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
| 91431 | 91431 | 12502 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
| 10618 | 10618 | 2271 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5990752.82343 | 2088228.49759 | 37.71334614597279 | -122.47384223413499 | (37.7133461459728, -122.473842234135) | |||
| 11028 | 11028 | 2270 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990735.60667 | 2088236.9442599998 | 37.7133683412468 | -122.473902356505 | (37.7133683412468, -122.473902356505) | |||
| 10938 | 10938 | 2269 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990714.96133 | 2088247.7727 | 37.7133968776506 | -122.473974502829 | (37.7133968776506, -122.473974502829) | |||
| 149883 | 149883 | 2256 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 5990689.72825 | 2088261.00769 | 37.7134317560555 | -122.47406268136801 | (37.7134317560555, -122.474062681368) | ||||
| 186596 | 186596 | 2255 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 5990660.02895 | 2088282.4204099998 | 37.713488829713796 | -122.474166893001 | (37.7134888297138, -122.474166893001) | ||||
| 80604 | 80604 | 109658 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 94555 | 94555 | 109656 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||
| 94669 | 94669 | 109654 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 94728 | 94728 | 109655 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 97780 | 97780 | 109648 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 102772 | 102772 | 109653 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 109323 | 109323 | 109649 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 109927 | 109927 | 109657 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 110258 | 110258 | 109650 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 111096 | 111096 | 109659 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 142047 | 142047 | 109652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 145583 | 145583 | 109651 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
| 10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
| 12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
| 184827 | 184827 | 176107 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 61 | Width 0ft | 6008982.60232 | 2089910.3513099998 | 37.7190031946297 | -122.41095224595699 | (37.7190031946297, -122.410952245957) | |||
| 40380 | 40380 | 176106 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009144.0469 | 2089931.11882 | 37.719069269612206 | -122.410395658243 | (37.7190692696122, -122.410395658243) | |||
| 148568 | 148568 | 176105 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 105 | Width 0ft | 6009225.48687 | 2089982.90412 | 37.7192160263732 | -122.41011780460899 | (37.7192160263732, -122.410117804609) | |||
| 58718 | 58718 | 22877 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 113957 | 113957 | 22878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 3 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | ||
| 176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
| 107501 | 107501 | 115835 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X LAKE MERCED BLVD | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | ||
| 111885 | 111885 | 115833 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | ||
| 20392 | 20392 | 106278 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
| 18578 | 18578 | 29625 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991156.8644 | 2090780.0583900001 | 37.7203755006984 | -122.472631660317 | (37.7203755006984, -122.472631660317) | ||
| 19930 | 19930 | 29624 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991155.39463 | 2090794.87778 | 37.720416106010795 | -122.472637820699 | (37.7204161060108, -122.472637820699) | ||
| 21913 | 21913 | 29618 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991164.47662 | 2090887.5563700001 | 37.720671104264 | -122.47261318107799 | (37.720671104264, -122.472613181078) | ||
| 20248 | 20248 | 29611 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991160.04623 | 2090951.2024400001 | 37.72084560421371 | -122.47263313341499 | (37.7208456042137, -122.472633133415) | ||
| 20640 | 20640 | 29609 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.14351 | 2091025.81173 | 37.7210511631493 | -122.472596754032 | (37.7210511631493, -122.472596754032) | ||
| 21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
| 22262 | 22262 | 29593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.05944 | 2091153.1258900003 | 37.7214011945921 | -122.47257866867201 | (37.7214011945921, -122.472578668672) | ||
| 17468 | 17468 | 11748 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991276.77165 | 2092652.88165 | 37.7255247498407 | -122.472353640304 | (37.7255247498407, -122.472353640304) | ||
| 17118 | 17118 | 11746 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | ||
| 17929 | 17929 | 11710 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991285.51963 | 2092735.44075 | 37.7257519428913 | -122.47232941528699 | (37.7257519428913, -122.472329415287) | ||
| 17727 | 17727 | 11703 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991288.65534 | 2092789.2072 | 37.725899753665104 | -122.47232249319299 | (37.7258997536651, -122.472322493193) | ||
| 20319 | 20319 | 11702 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991290.07475 | 2092800.9455099998 | 37.7259320662922 | -122.47231844175501 | (37.7259320662922, -122.472318441755) | ||
| 79420 | 79420 | 114061 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 52 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 98520 | 98520 | 114060 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 60 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 109936 | 109936 | 114056 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 61 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 118992 | 118992 | 114058 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 58 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 126354 | 126354 | 114055 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 50 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 142943 | 142943 | 114059 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 38 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 146162 | 146162 | 114057 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 46 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 110448 | 110448 | 15988 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | |||
| 99860 | 99860 | 114066 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 600x LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 36 | 5987697.0 | 2093816.0 | 37.7285105386339 | -122.48481373540702 | (37.7285105386339, -122.484813735407) | ||||
| 148418 | 148418 | 206840 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 500x Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5991435.20173 | 2094099.7014 | 37.72950652428771 | -122.47191136721399 | (37.7295065242877, -122.471911367214) | |||
| 20801 | 20801 | 29578 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991374.0324099995 | 2094196.50916 | 37.729768794481004 | -122.472129887178 | (37.729768794481, -122.472129887178) | ||
| 17384 | 17384 | 16354 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4-HOA | 5993443.33225 | 2095241.5642099997 | 37.7327577911269 | -122.465052016742 | (37.7327577911269, -122.465052016742) | |||
| 121423 | 121423 | 96856 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 324X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 410x30 | 6008894.018569999 | 2095530.1163 | 37.73442890905461 | -122.4116553033 | (37.7344289090546, -122.4116553033) | |||
| 12637 | 12637 | 19441 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 5986928.6035 | 2095895.7656 | 37.7341762495639 | -122.487622811763 | (37.7341762495639, -122.487622811763) | |||
| 173128 | 173128 | 185117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sloat Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5987506.2336 | 2095918.1597 | 37.7342714110431 | -122.485627430105 | (37.7342714110431, -122.485627430105) | |||
| 39207 | 39207 | 186925 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5985117.1657 | 2095920.8688 | 37.734139358467104 | -122.493887283293 | (37.7341393584671, -122.493887283293) | |||
| 10904 | 10904 | 19431 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.48490645815501 | (37.7343051218756, -122.484906458155) | ||
| 105313 | 105313 | 110264 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220x CASHMERE ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5x40 | 6015982.5 | 2095938.0 | 37.735943960522796 | -122.38717631599701 | (37.7359439605228, -122.387176315997) | ||||
| 88922 | 88922 | 21516 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801X Sunset Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2016 05:13:00 AM | 3 | 5985158.491992299 | 2096224.0649069 | 37.7349742721437 | -122.49376674256901 | (37.7349742721437, -122.493766742569) | |||
| 121496 | 121496 | 21457 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 142101 | 142101 | 21456 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | ||
| 53249 | 53249 | 115326 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 86075 | 86075 | 115328 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 88444 | 88444 | 115331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 89993 | 89993 | 21392 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 95094 | 95094 | 115327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95571 | 95571 | 115323 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95584 | 95584 | 115324 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95694 | 95694 | 115330 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 105689 | 105689 | 115322 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 120822 | 120822 | 115325 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 138329 | 138329 | 115329 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 106203 | 106203 | 23597 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 87415 | 87415 | 5005 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5300 Diamond Heights Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 119658 | 119658 | 4989 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5300 Diamond Heights Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 127927 | 127927 | 5011 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5300 Diamond Heights Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 17510 | 17510 | 23594 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 220X Vasquez Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5994483.09622 | 2099061.58793 | 37.7433065302734 | -122.461734198275 | (37.7433065302734, -122.461734198275) | |||
| 21464 | 21464 | 23593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 220X Vasquez Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994492.71955 | 2099073.95458 | 37.743341039961706 | -122.461701819996 | (37.7433410399617, -122.461701819996) | |||
| 118670 | 118670 | 23595 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5994508.862234999 | 2099085.9891 | 37.7433750129667 | -122.461646875513 | (37.7433750129667, -122.461646875513) | |||
| 21086 | 21086 | 23592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994656.2966599995 | 2099224.9929400003 | 37.7437651683354 | -122.461147162215 | (37.7437651683354, -122.461147162215) | |||
| 142607 | 142607 | 11185 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.744104705607704 | -122.45685222203001 | (37.7441047056077, -122.45685222203) | |||
| 127498 | 127498 | 11191 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 148 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | |||
| 4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
| 22142 | 22142 | 8214 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2189X Funston Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992287.42413 | 2100535.51604 | 37.747226921486295 | -122.469433461595 | (37.7472269214863, -122.469433461595) | |||
| 41855 | 41855 | 205878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2270x 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 3ft | 5993161.62229 | 2100566.3961 | 37.747362192108795 | -122.46641282052 | (37.7473621921088, -122.46641282052) | |||
| 89136 | 89136 | 99125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 90362 | 90362 | 99136 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 19 | Median : Cutout 11 | Tree 1 | Private 1 | 36 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96303 | 96303 | 99148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 32 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96326 | 96326 | 99151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 35 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96426 | 96426 | 99143 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 26 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 98538 | 98538 | 98820 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 28 | Median : Cutout 11 | Tree 1 | Private 1 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | |||
| 103186 | 103186 | 99154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 37 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 114310 | 114310 | 99153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 41 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 115225 | 115225 | 99164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 48 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 118159 | 118159 | 99144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 27 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 119431 | 119431 | 99122 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");