trees
326 rows where qSpecies_id = 146 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194188 | 96748 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 193758 | 37308 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 11 | 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 | ||
| 192679 | 222702 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 123 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008311.654 | 2097864.96994 | 37.7408072216699 | -122.413833840154 | (37.7408072216699, -122.413833840154) | 2 | 7 | 7 | 28859 | 2 | |||
| 192159 | 106327 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 37 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772574 | 6007569.3 | 2099210.3 | 37.7444594805766 | -122.4164959017 | (37.7444594805766, -122.4164959017) | 2 | 7 | 7 | 28859 | 2 | ||||
| 191305 | 204724 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 21 | : | Tree | Private 2 | 8 | Width 0ft | 5991391.18592 | 2094484.34476 | 37.7305601115545 | -122.47209155809 | (37.7305601115545, -122.47209155809) | 9 | 8 | 4 | 64 | 40 | |||
| 188659 | 50832 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 886 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | Permit Number 781204 | 6012122.31213 | 2104263.66996 | 37.7585899355868 | -122.401107436752 | (37.7585899355868, -122.401107436752) | 10 | 3 | 8 | 28856 | 29 | ||
| 188514 | 175816 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 616 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781334 | 6009781.28405 | 2091163.70339 | 37.7224893931511 | -122.408279854737 | (37.7224893931511, -122.408279854737) | 9 | 3 | 7 | 309 | 28 |
| 188371 | 108905 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772783 | 6001785.8 | 2087307.2 | 37.7114493293027 | -122.435642616599 | (37.7114493293027, -122.435642616599) | 9 | 7 | 6 | 28861 | 5 |
| 186112 | 122680 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
| 186075 | 222698 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002437.17664 | 2100607.07314 | 37.7480047370361 | -122.434341551122 | (37.7480047370361, -122.434341551122) | 2 | 4 | 5 | 63 | 22 | |||
| 185217 | 53611 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 50102 | 5991755.89113084 | 2099997.75858136 | 37.7457196459604 | -122.471232271102 | (37.7457196459604, -122.471232271102) | 1 | 8 | 4 | 29491 | 40 | ||
| 185048 | 204732 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Junipero Serra Blvd | 92 | : | Tree | Private 2 | 9 | Width 0ft | 5991226.61275 | 2092125.57221 | 37.7240739859998 | -122.472488607886 | (37.7240739859998, -122.472488607886) | 9 | 8 | 4 | 64 | 40 | |||
| 184382 | 108836 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 699 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001204.89947 | 2089626.81587 | 37.7177854658113 | -122.437816386741 | (37.7177854658113, -122.437816386741) | 9 | 7 | 6 | 28861 | 5 |
| 184255 | 37856 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 50 Ina Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | |||
| 183183 | 36072 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1504 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | 8 | 4 | 7 | 28853 | 19 | ||
| 183067 | 179272 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 303 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 2ft | 6010315.74596 | 2092790.6472 | 37.7269865555705 | -122.406546922301 | (37.7269865555705, -122.406546922301) | 10 | 3 | 7 | 309 | 28 | |||
| 182439 | 42823 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 7 | 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 | ||
| 181929 | 222696 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 73 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005530.87932 | 2096284.28114 | 37.7363104459702 | -122.423336387162 | (37.7363104459702, -122.423336387162) | 2 | 7 | 7 | 28859 | 2 | |||
| 181139 | 37304 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 5 | 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 | ||
| 180901 | 51954 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 82 Mary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711 | -122.406019811456 | (37.781019735711, -122.406019811456) | 14 | 2 | 9 | 28853 | 34 | |||
| 180753 | 222710 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 201 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6004263.21249 | 2097476.0489 | 37.7395111430209 | -122.427804130079 | (37.7395111430209, -122.427804130079) | 2 | 7 | 5 | 63 | 7 | |||
| 180584 | 37284 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 4 | 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 | |||
| 179740 | 51903 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 168 Caselli Ave | 2 | 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 | |||
| 175751 | 106923 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 196 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886 | (37.7637969766711, -122.43958767886) | 15 | 5 | 5 | 28862 | 3 | |||
| 175637 | 37299 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 4 | 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 | ||
| 175379 | 256321 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 225X Head St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5993438 | 2087500 | 37.7115010262354 | -122.4645085409 | (37.7115010262354, -122.4645085409) | 9 | 8 | 4 | 64 | 24 | ||||
| 174179 | 188406 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1300x De Haro St | 6 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | 10 | 3 | 8 | 28856 | 29 | |||
| 173178 | 80780 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 702 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773102 | 6011234.66837 | 2105019.04099 | 37.7606144579058 | -122.404230490851 | (37.7606144579058, -122.404230490851) | 10 | 3 | 8 | 28856 | 29 |
| 170221 | 52690 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1401@ RIVOLI Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2011 12:00:00 AM | Permit Number 768319 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
| 170150 | 45178 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 8 Joy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44026 | 6010481.29682875 | 2098887.30560798 | 37.7437359418448 | -122.406404010665 | (37.7437359418448, -122.406404010665) | 2 | 7 | 7 | 28859 | 2 | ||
| 168013 | 175810 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 La Grande Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | 9 | 7 | 6 | 28861 | 5 | ||||
| 167647 | 204722 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 422 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5993793.31583 | 2090006.70292 | 37.7184043108851 | -122.463462282455 | (37.7184043108851, -122.463462282455) | 9 | 8 | 6 | 64 | 24 | ||||
| 167338 | 96747 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 166892 | 97347 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2011 12:00:00 AM | 3x3 | Permit Number 768267 | 5998216.1 | 2106370.5 | 37.7635891788793 | -122.449352986262 | (37.7635891788793, -122.449352986262) | 15 | 5 | 11 | 29492 | 9 | ||
| 166635 | 37294 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 261 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39823 | 6003941.02088917 | 2104485.98513979 | 37.7587405625745 | -122.429417892846 | (37.7587405625745, -122.429417892846) | 2 | 4 | 5 | 28862 | 3 | ||
| 166591 | 115771 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1204 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.388946547811 | (37.7207308974409, -122.388946547811) | 10 | 3 | 8 | 58 | 1 | ||
| 165219 | 188413 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 398 Mississippi St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6014027.47868 | 2105319.83411 | 37.7615960301482 | -122.394592417822 | (37.7615960301482, -122.394592417822) | 10 | 3 | 8 | 28856 | 29 | |||
| 164924 | 204733 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 80 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994927.12974 | 2099849.55804 | 37.7454956501066 | -122.460255934077 | (37.7454956501066, -122.460255934077) | 1 | 8 | 4 | 59 | 40 | |||
| 163337 | 37300 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 1 | 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 | ||
| 162926 | 222699 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2102 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 5ft | 6002635.97774 | 2099387.54719 | 37.7446674869072 | -122.43356696417 | (37.7446674869072, -122.43356696417) | 2 | 7 | 5 | 63 | 22 | |||
| 162850 | 42691 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2500 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
| 162802 | 124049 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 651 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5992517.64773 | 2111006.08275 | 37.7759896425418 | -122.469399404795 | (37.7759896425418, -122.469399404795) | 11 | 6 | 2 | 54 | 11 | |||
| 162679 | 175811 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6005336.45581 | 2093162.30321 | 37.727727212929 | -122.423786672331 | (37.727727212929, -122.423786672331) | 9 | 7 | 6 | 28861 | 5 | ||||
| 162578 | 49971 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 168@ DOUGLASS Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/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 | ||
| 160983 | 108906 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 214 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772968 | 6009519.2 | 2097295.6 | 37.7393115967784 | -122.409618404887 | (37.7393115967784, -122.409618404887) | 10 | 7 | 7 | 28859 | 2 |
| 159420 | 222703 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 214 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009527.84065 | 2097295.3841 | 37.7393114881468 | -122.409588514003 | (37.7393114881468, -122.409588514003) | 10 | 7 | 7 | 28859 | 2 | |||
| 158648 | 188407 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1300x De Haro St | 5 | Median : Yard | Tree | DPW 1 | 6 | 6012285.79175 | 2102196.41625 | 37.7529228280459 | -122.400396843734 | (37.7529228280459, -122.400396843734) | 10 | 3 | 8 | 28856 | 29 | ||||
| 158397 | 188412 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 398 Mississippi St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6014026.1658 | 2105339.44297 | 37.761649798809 | -122.394598331744 | (37.761649798809, -122.394598331744) | 10 | 3 | 8 | 28856 | 29 | |||
| 158277 | 187574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 Bishop St | 1 | Side Yard : Yard | Tree | Private 2 | 10 | 6010842.89139 | 2089488.5588 | 37.71794917929 | -122.404492242147 | (37.71794917929, -122.404492242147) | 10 | 7 | 8 | 309 | 39 | ||||
| 157016 | 107476 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 69 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2014 12:00:00 AM | 3 | 10x6 | Permit Number 773500 | 6007782.91071 | 2100032.55813 | 37.7467292283859 | -122.415815490129 | (37.7467292283859, -122.415815490129) | 2 | 7 | 7 | 28859 | 2 | ||
| 155659 | 204723 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 12 | : | Tree | Private 2 | 5 | Width 0ft | 5991397.3981 | 2094531.55014 | 37.7306900851772 | -122.472073521298 | (37.7306900851772, -122.472073521298) | 9 | 8 | 4 | 64 | 40 | |||
| 155214 | 188416 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1790 McKinnon Ave | 1 | : | Tree | Private 2 | 20 | Width 8ft | 6014390.68688 | 2096696.7168 | 37.7379389617097 | -122.392732952571 | (37.7379389617097, -122.392732952571) | 10 | 3 | 8 | 58 | 1 | |||
| 154403 | 42825 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 5 | 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 | ||
| 153776 | 37305 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 6 | 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 | ||
| 153342 | 188405 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1300x De Haro St | 9 | Median : Yard | Tree | DPW 1 | 9 | 6012256.82794 | 2102204.54617 | 37.7529435358206 | -122.400497577699 | (37.7529435358206, -122.400497577699) | 10 | 3 | 8 | 28856 | 29 | ||||
| 152958 | 258304 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2946 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008567 | 2103911 | 37.7574226061115 | -122.413378415329 | (37.7574226061115, -122.413378415329) | 2 | 4 | 7 | 28859 | 19 | ||||
| 152393 | 188402 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 654 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012373.88939 | 2104883.09648 | 37.7603047754705 | -122.40028086897 | (37.7603047754705, -122.40028086897) | 10 | 3 | 8 | 28856 | 29 | |||
| 151698 | 188403 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6012073.44818 | 2105095.84941 | 37.7608721901295 | -122.401334912194 | (37.7608721901295, -122.401334912194) | 10 | 3 | 8 | 28856 | 29 | ||||
| 150616 | 204728 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 2 | Width 0ft | 5991366.51565 | 2094145.3724 | 37.7296279507483 | -122.472152147224 | (37.7296279507483, -122.472152147224) | 9 | 8 | 4 | 64 | 40 | |||
| 150507 | 222689 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Eugenia Ave | 33 | Front Yard : Yard | Tree | Private 2 | 7 | Width 10ft | 6006609.95498 | 2098107.92904 | 37.7413786194175 | -122.419734923451 | (37.7413786194175, -122.419734923451) | 2 | 7 | 7 | 28859 | 2 | |||
| 150129 | 188408 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2033 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6011976.80987 | 2103707.86259 | 37.7570556930855 | -122.401571588573 | (37.7570556930855, -122.401571588573) | 10 | 3 | 8 | 28856 | 29 | |||
| 150096 | 202860 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 650 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2018 12:00:00 AM | 3 | Width 5ft | 6011493.61772 | 2105454.79745 | 37.7618254139376 | -122.403365553474 | (37.7618254139376, -122.403365553474) | 10 | 3 | 8 | 28856 | 29 | ||
| 149720 | 93869 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400-422X Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012466.99875 | 2086683.8296 | 37.7103385819422 | -122.398681660343 | (37.7103385819422, -122.398681660343) | 10 | 3 | 8 | 309 | 1 |
| 148750 | 106924 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 196 States St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886 | (37.7637969766711, -122.43958767886) | 15 | 5 | 5 | 28862 | 3 | |||
| 148048 | 247976 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 503 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 9 | 6009801.95016 | 2099270.17301 | 37.7447491849331 | -122.408780045086 | (37.7447491849331, -122.408780045086) | 2 | 7 | 7 | 28859 | 2 | ||||
| 147889 | 222695 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 52 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007649.81084 | 2099951.99688 | 37.7465005417854 | -122.416270032545 | (37.7465005417854, -122.416270032545) | 2 | 7 | 7 | 28859 | 2 | |||
| 147109 | 102524 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 154 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770317 | 6011839.9295 | 2088903.37059 | 37.7163980403033 | -122.401004803454 | (37.7163980403033, -122.401004803454) | 10 | 7 | 8 | 309 | 39 | |
| 145931 | 45157 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 52 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2001 12:00:00 AM | Permit Number 44010 | 6009584.15178374 | 2098431.32664232 | 37.7424336946684 | -122.409473962707 | (37.7424336946684, -122.409473962707) | 10 | 7 | 7 | 28859 | 2 | ||
| 145494 | 251243 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008953 | 2098186 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | 10 | 7 | 7 | 28859 | 2 | ||||
| 144929 | 37261 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.384018475054 | (37.7603812969624, -122.384018475054) | 10 | 3 | 8 | 310 | 29 | |
| 143767 | 187573 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 73 Bishop St | 4 | Side Yard : Yard | Tree | Private 2 | 14 | 6010858.37792 | 2089492.30559 | 37.7179603326743 | -122.404438975305 | (37.7179603326743, -122.404438975305) | 10 | 7 | 8 | 309 | 39 | ||||
| 143408 | 37338 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44638 | 6003659.25274291 | 2103921.20422444 | 37.7571738517676 | -122.430352080919 | (37.7571738517676, -122.430352080919) | 2 | 4 | 5 | 28862 | 3 | ||
| 143274 | 37339 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 790 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39845 | 6003692.20622256 | 2103684.04749104 | 37.7565245422275 | -122.430221196235 | (37.7565245422275, -122.430221196235) | 2 | 4 | 5 | 28862 | 3 | ||
| 141314 | 109575 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002004 | 2089808.9 | 37.7183308355338 | -122.435067272053 | (37.7183308355338, -122.435067272053) | 9 | 7 | 6 | 28861 | 5 |
| 138347 | 116585 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2100 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2018 12:00:00 AM | 30 | 3x3 | 6011855.05017 | 2103755.96694 | 37.7571809821214 | -122.401996064067 | (37.7571809821214, -122.401996064067) | 10 | 3 | 8 | 28856 | 29 | |
| 138112 | 222687 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Eugenia Ave | 19 | Front Yard : Yard | Tree | Private 2 | 5 | 6006597.39234 | 2098081.5973 | 37.741305610657 | -122.419776492811 | (37.741305610657, -122.419776492811) | 2 | 7 | 7 | 28859 | 2 | ||||
| 137568 | 222700 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 551 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001566.92809 | 2102610.03358 | 37.7534549532875 | -122.437494242369 | (37.7534549532875, -122.437494242369) | 2 | 4 | 5 | 28862 | 22 | |||
| 137479 | 37302 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 3 | 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 | ||
| 136012 | 204730 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 20 | : | Tree | Private 2 | 7 | Width 0ft | 5991365.09978 | 2094040.00624 | 37.7293385597172 | -122.472149364714 | (37.7293385597172, -122.472149364714) | 9 | 8 | 4 | 64 | 40 | |||
| 134658 | 102090 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 27 Santa Ana Ave | 2 | 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 | |
| 134606 | 222707 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 290 States St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6000349.79562 | 2106864.73806 | 37.7650680535768 | -122.442008704151 | (37.7650680535768, -122.442008704151) | 15 | 5 | 5 | 28862 | 3 | |||
| 134475 | 222693 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 440 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003701.60237 | 2098966.92625 | 37.7435729634133 | -122.42985224701 | (37.7435729634133, -122.42985224701) | 2 | 7 | 5 | 63 | 22 | |||
| 133067 | 49132 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Valdez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | 9 | 7 | 4 | 28861 | 40 | ||
| 133024 | 108841 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 125 Pioche St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773762 | 6006499.8637 | 2093472.98879 | 37.7286458955893 | -122.419786780156 | (37.7286458955893, -122.419786780156) | 9 | 7 | 7 | 309 | 5 | |
| 130977 | 150652 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 647 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6011556.07446 | 2105379.04628 | 37.7616209062969 | -122.403144210544 | (37.7616209062969, -122.403144210544) | 10 | 3 | 8 | 28856 | 29 | |||
| 129211 | 50389 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 296 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
| 128966 | 222691 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2981 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009598.49349 | 2101000.57831 | 37.7494890986626 | -122.409605671268 | (37.7494890986626, -122.409605671268) | 2 | 4 | 7 | 28859 | 19 | |||
| 128858 | 57041 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 1 | Permit Number 31232 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | 15 | 5 | 11 | 29492 | 9 | ||
| 128791 | 247940 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.28814 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | 2 | 7 | 7 | 28859 | 2 | |||
| 128528 | 204745 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 370 Monterey Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999685.08818 | 2094723.93815 | 37.7316944498203 | -122.443435605388 | (37.7316944498203, -122.443435605388) | 9 | 7 | 4 | 63 | 40 | |||
| 128439 | 108903 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 772783 | 6001785.77868 | 2087307.18495 | 37.7114492867677 | -122.43564268921 | (37.7114492867677, -122.43564268921) | 9 | 7 | 6 | 28861 | 5 | ||
| 127456 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 339 Kirkham St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.58741 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | 1 | 8 | 4 | 56 | 12 | ||
| 126738 | 247941 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.407074570729 | (37.743786764646, -122.407074570729) | 2 | 7 | 7 | 28859 | 2 | |||
| 126503 | 34365 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1863 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38121 | 6004615.32037959 | 2097871.72676254 | 37.7406174967526 | -122.42661486214 | (37.7406174967526, -122.42661486214) | 2 | 7 | 5 | 63 | 7 | ||
| 125896 | 188397 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 501 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6010696.0277 | 2105850.49204 | 37.7628673226003 | -122.406151993137 | (37.7628673226003, -122.406151993137) | 8 | 4 | 8 | 28859 | 19 | |||
| 124469 | 37281 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 5 | 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 | |||
| 124448 | 222685 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 145 Coso Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6007512.1231 | 2099620.66206 | 37.7455830273527 | -122.416722673922 | (37.7455830273527, -122.416722673922) | 2 | 7 | 7 | 28859 | 2 | ||||
| 124013 | 88642 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 637 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51602 | 6003051 | 2104517 | 37.7587752917563 | -122.432498206664 | (37.7587752917563, -122.432498206664) | 2 | 4 | 5 | 28862 | 3 | |||
| 124009 | 202834 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 9 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781215 | 6012361.84911 | 2103951.76771 | 37.7577468805228 | -122.400257098083 | (37.7577468805228, -122.400257098083) | 10 | 3 | 8 | 28856 | 29 |
| 123808 | 109313 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 3261 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771278 | 6009056.2 | 2099704.9 | 37.745901050724 | -122.411389421874 | (37.745901050724, -122.411389421874) | 2 | 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) );