trees
326 rows where qSpecies_id = 146 sorted by Location
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 | |||||||||||||
53634 | 108898 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 378 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772818 | 6000293.95374 | 2086893.33677 | 37.7102281038126 | -122.440769142495 | (37.7102281038126, -122.440769142495) | 9 | 7 | 6 | 28861 | 5 |
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 |
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 |
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 | |||
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 | |||
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 | |||
128439 | 108903 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 772783 | 6001785.77868 | 2087307.18495 | 37.7114492867677 | -122.43564268921 | (37.7114492867677, -122.43564268921) | 9 | 7 | 6 | 28861 | 5 | ||
188371 | 108905 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772783 | 6001785.8 | 2087307.2 | 37.7114493293027 | -122.435642616599 | (37.7114493293027, -122.435642616599) | 9 | 7 | 6 | 28861 | 5 |
175379 | 256321 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 225X Head St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5993438 | 2087500 | 37.7115010262354 | -122.4645085409 | (37.7115010262354, -122.4645085409) | 9 | 8 | 4 | 64 | 24 | ||||
10977 | 251382 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 731 Huron Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2x5 | 5997668 | 2087467 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | 9 | 7 | 6 | 28861 | 25 | ||||
67632 | 159354 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 417x Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998501.29354 | 2087549.7908 | 37.7119283225022 | -122.447012123728 | (37.7119283225022, -122.447012123728) | 9 | 7 | 6 | 28861 | 25 | |
92867 | 175806 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 154 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010320.93963 | 2087695.47295 | 37.7129965480265 | -122.406170150427 | (37.7129965480265, -122.406170150427) | 9 | 7 | 8 | 309 | 39 | |||
121043 | 39934 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 186 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41205 | 6010249.35801 | 2088014.84318 | 37.7138694695674 | -122.406440051393 | (37.7138694695674, -122.406440051393) | 9 | 7 | 8 | 309 | 39 |
54205 | 109071 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 35 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772757 | 5999530.156 | 2088703.36466 | 37.7151545045388 | -122.443538910497 | (37.7151545045388, -122.443538910497) | 9 | 7 | 6 | 28861 | 25 |
88080 | 15071 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1X Minerva St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5995959.85959 | 2089005.66859 | 37.7157802951115 | -122.455901163122 | (37.7157802951115, -122.455901163122) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |
37756 | 175805 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 35 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009673.12409 | 2089221.07256 | 37.7171492746007 | -122.408516774841 | (37.7171492746007, -122.408516774841) | 9 | 7 | 8 | 309 | 39 | |||
184382 | 108836 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 699 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001204.89947 | 2089626.81587 | 37.7177854658113 | -122.437816386741 | (37.7177854658113, -122.437816386741) | 9 | 7 | 6 | 28861 | 5 |
82996 | 108837 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 699 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001210.74249 | 2089636.42248 | 37.7178121756617 | -122.437796877731 | (37.7178121756617, -122.437796877731) | 9 | 7 | 6 | 28861 | 5 |
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
106412 | 175800 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 701 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001959.22027 | 2089802.64954 | 37.7183111303438 | -122.435221609694 | (37.7183111303438, -122.435221609694) | 9 | 7 | 6 | 28861 | 5 | |||
141314 | 109575 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002004 | 2089808.9 | 37.7183308355338 | -122.435067272053 | (37.7183308355338, -122.435067272053) | 9 | 7 | 6 | 28861 | 5 |
29252 | 109574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002013.87176 | 2089826.50094 | 37.7183797243364 | -122.435034407708 | (37.7183797243364, -122.435034407708) | 9 | 7 | 6 | 28861 | 5 |
167647 | 204722 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 422 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5993793.31583 | 2090006.70292 | 37.7184043108851 | -122.463462282455 | (37.7184043108851, -122.463462282455) | 9 | 8 | 6 | 64 | 24 | ||||
14441 | 110032 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 630 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775191 | 6002420.02658 | 2090107.39388 | 37.7191740478241 | -122.433650566035 | (37.7191740478241, -122.433650566035) | 9 | 7 | 6 | 28861 | 5 |
64583 | 180729 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 727 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/15/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782865 | 5999059.45631 | 2090357.33436 | 37.7196690715525 | -122.445284694236 | (37.7196690715525, -122.445284694236) | 9 | 7 | 6 | 28861 | 25 | |
72659 | 258063 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 727 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/15/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782865 | 5999059.45631 | 2090357.33436 | 37.7196690715525 | -122.445284694236 | (37.7196690715525, -122.445284694236) | 9 | 7 | 6 | 28861 | 25 | |
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 | |||
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 | ||
19809 | 40738 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 20 Alviso St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1999 12:00:00 AM | Permit Number 41717 | 5992072.81756498 | 2091384.27409538 | 37.7220875062624 | -122.469509497536 | (37.7220875062624, -122.469509497536) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 |
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 |
46047 | 51242 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 80 De Soto St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47612 | 5993144.07933001 | 2091663.61630064 | 37.7229163655097 | -122.4658267259 | (37.7229163655097, -122.4658267259) | 9 | 8 | 4 | 59 | 40 | ||
94499 | 108378 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 358 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773808 | 6003377.41913 | 2091635.77484 | 37.7234249209965 | -122.43045021882 | (37.7234249209965, -122.43045021882) | 9 | 7 | 6 | 28861 | 5 |
6357 | 261583 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
6460 | 261585 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
9333 | 261584 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
11732 | 261580 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
14168 | 261582 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
19480 | 261581 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
111971 | 37855 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 50 Ina Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | |||
123306 | 37854 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 50 Ina Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | |||
184255 | 37856 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 50 Ina Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | |||
168013 | 175810 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 La Grande Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | 9 | 7 | 6 | 28861 | 5 | ||||
112065 | 175809 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 La Grande Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6005230.95207 | 2091785.588 | 37.7239410985769 | -122.424053538037 | (37.7239410985769, -122.424053538037) | 9 | 7 | 6 | 28861 | 5 | ||||
123712 | 175808 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 La Grande Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6005234.38829 | 2091786.48978 | 37.7239437686747 | -122.42404172366 | (37.7239437686747, -122.42404172366) | 9 | 7 | 6 | 28861 | 5 | ||||
185048 | 204732 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 700 Junipero Serra Blvd | 92 | : | Tree | Private 2 | 9 | Width 0ft | 5991226.61275 | 2092125.57221 | 37.7240739859998 | -122.472488607886 | (37.7240739859998, -122.472488607886) | 9 | 8 | 4 | 64 | 40 | |||
21137 | 45396 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 135 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | Permit Number 44206 | 5992967.23882057 | 2092102.4527907 | 37.72411110068 | -122.466469901656 | (37.72411110068, -122.466469901656) | 9 | 8 | 4 | 59 | 40 | ||
83930 | 175807 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 156 San Juan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6001266.11551 | 2092303.88748 | 37.7251395810236 | -122.437796421768 | (37.7251395810236, -122.437796421768) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
33219 | 175813 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6005348.05368 | 2093155.48995 | 37.7277091599291 | -122.423746094022 | (37.7277091599291, -122.423746094022) | 9 | 7 | 6 | 28861 | 5 | ||||
27938 | 175812 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6005342.42292 | 2093158.16241 | 37.7277161800552 | -122.423765749609 | (37.7277161800552, -122.423765749609) | 9 | 7 | 6 | 28861 | 5 | ||||
162679 | 175811 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6005336.45581 | 2093162.30321 | 37.727727212929 | -122.423786672331 | (37.727727212929, -122.423786672331) | 9 | 7 | 6 | 28861 | 5 | ||||
68047 | 175814 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 11 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6005376.33288 | 2093192.89602 | 37.727813465104 | -122.423650990705 | (37.727813465104, -122.423650990705) | 9 | 7 | 6 | 28861 | 5 | ||||
58479 | 205923 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 266 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998304.03576 | 2093569.77611 | 37.7284465374612 | -122.448127087008 | (37.7284465374612, -122.448127087008) | 9 | 7 | 4 | 28861 | 40 | ||||
133024 | 108841 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 125 Pioche St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773762 | 6006499.8637 | 2093472.98879 | 37.7286458955893 | -122.419786780156 | (37.7286458955893, -122.419786780156) | 9 | 7 | 7 | 309 | 5 | |
59676 | 204731 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 5 | Width 0ft | 5991352.35851 | 2093912.83716 | 37.728988647895 | -122.472184145999 | (37.728988647895, -122.472184145999) | 9 | 8 | 4 | 64 | 40 | |||
121497 | 204721 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 460 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997139.03164 | 2093838.66053 | 37.7291181628495 | -122.452173936375 | (37.7291181628495, -122.452173936375) | 9 | 7 | 4 | 28861 | 40 | |||
136012 | 204730 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 20 | : | Tree | Private 2 | 7 | Width 0ft | 5991365.09978 | 2094040.00624 | 37.7293385597172 | -122.472149364714 | (37.7293385597172, -122.472149364714) | 9 | 8 | 4 | 64 | 40 | |||
31951 | 116582 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 195 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778001 | 6004664.28928 | 2093799.33843 | 37.7294384024451 | -122.426155697039 | (37.7294384024451, -122.426155697039) | 9 | 7 | 6 | 28861 | 5 | |
73637 | 204718 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1485x Northwood Dr | 6 | Median : Yard | Tree | DPW 1 | 3 | 5995836.31697 | 2094012.72029 | 37.7295213774971 | -122.456690081702 | (37.7295213774971, -122.456690081702) | 9 | 7 | 4 | 28861 | 40 | ||||
66973 | 204729 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 16 | : | Tree | Private 2 | 1 | Width 0ft | 5991368.5463 | 2094108.06034 | 37.7295256186902 | -122.47214240847 | (37.7295256186902, -122.47214240847) | 9 | 8 | 4 | 64 | 40 | |||
109617 | 204717 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1485x Northwood Dr | 5 | Median : Yard | Tree | DPW 1 | 2 | 5995876.20042 | 2094034.01596 | 37.7295821401899 | -122.456553740875 | (37.7295821401899, -122.456553740875) | 9 | 7 | 4 | 28861 | 40 | ||||
150616 | 204728 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 2 | Width 0ft | 5991366.51565 | 2094145.3724 | 37.7296279507483 | -122.472152147224 | (37.7296279507483, -122.472152147224) | 9 | 8 | 4 | 64 | 40 | |||
45147 | 29574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 9 | 3X3 | 5991374.69638 | 2094208.91815 | 37.729802904883 | -122.472128495928 | (37.729802904883, -122.472128495928) | 9 | 8 | 4 | 64 | 40 | |||
33107 | 29576 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991377.92956 | 2094240.43756 | 37.7298896363903 | -122.472119615131 | (37.7298896363903, -122.472119615131) | 9 | 8 | 4 | 64 | 40 | ||
133067 | 49132 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Valdez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | 9 | 7 | 4 | 28861 | 40 | ||
55595 | 204727 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 4 | Width 0ft | 5991391.65527 | 2094396.58957 | 37.73031918497 | -122.472083541538 | (37.73031918497, -122.472083541538) | 9 | 8 | 4 | 64 | 40 | |||
15405 | 204726 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 30 | : | Tree | Private 2 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | 9 | 8 | 4 | 64 | 40 | |||
79994 | 204725 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 29 | : | Tree | Private 2 | 5 | Width 0ft | 5991390.23736 | 2094439.33755 | 37.7304364781515 | -122.472091558075 | (37.7304364781515, -122.472091558075) | 9 | 8 | 4 | 64 | 40 | |||
87025 | 175799 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1500 San Jose Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6001536.44317 | 2094235.33238 | 37.7304582561421 | -122.43700014314 | (37.7304582561421, -122.43700014314) | 9 | 7 | 6 | 28861 | 25 | |||
191305 | 204724 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 21 | : | Tree | Private 2 | 8 | Width 0ft | 5991391.18592 | 2094484.34476 | 37.7305601115545 | -122.47209155809 | (37.7305601115545, -122.47209155809) | 9 | 8 | 4 | 64 | 40 | |||
155659 | 204723 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 12 | : | Tree | Private 2 | 5 | Width 0ft | 5991397.3981 | 2094531.55014 | 37.7306900851772 | -122.472073521298 | (37.7306900851772, -122.472073521298) | 9 | 8 | 4 | 64 | 40 | |||
11697 | 214030 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | Width 1ft | Permit Number 785373 | 6000729.56588 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | 9 | 7 | 4 | 63 | 40 | |
4064 | 214029 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | Width 1ft | Permit Number 785373 | 6000729.59206 | 2094530.61609 | 37.7312231430208 | -122.439810699013 | (37.7312231430208, -122.439810699013) | 9 | 7 | 4 | 63 | 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 | |||
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 | |||
128528 | 204745 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 370 Monterey Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999685.08818 | 2094723.93815 | 37.7316944498203 | -122.443435605388 | (37.7316944498203, -122.443435605388) | 9 | 7 | 4 | 63 | 40 | |||
38633 | 205922 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 370 Monterey Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999640.50046 | 2094726.6696 | 37.7316994068856 | -122.443589949734 | (37.7316994068856, -122.443589949734) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||
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 | ||
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 | |||
106694 | 204743 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 280 Joost Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 7ft | 6000165.05205 | 2094974.54581 | 37.732409919872 | -122.441794258103 | (37.732409919872, -122.441794258103) | 9 | 7 | 5 | 63 | 40 | |||
83863 | 204738 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 130 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001200.02257 | 2094962.19919 | 37.7324349372236 | -122.438215245944 | (37.7324349372236, -122.438215245944) | 9 | 7 | 5 | 63 | 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 | ||
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 | ||
22017 | 204737 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 230 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001436.76661 | 2095116.79206 | 37.7328728755875 | -122.43740783373 | (37.7328728755875, -122.43740783373) | 9 | 7 | 5 | 63 | 40 | |||
59122 | 204739 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 463 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998365.55897 | 2095230.78545 | 37.7330107938072 | -122.448033943319 | (37.7330107938072, -122.448033943319) | 9 | 7 | 4 | 59 | 40 |
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) );