trees

326 rows where qSpecies_id = 146 sorted by XCoord

✎ View and edit SQL

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)
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                    
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                    
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                    
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                    
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                    
55370 119433 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 715 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2018 12:00:00 AM 3 3x14   5985978.78842 2110984.89203 37.7755514115766 -122.492017154699 (37.7755514115766, -122.492017154699) 11 6 2 55 26
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
64690 50399 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 83 Sylvan Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47050 5987527.82253963 2095318.01016643 37.7326248146236 -122.485508763661 (37.7326248146236, -122.485508763661) 1 8 4 64 35
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
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
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
100695 45537 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 79 Melba Ave 2 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
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
63442 50909 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2450 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2014 12:00:00 AM     Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.473397176454 (37.742199437798, -122.473397176454) 1 8 4 29491 40
52701 204714 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1484 16th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   5991182.79274 2105342.18801 37.7603608823676 -122.473603723127 (37.7603608823676, -122.473603723127) 1 8 4 56 12
48818 204713 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1484 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   5991184.77792 2105315.94504 37.7602889411076 -122.473594943052 (37.7602889411076, -122.473594943052) 1 8 4 56 12
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
59676 204731 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 400 Junipero Serra Blvd 25 : Tree Private 2     5 Width 0ft   5991352.35851 2093912.83716 37.728988647895 -122.472184145999 (37.728988647895, -122.472184145999) 9 8 4 64 40
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
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
66973 204729 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 400 Junipero Serra Blvd 16 : Tree Private 2     1 Width 0ft   5991368.5463 2094108.06034 37.7295256186902 -122.47214240847 (37.7295256186902, -122.47214240847) 9 8 4 64 40
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
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
79994 204725 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 300 Junipero Serra Blvd 29 : Tree Private 2     5 Width 0ft   5991390.23736 2094439.33755 37.7304364781515 -122.472091558075 (37.7304364781515, -122.472091558075) 9 8 4 64 40
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
55595 204727 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 300 Junipero Serra Blvd 38 : Tree Private 2     4 Width 0ft   5991391.65527 2094396.58957 37.73031918497 -122.472083541538 (37.73031918497, -122.472083541538) 9 8 4 64 40
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
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
97827 155299 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2246 Cecilia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2018 12:00:00 AM 3 3x3 Permit Number 781265 5991542.12865 2100124.4857 37.7460552388554 -122.471980658208 (37.7460552388554, -122.471980658208) 1 8 4 29491 40
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
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
83728 123045 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 568 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5991929.81513 2111594.03006 37.7775699977667 -122.471475704283 (37.7775699977667, -122.471475704283) 11 6 2 54 11
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
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
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
75024 123068 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 678 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992266.69336 2110864.34538 37.7755859643914 -122.470257189892 (37.7755859643914, -122.470257189892) 11 6 2 54 11
88088 59091 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 3524 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1980 12:00:00 AM 1   Permit Number 18392 5992426.17488 2110042.44688 37.7733384720216 -122.46964566266 (37.7733384720216, -122.46964566266) 11 6 2 54 11
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
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
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
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
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
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
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
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
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
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
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
88659 204716 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 155 Madrone Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992699.21388 2098207.72713 37.7408591943976 -122.467840257748 (37.7408591943976, -122.467840257748) 1 8 4 59 40
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
46047 51242 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 80 De Soto St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47612 5993144.07933001 2091663.61630064 37.7229163655097 -122.4658267259 (37.7229163655097, -122.4658267259) 9 8 4 59 40
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
105081 97214 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 300X Claremont Blvd 1 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     12     5993486 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055) 1 8 4 59 40
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
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
123398 204719 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 110 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331 (37.7458012037543, -122.46380433331) 1 8 4 29491 40
56056 36956 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 16 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39587 5994274.56771258 2115474.49567321 37.7883600733979 -122.463646184404 (37.7883600733979, -122.463646184404) 11 6 1 54 11
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
116431 204734 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 80 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994953.56479 2099867.13318 37.7455454275919 -122.460165799529 (37.7455454275919, -122.460165799529) 1 8 4 59 40
57894 204735 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 40 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995650.24765 2100035.09823 37.746046665624 -122.457768945275 (37.746046665624, -122.457768945275) 1 5 4 59 40
48397 204736 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 40 Vasquez Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995677.52131 2100065.80071 37.7461325337836 -122.457676858293 (37.7461325337836, -122.457676858293) 1 5 4 59 40
73637 204718 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1485x Northwood Dr 6 Median : Yard Tree DPW 1     3     5995836.31697 2094012.72029 37.7295213774971 -122.456690081702 (37.7295213774971, -122.456690081702) 9 7 4 28861 40
109617 204717 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1485x Northwood Dr 5 Median : Yard Tree DPW 1     2     5995876.20042 2094034.01596 37.7295821401899 -122.456553740875 (37.7295821401899, -122.456553740875) 9 7 4 28861 40
88080 15071 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1X Minerva St 3 Median : Cutout Tree DPW 1     3 11   5995959.85959 2089005.66859 37.7157802951115 -122.455901163122 (37.7157802951115, -122.455901163122) 9 8 6 28861 24
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
54745 204715 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 327 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   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) 15 5 11 29492 12
71407 47962 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 545 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45692 5996911.63382453 2095401.78894083 37.733397110236 -122.453072856436 (37.733397110236, -122.453072856436) 9 7 4 59 40
57947 204744 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 545 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5996927.58011 2095415.2897 37.7334350939589 -122.453018700168 (37.7334350939589, -122.453018700168) 9 7 4 59 40
105681 204720 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 60 Agua Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997138.08387 2098588.27013 37.7421593919444 -122.452519836329 (37.7421593919444, -122.452519836329) 9 7 4 59 40
121497 204721 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 460 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5997139.03164 2093838.66053 37.7291181628495 -122.452173936375 (37.7291181628495, -122.452173936375) 9 7 4 28861 40
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
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
107782 101469 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2           5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748) 2 5 4 63 38
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
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
51409 109401 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1588 WALLER ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997977.9 2108248 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331) 15 5 11 29492 9
77966 109400 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1588 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997977.9 2108248 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331) 15 5 11 29492 9
91616 109399 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1588 WALLER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997977.9 2108248 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331) 15 5 11 29492 9
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
58479 205923 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 266 Judson Ave 3 Sidewalk: Property side : Yard Tree Private 2     6     5998304.03576 2093569.77611 37.7284465374612 -122.448127087008 (37.7284465374612, -122.448127087008) 9 7 4 28861 40
59122 204739 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 463 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.448033943319 (37.7330107938072, -122.448033943319) 9 7 4 59 40
67632 159354 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 417x Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.447012123728 (37.7119283225022, -122.447012123728) 9 7 6 28861 25
100784 204742 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 933 Teresita Blvd 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 7ft   5998605.5734 2095661.21413 37.7342063660283 -122.447235121417 (37.7342063660283, -122.447235121417) 9 7 4 59 40
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
78128 256675 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 330 Twin Peaks Blvd 3 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
118497 108023 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 721 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 773960 5998996.17008 2108175.50509 37.7685898587188 -122.446784866101 (37.7685898587188, -122.446784866101) 15 5 11 29492 9
64583 180729 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 727 Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2   05/15/2019 12:00:00 AM 3 Width 10ft Permit Number 782865 5999059.45631 2090357.33436 37.7196690715525 -122.445284694236 (37.7196690715525, -122.445284694236) 9 7 6 28861 25
72659 258063 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 727 Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2   05/15/2019 12:00:00 AM 3 Width 10ft Permit Number 782865 5999059.45631 2090357.33436 37.7196690715525 -122.445284694236 (37.7196690715525, -122.445284694236) 9 7 6 28861 25
62344 204740 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 317 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373) 9 7 4 59 40
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
121297 204741 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 843 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999425.99834 2095633.84899 37.7341780724462 -122.444396695552 (37.7341780724462, -122.444396695552) 9 7 4 59 40
54205 109071 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 35 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772757 5999530.156 2088703.36466 37.7151545045388 -122.443538910497 (37.7151545045388, -122.443538910497) 9 7 6 28861 25
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);