trees
39,840 rows where qLegalStatus_id = 7 sorted by Zip Codes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
29826 | 45324 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 783 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | 12 | 3x3 | Permit Number 44160 | 5993495.28481514 | 2091072.88877235 | 37.7213146240404 | -122.46456981823 | (37.7213146240404, -122.46456981823) | 9 | 8 | 6 | 64 | 24 |
29862 | 48581 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45895 | 5992994.26817447 | 2088334.73866608 | 37.7137674293264 | -122.466102801731 | (37.7137674293264, -122.466102801731) | 9 | 8 | 6 | 64 | 24 | ||
29969 | 44147 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
29972 | 53133 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.462829635252 | (37.7216197566197, -122.462829635252) | 9 | 8 | 6 | 64 | 24 | ||
30021 | 47367 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 45 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45287 | 5993882.1938903 | 2089153.88326205 | 37.7160677926377 | -122.463093226229 | (37.7160677926377, -122.463093226229) | 9 | 8 | 6 | 64 | 24 | ||
30563 | 39634 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 532 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41029 | 5992763.77558421 | 2090734.51245254 | 37.720343327583 | -122.467073829079 | (37.720343327583, -122.467073829079) | 9 | 8 | 6 | 64 | 24 | ||
30689 | 47363 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 9 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 45283 | 5993960.32642568 | 2089153.19671613 | 37.7160704080681 | -122.462823115402 | (37.7160704080681, -122.462823115402) | 9 | 8 | 6 | 64 | 24 | ||
30848 | 47332 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 131 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45263 | 5993704.23092481 | 2090493.94065656 | 37.7197370153769 | -122.463805555403 | (37.7197370153769, -122.463805555403) | 9 | 8 | 6 | 64 | 24 | ||
31285 | 377 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
31511 | 31182 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34880 | 5992624.59921054 | 2089874.97031305 | 37.7179751991794 | -122.467492439169 | (37.7179751991794, -122.467492439169) | 9 | 8 | 6 | 64 | 24 | ||
31593 | 89364 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 Ocean Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51942 | 5990665.5 | 2095192.3 | 37.7324619562673 | -122.474651985861 | (37.7324619562673, -122.474651985861) | 1 | 8 | 4 | 64 | 40 | ||||
31631 | 12498 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 43 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
31724 | 24412 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
32477 | 53491 | Permitted Site 7 | Tree(s) :: 17 | 242 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1969 12:00:00 AM | Permit Number 6401 | 5992226.87334015 | 2089483.12067898 | 37.7168763049169 | -122.468838692522 | (37.7168763049169, -122.468838692522) | 9 | 8 | 6 | 64 | 24 | |||
32585 | 1312 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 4043 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x5 | 5991834.02635 | 2087022.6898 | 37.7100978532157 | -122.470017510902 | (37.7100978532157, -122.470017510902) | 9 | 8 | 4 | 64 | 24 | |||
32989 | 50828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.468348178801 | (37.7117332358721, -122.468348178801) | 9 | 8 | 4 | 64 | 24 | |||
33038 | 53278 | Permitted Site 7 | Tree(s) :: 17 | 574 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6168 | 5993530.83182531 | 2089667.17380693 | 37.7174569188328 | -122.464344935551 | (37.7174569188328, -122.464344935551) | 9 | 8 | 6 | 64 | 24 | |||
33619 | 12466 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
33745 | 100428 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
34115 | 45322 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 772 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44158 | 5993546.47195842 | 2091002.85847364 | 37.7211252885031 | -122.464387798146 | (37.7211252885031, -122.464387798146) | 9 | 8 | 6 | 64 | 24 | ||
34452 | 11772 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
35259 | 52958 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 663@ HOLLOWAY Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48945 | 5994015.16633277 | 2090968.44909392 | 37.7210578144533 | -122.462765175202 | (37.7210578144533, -122.462765175202) | 9 | 8 | 6 | 64 | 24 | ||
35289 | 11714 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
35376 | 24410 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
35747 | 93927 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | |||
36059 | 38916 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.469917900123 | (37.7170074074891, -122.469917900123) | 9 | 8 | 6 | 64 | 24 | ||
36440 | 47341 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 615 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45268 | 5992432.680184 | 2090468.17220354 | 37.7195929051759 | -122.468198942558 | (37.7195929051759, -122.468198942558) | 9 | 8 | 6 | 64 | 24 | ||
36571 | 102678 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 4 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
36811 | 46745 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
36820 | 32170 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
37295 | 12460 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
37597 | 254781 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
37694 | 86761 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
37755 | 39665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.464376148313 | (37.7201338116039, -122.464376148313) | 9 | 8 | 6 | 64 | 24 | ||
38506 | 11875 | Permitted Site 7 | Juglans californica :: Walnut: Black (s.calif) 412 | 1501X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
38536 | 95334 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 466 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2011 12:00:00 AM | 75 | Permit Number 767212 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | ||
39401 | 12484 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
39998 | 107899 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 101X Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.7178318788778 | -122.463675564283 | (37.7178318788778, -122.463675564283) | 9 | 8 | 6 | 64 | 24 | ||
40191 | 47339 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | 9 | 8 | 6 | 64 | 24 | ||
40286 | 47338 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | 9 | 8 | 6 | 64 | 24 | ||
40427 | 47357 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | 9 | 8 | 6 | 64 | 24 | |||
40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
40785 | 68008 | Permitted Site 7 | Photinia fraseri :: Photinia Tree 225 | 525 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31733 | 5993230.57991473 | 2090673.1721909 | 37.7202018358304 | -122.465455798615 | (37.7202018358304, -122.465455798615) | 9 | 8 | 6 | 64 | 24 | ||
40861 | 85261 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2998 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989779.1 | 2095328.3 | 37.7327839760928 | -122.477726384657 | (37.7327839760928, -122.477726384657) | 1 | 8 | 4 | 64 | 35 | |||
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
41437 | 12469 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
42301 | 87834 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
42564 | 31177 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 315 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34875 | 5993203.2373469 | 2089815.65353127 | 37.7178457197957 | -122.465488049675 | (37.7178457197957, -122.465488049675) | 9 | 8 | 6 | 64 | 24 | ||
42572 | 91234 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 829 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52047: Correct address is 829: Replanted w/ Birch | 5988302.4 | 2089565.8 | 37.7168758094884 | -122.482409573013 | (37.7168758094884, -122.482409573013) | 1 | 8 | 4 | 64 | 14 | ||
42805 | 45310 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.469744896664 | (37.71762835398, -122.469744896664) | 9 | 8 | 6 | 64 | 24 | ||
42994 | 50394 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 84 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47045 | 5987580.16978348 | 2095308.26318011 | 37.7326011016802 | -122.485327073779 | (37.7326011016802, -122.485327073779) | 1 | 8 | 4 | 64 | 35 | ||
43235 | 57575 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 16442 | 5991446.93129096 | 2089419.02625002 | 37.7166552263353 | -122.471529877911 | (37.7166552263353, -122.471529877911) | 9 | 8 | 6 | 64 | 24 | ||
43922 | 36268 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.7301889867506 | -122.472648886457 | (37.7301889867506, -122.472648886457) | 9 | 8 | 4 | 64 | 40 | ||
44026 | 45318 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 651 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44155 | 5993484.7456852 | 2090166.18126819 | 37.718824416648 | -122.464540445707 | (37.718824416648, -122.464540445707) | 9 | 8 | 6 | 64 | 24 | ||
44234 | 50018 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.468137918171 | (37.7192055701762, -122.468137918171) | 9 | 8 | 6 | 64 | 24 | ||
44323 | 61945 | Permitted Site 7 | Tree(s) :: 17 | 3080 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1985 12:00:00 AM | Permit Number 22004 | 5990044.77595863 | 2094829.23629158 | 37.7314290888572 | -122.476771435923 | (37.7314290888572, -122.476771435923) | 1 | 8 | 4 | 64 | 35 | |||
44422 | 94231 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
44795 | 45534 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 15 Melba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | Permit Number 44292 | 5989574.15001613 | 2095172.62904296 | 37.7323446471921 | -122.478423561278 | (37.7323446471921, -122.478423561278) | 1 | 8 | 4 | 64 | 35 | ||
45088 | 36294 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | |||
45401 | 53595 | Permitted Site 7 | Tree(s) :: 17 | 234 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 6524 | 5992226.30917195 | 2089432.94349721 | 37.7167384979602 | -122.468836993274 | (37.7167384979602, -122.468836993274) | 9 | 8 | 6 | 64 | 24 | |||
45758 | 45355 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 319 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44180 | 5993213.8738989 | 2089318.70115228 | 37.7164818216733 | -122.465415204128 | (37.7164818216733, -122.465415204128) | 9 | 8 | 6 | 64 | 24 | ||
45802 | 46737 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | |||
45967 | 12480 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
46140 | 36291 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 71 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39283 | 5990873.51092873 | 2094495.59206602 | 37.730561022921 | -122.473882039472 | (37.730561022921, -122.473882039472) | 9 | 8 | 4 | 64 | 40 | ||
46360 | 44142 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
46600 | 46740 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 Sargent St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | ||
46805 | 47372 | Permitted Site 7 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 266 | 800 Shields St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | ||
46869 | 47344 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.468388624259 | (37.7195915118568, -122.468388624259) | 9 | 8 | 6 | 64 | 24 | ||
46959 | 36302 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 95 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39287 | 5990678.02579925 | 2094412.82621209 | 37.73032244404 | -122.474551815663 | (37.73032244404, -122.474551815663) | 9 | 8 | 4 | 64 | 40 | ||
47074 | 31181 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34879 | 5992668.86925851 | 2089822.40668247 | 37.7178334279778 | -122.467335598289 | (37.7178334279778, -122.467335598289) | 9 | 8 | 6 | 64 | 24 | ||
47591 | 52971 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 201ON HEAD Garfield St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48952 | 5993506.31850985 | 2090455.68500946 | 37.7196205677237 | -122.464486886677 | (37.7196205677237, -122.464486886677) | 9 | 8 | 6 | 64 | 24 | ||
48081 | 36274 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 40 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39277 | 5991083.73396182 | 2094463.16637056 | 37.730484164305 | -122.473152910623 | (37.730484164305, -122.473152910623) | 9 | 8 | 4 | 64 | 40 | ||
48084 | 39666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
48152 | 39645 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 581 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41039 | 5992714.48246081 | 2091068.51314927 | 37.7212575667576 | -122.467268490802 | (37.7212575667576, -122.467268490802) | 9 | 8 | 6 | 64 | 24 | ||
48230 | 11762 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
48416 | 87631 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523 | 2091214.465808 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | 9 | 8 | 4 | 64 | 40 | ||
49179 | 86765 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
49534 | 36292 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 71 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39283 | 5990873.51092873 | 2094495.59206602 | 37.730561022921 | -122.473882039472 | (37.730561022921, -122.473882039472) | 9 | 8 | 4 | 64 | 40 | ||
49547 | 32186 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 439 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | 1 | 8 | 4 | 64 | 35 | ||
49554 | 32187 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 439 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | 1 | 8 | 4 | 64 | 35 | ||
50272 | 36267 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 80 Elmhurst Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.7307300237066 | -122.473310148521 | (37.7307300237066, -122.473310148521) | 9 | 8 | 4 | 64 | 40 | ||
50540 | 45500 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3070 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.7315638149816 | -122.479072048364 | (37.7315638149816, -122.479072048364) | 1 | 8 | 4 | 64 | 35 | ||
50854 | 95880 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
51250 | 85264 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
51318 | 52963 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48948 | 5993488.64835927 | 2090503.61064911 | 37.7197511413359 | -122.464551443607 | (37.7197511413359, -122.464551443607) | 9 | 8 | 6 | 64 | 24 | |||
51338 | 36296 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 74 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | ||
51442 | 321 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3484X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
51469 | 12490 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
51557 | 52976 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 558 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48956 | 5993806.7125346 | 2090931.2656538 | 37.7209437095114 | -122.46348303611 | (37.7209437095114, -122.46348303611) | 9 | 8 | 6 | 64 | 24 | ||
51907 | 33950 | Permitted Site 7 | Tree(s) :: 17 | 320 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37908 | 5991410.2614719 | 2094568.19593754 | 37.7307914497185 | -122.472031721061 | (37.7307914497185, -122.472031721061) | 9 | 8 | 4 | 64 | 40 | ||||
52110 | 52417 | Permitted Site 7 | Tree(s) :: 17 | 110 Broadmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2005 12:00:00 AM | Permit Number 48536 | 5990976.04560988 | 2093076.06228561 | 37.7266692886086 | -122.473424066354 | (37.7266692886086, -122.473424066354) | 9 | 8 | 4 | 64 | 40 | |||
52189 | 93926 | Permitted Site 7 | Tree(s) :: 17 | 3711 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | |||||
52586 | 109284 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
53126 | 265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
53868 | 91504 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
53879 | 114377 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
54579 | 12458 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );