trees
326 rows where qSpecies_id = 146 sorted by Fire Prevention Districts
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 | |||||||||||||
53325 | 188414 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 602 Arthur Ave | 36 | Front Yard : Yard | Tree | Private 2 | 5 | 6015677.9579 | 2099872.41216 | 37.7467301800674 | -122.388503787217 | (37.7467301800674, -122.388503787217) | 3 | 8 | 58 | 1 | |||||
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 | |
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 | |||
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 | |
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 | |||
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 | ||||
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 | |
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 | ||||
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 | ||
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 |
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 | ||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 |
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |
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 | |
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 |
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
46351 | 37260 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801X Church St | 3 | 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 | |
48861 | 175802 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 421 Wheeler Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011992.04716 | 2086775.88516 | 37.7105648747395 | -122.400329663484 | (37.7105648747395, -122.400329663484) | 10 | 3 | 8 | 309 | 1 | |||
50589 | 188415 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2 Jennings St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6019090.32903 | 2097590.47628 | 37.7406529492792 | -122.37654576819 | (37.7406529492792, -122.37654576819) | 10 | 3 | 8 | 58 | 1 | |||
55683 | 188417 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 274 Topeka Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013295.80448 | 2094667.84679 | 37.7323072334974 | -122.396376359792 | (37.7323072334974, -122.396376359792) | 10 | 3 | 8 | 58 | 1 | |||
59541 | 188409 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2033 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.401547091948 | (37.757057753421, -122.401547091948) | 10 | 3 | 8 | 28856 | 29 | |||
60197 | 117424 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 600x POWHATTAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008524 | 2098073 | 37.7413903494898 | -122.413114331027 | (37.7413903494898, -122.413114331027) | 10 | 7 | 7 | 28859 | 2 | |||
61433 | 150776 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2112 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2018 12:00:00 AM | 0 | Width 2ft | 6011802.53574 | 2103753.06347 | 37.757170078752 | -122.402177476208 | (37.757170078752, -122.402177476208) | 10 | 3 | 8 | 28856 | 29 | |
64939 | 188418 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1790 McKinnon Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014392.11707 | 2096695.01257 | 37.7379343616788 | -122.392727888474 | (37.7379343616788, -122.392727888474) | 10 | 3 | 8 | 58 | 1 | |||
66283 | 92854 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 52 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x4 | Permit Number 53073 | 6008847.1 | 2098275.4 | 37.7419642285502 | -122.412011459633 | (37.7419642285502, -122.412011459633) | 10 | 7 | 7 | 28859 | 2 | ||
67118 | 187570 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 73 Bishop St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6010859.73078 | 2089462.03095 | 37.7178772802949 | -122.404432169207 | (37.7178772802949, -122.404432169207) | 10 | 7 | 8 | 309 | 39 | ||||
67954 | 40436 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1999 12:00:00 AM | Permit Number 41528 | 6008599.59735478 | 2097476.96685444 | 37.7397580168027 | -122.412810811968 | (37.7397580168027, -122.412810811968) | 10 | 7 | 7 | 28859 | 2 | ||
75820 | 187575 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 Bishop St | 2 | Side Yard : Yard | Tree | Private 2 | 11 | 6010832.96557 | 2089490.79182 | 37.7179547559905 | -122.40452670864 | (37.7179547559905, -122.40452670864) | 10 | 7 | 8 | 309 | 39 | ||||
86172 | 188399 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010997.55787 | 2105333.97174 | 37.7614659351153 | -122.405072728445 | (37.7614659351153, -122.405072728445) | 10 | 3 | 8 | 28856 | 29 | |||
86175 | 37262 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801X Church St | 4 | 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 | |
101931 | 108725 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 877 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773104 | 6011895.30838 | 2104315.65478 | 37.758720008153 | -122.401896177292 | (37.758720008153, -122.401896177292) | 10 | 3 | 8 | 28856 | 29 |
105708 | 188400 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1045 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015554.8451 | 2104260.21833 | 37.7587713477501 | -122.389235841663 | (37.7587713477501, -122.389235841663) | 10 | 3 | 8 | 28856 | 29 | |||
109430 | 188404 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1300x De Haro St | 10 | Median : Yard | Tree | DPW 1 | 2 | 6012258.41015 | 2102196.39231 | 37.7529212353325 | -122.400491533374 | (37.7529212353325, -122.400491533374) | 10 | 3 | 8 | 28856 | 29 | ||||
110747 | 187576 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 Bishop St | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6010826.85106 | 2089479.85831 | 37.7179243930824 | -122.404547074713 | (37.7179243930824, -122.404547074713) | 10 | 7 | 8 | 309 | 39 | ||||
111576 | 254190 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 9 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781215 | 6012415.77849 | 2103885.20758 | 37.7575671280362 | -122.400065912549 | (37.7575671280362, -122.400065912549) | 10 | 3 | 8 | 28856 | 29 |
112953 | 175801 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 421 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011986.87888 | 2086756.62186 | 37.7105116933366 | -122.400346174163 | (37.7105116933366, -122.400346174163) | 10 | 3 | 8 | 309 | 1 | |||
117069 | 187571 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 73 Bishop St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6010860.52073 | 2089475.11103 | 37.7179132396708 | -122.404430358869 | (37.7179132396708, -122.404430358869) | 10 | 7 | 8 | 309 | 39 | ||||
119972 | 188401 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 909 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015267.441 | 2104396.98208 | 37.7591309344718 | -122.390239380741 | (37.7591309344718, -122.390239380741) | 10 | 3 | 8 | 28856 | 29 | |||
123246 | 22155 | Private 9 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3X3 | 6015579 | 2098247 | 37.7422616499572 | -122.388732527256 | (37.7422616499572, -122.388732527256) | 10 | 3 | 8 | 58 | 1 | |||
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 |
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 | |||
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 | |
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 | ||||
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 | |
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 | ||||
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 | ||
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 | |
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 |
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 |
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 | |||
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 | ||
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 |
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 | |||
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 | |||
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 | ||
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 | ||
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 |
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) );