trees
27,746 rows where qCaretaker_id = 1 sorted by qSpecies_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194323 | 264998 | DPW Maintained 1 | :: Tree 573 | 712 Francisco St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007843 | 2120971 | 37.8042245839852 | -122.417091095202 | (37.8042245839852, -122.417091095202) | 5 | 1 | 1 | 308 | 32 | |||||
| 137681 | 101255 | DPW Maintained 1 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 552 | 3700X Cesar Chavez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6005840.6 | 2100555.6 | 37.7480559984104 | -122.422568977073 | (37.7480559984104, -122.422568977073) | 2 | 4 | 5 | 28859 | 19 | |||||
| 110730 | 23365 | DPW Maintained 1 | Eucalyptus simmondsi :: Simmond's Peppermint 539 | 1356X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | |||
| 137657 | 23368 | DPW Maintained 1 | Eucalyptus simmondsi :: Simmond's Peppermint 539 | 1356X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | |||
| 101163 | 21434 | DPW Maintained 1 | Pinus pinaster :: Maritime Pine 535 | 2692X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
| 135268 | 18552 | DPW Maintained 1 | Quercus engelmannii :: Engelmann oak 530 | 1700X Quesada Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | 19 | 6014642.29362 | 2095077.14438 | 37.7335059182554 | -122.391749808332 | (37.7335059182554, -122.391749808332) | 10 | 3 | 8 | 58 | 1 | |||
| 92542 | 23447 | DPW Maintained 1 | Eucalyptus odorata :: Peppermint Box 526 | 2100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006027.0678818 | 2117578.0674993 | 37.7948061313097 | -122.423133960124 | (37.7948061313097, -122.423133960124) | 13 | 9 | 10 | 28858 | 32 | |||
| 91728 | 106979 | DPW Maintained 1 | Prunus domestica 'Green Gage' :: Green Gage Plum 524 | 801X Clipper St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 24 | 5999765.50041 | 2100345.59515 | 37.7471347718267 | -122.443561289165 | (37.7471347718267, -122.443561289165) | 2 | 4 | 5 | 63 | 22 | ||||
| 84816 | 187788 | DPW Maintained 1 | Acacia vestita :: Hairy wattle 518 | 1300x De Haro St | 15 | Median : Yard | Tree | DPW 1 | 2 | 6012267.84735 | 2102159.07234 | 37.7528192891044 | -122.400456276334 | (37.7528192891044, -122.400456276334) | 10 | 3 | 8 | 28856 | 29 | ||||
| 122310 | 23405 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1700X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006206.2376454 | 2116289.0241793 | 37.7912768502352 | -122.422422371222 | (37.7912768502352, -122.422422371222) | 13 | 9 | 10 | 28858 | 21 | |||
| 152627 | 3925 | DPW Maintained 1 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 | 99X Castro St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 70027 | 8268 | DPW Maintained 1 | Acer x 'Autumn Blaze' :: Hybrid Maple 507 | 1525 GALVEZ AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 10 | 3 | 8 | 58 | 1 | ||
| 60742 | 21317 | DPW Maintained 1 | Eucalyptus longifolia :: Woollybutt 488 | 2501X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 69081 | 21318 | DPW Maintained 1 | Eucalyptus longifolia :: Woollybutt 488 | 2501X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 154777 | 21319 | DPW Maintained 1 | Eucalyptus longifolia :: Woollybutt 488 | 2501X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 81403 | 93416 | DPW Maintained 1 | Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 | 1750X Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 03:07:00 PM | 3 | 3x3 | 5987732.225 | 2098992.9724 | 37.7427272048793 | -122.485071636504 | (37.7427272048793, -122.485071636504) | 1 | 8 | 3 | 29491 | 35 | ||
| 122086 | 93410 | DPW Maintained 1 | Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 | 1500 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 03:13:00 PM | 3 | 3x3 | 5988524.1321 | 2099019.3693 | 37.7428457803472 | -122.482335414501 | (37.7428457803472, -122.482335414501) | 1 | 8 | 3 | 29491 | 35 | ||
| 97167 | 4735 | DPW Maintained 1 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 1100X Columbus Ave | 6 | Median : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.8044235907504 | -122.41601752221 | (37.8044235907504, -122.41601752221) | 5 | 1 | 10 | 308 | 23 | ||
| 64884 | 258082 | DPW Maintained 1 | Brachychiton acerifolius :: Australian Flame Tree 477 | 273 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6007797.60382 | 2106350.79957 | 37.7640785043414 | -122.416212094635 | (37.7640785043414, -122.416212094635) | 8 | 4 | 7 | 28859 | 19 | ||||
| 152454 | 221276 | DPW Maintained 1 | Brachychiton acerifolius :: Australian Flame Tree 477 | 273 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x4 | 6007797.60382 | 2106350.79957 | 37.7640785043414 | -122.416212094635 | (37.7640785043414, -122.416212094635) | 8 | 4 | 7 | 28859 | 19 | |||
| 62639 | 11217 | DPW Maintained 1 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 475 | 1050X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018147.72557 | 2094707.73836 | 37.7326855710813 | -122.379604746459 | (37.7326855710813, -122.379604746459) | 10 | 3 | 8 | 58 | 1 | ||
| 154964 | 11216 | DPW Maintained 1 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 475 | 1050X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018149.25461 | 2094698.05349 | 37.7326590626605 | -122.379598787551 | (37.7326590626605, -122.379598787551) | 10 | 3 | 8 | 58 | 1 | ||
| 148439 | 24818 | DPW Maintained 1 | Prunus spp 'Purpurea' :: Cherry Plum 469 | 400X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/2015 12:00:00 AM | 3 | 3x3 | 6007983.04766 | 2094988.06802 | 37.7328894185911 | -122.414766489677 | (37.7328894185911, -122.414766489677) | 2 | 7 | 7 | 28859 | 2 | ||
| 46936 | 21677 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1800 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003970.2090836 | 2114619.2359317 | 37.7865656432478 | -122.430039804056 | (37.7865656432478, -122.430039804056) | 13 | 9 | 11 | 29490 | 27 | |||
| 88199 | 13138 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1769 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1994 12:00:00 AM | 50 | 3X3 | 6003923.81049 | 2119648.33681 | 37.8003716425884 | -122.430559314616 | (37.8003716425884, -122.430559314616) | 13 | 9 | 1 | 57 | 17 | ||
| 97157 | 143118 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6004371.2706 | 2119743.6634 | 37.8006587231355 | -122.429017724856 | (37.8006587231355, -122.429017724856) | 13 | 9 | 1 | 57 | 17 | |||
| 113202 | 21678 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1800 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003970.2090836 | 2114619.2359317 | 37.7865656432478 | -122.430039804056 | (37.7865656432478, -122.430039804056) | 13 | 9 | 11 | 29490 | 27 | |||
| 125576 | 13123 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1671 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6004412.31017 | 2119715.97512 | 37.8005850211999 | -122.428873735983 | (37.8005850211999, -122.428873735983) | 13 | 9 | 1 | 57 | 17 | |||
| 166581 | 17198 | DPW Maintained 1 | Persea borbonia :: False Avocado 465 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 6004367.95797 | 2119722.65234 | 37.8006008446769 | -122.429027689031 | (37.8006008446769, -122.429027689031) | 13 | 9 | 1 | 57 | 17 | |||
| 136857 | 28265 | DPW Maintained 1 | Prunus lusitanica :: Portugese Cherry Laurel 462 | 2X 12th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992095.82399 | 2114846.95109 | 37.7865112284639 | -122.47113847763 | (37.7865112284639, -122.47113847763) | 11 | 6 | 1 | 54 | 11 | |||
| 145793 | 122908 | DPW Maintained 1 | Prunus lusitanica :: Portugese Cherry Laurel 462 | 2x 12th Ave | 4 | Median : Yard | Tree | DPW 1 | 14 | 5992093.66064 | 2114888.38015 | 37.7866248560676 | -122.471148981632 | (37.7866248560676, -122.471148981632) | 11 | 6 | 1 | 54 | 11 | ||||
| 42945 | 25023 | DPW Maintained 1 | Phoenix rupicola :: Cliff date palm 459 | 700X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005002.68388 | 2104089.9673 | 37.7577132413816 | -122.425717985308 | (37.7577132413816, -122.425717985308) | 2 | 4 | 5 | 28862 | 3 | |||
| 90569 | 4377 | DPW Maintained 1 | Juglans hindsii :: Walnut: Black (n.calif) 457 | 4057X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991728.08731 | 2086927.29279 | 37.7098297912622 | -122.470376710844 | (37.7098297912622, -122.470376710844) | 9 | 8 | 4 | 64 | 24 | |||
| 38655 | 17888 | DPW Maintained 1 | Lagerstroemia indica 'Tuscarora' :: Tuscarora Crape Myrtle 446 | 2225 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2016 12:00:00 AM | 2 | 3x3 | 6003282.0408 | 2115167.5848 | 37.7880322720911 | -122.432459876091 | (37.7880322720911, -122.432459876091) | 13 | 9 | 11 | 29490 | 27 | ||
| 88578 | 252858 | DPW Maintained 1 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 1800X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002556 | 2114541 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | 13 | 9 | 11 | 29490 | 27 | ||||
| 173709 | 252859 | DPW Maintained 1 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 1800X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002556 | 2114541 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | 13 | 9 | 11 | 29490 | 27 | ||||
| 192247 | 252860 | DPW Maintained 1 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 1800X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002556 | 2114541 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | 13 | 9 | 11 | 29490 | 27 | ||||
| 40111 | 968 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 1590 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001795.10153 | 2092966.31669 | 37.7269885268937 | -122.43601515438 | (37.7269885268937, -122.43601515438) | 9 | 7 | 6 | 28861 | 25 | |||
| 43657 | 1494 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 324 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995577.80377 | 2114269.78736 | 37.7851272759959 | -122.459049963834 | (37.7851272759959, -122.459049963834) | 11 | 6 | 1 | 54 | 31 | |||
| 98058 | 210902 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 200x Terrace Dr | 43 | Median : Yard | Tree | DPW 1 | 9 | 5993874.81646 | 2096520.07215 | 37.7362931286123 | -122.463653037673 | (37.7362931286123, -122.463653037673) | 1 | 8 | 4 | 59 | 40 | ||||
| 137413 | 27663 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 930 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X10 | 6009093.83073 | 2089989.28092 | 37.7192261554318 | -122.410573341811 | (37.7192261554318, -122.410573341811) | 9 | 3 | 7 | 309 | 28 | |||
| 138495 | 1521 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 412 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/1994 12:00:00 AM | 18 | 9x5 | 5995599.47459 | 2113643.2041 | 37.7834080920918 | -122.45892960755 | (37.7834080920918, -122.45892960755) | 11 | 6 | 1 | 54 | 31 | ||
| 145944 | 96721 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2049 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007184.38277 | 2119401.11743 | 37.7998770112863 | -122.419258865528 | (37.7998770112863, -122.419258865528) | 5 | 1 | 1 | 28858 | 32 | |||
| 146967 | 10352 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 1001 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001272.05571 | 2108987.20412 | 37.7709483319284 | -122.438970960635 | (37.7709483319284, -122.438970960635) | 15 | 5 | 11 | 29492 | 9 | |||
| 175357 | 96722 | DPW Maintained 1 | Persea indica :: Indian Bay 441 | 2049 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007183.55193 | 2119384.91309 | 37.7998324714572 | -122.419260590431 | (37.7998324714572, -122.419260590431) | 5 | 1 | 1 | 28858 | 32 | |||
| 36113 | 199413 | DPW Maintained 1 | Euphorbia ingens :: Candelabra tree 439 | 1510x 22nd St | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 6013475.19386 | 2103827.84033 | 37.7574686213087 | -122.396397978582 | (37.7574686213087, -122.396397978582) | 10 | 3 | 8 | 28856 | 29 | |||
| 33529 | 5534 | DPW Maintained 1 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 432 | 900X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 4 | 3X6 | 6005027.1572891 | 2103111.0000553 | 37.7550266096242 | -122.425563674214 | (37.7550266096242, -122.425563674214) | 2 | 4 | 5 | 28862 | 22 | ||
| 67297 | 5426 | DPW Maintained 1 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 432 | 460X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6004889.2026724 | 2105697.5669462 | 37.7621209168257 | -122.426224900449 | (37.7621209168257, -122.426224900449) | 8 | 4 | 5 | 28862 | 3 | ||
| 72842 | 5548 | DPW Maintained 1 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 432 | 947 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/07/1997 12:00:00 AM | 18 | 3X3 | 6005119.2884742 | 2102839.5530036 | 37.7542864846581 | -122.425225743462 | (37.7542864846581, -122.425225743462) | 2 | 4 | 5 | 28859 | 19 | ||
| 29007 | 90468 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 600 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988164.289455 | 2111871.41207 | 37.7781130541083 | -122.484522111506 | (37.7781130541083, -122.484522111506) | 11 | 6 | 2 | 55 | 26 | |
| 109015 | 90517 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988128.545308 | 2111752.691709 | 37.7777849997818 | -122.484637051137 | (37.7777849997818, -122.484637051137) | 11 | 6 | 2 | 55 | 26 | |
| 141633 | 89640 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 3349X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988302.001433 | 2111876.734088 | 37.7781356853217 | -122.484046112267 | (37.7781356853217, -122.484046112267) | 11 | 6 | 2 | 55 | 26 | |
| 144220 | 90502 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 401X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988073.547859 | 2113275.972392 | 37.7819642960053 | -122.484939086563 | (37.7819642960053, -122.484939086563) | 11 | 6 | 2 | 55 | 26 | |
| 175804 | 90497 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 319 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988052.709 | 2113836.722691 | 37.7835027435823 | -122.485052332629 | (37.7835027435823, -122.485052332629) | 11 | 6 | 2 | 55 | 26 | |
| 184215 | 91017 | DPW Maintained 1 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 457 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988087.568302 | 2112897.540762 | 37.7809260463619 | -122.484862812009 | (37.7809260463619, -122.484862812009) | 11 | 6 | 2 | 55 | 26 | |
| 27796 | 13725 | DPW Maintained 1 | Platanus orientalis :: Eastern Plane Tree 418 | 776 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6011167.8494838 | 2114433.7120502 | 37.7864612448363 | -122.405124533765 | (37.7864612448363, -122.405124533765) | 5 | 2 | 10 | 28852 | 6 | |||
| 97949 | 13724 | DPW Maintained 1 | Platanus orientalis :: Eastern Plane Tree 418 | 774X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6011177.3442372 | 2114442.7932564 | 37.7864867104667 | -122.405092323795 | (37.7864867104667, -122.405092323795) | 5 | 2 | 10 | 28852 | 6 | |||
| 24975 | 93320 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 30524 | 93352 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 37291 | 93335 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 43180 | 93331 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 43940 | 93349 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 47630 | 93326 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 54733 | 93337 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 58455 | 93336 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 68637 | 93334 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 69607 | 93327 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 73106 | 93323 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 76999 | 93380 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 3098X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996221.5 | 2111515.5 | 37.7776017159973 | -122.456623735227 | (37.7776017159973, -122.456623735227) | 11 | 6 | 2 | 54 | 16 | ||
| 78053 | 93318 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 78561 | 93343 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 81427 | 93345 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 95855 | 93342 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 102635 | 93347 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 104456 | 93321 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 106640 | 93328 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 107644 | 93381 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 3098X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996221.5 | 2111515.5 | 37.7776017159973 | -122.456623735227 | (37.7776017159973, -122.456623735227) | 11 | 6 | 2 | 54 | 16 | ||
| 107952 | 93341 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 111325 | 93333 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 114410 | 93344 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 127954 | 93346 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 130528 | 93348 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 132205 | 93339 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 134591 | 93319 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 135584 | 93324 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 144099 | 93354 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 145072 | 93330 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 145360 | 93382 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 3098X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996221.5 | 2111515.5 | 37.7776017159973 | -122.456623735227 | (37.7776017159973, -122.456623735227) | 11 | 6 | 2 | 54 | 16 | ||
| 151401 | 93340 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 155784 | 93353 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 160850 | 93325 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 169749 | 93329 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 176846 | 93338 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 182136 | 93322 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 184548 | 93350 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 191377 | 93332 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 194253 | 93351 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 24356 | 90733 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4525 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981604.755434 | 2110272.748468 | 37.7733394274163 | -122.50709488652 | (37.7733394274163, -122.50709488652) | 11 | 6 | 2 | 55 | 26 | |
| 51424 | 90707 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4332 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982199.060847 | 2110334.343898 | 37.7735435345112 | -122.505043702231 | (37.7735435345112, -122.505043702231) | 11 | 6 | 2 | 55 | 26 | |
| 79929 | 90726 | DPW Maintained 1 | Quercus frainetto 'Trump' :: Hungarian Oak 406 | 4799X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980764.077178 | 2110242.237714 | 37.773206105836 | -122.510000589277 | (37.773206105836, -122.510000589277) | 11 | 6 | 2 | 55 | 26 |
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) );