trees
326 rows where qSpecies_id = 146
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 862 | 51904 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.442410364393 | (37.7596792654558, -122.442410364393) | 2 | 4 | 5 | 28862 | 3 | |||
| 1866 | 150777 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2112 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011789.01086 | 2103751.70928 | 37.7571656055116 | -122.402224155531 | (37.7571656055116, -122.402224155531) | 10 | 3 | 8 | 28856 | 29 | |||
| 1992 | 260845 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 6 Cragmont Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782122 | 5992584.1181 | 2101828.636 | 37.7507946382458 | -122.468501593976 | (37.7507946382458, -122.468501593976) | 1 | 8 | 4 | 29491 | 12 | |
| 2144 | 262399 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 17 Benton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | Width 9ft | 6004468 | 2094766 | 37.7320815428237 | -122.426903105989 | (37.7320815428237, -122.426903105989) | 2 | 7 | 7 | 28861 | 2 | ||
| 4064 | 214029 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | Width 1ft | Permit Number 785373 | 6000729.59206 | 2094530.61609 | 37.7312231430208 | -122.439810699013 | (37.7312231430208, -122.439810699013) | 9 | 7 | 4 | 63 | 40 | |
| 6357 | 261583 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 6460 | 261585 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 6578 | 245102 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999861.4659 | 2109378.2907 | 37.7719417978626 | -122.443878316418 | (37.7719417978626, -122.443878316418) | 15 | 5 | 11 | 29492 | 9 | |||
| 7422 | 52837 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4219@ CASTRO 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48855 | 6002474.48025452 | 2100603.93596677 | 37.7479982404255 | -122.434212332638 | (37.7479982404255, -122.434212332638) | 2 | 4 | 5 | 63 | 22 | |||
| 7455 | 152146 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 422 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2020 12:00:00 AM | 3 | Width 3ft | 6005912.13833 | 2107880.12281 | 37.7681714646705 | -122.422842073015 | (37.7681714646705, -122.422842073015) | 8 | 4 | 5 | 28853 | 19 | ||
| 7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
| 7765 | 263633 | Section 806 (d) 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 160 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782824 | 6000235.49843 | 2104901.88273 | 37.7596720242526 | -122.442263109517 | (37.7596720242526, -122.442263109517) | 2 | 4 | 5 | 28862 | 3 | |
| 8012 | 222708 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 290 States St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000342.85088 | 2106861.94292 | 37.7650599830613 | -122.442032523579 | (37.7650599830613, -122.442032523579) | 15 | 5 | 5 | 28862 | 3 | |||
| 8160 | 107407 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.447794991901 | (37.7589750798494, -122.447794991901) | 15 | 5 | 5 | 28862 | 12 | ||||
| 8520 | 108716 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 201 Randall St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773302 | 6004213.21698 | 2097517.41416 | 37.7396218942487 | -122.427979939698 | (37.7396218942487, -122.427979939698) | 2 | 7 | 5 | 63 | 7 | |
| 8529 | 108850 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250x MONTCALM ST | 1 | Back Yard : Yard | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | Permit Number 774524 | 6009909.2 | 2099657.1 | 37.7458176084011 | -122.40843648152 | (37.7458176084011, -122.40843648152) | 2 | 7 | 7 | 28859 | 2 | ||
| 8999 | 222681 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2318 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011232.98207 | 2103716.09635 | 37.7570367677534 | -122.404144621787 | (37.7570367677534, -122.404144621787) | 10 | 4 | 8 | 28859 | 19 | ||||
| 9333 | 261584 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 9665 | 37327 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39838 | ||||||||||||||
| 10245 | 222701 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 340 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004099.43344 | 2096524.74955 | 37.7368898251991 | -122.428302624264 | (37.7368898251991, -122.428302624264) | 2 | 7 | 5 | 63 | 7 | |||
| 10923 | 96749 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 10972 | 222690 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1071 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010267.11643 | 2102987.22407 | 37.7549814319516 | -122.407433583719 | (37.7549814319516, -122.407433583719) | 10 | 4 | 7 | 28859 | 19 | |||
| 10977 | 251382 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 731 Huron Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2x5 | 5997668 | 2087467 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | 9 | 7 | 6 | 28861 | 25 | ||||
| 11485 | 262403 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 24 Benton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | Width 9ft | 6004551 | 2094783 | 37.7321329137501 | -122.426617366798 | (37.7321329137501, -122.426617366798) | 2 | 7 | 7 | 28861 | 2 | ||
| 11697 | 214030 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | Width 1ft | Permit Number 785373 | 6000729.56588 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | 9 | 7 | 4 | 63 | 40 | |
| 11732 | 261580 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 13660 | 71174 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1432 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988368.0802 | 2099689.3718 | 37.7446763519612 | -122.482924085363 | (37.7446763519612, -122.482924085363) | 1 | 8 | 3 | 29491 | 35 | |||
| 14168 | 261582 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 14441 | 110032 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 630 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775191 | 6002420.02658 | 2090107.39388 | 37.7191740478241 | -122.433650566035 | (37.7191740478241, -122.433650566035) | 9 | 7 | 6 | 28861 | 5 |
| 15328 | 39925 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 0 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41198 | |||||||||||||
| 15405 | 204726 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 30 | : | Tree | Private 2 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | 9 | 8 | 4 | 64 | 40 | |||
| 15555 | 39924 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 0 Arleta Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41198 | |||||||||||||
| 15575 | 111241 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 745X SANCHEZ ST | 4 | Median : Yard | Tree | DPW 1 | 6 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
| 16662 | 260846 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 6 Cragmont Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782122 | 5992584.1181 | 2101828.636 | 37.7507946382458 | -122.468501593976 | (37.7507946382458, -122.468501593976) | 1 | 8 | 4 | 29491 | 12 | |
| 16720 | 245107 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999850.165 | 2109456.7325 | 37.7721565345872 | -122.443923043844 | (37.7721565345872, -122.443923043844) | 15 | 5 | 11 | 29492 | 9 | |||
| 17722 | 39926 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 0 Arleta Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41198 | |||||||||||||
| 17797 | 42821 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 17946 | 37328 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39838 | ||||||||||||||
| 19074 | 39923 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 0 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41198 | |||||||||||||
| 19115 | 169677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002720.1225 | 2096203.62304 | 37.7359299419005 | -122.433048571547 | (37.7359299419005, -122.433048571547) | 2 | 7 | 5 | 63 | 7 | |||
| 19480 | 261581 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 19549 | 32269 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2033 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1996 12:00:00 AM | 4 | Permit Number 36855 | 6011970.48286 | 2103707.99117 | 37.7570556930908 | -122.40159347895 | (37.7570556930908, -122.40159347895) | 10 | 3 | 8 | 28856 | 29 | |
| 19809 | 40738 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 20 Alviso St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1999 12:00:00 AM | Permit Number 41717 | 5992072.81756498 | 2091384.27409538 | 37.7220875062624 | -122.469509497536 | (37.7220875062624, -122.469509497536) | 9 | 8 | 4 | 59 | 40 | |||
| 20816 | 202894 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2106 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Width 2ft | 6011819.10841 | 2103753.43928 | 37.7571720356734 | -122.402120187599 | (37.7571720356734, -122.402120187599) | 10 | 3 | 8 | 28856 | 29 | |
| 21137 | 45396 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 135 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | Permit Number 44206 | 5992967.23882057 | 2092102.4527907 | 37.72411110068 | -122.466469901656 | (37.72411110068, -122.466469901656) | 9 | 8 | 4 | 59 | 40 | ||
| 21192 | 218236 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 353 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781280 | 5991977.13565 | 2097137.64691 | 37.7378793033766 | -122.470259005951 | (37.7378793033766, -122.470259005951) | 1 | 8 | 4 | 59 | 40 |
| 21262 | 45536 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 79 Melba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | 1 | 8 | 4 | 64 | 35 | |||
| 21334 | 125935 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1132 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | 5 | 1 | 1 | 28858 | 32 | ||||
| 21444 | 87268 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 727 Moraga St | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/05/2008 12:00:00 AM | Permit Number 50290 | 5992077 | 2103851 | 37.7563182174397 | -122.470402504062 | (37.7563182174397, -122.470402504062) | 1 | 8 | 4 | 56 | 12 | ||||
| 21579 | 34415 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 209 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38162 | 6004171.37602222 | 2097541.35369817 | 37.7396852595345 | -122.428126313345 | (37.7396852595345, -122.428126313345) | 2 | 7 | 5 | 63 | 7 | ||
| 22017 | 204737 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 230 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001436.76661 | 2095116.79206 | 37.7328728755875 | -122.43740783373 | (37.7328728755875, -122.43740783373) | 9 | 7 | 5 | 63 | 40 | |||
| 22988 | 48984 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2002 12:00:00 AM | Permit Number 46171 | 6002499.14803074 | 2100605.29142344 | 37.7480033622388 | -122.434127129453 | (37.7480033622388, -122.434127129453) | 2 | 4 | 5 | 63 | 22 | ||
| 23075 | 93870 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.40726 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) | 10 | 3 | 8 | 309 | 1 |
| 24369 | 222679 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | 2 | 4 | 5 | 28859 | 19 | |||
| 25336 | 102089 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 27 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | 1 | 8 | 4 | 59 | 40 | |
| 25880 | 247897 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 351 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6010077.88258 | 2098386.84291 | 37.7423392041858 | -122.407763645688 | (37.7423392041858, -122.407763645688) | 10 | 7 | 7 | 28859 | 2 | ||||
| 26624 | 217762 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 470 West Portal Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5991703.40817 | 2096440.7638 | 37.7359500093762 | -122.471154649778 | (37.7359500093762, -122.471154649778) | 1 | 8 | 4 | 29491 | 40 | ||||
| 27938 | 175812 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6005342.42292 | 2093158.16241 | 37.7277161800552 | -122.423765749609 | (37.7277161800552, -122.423765749609) | 9 | 7 | 6 | 28861 | 5 | ||||
| 28293 | 42826 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 29252 | 109574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002013.87176 | 2089826.50094 | 37.7183797243364 | -122.435034407708 | (37.7183797243364, -122.435034407708) | 9 | 7 | 6 | 28861 | 5 |
| 29923 | 116678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 30025 | 222683 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1100 San Jose Ave | 27 | Front Yard : Yard | Tree | Private 2 | 4 | 6004834.70298 | 2096673.11166 | 37.7373387712724 | -122.425771027308 | (37.7373387712724, -122.425771027308) | 2 | 7 | 5 | 63 | 7 | ||||
| 30641 | 188411 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 398 Mississippi St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6014024.24871 | 2105357.36092 | 37.7616988910081 | -122.394606216998 | (37.7616988910081, -122.394606216998) | 10 | 3 | 8 | 28856 | 29 | |||
| 31951 | 116582 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 195 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778001 | 6004664.28928 | 2093799.33843 | 37.7294384024451 | -122.426155697039 | (37.7294384024451, -122.426155697039) | 9 | 7 | 6 | 28861 | 5 | |
| 32327 | 34411 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38159 | 6004342.16299585 | 2097508.24193041 | 37.7396040036268 | -122.427533446458 | (37.7396040036268, -122.427533446458) | 2 | 7 | 5 | 63 | 7 | ||
| 32618 | 188410 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1501 22nd St | 23 | Front Yard : Yard | Tree | Private 2 | 15 | 6013292.91596 | 2103788.26891 | 37.7573498217412 | -122.397025598364 | (37.7573498217412, -122.397025598364) | 10 | 3 | 8 | 28856 | 29 | ||||
| 33107 | 29576 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991377.92956 | 2094240.43756 | 37.7298896363903 | -122.472119615131 | (37.7298896363903, -122.472119615131) | 9 | 8 | 4 | 64 | 40 | ||
| 33202 | 42819 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 33219 | 175813 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6005348.05368 | 2093155.48995 | 37.7277091599291 | -122.423746094022 | (37.7277091599291, -122.423746094022) | 9 | 7 | 6 | 28861 | 5 | ||||
| 33280 | 110797 | Section 143 10 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 440 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 6003697.7 | 2098979.2 | 37.7436064433062 | -122.429866615733 | (37.7436064433062, -122.429866615733) | 2 | 7 | 5 | 63 | 22 | |||
| 33321 | 42824 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 33370 | 43593 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2014 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43254 | 5986663.03161814 | 2101533.45903453 | 37.7496403612652 | -122.488955268867 | (37.7496403612652, -122.488955268867) | 1 | 8 | 3 | 29491 | 35 | ||
| 33413 | 14597 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1245 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2008 12:00:00 AM | 3 | 5999399.25196 | 2108537.97287 | 37.769608122005 | -122.445416710249 | (37.769608122005, -122.445416710249) | 15 | 5 | 11 | 29492 | 9 | |||
| 34177 | 109402 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
| 35190 | 175803 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 421 Wheeler Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011997.87722 | 2086794.11576 | 37.7106152574533 | -122.400310793023 | (37.7106152574533, -122.400310793023) | 10 | 3 | 8 | 309 | 1 | |||
| 35349 | 37309 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | 2 | 4 | 5 | 28862 | 22 | ||
| 35495 | 37280 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | 2 | 4 | 5 | 28862 | 3 | |||
| 35571 | 175804 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 500x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6010489.90873 | 2090338.00617 | 37.7202618542943 | -122.405772155484 | (37.7202618542943, -122.405772155484) | 10 | 7 | 8 | 309 | 28 | |||
| 36147 | 51597 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | 3x3 | Permit Number 47890 | 5999641.13876025 | 2107457.97579425 | 37.7666565269243 | -122.444502404738 | (37.7666565269243, -122.444502404738) | 15 | 5 | 5 | 29492 | 9 | ||
| 37438 | 202043 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 52 Exeter St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6012522.16713 | 2090984.69593 | 37.7221509746816 | -122.398792625891 | (37.7221509746816, -122.398792625891) | 10 | 3 | 8 | 58 | 1 | |||
| 37535 | 122679 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
| 37756 | 175805 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 35 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009673.12409 | 2089221.07256 | 37.7171492746007 | -122.408516774841 | (37.7171492746007, -122.408516774841) | 9 | 7 | 8 | 309 | 39 | |||
| 37759 | 42820 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 38223 | 109398 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774632 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | |
| 38633 | 205922 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 370 Monterey Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999640.50046 | 2094726.6696 | 37.7316994068856 | -122.443589949734 | (37.7316994068856, -122.443589949734) | 9 | 7 | 4 | 63 | 40 | |||
| 38810 | 50910 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | 2 | 3x9 | Permit Number 772737 | 5991103.05311172 | 2098729.45888754 | 37.742199437798 | -122.473397176454 | (37.742199437798, -122.473397176454) | 1 | 8 | 4 | 29491 | 40 |
| 39618 | 37278 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | 2 | 4 | 5 | 28862 | 3 | |||
| 39733 | 157410 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | 2 | 7 | 7 | 28859 | 2 | ||
| 40519 | 222688 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Eugenia Ave | 20 | Front Yard : Yard | Tree | Private 2 | 10 | 6006604.22222 | 2098080.62198 | 37.7413033173982 | -122.419752808255 | (37.7413033173982, -122.419752808255) | 2 | 7 | 7 | 28859 | 2 | ||||
| 41163 | 105989 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 651X Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002337 | 2099724 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | 2 | 7 | 5 | 63 | 22 | |||||
| 42994 | 50394 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 84 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47045 | 5987580.16978348 | 2095308.26318011 | 37.7326011016802 | -122.485327073779 | (37.7326011016802, -122.485327073779) | 1 | 8 | 4 | 64 | 35 | ||
| 43270 | 175815 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 616 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781334 | 6009798.67948 | 2091167.87572 | 37.722501823573 | -122.408220016543 | (37.722501823573, -122.408220016543) | 9 | 3 | 7 | 309 | 28 |
| 43711 | 222706 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001708.51992 | 2101780.94195 | 37.7511865150679 | -122.436945237732 | (37.7511865150679, -122.436945237732) | 2 | 4 | 5 | 28862 | 22 | |||
| 43722 | 96750 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 44483 | 22153 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1570X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 6015582.1559258 | 2098251.0940713 | 37.7422730663456 | -122.388721900676 | (37.7422730663456, -122.388721900676) | 10 | 3 | 8 | 58 | 1 | |||
| 44730 | 42827 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
| 45147 | 29574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 9 | 3X3 | 5991374.69638 | 2094208.91815 | 37.729802904883 | -122.472128495928 | (37.729802904883, -122.472128495928) | 9 | 8 | 4 | 64 | 40 | |||
| 45815 | 102091 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 27 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | 1 | 8 | 4 | 59 | 40 | |
| 45838 | 222725 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 455 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781248 | 6008774.19348 | 2096652.26781 | 37.7375033714759 | -122.412148860481 | (37.7375033714759, -122.412148860481) | 10 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );