trees
326 rows where qSpecies_id = 146 sorted by Neighborhoods (old)
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 | |||||||||||||
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 |
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 | |||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | |
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 | ||||
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 | |||
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 | |
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 | ||
122389 | 94813 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2948 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53896 | 6002515.07841 | 2118365.04564 | 37.7967681547718 | -122.435342234868 | (37.7967681547718, -122.435342234868) | 13 | 9 | 1 | 57 | 17 | |
7455 | 152146 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 422 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2020 12:00:00 AM | 3 | Width 3ft | 6005912.13833 | 2107880.12281 | 37.7681714646705 | -122.422842073015 | (37.7681714646705, -122.422842073015) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
24369 | 222679 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | 2 | 4 | 5 | 28859 | 19 | |||
52584 | 36071 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1504 Bryant St | 3 | 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 | ||
65409 | 222678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | 2 | 4 | 5 | 28859 | 19 | |||
78360 | 36069 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44775 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | 8 | 4 | 7 | 28853 | 19 | ||
94221 | 222692 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 501 York St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009835.71539 | 2105907.76012 | 37.7629764094606 | -122.409131567579 | (37.7629764094606, -122.409131567579) | 8 | 4 | 8 | 28859 | 19 | |||
94964 | 36068 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1504 Bryant St | 5 | 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 | ||
104858 | 222682 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2 Trainor St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008292.27538 | 2108046.95875 | 37.7687635657167 | -122.414621202905 | (37.7687635657167, -122.414621202905) | 8 | 4 | 7 | 28853 | 19 | |||
109730 | 52165 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2981 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48358 | 6009655.09893949 | 2101001.15400866 | 37.7494938511533 | -122.409409967788 | (37.7494938511533, -122.409409967788) | 2 | 4 | 7 | 28859 | 19 | ||
119731 | 188398 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 501 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6010694.68122 | 2105889.4054 | 37.7629740945886 | -122.406159391868 | (37.7629740945886, -122.406159391868) | 8 | 4 | 8 | 28859 | 19 | |||
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 | |||
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 | |||
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 | ||||
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 | ||
848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
2144 | 262399 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 17 Benton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | Width 9ft | 6004468 | 2094766 | 37.7320815428237 | -122.426903105989 | (37.7320815428237, -122.426903105989) | 2 | 7 | 7 | 28861 | 2 | ||
7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
8529 | 108850 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250x MONTCALM ST | 1 | Back Yard : Yard | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | Permit Number 774524 | 6009909.2 | 2099657.1 | 37.7458176084011 | -122.40843648152 | (37.7458176084011, -122.40843648152) | 2 | 7 | 7 | 28859 | 2 | ||
11485 | 262403 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 24 Benton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | Width 9ft | 6004551 | 2094783 | 37.7321329137501 | -122.426617366798 | (37.7321329137501, -122.426617366798) | 2 | 7 | 7 | 28861 | 2 | ||
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 | ||||
29923 | 116678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
37535 | 122679 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
39733 | 157410 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | 2 | 7 | 7 | 28859 | 2 | ||
40519 | 222688 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Eugenia Ave | 20 | Front Yard : Yard | Tree | Private 2 | 10 | 6006604.22222 | 2098080.62198 | 37.7413033173982 | -122.419752808255 | (37.7413033173982, -122.419752808255) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |
47914 | 246707 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | 2 | 7 | 7 | 28859 | 2 | ||||
54426 | 247973 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 155 Faith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6010331.53551 | 2099090.76742 | 37.7442862247418 | -122.406936189376 | (37.7442862247418, -122.406936189376) | 2 | 7 | 7 | 28859 | 2 | |||
55526 | 222705 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007841.33022 | 2100005.82897 | 37.7466591201298 | -122.415611588529 | (37.7466591201298, -122.415611588529) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
66830 | 222686 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1201 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 1 | 6004284.84781 | 2095906.59844 | 37.7352030118052 | -122.427617536921 | (37.7352030118052, -122.427617536921) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | ||
78784 | 222680 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 76 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6006248.11174 | 2099605.96855 | 37.7454715078156 | -122.421092396098 | (37.7454715078156, -122.421092396098) | 2 | 7 | 5 | 28859 | 2 | |||
83330 | 157409 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 125 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2017 12:00:00 AM | 3 | 3x5 | 6005572.56549 | 2096690.11021 | 37.7374271143738 | -122.423221099494 | (37.7374271143738, -122.423221099494) | 2 | 7 | 7 | 28859 | 2 | ||
89239 | 248046 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 38 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6010555.40468 | 2099417.48898 | 37.745195855722 | -122.406185107956 | (37.745195855722, -122.406185107956) | 2 | 7 | 7 | 28859 | 2 | ||||
90395 | 122681 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
92895 | 115439 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777507 | 6007860.5 | 2100030.9 | 37.7467290371161 | -122.41554707594 | (37.7467290371161, -122.41554707594) | 2 | 7 | 7 | 28859 | 2 | ||
119844 | 222704 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 69 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007772.24851 | 2100018.26139 | 37.7466893733293 | -122.415851346858 | (37.7466893733293, -122.415851346858) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||
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 |
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | |||
7422 | 52837 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4219@ CASTRO 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48855 | 6002474.48025452 | 2100603.93596677 | 37.7479982404255 | -122.434212332638 | (37.7479982404255, -122.434212332638) | 2 | 4 | 5 | 63 | 22 | |||
22988 | 48984 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2002 12:00:00 AM | Permit Number 46171 | 6002499.14803074 | 2100605.29142344 | 37.7480033622388 | -122.434127129453 | (37.7480033622388, -122.434127129453) | 2 | 4 | 5 | 63 | 22 | ||
33280 | 110797 | Section 143 10 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 440 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 6003697.7 | 2098979.2 | 37.7436064433062 | -122.429866615733 | (37.7436064433062, -122.429866615733) | 2 | 7 | 5 | 63 | 22 | |||
35349 | 37309 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | 2 | 4 | 5 | 28862 | 22 | ||
41163 | 105989 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 651X Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002337 | 2099724 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | 2 | 7 | 5 | 63 | 22 | |||||
43711 | 222706 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001708.51992 | 2101780.94195 | 37.7511865150679 | -122.436945237732 | (37.7511865150679, -122.436945237732) | 2 | 4 | 5 | 28862 | 22 | |||
57969 | 222697 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 690 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001460.97341 | 2099432.54018 | 37.7447242889909 | -122.437633112991 | (37.7447242889909, -122.437633112991) | 2 | 7 | 5 | 63 | 22 | |||
69524 | 55158 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | Permit Number 775652 | 6001766.13275037 | 2101783.99509326 | 37.751198172676 | -122.436746225237 | (37.751198172676, -122.436746225237) | 2 | 4 | 5 | 28862 | 22 |
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) );