Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17436 | 17436 | 29576 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991377.92956 | 2094240.4375599998 | 37.7298896363903 | -122.47211961513099 | (37.7298896363903, -122.472119615131) | ||
18868 | 18868 | 15071 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1X Minerva St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995959.8595900005 | 2089005.6685900001 | 37.7157802951115 | -122.45590116312201 | (37.7157802951115, -122.455901163122) | |||
28419 | 28419 | 108850 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250x MONTCALM ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/09/2015 12:00:00 AM | 3 | Permit Number 774524 | 6009909.2 | 2099657.1 | 37.745817608401104 | -122.40843648152 | (37.7458176084011, -122.40843648152) | ||
42508 | 42508 | 204742 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 933 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5998605.5734 | 2095661.21413 | 37.734206366028296 | -122.44723512141701 | (37.7342063660283, -122.447235121417) | |||
44937 | 44937 | 222679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | |||
45347 | 45347 | 108716 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 201 Randall St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773302 | 6004213.21698 | 2097517.4141599997 | 37.73962189424871 | -122.427979939698 | (37.7396218942487, -122.427979939698) | |
48133 | 48133 | 60575 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | 3 | Permit Number 20188 | 6013715.09373 | 2105885.47906 | 37.763131795228794 | -122.395712472146 | (37.7631317952288, -122.395712472146) | ||
53626 | 53626 | 175808 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6005234.38829 | 2091786.48978 | 37.7239437686747 | -122.42404172366001 | (37.7239437686747, -122.42404172366) | ||||
56364 | 56364 | 204718 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995836.31697 | 2094012.72029 | 37.7295213774971 | -122.456690081702 | (37.7295213774971, -122.456690081702) | ||||
63986 | 63986 | 188409 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.40154709194799 | (37.757057753421, -122.401547091948) | |||
70380 | 70380 | 204738 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 130 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001200.02257 | 2094962.19919 | 37.7324349372236 | -122.43821524594401 | (37.7324349372236, -122.438215245944) | |||
75485 | 75485 | 175814 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 11 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005376.332880001 | 2093192.89602 | 37.727813465104 | -122.423650990705 | (37.727813465104, -122.423650990705) | ||||
77589 | 77589 | 110797 | Section 143 8 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 440 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 6003697.7 | 2098979.2 | 37.743606443306206 | -122.42986661573299 | (37.7436064433062, -122.429866615733) | |||
79940 | 79940 | 37260 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
81984 | 81984 | 14597 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1245 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 3 | 5999399.25196 | 2108537.97287 | 37.769608122005 | -122.445416710249 | (37.769608122005, -122.445416710249) | |||
90437 | 90437 | 109398 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774632 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | |
94233 | 94233 | 115439 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777507 | 6007860.5 | 2100030.9 | 37.746729037116104 | -122.41554707594 | (37.7467290371161, -122.41554707594) | ||
97304 | 97304 | 37262 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
110619 | 110619 | 108023 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 721 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773960 | 5998996.170080001 | 2108175.50509 | 37.7685898587188 | -122.446784866101 | (37.7685898587188, -122.446784866101) | ||
112848 | 112848 | 37261 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
113561 | 113561 | 115771 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1204 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.38894654781099 | (37.7207308974409, -122.388946547811) | ||
116475 | 116475 | 109575 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002004.0 | 2089808.9 | 37.7183308355338 | -122.43506727205299 | (37.7183308355338, -122.435067272053) |
117432 | 117432 | 107476 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 69 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 10x6 | Permit Number 773500 | 6007782.9107099995 | 2100032.55813 | 37.746729228385895 | -122.41581549012899 | (37.7467292283859, -122.415815490129) | ||
118878 | 118878 | 108906 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 214 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772968 | 6009519.2 | 2097295.6 | 37.7393115967784 | -122.40961840488701 | (37.7393115967784, -122.409618404887) |
125305 | 125305 | 222705 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007841.33022 | 2100005.82897 | 37.74665912012979 | -122.41561158852899 | (37.7466591201298, -122.415611588529) | |||
129702 | 129702 | 204734 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994953.56479 | 2099867.13318 | 37.7455454275919 | -122.460165799529 | (37.7455454275919, -122.460165799529) | |||
131430 | 131430 | 204721 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 460 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997139.03164 | 2093838.66053 | 37.729118162849495 | -122.452173936375 | (37.7291181628495, -122.452173936375) | |||
140417 | 140417 | 108905 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772783 | 6001785.8 | 2087307.2 | 37.7114493293027 | -122.43564261659901 | (37.7114493293027, -122.435642616599) |
155099 | 155099 | 222702 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 123 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008311.654 | 2097864.96994 | 37.7408072216699 | -122.413833840154 | (37.7408072216699, -122.413833840154) | |||
166040 | 166040 | 175807 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 156 San Juan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001266.11551 | 2092303.88748 | 37.725139581023605 | -122.437796421768 | (37.7251395810236, -122.437796421768) | |||
169588 | 169588 | 204739 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 463 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998365.55897 | 2095230.78545 | 37.7330107938072 | -122.44803394331899 | (37.7330107938072, -122.448033943319) | |||
171201 | 171201 | 175802 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 421 Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011992.04716 | 2086775.8851599998 | 37.7105648747395 | -122.400329663484 | (37.7105648747395, -122.400329663484) | |||
178842 | 178842 | 204733 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994927.12974 | 2099849.55804 | 37.745495650106605 | -122.460255934077 | (37.7454956501066, -122.460255934077) | |||
184518 | 184518 | 39934 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 186 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41205 | 6010249.35801 | 2088014.8431799999 | 37.7138694695674 | -122.40644005139299 | (37.7138694695674, -122.406440051393) |
26902 | 26902 | 175812 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005342.42292 | 2093158.1624099999 | 37.727716180055204 | -122.42376574960899 | (37.7277161800552, -122.423765749609) | ||||
36204 | 36204 | 222700 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 551 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001566.9280900005 | 2102610.03358 | 37.7534549532875 | -122.437494242369 | (37.7534549532875, -122.437494242369) | |||
44360 | 44360 | 222680 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 76 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6006248.111740001 | 2099605.96855 | 37.7454715078156 | -122.421092396098 | (37.7454715078156, -122.421092396098) | |||
68446 | 68446 | 188417 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 274 Topeka Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013295.80448 | 2094667.84679 | 37.7323072334974 | -122.396376359792 | (37.7323072334974, -122.396376359792) | |||
75225 | 75225 | 204717 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995876.20042 | 2094034.0159599998 | 37.7295821401899 | -122.456553740875 | (37.7295821401899, -122.456553740875) | ||||
81516 | 81516 | 50910 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 2 | 3x9 | Permit Number 772737 | 5991103.05311172 | 2098729.45888754 | 37.742199437798 | -122.47339717645399 | (37.742199437798, -122.473397176454) |
84993 | 84993 | 117424 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 600x POWHATTAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008524.0 | 2098073.0 | 37.7413903494898 | -122.41311433102699 | (37.7413903494898, -122.413114331027) | |||
91704 | 91704 | 188404 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012258.41015 | 2102196.39231 | 37.7529212353325 | -122.40049153337401 | (37.7529212353325, -122.400491533374) | ||||
128258 | 128258 | 204719 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 110 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993903.71897 | 2099982.29966 | 37.7458012037543 | -122.46380433331001 | (37.7458012037543, -122.46380433331) | |||
129739 | 129739 | 204728 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991366.51565 | 2094145.3724 | 37.729627950748295 | -122.47215214722401 | (37.7296279507483, -122.472152147224) | |||
133308 | 133308 | 222682 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 Trainor St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008292.2753800005 | 2108046.95875 | 37.768763565716704 | -122.41462120290501 | (37.7687635657167, -122.414621202905) | |||
135290 | 135290 | 222704 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 69 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007772.24851 | 2100018.26139 | 37.746689373329296 | -122.415851346858 | (37.7466893733293, -122.415851346858) | |||
146575 | 146575 | 222710 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 201 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6004263.21249 | 2097476.0489 | 37.7395111430209 | -122.427804130079 | (37.7395111430209, -122.427804130079) | |||
156342 | 156342 | 222693 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 440 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003701.6023699995 | 2098966.92625 | 37.74357296341329 | -122.42985224701 | (37.7435729634133, -122.42985224701) | |||
167905 | 167905 | 94813 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2948 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53896 | 6002515.07841 | 2118365.04564 | 37.7967681547718 | -122.43534223486799 | (37.7967681547718, -122.435342234868) | |
175877 | 175877 | 222699 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2102 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6002635.97774 | 2099387.5471900003 | 37.744667486907204 | -122.43356696417 | (37.7446674869072, -122.43356696417) | |||
175957 | 175957 | 204740 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 317 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999296.31857 | 2095221.44608 | 37.7330383112512 | -122.44481540373 | (37.7330383112512, -122.44481540373) | |||
176434 | 176434 | 124049 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 651 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5992517.64773 | 2111006.08275 | 37.775989642541795 | -122.469399404795 | (37.7759896425418, -122.469399404795) | |||
24848 | 24848 | 188408 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6011976.80987 | 2103707.86259 | 37.7570556930855 | -122.40157158857299 | (37.7570556930855, -122.401571588573) | |||
28752 | 28752 | 222686 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1201 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004284.84781 | 2095906.59844 | 37.735203011805204 | -122.427617536921 | (37.7352030118052, -122.427617536921) | ||||
35603 | 35603 | 204716 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 155 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992699.213880001 | 2098207.72713 | 37.7408591943976 | -122.467840257748 | (37.7408591943976, -122.467840257748) | |||
37117 | 37117 | 175815 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 616 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009798.67948 | 2091167.8757200001 | 37.722501823573 | -122.40822001654301 | (37.722501823573, -122.408220016543) | |||
38985 | 38985 | 123068 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 678 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992266.69336 | 2110864.34538 | 37.7755859643914 | -122.47025718989201 | (37.7755859643914, -122.470257189892) | |||
39239 | 39239 | 175813 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005348.05368 | 2093155.48995 | 37.727709159929105 | -122.42374609402201 | (37.7277091599291, -122.423746094022) | ||||
40369 | 40369 | 222690 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1071 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010267.11643 | 2102987.22407 | 37.754981431951606 | -122.40743358371901 | (37.7549814319516, -122.407433583719) | |||
44119 | 44119 | 222706 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001708.51992 | 2101780.94195 | 37.7511865150679 | -122.43694523773199 | (37.7511865150679, -122.436945237732) | |||
47522 | 47522 | 188400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1045 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015554.8451 | 2104260.21833 | 37.7587713477501 | -122.389235841663 | (37.7587713477501, -122.389235841663) | |||
48921 | 48921 | 204737 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 230 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001436.76661 | 2095116.79206 | 37.7328728755875 | -122.43740783373 | (37.7328728755875, -122.43740783373) | |||
49828 | 49828 | 222696 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005530.879319999 | 2096284.28114 | 37.736310445970204 | -122.423336387162 | (37.7363104459702, -122.423336387162) | |||
52474 | 52474 | 204720 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 60 Agua Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5997138.083869999 | 2098588.27013 | 37.7421593919444 | -122.452519836329 | (37.7421593919444, -122.452519836329) | |||
53901 | 53901 | 222695 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 52 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007649.81084 | 2099951.99688 | 37.746500541785394 | -122.416270032545 | (37.7465005417854, -122.416270032545) | |||
54760 | 54760 | 188413 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014027.478680001 | 2105319.8341099997 | 37.7615960301482 | -122.394592417822 | (37.7615960301482, -122.394592417822) | |||
56499 | 56499 | 222681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2318 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6011232.98207 | 2103716.09635 | 37.7570367677534 | -122.404144621787 | (37.7570367677534, -122.404144621787) | ||||
62795 | 62795 | 188412 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014026.1658 | 2105339.44297 | 37.761649798808996 | -122.394598331744 | (37.761649798809, -122.394598331744) | |||
63826 | 63826 | 204741 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 843 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999425.99834 | 2095633.84899 | 37.734178072446205 | -122.444396695552 | (37.7341780724462, -122.444396695552) | |||
77059 | 77059 | 188411 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014024.24871 | 2105357.36092 | 37.7616988910081 | -122.394606216998 | (37.7616988910081, -122.394606216998) | |||
105228 | 105228 | 57041 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 1 | Permit Number 31232 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | ||
109961 | 109961 | 22155 | Private 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3X3 | 6015579.0 | 2098247.0 | 37.74226164995721 | -122.388732527256 | (37.7422616499572, -122.388732527256) | |||
130324 | 130324 | 123045 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 568 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991929.81513 | 2111594.03006 | 37.777569997766705 | -122.47147570428301 | (37.7775699977667, -122.471475704283) | |||
137834 | 137834 | 175805 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 35 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6009673.12409 | 2089221.0725599998 | 37.7171492746007 | -122.408516774841 | (37.7171492746007, -122.408516774841) | |||
149164 | 149164 | 175811 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005336.45581 | 2093162.3032099998 | 37.727727212929004 | -122.423786672331 | (37.727727212929, -122.423786672331) | ||||
153957 | 153957 | 218236 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 353 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991977.13565 | 2097137.64691 | 37.7378793033766 | -122.47025900595101 | (37.7378793033766, -122.470259005951) | |||
156475 | 156475 | 175816 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 616 Dwight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009781.28405 | 2091163.7033900002 | 37.7224893931511 | -122.40827985473699 | (37.7224893931511, -122.408279854737) | |||
165838 | 165838 | 59091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 3524 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18392 | 5992426.174880001 | 2110042.4468799997 | 37.77333847202161 | -122.46964566266001 | (37.7733384720216, -122.46964566266) | ||
167143 | 167143 | 188401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 909 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015267.441000001 | 2104396.98208 | 37.7591309344718 | -122.39023938074101 | (37.7591309344718, -122.390239380741) | |||
170167 | 170167 | 222677 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1498 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010454.79524 | 2100826.85949 | 37.749060050992604 | -122.40663230034201 | (37.7490600509926, -122.406632300342) | |||
171203 | 171203 | 204735 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 40 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995650.24765 | 2100035.09823 | 37.746046665624 | -122.457768945275 | (37.746046665624, -122.457768945275) | |||
172403 | 172403 | 204736 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 40 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995677.52131 | 2100065.8007099996 | 37.7461325337836 | -122.457676858293 | (37.7461325337836, -122.457676858293) | |||
174132 | 174132 | 188415 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 Jennings St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6019090.329030001 | 2097590.47628 | 37.7406529492792 | -122.37654576818998 | (37.7406529492792, -122.37654576819) | |||
178316 | 178316 | 202043 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 52 Exeter St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012522.16713 | 2090984.69593 | 37.722150974681604 | -122.398792625891 | (37.7221509746816, -122.398792625891) | |||
185050 | 185050 | 204744 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 545 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5996927.5801099995 | 2095415.2897 | 37.733435093958896 | -122.453018700168 | (37.7334350939589, -122.453018700168) | |||
187407 | 187407 | 175800 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 701 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001959.2202699995 | 2089802.6495400001 | 37.71831113034379 | -122.43522160969401 | (37.7183111303438, -122.435221609694) | |||
188538 | 188538 | 204729 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 16 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991368.5463 | 2094108.06034 | 37.729525618690204 | -122.47214240847 | (37.7295256186902, -122.47214240847) | |||
5046 | 5046 | 150652 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 647 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 6011556.07446 | 2105379.04628 | 37.7616209062969 | -122.403144210544 | (37.7616209062969, -122.403144210544) | |||
81119 | 81119 | 22153 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6015582.155925799 | 2098251.0940713002 | 37.742273066345604 | -122.388721900676 | (37.7422730663456, -122.388721900676) | |||
185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
3465 | 3465 | 39926 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
5660 | 5660 | 39923 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
8008 | 8008 | 39924 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
8423 | 8423 | 37327 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39838 | |||||||||
10733 | 10733 | 39925 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
14920 | 14920 | 37328 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39838 | |||||||||
18455 | 18455 | 51904 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
19241 | 19241 | 116677 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
20912 | 20912 | 52837 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4219@ CASTRO 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48855 | 6002474.48025452 | 2100603.93596677 | 37.7479982404255 | -122.434212332638 | (37.7479982404255, -122.434212332638) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");