Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 126538 | 126538 | 43593 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2014 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43254 | 5986663.03161814 | 2101533.45903453 | 37.7496403612652 | -122.488955268867 | (37.7496403612652, -122.488955268867) | ||
| 87762 | 87762 | 50399 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 83 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47050 | 5987527.82253963 | 2095318.01016643 | 37.732624814623605 | -122.485508763661 | (37.7326248146236, -122.485508763661) | ||
| 81255 | 81255 | 50394 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 84 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47045 | 5987580.16978348 | 2095308.26318011 | 37.7326011016802 | -122.48532707377899 | (37.7326011016802, -122.485327073779) | ||
| 1060 | 1060 | 71174 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1432 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988368.0802 | 2099689.3718 | 37.7446763519612 | -122.48292408536301 | (37.7446763519612, -122.482924085363) | ||
| 125410 | 125410 | 45536 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 79 Melba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | |||
| 52605 | 52605 | 204713 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991184.777919999 | 2105315.94504 | 37.7602889411076 | -122.473594943052 | (37.7602889411076, -122.473594943052) | |||
| 88611 | 88611 | 50909 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2014 12:00:00 AM | Permit Number 772737 | 5991103.05311172 | 2098729.45888754 | 37.742199437798 | -122.47339717645399 | (37.742199437798, -122.473397176454) | ||
| 140864 | 140864 | 53611 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 50102 | 5991755.89113084 | 2099997.75858136 | 37.7457196459604 | -122.47123227110201 | (37.7457196459604, -122.471232271102) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 125714 | 125714 | 102089 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
| 128301 | 128301 | 45396 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 135 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 44206 | 5992967.23882057 | 2092102.4527906997 | 37.72411110068 | -122.466469901656 | (37.72411110068, -122.466469901656) | ||
| 84059 | 84059 | 51242 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 De Soto St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47612 | 5993144.07933001 | 2091663.61630064 | 37.722916365509704 | -122.4658267259 | (37.7229163655097, -122.4658267259) | ||
| 98857 | 98857 | 97214 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
| 107044 | 107044 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 339 Kirkham St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.5874099997 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 3095 | 3095 | 204715 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 327 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3 | Width 6ft | Permit Number 51243 | 5996623.78142 | 2106956.86791 | 37.7651079834665 | -122.454902653043 | (37.7651079834665, -122.454902653043) | |
| 90766 | 90766 | 47962 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 545 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45692 | 5996911.63382453 | 2095401.78894083 | 37.733397110236 | -122.45307285643601 | (37.733397110236, -122.453072856436) | ||
| 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) | |||
| 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) | |||
| 118481 | 118481 | 52690 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1401@ RIVOLI Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2011 12:00:00 AM | Permit Number 768319 | 5997782.141834901 | 2105912.5855129 | 37.76230702883 | -122.45082088432301 | (37.76230702883, -122.450820884323) | |||
| 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) | |
| 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) | |||||
| 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) | ||||
| 122286 | 122286 | 97347 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2011 12:00:00 AM | 3x3 | Permit Number 768267 | 5998216.1 | 2106370.5 | 37.7635891788793 | -122.449352986262 | (37.7635891788793, -122.449352986262) | ||
| 18891 | 18891 | 107407 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.44779499190099 | (37.7589750798494, -122.447794991901) | ||||
| 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) | |||
| 9782 | 9782 | 159354 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 417x Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998501.29354 | 2087549.7908 | 37.7119283225022 | -122.44701212372802 | (37.7119283225022, -122.447012123728) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 129111 | 129111 | 51597 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | 3x3 | Permit Number 47890 | 5999641.13876025 | 2107457.97579425 | 37.766656526924294 | -122.444502404738 | (37.7666565269243, -122.444502404738) | ||
| 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) | |||
| 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) | ||
| 11143 | 11143 | 109071 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 35 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772757 | 5999530.156 | 2088703.36466 | 37.715154504538795 | -122.443538910497 | (37.7151545045388, -122.443538910497) |
| 121909 | 121909 | 49971 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168@ DOUGLASS Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | ||
| 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) | |||
| 12022 | 12022 | 108898 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 378 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772818 | 6000293.95374 | 2086893.3367700002 | 37.7102281038126 | -122.440769142495 | (37.7102281038126, -122.440769142495) |
| 82422 | 82422 | 113192 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 150X Museum Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | Permit Number 774288 | 6001029.7 | 2106463.5 | 37.7640050744287 | -122.439628320832 | (37.7640050744287, -122.439628320832) | |||
| 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) | |||
| 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) | |||
| 12216 | 12216 | 108836 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 699 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001204.89947 | 2089626.81587 | 37.717785465811296 | -122.437816386741 | (37.7177854658113, -122.437816386741) |
| 59138 | 59138 | 222697 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 690 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6001460.97341 | 2099432.54018 | 37.744724288990895 | -122.43763311299101 | (37.7447242889909, -122.437633112991) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 89633 | 89633 | 55158 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | Permit Number 775652 | 6001766.13275037 | 2101783.99509326 | 37.751198172676 | -122.436746225237 | (37.751198172676, -122.436746225237) | |||
| 110009 | 110009 | 108903 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772783 | 6001785.77868 | 2087307.18495 | 37.7114492867677 | -122.43564268921001 | (37.7114492867677, -122.43564268921) | ||
| 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) | |
| 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) | |||
| 12634 | 12634 | 109574 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002013.87176 | 2089826.5009400002 | 37.7183797243364 | -122.435034407708 | (37.7183797243364, -122.435034407708) |
| 94755 | 94755 | 105988 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 651X Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002337.0 | 2099724.0 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | |||||
| 61729 | 61729 | 222698 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002437.17664 | 2100607.07314 | 37.7480047370361 | -122.434341551122 | (37.7480047370361, -122.434341551122) | |||
| 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) | |||
| 124888 | 124888 | 48984 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | Permit Number 46171 | 6002499.14803074 | 2100605.29142344 | 37.7480033622388 | -122.43412712945299 | (37.7480033622388, -122.434127129453) | ||
| 10903 | 10903 | 110032 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 630 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775191 | 6002420.02658 | 2090107.3938799999 | 37.719174047824104 | -122.433650566035 | (37.7191740478241, -122.433650566035) |
| 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) | |||
| 85068 | 85068 | 37279 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
| 114980 | 114980 | 37338 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44638 | 6003659.25274291 | 2103921.20422444 | 37.757173851767604 | -122.430352080919 | (37.7571738517676, -122.430352080919) | ||
| 115789 | 115789 | 37339 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 790 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39845 | 6003692.20622256 | 2103684.04749104 | 37.7565245422275 | -122.43022119623501 | (37.7565245422275, -122.430221196235) | ||
| 121505 | 121505 | 96747 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 118645 | 118645 | 37300 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 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) | |||
| 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) | |||
| 122747 | 122747 | 37294 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 261 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39823 | 6003941.02088917 | 2104485.98513979 | 37.7587405625745 | -122.42941789284599 | (37.7587405625745, -122.429417892846) | ||
| 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) | |||
| 86034 | 86034 | 51889 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 340 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48102 | 6004103.48678716 | 2096538.35102027 | 37.736927401104396 | -122.42828957914601 | (37.7369274011044, -122.428289579146) | |||
| 77303 | 77303 | 34415 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 209 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38162 | 6004171.37602222 | 2097541.35369817 | 37.739685259534504 | -122.42812631334499 | (37.7396852595345, -122.428126313345) | ||
| 107669 | 107669 | 50389 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 296 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 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) | |||
| 125182 | 125182 | 34411 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38159 | 6004342.16299585 | 2097508.24193041 | 37.739604003626795 | -122.427533446458 | (37.7396040036268, -122.427533446458) | ||
| 105073 | 105073 | 34365 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1863 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38121 | 6004615.32037959 | 2097871.72676254 | 37.7406174967526 | -122.42661486213999 | (37.7406174967526, -122.42661486214) | ||
| 12013 | 12013 | 116582 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 195 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778001 | 6004664.28928 | 2093799.33843 | 37.729438402445105 | -122.426155697039 | (37.7294384024451, -122.426155697039) | |
| 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) | ||||
| 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) | ||||
| 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) | |||
| 438 | 438 | 157409 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 3x5 | 6005572.56549 | 2096690.1102099998 | 37.7374271143738 | -122.423221099494 | (37.7374271143738, -122.423221099494) | ||
| 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) | |||
| 119936 | 119936 | 42691 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2500 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 78919 | 78919 | 42827 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 11005 | 11005 | 108841 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Pioche St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773762 | 6006499.8637 | 2093472.98879 | 37.7286458955893 | -122.419786780156 | (37.7286458955893, -122.419786780156) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 85314 | 85314 | 40436 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1999 12:00:00 AM | Permit Number 41528 | 6008599.59735478 | 2097476.96685444 | 37.7397580168027 | -122.412810811968 | (37.7397580168027, -122.412810811968) | ||
| 88482 | 88482 | 92854 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 52 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x4 | Permit Number 53073 | 6008847.1 | 2098275.4 | 37.7419642285502 | -122.412011459633 | (37.7419642285502, -122.412011459633) | ||
| 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) | ||||
| 105253 | 105253 | 109313 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 3261 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771278 | 6009056.2 | 2099704.9 | 37.745901050724 | -122.411389421874 | (37.745901050724, -122.411389421874) | |
| 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) |
| 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) | |||
| 24397 | 24397 | 222703 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 214 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009527.84065 | 2097295.3841 | 37.7393114881468 | -122.40958851400299 | (37.7393114881468, -122.409588514003) |
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");