Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46130 | 46130 | 132162 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.40771371440901 | (37.8053168133783, -122.407713714409) | ||||
| 185848 | 185848 | 132161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010552.8238 | 2121311.7929599998 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | ||||
| 65528 | 65528 | 132163 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011528.08163 | 2120803.5748799997 | 37.8039714887622 | -122.40432672370399 | (37.8039714887622, -122.404326723704) | |||
| 39232 | 39232 | 132164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011515.19186 | 2120799.8495099996 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | |||
| 151346 | 151346 | 132160 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1141 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6006382.37262 | 2120397.93248 | 37.802568811663605 | -122.422104980572 | (37.8025688116636, -122.422104980572) | ||||
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 145855 | 145855 | 122584 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2500X Lyon St | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 11 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 144047 | 144047 | 108298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10X Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830.0 | 2116175.0 | 37.791335193350896 | -122.399496166675 | (37.7913351933509, -122.399496166675) | ||
| 86909 | 86909 | 120542 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2450 California St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | DPW for City Agency 2 | 6002644.1089699995 | 2115479.97736 | 37.7888538273233 | -122.43468935172599 | (37.7888538273233, -122.434689351726) | ||||
| 166247 | 166247 | 120262 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 100 24th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | ||||
| 77480 | 77480 | 8344 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 80466 | 80466 | 8349 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 80484 | 80484 | 8339 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 88546 | 88546 | 8341 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 92710 | 92710 | 8340 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 108857 | 108857 | 8348 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 115283 | 115283 | 8342 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 117891 | 117891 | 8351 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 179339 | 179339 | 139329 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.785246088934706 | -122.425761723999 | (37.7852460889347, -122.425761723999) | |||
| 62236 | 62236 | 139330 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6005126.2471 | 2114101.4827 | 37.7852094256692 | -122.42600332266599 | (37.7852094256692, -122.426003322666) | |||
| 131295 | 131295 | 139356 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.785175434752105 | -122.42622102328698 | (37.7851754347521, -122.426221023287) | |||
| 176294 | 176294 | 139358 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6004934.0187 | 2114075.446 | 37.7851270694756 | -122.426666519258 | (37.7851270694756, -122.426666519258) | |||
| 60960 | 60960 | 139214 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004809.3749 | 2114055.503 | 37.78506526335679 | -122.427096327106 | (37.7850652633568, -122.427096327106) | |||
| 90526 | 90526 | 120629 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 70800 | 70800 | 139359 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.42752453341801 | (37.7850156556233, -122.427524533418) | |||
| 5271 | 5271 | 8390 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.784923768316396 | -122.428202546761 | (37.7849237683164, -122.428202546761) | |||
| 5273 | 5273 | 8391 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949004 | -122.428376269712 | (37.784906265949, -122.428376269712) | |||
| 5280 | 5280 | 8392 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004378.143999999 | 2113996.8521 | 37.784879827842296 | -122.428584068109 | (37.7848798278423, -122.428584068109) | |||
| 4472 | 4472 | 8393 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | |||
| 6395 | 6395 | 8394 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | |||
| 5837 | 5837 | 8395 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004192.8617 | 2113973.9777 | 37.7848065332396 | -122.429223453232 | (37.7848065332396, -122.429223453232) | ||
| 61501 | 61501 | 120626 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
| 111709 | 111709 | 120624 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
| 117256 | 117256 | 120627 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
| 121508 | 121508 | 120628 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
| 79301 | 79301 | 120625 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004349.0 | 2113949.0 | 37.784746788576705 | -122.428681484586 | (37.7847467885767, -122.428681484586) | |||||
| 6405 | 6405 | 8469 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | |||
| 3479 | 3479 | 8471 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.783879157642104 | -122.43635890448 | (37.7838791576421, -122.43635890448) | ||
| 1548 | 1548 | 8472 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | |||
| 129015 | 129015 | 8536 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651002 | (37.7837972495813, -122.43786449651) | ||
| 140538 | 140538 | 8537 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 3 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651002 | (37.7837972495813, -122.43786449651) | ||
| 6701 | 6701 | 8474 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001879.2717 | 2113651.8819999998 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | |||
| 7244 | 7244 | 8475 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.43736806210899 | (37.7837696172579, -122.437368062109) | ||
| 8796 | 8796 | 8530 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.783676377346794 | -122.438063730933 | (37.7836763773468, -122.438063730933) | |||
| 6954 | 6954 | 8532 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.783575742772705 | -122.438389071264 | (37.7835757427727, -122.438389071264) | ||
| 88368 | 88368 | 8563 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
| 89362 | 89362 | 8562 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
| 99151 | 99151 | 8561 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 100876 | 100876 | 8560 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 7257 | 7257 | 8535 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | |||
| 5263 | 5263 | 8574 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001134.4053 | 2113480.9790000003 | 37.783279269060294 | -122.43976932905301 | (37.7832792690603, -122.439769329053) | |||
| 7070 | 7070 | 8575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | |||
| 1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
| 5311 | 5311 | 8577 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.783194913277796 | -122.440376203878 | (37.7831949132778, -122.440376203878) | |||
| 8091 | 8091 | 8578 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.44055816885599 | (37.7831658887746, -122.440558168856) | |||
| 6394 | 6394 | 8581 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | |||
| 8635 | 8635 | 8582 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000649.7853 | 2113412.1102 | 37.7830625764785 | -122.441440973241 | (37.7830625764785, -122.441440973241) | |||
| 7700 | 7700 | 8586 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.782952673809795 | -122.442300177437 | (37.7829526738098, -122.442300177437) | |||
| 96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |
| 117254 | 117254 | 24789 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.779435386439204 | -122.50204978501301 | (37.7794353864392, -122.502049785013) | |||
| 9686 | 9686 | 173637 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | ||||
| 128707 | 128707 | 27300 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.933540001 | 2112415.51016 | 37.7792783288562 | -122.50399109880101 | (37.7792783288562, -122.503991098801) | ||
| 125546 | 125546 | 27294 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.77924621575129 | -122.503283404585 | (37.7792462157513, -122.503283404585) | ||
| 92056 | 92056 | 27295 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.779242313567295 | -122.50336180684499 | (37.7792423135673, -122.503361806845) | ||
| 114112 | 114112 | 27296 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.7930900003 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | ||
| 111288 | 111288 | 27297 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.863919999 | 2112396.64212 | 37.7792343387449 | -122.50352984750401 | (37.7792343387449, -122.503529847504) | ||
| 143978 | 143978 | 27298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | ||
| 86601 | 86601 | 27299 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.779227117259296 | -122.503705073784 | (37.7792271172593, -122.503705073784) | ||
| 161403 | 161403 | 118538 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 5982472.235830001 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | |||
| 280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 65779 | 65779 | 194426 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6007946.83693 | 2109121.1094299997 | 37.77169351738029 | -122.415892125715 | (37.7716935173803, -122.415892125715) | |||
| 175007 | 175007 | 194425 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6007938.01013 | 2109107.31213 | 37.771655137004 | -122.41592168104799 | (37.771655137004, -122.415921681048) | |||
| 47480 | 47480 | 194424 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 5ft | 6007931.050980001 | 2109095.29996 | 37.77162176316789 | -122.41594490245599 | (37.7716217631679, -122.415944902456) | |||
| 155635 | 155635 | 194423 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 6007917.867000001 | 2109077.33792 | 37.771571702413 | -122.41598923453002 | (37.771571702413, -122.41598923453) | |||
| 4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
| 159854 | 159854 | 247525 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1101 Waller St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000029.935269999 | 2108491.2793400004 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | ||||
| 64531 | 64531 | 184348 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.762974680362206 | -122.496160108596 | (37.7629746803622, -122.496160108596) | |||
| 185501 | 185501 | 184347 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.9334 | 2106421.3632 | 37.7629440193232 | -122.49624600189699 | (37.7629440193232, -122.496246001897) | |||
| 55771 | 55771 | 186733 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1250 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984855.8629 | 2106397.0571 | 37.7628888152225 | -122.49556310804701 | (37.7628888152225, -122.495563108047) | |||
| 174927 | 174927 | 181557 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984875.8554 | 2106073.5142 | 37.76200162774529 | -122.495470098326 | (37.7620016277453, -122.495470098326) | |||
| 160510 | 160510 | 234472 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4810 17th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 2ft | 5998175.60392 | 2105685.14055 | 37.7617050378737 | -122.44944366388701 | (37.7617050378737, -122.449443663887) | |||
| 187908 | 187908 | 181540 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984863.0454 | 2105869.1102 | 37.7614396414651 | -122.49549932614799 | (37.7614396414651, -122.495499326148) | |||
| 174392 | 174392 | 181538 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984897.5768 | 2105857.4141 | 37.761409549185 | -122.495379035532 | (37.761409549185, -122.495379035532) | |||
| 70507 | 70507 | 184801 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302148998 | (37.7611272600096, -122.49598302149) | |||
| 136877 | 136877 | 181519 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 79 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984899.8047 | 2105606.7824 | 37.76072151501489 | -122.49535284581002 | (37.7607215150149, -122.49535284581) | |||
| 166214 | 166214 | 181513 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984909.8299 | 2105563.3396 | 37.7606028201969 | -122.49531496977501 | (37.7606028201969, -122.495314969775) | |||
| 69894 | 69894 | 186685 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984734.6622 | 2105357.4834 | 37.7600273389586 | -122.495905599978 | (37.7600273389586, -122.495905599978) | |||
| 177368 | 177368 | 181473 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984918.4628 | 2105275.6702 | 37.759813465723795 | -122.49526389807 | (37.7598134657238, -122.49526389807) | |||
| 44224 | 44224 | 186691 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984728.0673 | 2105259.502 | 37.7597579231437 | -122.49592118002701 | (37.7597579231437, -122.495921180027) | |||
| 69007 | 69007 | 186699 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984730.9983 | 2105175.3386 | 37.759527005597604 | -122.495904834542 | (37.7595270055976, -122.495904834542) | |||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 123604 | 123604 | 23614 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | |||
| 2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 54231 | 54231 | 181385 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984917.5854 | 2104501.8427 | 37.7576886993488 | -122.495209866912 | (37.7576886993488, -122.495209866912) | |||
| 170555 | 170555 | 181384 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984945.4334 | 2104486.2478 | 37.75764751046 | -122.49511240858 | (37.75764751046, -122.49511240858) | |||
| 64562 | 64562 | 181379 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | |||
| 177987 | 177987 | 186620 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1501 Sunset Blvd | 91 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984755.0749 | 2104355.2681 | 37.7572767304033 | -122.495761074715 | (37.7572767304033, -122.495761074715) | |||
| 74141 | 74141 | 186421 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | |||
| 170936 | 170936 | 186435 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984740.5243 | 2104016.8346 | 37.7563466338471 | -122.495786431621 | (37.7563466338471, -122.495786431621) | |||
| 36257 | 36257 | 186440 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984767.7413 | 2103960.7256 | 37.7561941679911 | -122.495688168642 | (37.7561941679911, -122.495688168642) |
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");