Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 347 | 347 | 250073 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 373 | 373 | 250075 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 377 | 377 | 250072 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 395 | 395 | 249557 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005881.27559 | 2115126.52616 | 37.788066583556706 | -122.423464052238 | (37.7880665835567, -122.423464052238) | |
| 404 | 404 | 249555 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.787898211588704 | -122.423418809148 | (37.7878982115887, -122.423418809148) | |
| 406 | 406 | 249556 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005884.0832400005 | 2115105.79396 | 37.7880098165527 | -122.423452863778 | (37.7880098165527, -122.423452863778) | |
| 413 | 413 | 249558 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005877.98213 | 2115146.79048 | 37.7881220384566 | -122.42347688825899 | (37.7881220384566, -122.423476888259) | |
| 415 | 415 | 250074 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 3299 | 3299 | 192595 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008285.14461 | 2110684.68439 | 37.776005738696604 | -122.414832573262 | (37.7760057386966, -122.414832573262) | |
| 3302 | 3302 | 192594 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.775978773435504 | -122.414869184668 | (37.7759787734355, -122.414869184668) | |
| 3307 | 3307 | 192596 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1335 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008295.90964 | 2110693.56586 | 37.776030729971794 | -122.41479596277901 | (37.7760307299718, -122.414795962779) | |
| 14 | 14 | 196590 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 772992 | 6007565.6944699995 | 2109618.27361 | 37.773037177355796 | -122.41724576098301 | (37.7730371773558, -122.417245760983) | ||
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 30 | 30 | 196592 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.41735848920901 | (37.7731013709756, -122.417358489209) | ||
| 369 | 369 | 192563 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008747.97709 | 2111280.89227 | 37.777668779422896 | -122.413273679445 | (37.7776687794229, -122.413273679445) | |
| 372 | 372 | 251291 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 400 | 400 | 251289 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 412 | 412 | 251290 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 416 | 416 | 192564 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 451 | 451 | 192346 | Planning Code 138.1 required 4 | Fraxinus spp :: Ash Spp 83 | 118 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.5452799997 | 37.7750719195804 | -122.41581539288201 | (37.7750719195804, -122.415815392882) | |
| 1634 | 1634 | 199504 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | |
| 1642 | 1642 | 199503 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.983080001 | 2111924.50305 | 37.7795342467397 | -122.40725478770099 | (37.7795342467397, -122.407254787701) | |
| 2257 | 2257 | 229627 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.41333091228701 | (37.7406815009641, -122.413330912287) | |||
| 4329 | 4329 | 239457 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | |
| 4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 4404 | 4404 | 239458 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | |
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 129011 | 129011 | 121540 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 144636 | 144636 | 121541 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 3687 | 3687 | 152811 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009988.15821 | 2101607.87857 | 37.7511784382559 | -122.40830102206999 | (37.7511784382559, -122.40830102207) | |
| 3691 | 3691 | 152812 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6010002.42353 | 2101608.75594 | 37.751181646126795 | -122.40825175271401 | (37.7511816461268, -122.408251752714) | |
| 3700 | 3700 | 152810 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.751177979599206 | -122.408352609887 | (37.7511779795992, -122.408352609887) | |
| 82070 | 82070 | 121539 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 138808 | 138808 | 121536 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 139668 | 139668 | 121535 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 140570 | 140570 | 121537 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 142431 | 142431 | 121538 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 145519 | 145519 | 121534 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 23422 | 23422 | 54948 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.758037793894204 | -122.503684942327 | (37.7580377938942, -122.503684942327) | |
| 81075 | 81075 | 121531 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 83676 | 83676 | 121526 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 91964 | 91964 | 121522 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101224 | 101224 | 121527 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 101696 | 101696 | 121525 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | |||
| 101714 | 101714 | 121533 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 121482 | 121482 | 121532 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 121865 | 121865 | 121530 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 126691 | 126691 | 121528 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 127155 | 127155 | 121523 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 144469 | 144469 | 121529 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 145478 | 145478 | 121524 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 4964 | 4964 | 253756 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5007 | 5007 | 253755 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 140646 | 140646 | 121962 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 20 16th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 5x10 | Permit Number 778592 | 5990850.71184 | 2114913.60159 | 37.78662213560371 | -122.47545108088 | (37.7866221356037, -122.47545108088) | |
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 76409 | 76409 | 113646 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 77524 | 77524 | 113650 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 95753 | 95753 | 113653 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 101113 | 101113 | 113643 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 104148 | 104148 | 113647 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 106915 | 106915 | 113654 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 107442 | 107442 | 113644 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 108427 | 108427 | 113652 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 112854 | 112854 | 113649 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 119948 | 119948 | 113645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 120517 | 120517 | 113648 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 124502 | 124502 | 113651 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 101885 | 101885 | 122625 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222.0 | 2094938.0 | 37.731388248087605 | -122.496909587532 | (37.7313882480876, -122.496909587532) | |
| 138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
| 1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 3174 | 3174 | 253344 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2586 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780063 | 5987098.36417 | 2097677.28593 | 37.7390777358027 | -122.487166705945 | (37.7390777358027, -122.487166705945) | |
| 3890 | 3890 | 161753 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022.0 | 2087749.0 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | |
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 7556 | 7556 | 115529 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | |
| 7909 | 7909 | 115530 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | |
| 8658 | 8658 | 115528 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007325.8351 | 2111377.63368 | 37.77785446243671 | -122.418200224953 | (37.7778544624367, -122.418200224953) | |
| 8908 | 8908 | 33111 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.797185891667105 | -122.442801853125 | (37.7971858916671, -122.442801853125) | |
| 9788 | 9788 | 115347 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
| 9806 | 9806 | 115346 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
| 12678 | 12678 | 108261 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.43328956378201 | (37.7223123355393, -122.433289563782) | |
| 22901 | 22901 | 183545 | Planning Code 138.1 required 4 | Agonis flexuosa :: Peppermint Willow 7 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.73937736557679 | -122.482876432223 | (37.7393773655768, -122.482876432223) | |
| 22935 | 22935 | 109466 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013302.89282 | 2109368.02055 | 37.7726711397891 | -122.39738238550699 | (37.7726711397891, -122.397382385507) | |
| 22937 | 22937 | 109463 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013357.96458 | 2109418.68041 | 37.7728133064148 | -122.39719543803899 | (37.7728133064148, -122.397195438039) | |
| 27515 | 27515 | 109465 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013321.87847 | 2109385.26551 | 37.772719547604495 | -122.397317921189 | (37.7727195476045, -122.397317921189) | ||
| 46526 | 46526 | 109467 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | Permit Number 773752 | 6013285.76594 | 2109350.55221 | 37.7726222220803 | -122.39744040434601 | (37.7726222220803, -122.397440404346) |
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");