trees
140 rows where qSpecies_id = 139
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 774 | 208910 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 24 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5999949.61858 | 2095523.77288 | 37.7339056911991 | -122.442578479527 | (37.7339056911991, -122.442578479527) | 9 | 7 | 4 | 63 | 40 | ||||
| 5977 | 177494 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1002x Naples St | 8 | Median : Yard | Tree | DPW 1 | 1 | 6001533.96245 | 2088133.73568 | 37.7137045060241 | -122.436572153999 | (37.7137045060241, -122.436572153999) | 9 | 7 | 6 | 28861 | 5 | ||||
| 11050 | 131026 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2399 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | Width 3ft | 5999337.89479 | 2120454.53437 | 37.8023243858278 | -122.446486380046 | (37.8023243858278, -122.446486380046) | 13 | 9 | 1 | 57 | 17 | ||
| 16326 | 108982 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772764 | 5998041.9 | 2106031.7 | 37.7626489535182 | -122.449931067375 | (37.7626489535182, -122.449931067375) | 15 | 5 | 11 | 29492 | 9 |
| 16434 | 64969 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1654 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51740 | 6005014.41184 | 2119207.33105 | 37.7992224756828 | -122.42675397462 | (37.7992224756828, -122.42675397462) | 13 | 9 | 1 | 57 | 17 | |
| 17338 | 49652 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1435 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | Permit Number 46505 | 5995865.51588119 | 2093595.60711294 | 37.7283777615218 | -122.456558987005 | (37.7283777615218, -122.456558987005) | 9 | 7 | 4 | 28861 | 40 | ||
| 18574 | 52164 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2976 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48357 | 6009650.91452488 | 2101053.00211484 | 37.7496359801214 | -122.409428096322 | (37.7496359801214, -122.409428096322) | 2 | 4 | 7 | 28859 | 19 | ||
| 19350 | 193461 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1301 Minnesota St | 23 | Front Yard : Yard | Tree | Private 2 | 3 | 6015381.88027 | 2102419.9809 | 37.7537088571035 | -122.389705508105 | (37.7537088571035, -122.389705508105) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20565 | 231507 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 3327 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007430.8177 | 2105560.35808 | 37.7618875049167 | -122.41742468201 | (37.7618875049167, -122.41742468201) | 2 | 4 | 7 | 28859 | 19 | |||
| 20750 | 246430 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 486 Duncan St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6003406.93545 | 2099829.65201 | 37.7459251168641 | -122.430932690703 | (37.7459251168641, -122.430932690703) | 2 | 7 | 5 | 63 | 22 | |||
| 25037 | 231513 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 101 Arbor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001705.93238 | 2096650.08849 | 37.7370982520851 | -122.436586971219 | (37.7370982520851, -122.436586971219) | 2 | 7 | 5 | 63 | 7 | |||
| 26109 | 231502 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 900 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009919.81805 | 2103855.42588 | 37.7573458746296 | -122.408695890999 | (37.7573458746296, -122.408695890999) | 2 | 4 | 7 | 28859 | 19 | |||
| 26915 | 118001 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 7 Shore View Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 5984644.22943 | 2112843.78697 | 37.7805773013934 | -122.496770866694 | (37.7805773013934, -122.496770866694) | 11 | 6 | 2 | 55 | 26 | |||
| 27323 | 193464 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1 Jack Balestreri Way | 33 | Front Yard : Yard | Tree | Private 2 | 4 | 6012381.25429 | 2104808.92701 | 37.7601015331684 | -122.400250187717 | (37.7601015331684, -122.400250187717) | 10 | 3 | 8 | 28856 | 29 | ||||
| 27814 | 131039 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 3001 Divisadero St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 9ft | 6000465.59076 | 2118697.11067 | 37.7975633137397 | -122.442457765333 | (37.7975633137397, -122.442457765333) | 13 | 9 | 1 | 57 | 17 | |||
| 28334 | 231508 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 675 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001243.5368 | 2102486.94804 | 37.7530985987403 | -122.43860377736 | (37.7530985987403, -122.43860377736) | 2 | 4 | 5 | 28862 | 22 | |||
| 32315 | 131037 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2626 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999229.87271 | 2117849.28624 | 37.7951649018972 | -122.44667263056 | (37.7951649018972, -122.44667263056) | 13 | 9 | 1 | 57 | 17 | |||
| 34290 | 123585 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 72 05th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 5994294.07305 | 2115092.30924 | 37.7873118175677 | -122.4635509519 | (37.7873118175677, -122.4635509519) | 11 | 6 | 1 | 54 | 11 | |||
| 35124 | 208896 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2428 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991728.53622 | 2098896.71935 | 37.7426948923565 | -122.471246654027 | (37.7426948923565, -122.471246654027) | 1 | 8 | 4 | 29491 | 40 | |||
| 37607 | 177490 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 408 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6003792.56741 | 2092602.35593 | 37.7261024464497 | -122.429084011941 | (37.7261024464497, -122.429084011941) | 9 | 7 | 6 | 28861 | 5 | |||
| 37938 | 193465 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1444 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6012266.74912 | 2101649.90282 | 37.7514211589606 | -122.400424312646 | (37.7514211589606, -122.400424312646) | 10 | 3 | 8 | 28856 | 29 | ||||
| 39587 | 131033 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999233.38677 | 2117813.4097 | 37.7950665951926 | -122.446657888855 | (37.7950665951926, -122.446657888855) | 13 | 9 | 1 | 57 | 17 | |||
| 40925 | 47939 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 278 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45673 | 6000243.93112828 | 2094980.48584366 | 37.7324307240372 | -122.441521981529 | (37.7324307240372, -122.441521981529) | 9 | 7 | 5 | 63 | 40 | ||
| 41388 | 131056 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1136 Havens St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 7ft | 6007519.11439 | 2119360.78555 | 37.7997851158565 | -122.41809770494 | (37.7997851158565, -122.41809770494) | 5 | 1 | 1 | 28858 | 32 | |||
| 42147 | 34678 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2053 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 2 | Permit Number 41917 | 6003078.74052 | 2118893.49634 | 37.798251137739 | -122.433429618792 | (37.798251137739, -122.433429618792) | 13 | 9 | 1 | 57 | 17 | |
| 42513 | 208903 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 10 Sotelo Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994012.19816 | 2100949.80117 | 37.7484639686362 | -122.463499431657 | (37.7484639686362, -122.463499431657) | 1 | 8 | 4 | 29491 | 40 | |||
| 43145 | 181909 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2351 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986382.7681 | 2099237.1437 | 37.7433189361803 | -122.489755562023 | (37.7433189361803, -122.489755562023) | 1 | 8 | 3 | 29491 | 35 | |||
| 43595 | 47694 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 169 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46991 | 6002076.52679692 | 2095073.98846097 | 37.7327916971726 | -122.435192961815 | (37.7327916971726, -122.435192961815) | 9 | 7 | 5 | 63 | 40 | ||
| 45155 | 231515 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 47 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6003273.20144 | 2097689.33785 | 37.7400407312878 | -122.431242375841 | (37.7400407312878, -122.431242375841) | 2 | 7 | 5 | 63 | 7 | |||
| 45440 | 208912 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 280 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 7ft | 6000214.85197 | 2094972.05949 | 37.7324059304914 | -122.441621910243 | (37.7324059304914, -122.441621910243) | 9 | 7 | 5 | 63 | 40 | |||
| 48841 | 131032 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5999235.41218 | 2117772.39106 | 37.7949540846108 | -122.446647927967 | (37.7949540846108, -122.446647927967) | 13 | 9 | 1 | 57 | 17 | |||
| 49001 | 209301 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 535 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5997871.95141 | 2095233.70854 | 37.7329905914255 | -122.449740676691 | (37.7329905914255, -122.449740676691) | 9 | 7 | 4 | 59 | 40 | |||
| 49692 | 231500 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2974 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6009637.75314 | 2101050.76455 | 37.7496290988195 | -122.409473451155 | (37.7496290988195, -122.409473451155) | 2 | 4 | 7 | 28859 | 19 | |||
| 51602 | 79394 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1001 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52248 | 6008663.01056 | 2118637.41866 | 37.7978632466564 | -122.414088183737 | (37.7978632466564, -122.414088183737) | 5 | 1 | 10 | 308 | 21 | |
| 51879 | 193462 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 763 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6012154.59973 | 2104905.10236 | 37.7603529683261 | -122.401040840157 | (37.7603529683261, -122.401040840157) | 10 | 3 | 8 | 28856 | 29 | |||
| 53953 | 68964 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 245 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 2 | Permit Number 32954 | 6001096.30206 | 2120017.97021 | 37.8012259745513 | -122.440370118704 | (37.8012259745513, -122.440370118704) | 13 | 9 | 1 | 57 | 17 | |
| 53971 | 177488 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 901 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5998646.23423 | 2089574.24227 | 37.7174952842653 | -122.446656735942 | (37.7174952842653, -122.446656735942) | 9 | 7 | 6 | 28861 | 25 | |||
| 56813 | 208902 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 10 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994027.4293 | 2100933.67352 | 37.7484205637567 | -122.463445592852 | (37.7484205637567, -122.463445592852) | 1 | 8 | 4 | 29491 | 40 | |||
| 57964 | 177485 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1797 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5997833.73827 | 2088386.06909 | 37.7141863888682 | -122.449379588123 | (37.7141863888682, -122.449379588123) | 9 | 7 | 6 | 28861 | 25 | |||
| 59277 | 39495 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 4120 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40953 | 6003100.36134264 | 2100690.40570429 | 37.7482711695865 | -122.432054236687 | (37.7482711695865, -122.432054236687) | 2 | 4 | 5 | 28862 | 22 | ||
| 63416 | 116542 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1002x Naples St | 5 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001553.5279 | 2088171.08536 | 37.7138081717955 | -122.436507200445 | (37.7138081717955, -122.436507200445) | 9 | 7 | 6 | 28861 | 5 | |||
| 64442 | 58725 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1400 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1979 12:00:00 AM | 2 | Permit Number 17959 | 6011699.30009 | 2101802.15419 | 37.7518075472806 | -122.402397334364 | (37.7518075472806, -122.402397334364) | 10 | 3 | 8 | 28856 | 29 | ||
| 64633 | 131048 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1100 Filbert St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6007565.19764 | 2119569.36808 | 37.8003604247549 | -122.417953033701 | (37.8003604247549, -122.417953033701) | 5 | 1 | 1 | 28858 | 32 | |||
| 65805 | 131029 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999240.14841 | 2117739.57841 | 37.7948642603387 | -122.446629178021 | (37.7948642603387, -122.446629178021) | 13 | 9 | 1 | 57 | 17 | |||
| 66744 | 131028 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 5999241.84207 | 2117731.44882 | 37.7948420353895 | -122.446622732548 | (37.7948420353895, -122.446622732548) | 13 | 9 | 1 | 57 | 17 | |||
| 67577 | 131053 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1200 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 19 | 6006731.57793 | 2119798.12659 | 37.8009415864422 | -122.420853944473 | (37.8009415864422, -122.420853944473) | 5 | 1 | 1 | 28858 | 32 | ||||
| 71841 | 79395 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1001 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52248 | 6008661.794 | 2118635.19634 | 37.7978570763861 | -122.414092236088 | (37.7978570763861, -122.414092236088) | 5 | 1 | 10 | 308 | 21 | |
| 73753 | 208909 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 747 Detroit St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 5999437.80886 | 2095432.36155 | 37.7336255092046 | -122.444341388138 | (37.7336255092046, -122.444341388138) | 9 | 7 | 4 | 59 | 40 | ||||
| 76228 | 131021 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2898 Green St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999260.38273 | 2117722.26456 | 37.7948178768975 | -122.446557918422 | (37.7948178768975, -122.446557918422) | 13 | 9 | 1 | 57 | 17 | |||
| 77900 | 120751 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 98 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5989612.18123 | 2114795.90448 | 37.7862271008174 | -122.479727432636 | (37.7862271008174, -122.479727432636) | 11 | 6 | 1 | 55 | 33 | |||
| 78541 | 98815 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 290 Napoleon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011869.69036 | 2099744.03453 | 37.7461659067324 | -122.401663453432 | (37.7461659067324, -122.401663453432) | 10 | 3 | 8 | 58 | 1 | |||
| 80799 | 208898 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 50 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994459.99075 | 2101660.2845 | 37.7504405660911 | -122.462002499334 | (37.7504405660911, -122.462002499334) | 1 | 8 | 4 | 29491 | 40 | |||
| 91094 | 208906 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 160 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000362.37952 | 2095247.6723 | 37.733171103369 | -122.441131641236 | (37.733171103369, -122.441131641236) | 9 | 7 | 5 | 63 | 40 | |||
| 91508 | 131031 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5999236.31902 | 2117767.14442 | 37.7949397305328 | -122.446644412507 | (37.7949397305328, -122.446644412507) | 13 | 9 | 1 | 57 | 17 | |||
| 95411 | 231499 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2 Trainor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008309.09071 | 2108245.2203 | 37.7693088903093 | -122.414577071368 | (37.7693088903093, -122.414577071368) | 8 | 4 | 7 | 28853 | 19 | |||
| 97783 | 51226 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47593 | 5998582.21605403 | 2106878.18477143 | 37.7650040890386 | -122.448123269006 | (37.7650040890386, -122.448123269006) | 15 | 5 | 11 | 29492 | 9 | ||
| 99132 | 208897 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 150 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993781.18562 | 2099865.58645 | 37.7454736769631 | -122.464219561089 | (37.7454736769631, -122.464219561089) | 1 | 8 | 4 | 29491 | 40 | |||
| 101236 | 83709 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 201 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2006 12:00:00 AM | 2 | 6012689.27849 | 2093833.58554 | 37.7299827539984 | -122.398414756834 | (37.7299827539984, -122.398414756834) | 10 | 3 | 8 | 58 | 1 | ||
| 101902 | 131038 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2626 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999227.4926 | 2117859.91184 | 37.7951939410099 | -122.446681630968 | (37.7951939410099, -122.446681630968) | 13 | 9 | 1 | 57 | 17 | |||
| 105086 | 131040 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 3001 Divisadero St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 9ft | 6000467.64422 | 2118686.84374 | 37.7975352405117 | -122.442449922347 | (37.7975352405117, -122.442449922347) | 13 | 9 | 1 | 57 | 17 | |||
| 106390 | 131045 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1100 Filbert St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 6007579.14171 | 2119571.70024 | 37.8003676130408 | -122.417904946969 | (37.8003676130408, -122.417904946969) | 5 | 1 | 1 | 28858 | 32 | |||
| 107097 | 51673 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 631 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49826 | 5997240.83261363 | 2094378.6997026 | 37.7306068129583 | -122.451860947717 | (37.7306068129583, -122.451860947717) | 9 | 7 | 4 | 28861 | 40 | ||
| 107728 | 208907 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 160 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000360.30604 | 2095248.19776 | 37.7331724280529 | -122.441138847482 | (37.7331724280529, -122.441138847482) | 9 | 7 | 5 | 63 | 40 | |||
| 113667 | 131052 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1200 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6006740.5661 | 2119802.93565 | 37.8009552975166 | -122.420823183143 | (37.8009552975166, -122.420823183143) | 5 | 1 | 1 | 28858 | 32 | ||||
| 115018 | 131055 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1151 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006685.62477 | 2120091.24888 | 37.8017438356592 | -122.421033786405 | (37.8017438356592, -122.421033786405) | 5 | 1 | 1 | 28858 | 32 | ||||
| 117403 | 131046 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1100 Filbert St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6007575.55604 | 2119570.83895 | 37.8003650463583 | -122.417917293756 | (37.8003650463583, -122.417917293756) | 5 | 1 | 1 | 28858 | 32 | |||
| 119904 | 231503 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 3234 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008994.45875 | 2099840.54517 | 37.7462700392458 | -122.411612497634 | (37.7462700392458, -122.411612497634) | 2 | 7 | 7 | 28859 | 2 | |||
| 120239 | 131051 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1285 Greenwich St | 3 | Side Yard : Yard | Tree | Private 2 | 26 | 6006739.62065 | 2119756.87873 | 37.8008287835889 | -122.420823183157 | (37.8008287835889, -122.420823183157) | 5 | 1 | 1 | 28858 | 32 | ||||
| 120947 | 208899 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 195 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994397.39556 | 2100720.82338 | 37.7478574397742 | -122.462150832615 | (37.7478574397742, -122.462150832615) | 1 | 8 | 4 | 29491 | 40 | |||
| 121398 | 66786 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1234 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30059 | 6007019.18147596 | 2119496.46478061 | 37.8001295058435 | -122.419837294536 | (37.8001295058435, -122.419837294536) | 5 | 1 | 1 | 28858 | 32 | ||
| 121549 | 61127 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 679 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1983 12:00:00 AM | 3 | Permit Number 20978 | 6009068.81199 | 2111145.69994 | 37.7773155805859 | -122.412154241141 | (37.7773155805859, -122.412154241141) | 8 | 2 | 9 | 28853 | 34 | ||
| 123716 | 92787 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2031 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2009 12:00:00 AM | 3x3 | Permit Number 53003 | 5993449.2 | 2101650.9 | 37.7503565528165 | -122.465497177391 | (37.7503565528165, -122.465497177391) | 1 | 8 | 4 | 29491 | 40 | ||
| 126612 | 123584 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 72 05th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5994292.89241 | 2115108.24465 | 37.787355503836 | -122.463556193572 | (37.787355503836, -122.463556193572) | 11 | 6 | 1 | 54 | 11 | |||
| 126694 | 131057 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1001 Vallejo St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | 6008686.97866 | 2118645.92241 | 37.7978879420231 | -122.414005848993 | (37.7978879420231, -122.414005848993) | 5 | 1 | 10 | 308 | 21 | ||||
| 127031 | 110963 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2025x Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008581.73457 | 2119813.60798 | 37.8010882047176 | -122.414452692435 | (37.8010882047176, -122.414452692435) | 5 | 1 | 10 | 308 | 32 | |||
| 127040 | 231496 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1345 Stevenson St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6006281.98614 | 2108830.45406 | 37.7708017091696 | -122.421630310296 | (37.7708017091696, -122.421630310296) | 8 | 2 | 9 | 28853 | 19 | |||
| 127084 | 231516 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1345 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006281.71313 | 2108835.84624 | 37.7708164994137 | -122.421631637683 | (37.7708164994137, -122.421631637683) | 8 | 2 | 9 | 28853 | 19 | |||
| 127377 | 193463 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 730 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012091.96354 | 2104972.01768 | 37.7605332086642 | -122.401262173235 | (37.7605332086642, -122.401262173235) | 10 | 3 | 8 | 28856 | 29 | ||||
| 128034 | 131047 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1100 Filbert St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6007569.65156 | 2119570.0121 | 37.800362443737 | -122.417937667008 | (37.800362443737, -122.417937667008) | 5 | 1 | 1 | 28858 | 32 | |||
| 128577 | 116541 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1041x Naples St | 4 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001548.78537 | 2088145.26253 | 37.7137369985308 | -122.436521745206 | (37.7137369985308, -122.436521745206) | 9 | 7 | 6 | 28861 | 5 | |||
| 129128 | 231512 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 101 Arbor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001687.03494 | 2096641.16235 | 37.7370726690694 | -122.43665166936 | (37.7370726690694, -122.43665166936) | 2 | 7 | 5 | 63 | 7 | |||
| 129161 | 131025 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2399 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999327.24339 | 2120453.53227 | 37.8023210259496 | -122.446523166819 | (37.8023210259496, -122.446523166819) | 13 | 9 | 1 | 57 | 17 | |||
| 132010 | 193467 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 201 Williams Ave | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6012743.11977 | 2093821.49194 | 37.729952546666 | -122.398227771604 | (37.729952546666, -122.398227771604) | 10 | 3 | 8 | 58 | 1 | |||
| 133135 | 32050 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2047 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 5 | Permit Number 35431 | 6003889.57293 | 2107136.29696 | 37.7660147707915 | -122.429784859008 | (37.7660147707915, -122.429784859008) | 8 | 4 | 5 | 28862 | 3 | |
| 133136 | 33108 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 3033 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2002 12:00:00 AM | 3 | Permit Number 45433 | 6000463.72704 | 2118709.18067 | 37.7975963485349 | -122.442465081294 | (37.7975963485349, -122.442465081294) | 13 | 9 | 1 | 57 | 17 | |
| 133394 | 231517 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1345 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006280.02993 | 2108851.44344 | 37.7708592306872 | -122.421638567884 | (37.7708592306872, -122.421638567884) | 8 | 2 | 9 | 28853 | 19 | |||
| 134200 | 208911 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 278 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000243.01828 | 2094970.02212 | 37.7324019410823 | -122.441524386844 | (37.7324019410823, -122.441524386844) | 9 | 7 | 5 | 63 | 40 | |||
| 135756 | 208905 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 128 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 6000628.4729 | 2095243.25534 | 37.7331741286648 | -122.440211370376 | (37.7331741286648, -122.440211370376) | 9 | 7 | 5 | 63 | 40 | |||
| 136227 | 193471 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 981 Le Conte Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6013228.48091 | 2089472.4797 | 37.7180380610838 | -122.39624511994 | (37.7180380610838, -122.39624511994) | 10 | 3 | 8 | 58 | 1 | ||||
| 136403 | 131054 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1151 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006682.69518 | 2120091.01261 | 37.8017430217796 | -122.421043907372 | (37.8017430217796, -122.421043907372) | 5 | 1 | 1 | 28858 | 32 | ||||
| 136513 | 79101 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1001 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52248 | 6008663.84115 | 2118640.60559 | 37.7978720438282 | -122.414085535233 | (37.7978720438282, -122.414085535233) | 5 | 1 | 10 | 308 | 21 | |
| 136755 | 193468 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2500 Newhall St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6012783.6506 | 2093584.37403 | 37.7293037271707 | -122.398071022453 | (37.7293037271707, -122.398071022453) | 10 | 3 | 8 | 58 | 1 | |||
| 138986 | 231505 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1656 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003971.64703 | 2098592.83904 | 37.7425610948232 | -122.428891834899 | (37.7425610948232, -122.428891834899) | 2 | 7 | 5 | 63 | 22 | |||
| 141342 | 177493 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 1373 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007498.34181 | 2091857.43875 | 37.7242661405537 | -122.416220598611 | (37.7242661405537, -122.416220598611) | 9 | 3 | 7 | 309 | 28 | |||
| 141574 | 42020 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 100 Pinehurst Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.464633382328 | (37.7283633513404, -122.464633382328) | 9 | 8 | 4 | 59 | 40 | ||
| 143931 | 131036 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5999232.24204 | 2117831.64541 | 37.7951166002125 | -122.446663162471 | (37.7951166002125, -122.446663162471) | 13 | 9 | 1 | 57 | 17 | |||
| 144505 | 45201 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 674 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2001 12:00:00 AM | Permit Number 44045 | 5988831.94298563 | 2110732.19724929 | 37.7750239446504 | -122.482129003401 | (37.7750239446504, -122.482129003401) | 11 | 6 | 2 | 55 | 26 | |||
| 146045 | 209300 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 382 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5999565.55543 | 2094991.00608 | 37.7324209383565 | -122.443868033577 | (37.7324209383565, -122.443868033577) | 9 | 7 | 4 | 63 | 40 | ||||
| 147453 | 131027 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 2600 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 5999242.5655 | 2117725.53193 | 37.7948258305055 | -122.446619803474 | (37.7948258305055, -122.446619803474) | 13 | 9 | 1 | 57 | 17 | |||
| 148715 | 231514 | DPW Maintained 1 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 101 Arbor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001726.17119 | 2096659.25283 | 37.7371245653308 | -122.436517652362 | (37.7371245653308, -122.436517652362) | 2 | 7 | 5 | 63 | 7 |
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) );