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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69867 | 69867 | 222678 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | |||
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) | |||
70804 | 70804 | 175801 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 421 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011986.878880001 | 2086756.6218599998 | 37.7105116933366 | -122.400346174163 | (37.7105116933366, -122.400346174163) | |||
71501 | 71501 | 188399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010997.55787 | 2105333.97174 | 37.7614659351153 | -122.40507272844499 | (37.7614659351153, -122.405072728445) | |||
72067 | 72067 | 204730 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 20 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991365.099780001 | 2094040.0062400002 | 37.7293385597172 | -122.472149364714 | (37.7293385597172, -122.472149364714) | |||
72437 | 72437 | 222707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000349.79562 | 2106864.73806 | 37.7650680535768 | -122.44200870415101 | (37.7650680535768, -122.442008704151) | |||
72995 | 72995 | 217762 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 470 West Portal Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5991703.40817 | 2096440.7638 | 37.735950009376204 | -122.471154649778 | (37.7359500093762, -122.471154649778) | ||||
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) | ||||
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) | |||
83692 | 83692 | 109401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
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) | |||
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) | |
94670 | 94670 | 109400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
96969 | 96969 | 109399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
97134 | 97134 | 122681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
103296 | 103296 | 101469 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
115834 | 115834 | 246707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | ||||
116006 | 116006 | 106924 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886002 | (37.7637969766711, -122.43958767886) | |||
116919 | 116919 | 175809 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6005230.95207 | 2091785.5880000002 | 37.7239410985769 | -122.424053538037 | (37.7239410985769, -122.424053538037) | ||||
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) | ||
125228 | 125228 | 109402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
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) | |||
127137 | 127137 | 122679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
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) | |||
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) | |||
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) | |||
129974 | 129974 | 222689 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 10ft | 6006609.95498 | 2098107.9290400003 | 37.7413786194175 | -122.419734923451 | (37.7413786194175, -122.419734923451) | |||
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) | |||
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) | |||
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) | |||
135308 | 135308 | 204726 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 30 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | |||
136139 | 136139 | 222692 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 York St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009835.7153900005 | 2105907.76012 | 37.7629764094606 | -122.409131567579 | (37.7629764094606, -122.409131567579) | |||
136522 | 136522 | 204722 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 422 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5993793.315830001 | 2090006.70292 | 37.7184043108851 | -122.46346228245501 | (37.7184043108851, -122.463462282455) | ||||
136961 | 136961 | 205922 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 370 Monterey Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999640.50046 | 2094726.6696 | 37.7316994068856 | -122.443589949734 | (37.7316994068856, -122.443589949734) | |||
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) | |||
144281 | 144281 | 122680 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
144682 | 144682 | 106923 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886002 | (37.7637969766711, -122.43958767886) | |||
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) | |||
146973 | 146973 | 187576 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010826.85106 | 2089479.8583099998 | 37.7179243930824 | -122.40454707471301 | (37.7179243930824, -122.404547074713) | ||||
147518 | 147518 | 188397 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010696.0277 | 2105850.49204 | 37.7628673226003 | -122.406151993137 | (37.7628673226003, -122.406151993137) | |||
148165 | 148165 | 222701 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 340 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004099.43344 | 2096524.74955 | 37.7368898251991 | -122.42830262426399 | (37.7368898251991, -122.428302624264) | |||
148509 | 148509 | 188398 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010694.68122 | 2105889.4054 | 37.7629740945886 | -122.406159391868 | (37.7629740945886, -122.406159391868) | |||
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) | ||||
149330 | 149330 | 222691 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2981 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.49349 | 2101000.57831 | 37.7494890986626 | -122.40960567126801 | (37.7494890986626, -122.409605671268) | |||
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) | |||
154057 | 154057 | 204723 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991397.3981 | 2094531.5501400002 | 37.7306900851772 | -122.47207352129801 | (37.7306900851772, -122.472073521298) | |||
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) | |||
155156 | 155156 | 125935 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1132 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | ||||
155781 | 155781 | 222708 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000342.850880001 | 2106861.9429200003 | 37.76505998306129 | -122.442032523579 | (37.7650599830613, -122.442032523579) | |||
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) | |||
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) | |||
159639 | 159639 | 188416 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1790 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6014390.68688 | 2096696.7168 | 37.7379389617097 | -122.392732952571 | (37.7379389617097, -122.392732952571) | |||
162264 | 162264 | 187573 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010858.37792 | 2089492.3055900002 | 37.717960332674295 | -122.404438975305 | (37.7179603326743, -122.404438975305) | ||||
162790 | 162790 | 222684 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1100 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004829.85448 | 2096667.61167 | 37.7373233955514 | -122.42578739946501 | (37.7373233955514, -122.425787399465) | ||||
165084 | 165084 | 204743 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 280 Joost Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 7ft | 6000165.05205 | 2094974.5458099998 | 37.732409919872 | -122.441794258103 | (37.732409919872, -122.441794258103) | |||
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) | |||
166591 | 166591 | 222687 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006597.39234 | 2098081.5973 | 37.741305610657 | -122.419776492811 | (37.741305610657, -122.419776492811) | ||||
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) | |||
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) | |||
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) | |||
170368 | 170368 | 204724 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 21 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991391.18592 | 2094484.3447599998 | 37.730560111554496 | -122.47209155808999 | (37.7305601115545, -122.47209155809) | |||
170450 | 170450 | 204725 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 29 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991390.23736 | 2094439.33755 | 37.730436478151496 | -122.47209155807501 | (37.7304364781515, -122.472091558075) | |||
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) | |||
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) | |||
171726 | 171726 | 204714 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991182.79274 | 2105342.1880099997 | 37.7603608823676 | -122.473603723127 | (37.7603608823676, -122.473603723127) | |||
172205 | 172205 | 222688 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006604.22222 | 2098080.62198 | 37.741303317398206 | -122.419752808255 | (37.7413033173982, -122.419752808255) | ||||
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) | |||
173385 | 173385 | 175810 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | ||||
173848 | 173848 | 188410 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1501 22nd St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6013292.91596 | 2103788.2689099996 | 37.7573498217412 | -122.397025598364 | (37.7573498217412, -122.397025598364) | ||||
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) | |||
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) | |||
176601 | 176601 | 188418 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1790 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014392.11707 | 2096695.01257 | 37.737934361678796 | -122.39272788847401 | (37.7379343616788, -122.392727888474) | |||
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) | |||
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) | |||
179565 | 179565 | 222694 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 427 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6003122.71421 | 2099186.4838799997 | 37.7441430185014 | -122.431869572034 | (37.7441430185014, -122.431869572034) | ||||
183898 | 183898 | 188402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 654 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012373.88939 | 2104883.09648 | 37.7603047754705 | -122.40028086897 | (37.7603047754705, -122.40028086897) | |||
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) |
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");