trees
326 rows where qSpecies_id = 146 sorted by Police 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 | |||||||||||||
17797 | 42821 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
21334 | 125935 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1132 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | 5 | 1 | 1 | 28858 | 32 | ||||
28293 | 42826 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
33202 | 42819 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
33321 | 42824 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
37759 | 42820 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
44730 | 42827 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
55821 | 42828 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
109861 | 42822 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
154403 | 42825 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
182439 | 42823 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 801 Bay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.2276607 | 2121167.35462349 | 37.8047131790945 | -122.420211856319 | (37.8047131790945, -122.420211856319) | 5 | 1 | 1 | 28858 | 32 | ||
83979 | 51953 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 82 Mary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711 | -122.406019811456 | (37.781019735711, -122.406019811456) | 14 | 2 | 9 | 28853 | 34 | |||
104068 | 51952 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 82 Mary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711 | -122.406019811456 | (37.781019735711, -122.406019811456) | 14 | 2 | 9 | 28853 | 34 | |||
180901 | 51954 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 82 Mary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711 | -122.406019811456 | (37.781019735711, -122.406019811456) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 |
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 | |||
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 | |||
43270 | 175815 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 616 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781334 | 6009798.67948 | 2091167.87572 | 37.722501823573 | -122.408220016543 | (37.722501823573, -122.408220016543) | 9 | 3 | 7 | 309 | 28 |
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 | |||
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 | |||
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 | |||
57536 | 91228 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53161 | 6013714.91861 | 2105876.83519 | 37.7631080513185 | -122.39571247215 | (37.7631080513185, -122.39571247215) | 14 | 3 | 8 | 28856 | 29 | |
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 | |||
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 | |||
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 | |
87087 | 91227 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53161 | 6013717 | 2105930 | 37.7632541459928 | -122.395708998562 | (37.7632541459928, -122.395708998562) | 14 | 3 | 8 | 28856 | 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 | |||
106332 | 60575 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1982 12:00:00 AM | 3 | Permit Number 20188 | 6013715.09373 | 2105885.47906 | 37.7631317952288 | -122.395712472146 | (37.7631317952288, -122.395712472146) | 14 | 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 | ||||
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 | |||
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 | |
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 | |
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 | |||
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 | ||||
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 | |||
188514 | 175816 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 616 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781334 | 6009781.28405 | 2091163.70339 | 37.7224893931511 | -122.408279854737 | (37.7224893931511, -122.408279854737) | 9 | 3 | 7 | 309 | 28 |
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 | ||
862 | 51904 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.442410364393 | (37.7596792654558, -122.442410364393) | 2 | 4 | 5 | 28862 | 3 | |||
7422 | 52837 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4219@ CASTRO 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48855 | 6002474.48025452 | 2100603.93596677 | 37.7479982404255 | -122.434212332638 | (37.7479982404255, -122.434212332638) | 2 | 4 | 5 | 63 | 22 | |||
7455 | 152146 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 422 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2020 12:00:00 AM | 3 | Width 3ft | 6005912.13833 | 2107880.12281 | 37.7681714646705 | -122.422842073015 | (37.7681714646705, -122.422842073015) | 8 | 4 | 5 | 28853 | 19 | ||
7765 | 263633 | Section 806 (d) 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 160 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782824 | 6000235.49843 | 2104901.88273 | 37.7596720242526 | -122.442263109517 | (37.7596720242526, -122.442263109517) | 2 | 4 | 5 | 28862 | 3 | |
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 | ||||
10923 | 96749 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
10972 | 222690 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1071 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010267.11643 | 2102987.22407 | 37.7549814319516 | -122.407433583719 | (37.7549814319516, -122.407433583719) | 10 | 4 | 7 | 28859 | 19 | |||
15575 | 111241 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 745X SANCHEZ ST | 4 | Median : Yard | Tree | DPW 1 | 6 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||
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 | |||
35349 | 37309 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | 2 | 4 | 5 | 28862 | 22 | ||
35495 | 37280 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | 2 | 4 | 5 | 28862 | 3 | |||
39618 | 37278 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | 2 | 4 | 5 | 28862 | 3 | |||
43711 | 222706 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001708.51992 | 2101780.94195 | 37.7511865150679 | -122.436945237732 | (37.7511865150679, -122.436945237732) | 2 | 4 | 5 | 28862 | 22 | |||
43722 | 96750 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
49841 | 68449 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4054 20th St | 2 | Front Yard : Yard | Tree | Private 2 | FUF | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.7579344920216 | -122.431783761852 | (37.7579344920216, -122.431783761852) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
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 | |||
71970 | 37279 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | 2 | 4 | 5 | 28862 | 3 | |||
72370 | 50387 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 296 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
74618 | 37303 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 7 | 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 | ||
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 | ||
81481 | 37307 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 10 | 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 | ||
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 | |||
107635 | 37306 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 9 | 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 | ||
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 | ||
119631 | 37301 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 8 | 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 |
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) );