Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
106620 | 106620 | 108045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
106876 | 106876 | 111408 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
107740 | 107740 | 107644 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400x KIRKWOOD AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811873998 | (37.7371023539668, -122.38775811874) | |||||
108451 | 108451 | 104499 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 44X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
108704 | 108704 | 106057 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140X CANYON DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002713.0 | 2086188.2 | 37.708429419739794 | -122.432358106226 | (37.7084294197398, -122.432358106226) | ||||
108934 | 108934 | 113438 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180x LOWER TER | Median : Yard 3 | Tree 1 | Private 1 | 22 | 3x3 | 6000120.0 | 2106246.0 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | ||||
109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
109166 | 109166 | 103947 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2363X 36th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5985162.60331 | 2099213.25819 | 37.74318203563929 | -122.49397275511299 | (37.7431820356393, -122.493972755113) | ||||
109414 | 109414 | 111414 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
109648 | 109648 | 111396 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 53 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
113179 | 113179 | 108043 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
114353 | 114353 | 111399 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 48 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
121319 | 121319 | 111411 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121346 | 121346 | 111410 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121585 | 121585 | 111422 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
121860 | 121860 | 102111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 18 Saturn St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6000559.0 | 2106017.0 | 37.7627522940794 | -122.441224290546 | (37.7627522940794, -122.441224290546) | ||||
125646 | 125646 | 105762 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2400X CASTRO ST | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
127394 | 127394 | 111402 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 29 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
128096 | 128096 | 108044 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
131180 | 131180 | 194510 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016046.848569999 | 2096053.1347400001 | 37.7362636605344 | -122.38696186272199 | (37.7362636605344, -122.386961862722) | ||||
132404 | 132404 | 194516 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016014.59895 | 2095892.62299 | 37.7358211419175 | -122.387062172188 | (37.7358211419175, -122.387062172188) | ||||
132496 | 132496 | 211121 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5994170.3136599995 | 2101381.80401 | 37.7496592476733 | -122.46298401402099 | (37.7496592476733, -122.462984014021) | |||
132920 | 132920 | 194475 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012465.76971 | 2103588.87642 | 37.756756254802106 | -122.39987221343901 | (37.7567562548021, -122.399872213439) | ||||
133994 | 133994 | 132192 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996086.73681 | 2115931.64437 | 37.789719532087396 | -122.457409497957 | (37.7897195320874, -122.457409497957) | ||||
134096 | 134096 | 211134 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994034.9226400005 | 2101588.12447 | 37.7502179515095 | -122.463467168477 | (37.7502179515095, -122.463467168477) | |||
134773 | 134773 | 211117 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 5994180.92455 | 2101259.92982 | 37.7493252232836 | -122.462938480443 | (37.7493252232836, -122.462938480443) | |||
137392 | 137392 | 233313 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6001700.69582 | 2098799.77338 | 37.743000487396294 | -122.436758913492 | (37.7430004873963, -122.436758913492) | ||||
138011 | 138011 | 247573 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6008162.04858 | 2094997.2690700002 | 37.7329247385863 | -122.41414828632901 | (37.7329247385863, -122.414148286329) | ||||
140697 | 140697 | 111409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
142054 | 142054 | 111424 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
143022 | 143022 | 111421 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 46 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
144215 | 144215 | 116451 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 250X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6016081.0 | 2096072.0 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | |||||
144456 | 144456 | 108046 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985273.0 | 2095807.0 | 37.733835821368295 | -122.493340136435 | (37.7338358213683, -122.493340136435) | ||||
144513 | 144513 | 111401 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
145014 | 145014 | 111412 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 36 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
146895 | 146895 | 194509 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016049.52573 | 2096064.5674400001 | 37.7362952006575 | -122.38695340369699 | (37.7362952006575, -122.386953403697) | ||||
148035 | 148035 | 211128 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 5994115.08502 | 2101503.8852 | 37.749991270183294 | -122.463183852357 | (37.7499912701833, -122.463183852357) | |||
149165 | 149165 | 194480 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012271.44658 | 2102135.50365 | 37.7527547753262 | -122.400442174093 | (37.7527547753262, -122.400442174093) | ||||
150963 | 150963 | 211108 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 5994231.73864 | 2100997.1049200003 | 37.748606499504106 | -122.462743701679 | (37.7486064995041, -122.462743701679) | |||
160502 | 160502 | 194482 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012279.12158 | 2102212.21544 | 37.752965837218 | -122.40042102023999 | (37.752965837218, -122.40042102024) | ||||
161567 | 161567 | 211126 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994133.74344 | 2101463.42927 | 37.7498812633278 | -122.46311639602301 | (37.7498812633278, -122.463116396023) | |||
163348 | 163348 | 247572 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6008135.46244 | 2094979.0190299999 | 37.7328731345802 | -122.414238911006 | (37.7328731345802, -122.414238911006) | ||||
164446 | 164446 | 250139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2550x Lyon St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999209.46456 | 2117608.80739 | 37.794503445131 | -122.446725934276 | (37.794503445131, -122.446725934276) | ||||
167614 | 167614 | 194515 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016017.1360599995 | 2095897.09694 | 37.7358335669715 | -122.38705371226901 | (37.7358335669715, -122.387053712269) | ||||
171534 | 171534 | 194505 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016625.92106 | 2096014.8365599997 | 37.7361905483545 | -122.384957083216 | (37.7361905483545, -122.384957083216) | ||||
171651 | 171651 | 194479 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012266.007180001 | 2102082.8221 | 37.7526098199098 | -122.40045728448099 | (37.7526098199098, -122.400457284481) | ||||
171779 | 171779 | 211114 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 5994176.51166 | 2101165.80889 | 37.7490665369056 | -122.462946912466 | (37.7490665369056, -122.462946912466) | |||
171904 | 171904 | 211124 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 8ft | 5994160.0585 | 2101416.01346 | 37.749752587415294 | -122.46302195820101 | (37.7497525874153, -122.463021958201) | |||
172015 | 172015 | 211109 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 5994204.70393 | 2101056.5968 | 37.7487682920423 | -122.462841502058 | (37.7487682920423, -122.462841502058) | |||
172192 | 172192 | 194481 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012253.2004 | 2102155.0186 | 37.752807341589296 | -122.400506643765 | (37.7528073415893, -122.400506643765) | ||||
173233 | 173233 | 211130 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994106.02259 | 2101525.20056 | 37.7500492746747 | -122.46321673696 | (37.7500492746747, -122.46321673696) | |||
175113 | 175113 | 211119 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 5994174.87266 | 2101366.65398 | 37.749617912142504 | -122.46296714991999 | (37.7496179121425, -122.46296714992) | |||
176206 | 176206 | 211110 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 5994195.56932 | 2101082.15648 | 37.7488379463106 | -122.46287494332701 | (37.7488379463106, -122.462874943327) | |||
177528 | 177528 | 211105 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993636.389719999 | 2101004.93506 | 37.748593692259895 | -122.464802962985 | (37.7485936922599, -122.464802962985) | ||||
178221 | 178221 | 247571 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6008108.27012 | 2094965.3059 | 37.732833953824205 | -122.414331952177 | (37.7328339538242, -122.414331952177) | ||||
180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | ||||
181676 | 181676 | 186658 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 0ft | 5984710.2715 | 2105562.1346 | 37.7605878254343 | -122.49600505239401 | (37.7605878254343, -122.496005052394) | |||
186406 | 186406 | 211123 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994165.13571 | 2101402.3094200003 | 37.7497152520618 | -122.46300340698099 | (37.7497152520618, -122.463003406981) | |||
188268 | 188268 | 211116 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 5994179.36475 | 2101243.69399 | 37.749280553969605 | -122.46294269644501 | (37.7492805539696, -122.462942696445) | |||
164863 | 164863 | 129537 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306x Montgomery St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | |||
1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
29957 | 29957 | 187712 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013733.01886 | 2087017.8562099999 | 37.7113262093072 | -122.39432937061301 | (37.7113262093072, -122.394329370613) | |||
30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | |||
30436 | 30436 | 203829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | ||||
32164 | 32164 | 188743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | |||
33836 | 33836 | 246868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | ||||
35636 | 35636 | 187736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016350.44721 | 2096194.4230400003 | 37.7366684157019 | -122.38592203240101 | (37.7366684157019, -122.385922032401) | ||||
37011 | 37011 | 187739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016069.71075 | 2096081.9732700002 | 37.736344111196 | -122.38688482859399 | (37.736344111196, -122.386884828594) | ||||
37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
41904 | 41904 | 188655 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.38154925430099 | (37.7428536469791, -122.381549254301) | ||||
44332 | 44332 | 188644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | ||||
50657 | 50657 | 187735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 299x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016637.03713 | 2096003.6378799998 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | ||||
53526 | 53526 | 188662 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.38506465383101 | (37.7449879810223, -122.385064653831) | ||||
54181 | 54181 | 187745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016145.55201 | 2096259.4396400002 | 37.7368355969845 | -122.386634982516 | (37.7368355969845, -122.386634982516) | ||||
55759 | 55759 | 188646 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6018092.675340001 | 2098102.14022 | 37.74200288923021 | -122.380030855133 | (37.7420028892302, -122.380030855133) | ||||
56776 | 56776 | 187772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427x Innes Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | ||||
56907 | 56907 | 187701 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | |||
57966 | 57966 | 188747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6014639.494109999 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | |||
58370 | 58370 | 187738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016145.734540001 | 2096191.5007099998 | 37.7366490605065 | -122.38662961537399 | (37.7366490605065, -122.386629615374) | ||||
58643 | 58643 | 246871 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5999923.98222 | 2105342.76453 | 37.760864817484396 | -122.443372153705 | (37.7608648174844, -122.443372153705) | ||||
60507 | 60507 | 188584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710205995 | -122.39978828959299 | (37.756276710206, -122.399788289593) | ||||
63133 | 63133 | 188742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6014513.510980001 | 2086966.09658 | 37.7112274421761 | -122.391628153428 | (37.7112274421761, -122.391628153428) | |||
63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
65570 | 65570 | 188736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | |||
69580 | 69580 | 188649 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.734213959905205 | -122.393020304839 | (37.7342139599052, -122.393020304839) | |||
71411 | 71411 | 188737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014387.73209 | 2086976.03412 | 37.7112477461551 | -122.39206357459899 | (37.7112477461551, -122.392063574599) | |||
71605 | 71605 | 188746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | |||
71608 | 71608 | 188660 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017087.3290800005 | 2098898.6066400004 | 37.7441343103446 | -122.38356249103902 | (37.7441343103446, -122.383562491039) | ||||
72358 | 72358 | 124133 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5996054.79965 | 2112880.00292 | 37.781338707390105 | -122.45729914105499 | (37.7813387073901, -122.457299141055) | ||||
72616 | 72616 | 188650 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014234.97615 | 2095377.1002900002 | 37.734306916536 | -122.39317901359699 | (37.734306916536, -122.393179013597) | ||||
74110 | 74110 | 188585 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.39972630024799 | (37.755629771207, -122.399726300248) | ||||
75165 | 75165 | 188735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014342.21925 | 2086979.24909 | 37.711254046810495 | -122.39222110431601 | (37.7112540468105, -122.392221104316) | |||
104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
107099 | 107099 | 111243 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 3x3 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | |||
119608 | 119608 | 188659 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | ||||
122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) |
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");