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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
57 | 57 | 44642 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
84 | 84 | 36641 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
151 | 151 | 36617 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
308 | 308 | 46059 | Permitted Site 1 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
316 | 316 | 67789 | Permitted Site 1 | Tree(s) :: 17 | 7 4384 St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31429 | ||||||||
320 | 320 | 48259 | Permitted Site 1 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
321 | 321 | 65143 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | Permit Number 27118 | |||||||||
441 | 441 | 251295 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 3x3 | Permit Number 27117 | 5982087.0 | 2112698.0 | 37.7800268469822 | -122.50560657808902 | (37.7800268469822, -122.505606578089) | ||
444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
515 | 515 | 48129 | Permitted Site 1 | Tree(s) :: 17 | 297 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
536 | 536 | 45913 | Permitted Site 1 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
634 | 634 | 251340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
675 | 675 | 47038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 716 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45030 | ||||||||
689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
1113 | 1113 | 45845 | Permitted Site 1 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
1225 | 1225 | 44628 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
1418 | 1418 | 48339 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
1499 | 1499 | 44884 | Permitted Site 1 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
1511 | 1511 | 45972 | Permitted Site 1 | Tree(s) :: 17 | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
1526 | 1526 | 44588 | Permitted Site 1 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
1532 | 1532 | 44561 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
1649 | 1649 | 251584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
1765 | 1765 | 45968 | Permitted Site 1 | Tree(s) :: 17 | 155 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1777 | 1777 | 251693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1783 | 1783 | 251690 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1786 | 1786 | 251694 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1804 | 1804 | 44554 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
1810 | 1810 | 251708 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 239 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3x3 | Permit Number 776109 | 6008639.31193 | 2109768.7769299997 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | ||
1826 | 1826 | 31896 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1525 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35325 | ||||||||
1828 | 1828 | 35192 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
1869 | 1869 | 35202 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
1885 | 1885 | 30481 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 147 | |||||||||
1959 | 1959 | 48104 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
1973 | 1973 | 66343 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | Permit Number 29464 | |||||||||
1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
1985 | 1985 | 252841 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163.0 | 2111730.0 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | |||
2019 | 2019 | 48201 | Permitted Site 1 | Tree(s) :: 17 | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
2023 | 2023 | 35053 | Permitted Site 1 | Tree(s) :: 17 | 700 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
2073 | 2073 | 252864 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
2080 | 2080 | 34119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
2086 | 2086 | 45988 | Permitted Site 1 | Tree(s) :: 17 | 223 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
2115 | 2115 | 44893 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2127 | 2127 | 252902 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992177.0 | 2094185.0 | 37.7297836282973 | -122.469353126495 | (37.7297836282973, -122.469353126495) | |||
2154 | 2154 | 45014 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2193 | 2193 | 46043 | Permitted Site 1 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
2195 | 2195 | 44993 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2304 | 2304 | 44646 | Permitted Site 1 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
2357 | 2357 | 39974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
2366 | 2366 | 44966 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2404 | 2404 | 67784 | Permitted Site 1 | Tree(s) :: 17 | 1030 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31421 | ||||||||
2434 | 2434 | 48283 | Permitted Site 1 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
2477 | 2477 | 253094 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1360 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1992 12:00:00 AM | 3x3 | Permit Number 30561 | 5994899.98504 | 2106326.93315 | 37.7632793109173 | -122.460819144348 | (37.7632793109173, -122.460819144348) | ||
2503 | 2503 | 253120 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista Ave West | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x100 | 6000071.60031 | 2108311.04493 | 37.769023393565604 | -122.44307478834801 | (37.7690233935656, -122.443074788348) | ||||
2538 | 2538 | 39950 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
2618 | 2618 | 55203 | Permitted Site 1 | Tree(s) :: 17 | 40 Dalmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | Permit Number 11116 |
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");