trees
575 rows where qSpecies_id = 123 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
2223 | 241387 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004298.90777 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | 2 | 7 | 5 | 63 | 7 | |||
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
92135 | 241378 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 273 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004715.15963 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | 2 | 7 | 5 | 63 | 22 | |||
93244 | 86800 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 71 Miguel St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860 | 2097292 | 37.7389829690297 | -122.429185143196 | (37.7389829690297, -122.429185143196) | 2 | 7 | 5 | 63 | 7 | |||
98123 | 241389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002625.89983 | 2096003.53123 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | 2 | 7 | 5 | 63 | 7 | |||
104248 | 241377 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 281 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004660.79755 | 2100144.09881 | 37.7468594809746 | -122.426619392873 | (37.7468594809746, -122.426619392873) | 2 | 7 | 5 | 63 | 22 | |||
105739 | 43561 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 598 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50500 | 6002046.37252319 | 2099459.05244765 | 37.7448303525831 | -122.435610815213 | (37.7448303525831, -122.435610815213) | 2 | 7 | 5 | 63 | 22 | ||
109816 | 241388 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003420.97531 | 2097978.60034 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | 2 | 7 | 5 | 63 | 7 | |||
115294 | 246445 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 457 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.430405804901 | (37.7458198862793, -122.430405804901) | 2 | 7 | 5 | 63 | 22 | |||
27312 | 88136 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690 | 2096237 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | 9 | 7 | 4 | 59 | 40 | |||
39809 | 88509 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
47581 | 88507 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
66880 | 88511 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
71898 | 88508 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
96159 | 88510 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
121788 | 213854 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.448711968308 | (37.7331358031646, -122.448711968308) | 9 | 7 | 4 | 59 | 40 | ||||
140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
180009 | 88506 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | |||
4592 | 196983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
5120 | 197001 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 16 | : | Tree | Private 2 | 9 | Width 4ft | 6013598.90827 | 2100122.82985 | 37.7473023413409 | -122.395710528743 | (37.7473023413409, -122.395710528743) | 10 | 3 | 8 | 58 | 1 | |||
11064 | 196994 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 7 | : | Tree | Private 2 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.394724774624 | (37.7473596740254, -122.394724774624) | 10 | 3 | 8 | 58 | 1 | |||
20599 | 196997 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 11 | : | Tree | Private 2 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.7473355578075 | -122.395144856947 | (37.7473355578075, -122.395144856947) | 10 | 3 | 8 | 58 | 1 | |||
22157 | 197002 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2251 Silver Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012830.37736 | 2096288.90355 | 37.7367324078692 | -122.398099143384 | (37.7367324078692, -122.398099143384) | 10 | 3 | 8 | 58 | 1 | |||
23399 | 101632 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
35315 | 88470 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1519 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51424 | 6015916 | 2096861 | 37.7384746486807 | -122.387470605672 | (37.7384746486807, -122.387470605672) | 10 | 3 | 8 | 58 | 1 | |||
38784 | 22263 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1997 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
46025 | 101631 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
55570 | 100314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | 10 | 3 | 8 | 58 | 1 | |||
61090 | 104044 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
62748 | 196988 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
64144 | 95296 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4517 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015219.41618 | 2096207.76459 | 37.7366423919508 | -122.389833460403 | (37.7366423919508, -122.389833460403) | 10 | 3 | 8 | 58 | 1 | |||
64306 | 22261 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | |||
67071 | 3776 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 6 Carpenter Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.2597904 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | 10 | 3 | 8 | 58 | 1 | ||
70671 | 196993 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6013912.09606 | 2100139.02388 | 37.7473642236913 | -122.394628673985 | (37.7473642236913, -122.394628673985) | 10 | 3 | 8 | 58 | 1 | |||
71003 | 22267 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
74147 | 88499 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | 10 | 3 | 8 | 58 | 1 | ||
76848 | 22262 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | |||
77304 | 101627 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
80922 | 104045 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
85376 | 85063 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4532 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6015094.5224 | 2096297.78902 | 37.7368826538298 | -122.390271563398 | (37.7368826538298, -122.390271563398) | 10 | 3 | 8 | 58 | 1 | ||
86262 | 101634 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
86818 | 22265 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
88076 | 196990 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.393830644379 | (37.7474110756645, -122.393830644379) | 10 | 3 | 8 | 58 | 1 | |||
90252 | 22222 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4301 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768640 | 6015412.92695 | 2096851.83844 | 37.7384216168093 | -122.389209364399 | (37.7384216168093, -122.389209364399) | 10 | 3 | 8 | 58 | 1 | |
91890 | 22277 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
93143 | 22280 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
93279 | 101630 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | |
94686 | 95297 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4517 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015219.41618 | 2096207.76459 | 37.7366423919508 | -122.389833460403 | (37.7366423919508, -122.389833460403) | 10 | 3 | 8 | 58 | 1 | |||
97589 | 196999 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 14 | : | Tree | Private 2 | 4 | Width 4ft | 6013629.21679 | 2100123.8728 | 37.7473068910098 | -122.395605796394 | (37.7473068910098, -122.395605796394) | 10 | 3 | 8 | 58 | 1 | |||
102501 | 22264 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
104346 | 101628 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
105176 | 88473 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1554 Jerrold Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51426 | 6015626.2 | 2096846 | 37.7384174065816 | -122.388471555996 | (37.7384174065816, -122.388471555996) | 10 | 3 | 8 | 58 | 1 | |||
111608 | 22240 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4445 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2010 12:00:00 AM | 3 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | ||
111720 | 196987 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
115832 | 104046 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
121622 | 197000 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 15 | : | Tree | Private 2 | 6 | Width 4ft | 6013614.06576 | 2100123.51682 | 37.7473050707808 | -122.395658162994 | (37.7473050707808, -122.395658162994) | 10 | 3 | 8 | 58 | 1 | |||
123373 | 88498 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1599 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | 10 | 3 | 8 | 58 | 1 | ||
124135 | 196995 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | 10 | 3 | 8 | 58 | 1 | |||
124252 | 88468 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1950 Donner Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51422 | 6011569.2 | 2093583.7 | 37.7292341601061 | -122.402269464083 | (37.7292341601061, -122.402269464083) | 10 | 3 | 8 | 58 | 1 | |||
125523 | 104460 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
132977 | 101633 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
136365 | 22239 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4445 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1995 12:00:00 AM | 3 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | ||
141990 | 196989 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
146245 | 196984 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
148392 | 95290 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4416 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | |||
148421 | 196998 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 13 | : | Tree | Private 2 | 5 | Width 4ft | 6013702.50003 | 2100126.86267 | 37.7473191766464 | -122.395352595851 | (37.7473191766464, -122.395352595851) | 10 | 3 | 8 | 58 | 1 | |||
148723 | 22242 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4430 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1995 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
148991 | 22243 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4434 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
149067 | 95289 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4400 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015280 | 2096693 | 37.737978108932 | -122.389657874388 | (37.737978108932, -122.389657874388) | 10 | 3 | 8 | 58 | 1 | ||||
151905 | 22278 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
162699 | 22272 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4720 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1995 12:00:00 AM | 6 | 3x3 | 6014914.77079 | 2095774.79236 | 37.7354366396256 | -122.390856509346 | (37.7354366396256, -122.390856509346) | 10 | 3 | 8 | 58 | 1 | ||
163314 | 22266 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
168607 | 196986 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
170027 | 22282 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 4 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
170158 | 196985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
174039 | 22279 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
176314 | 196982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
183387 | 22238 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4420 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
184445 | 196996 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | 10 | 3 | 8 | 58 | 1 | |||
186419 | 100315 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015443.91077 | 2097940.33755 | 37.7414121299803 | -122.389178220304 | (37.7414121299803, -122.389178220304) | 10 | 3 | 8 | 58 | 1 | |||
191217 | 22252 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4544 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015060.7997 | 2096239.5516 | 37.7367208751663 | -122.390384090827 | (37.7367208751663, -122.390384090827) | 10 | 3 | 8 | 58 | 1 | ||
193442 | 101629 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
193907 | 196992 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.7473701394162 | -122.394524516312 | (37.7473701394162, -122.394524516312) | 10 | 3 | 8 | 58 | 1 | |||
2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 | |
6340 | 33134 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3107 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 10 | Permit Number 37364 | 6001390.00916 | 2119109.09622 | 37.7987471650933 | -122.439288583214 | (37.7987471650933, -122.439288583214) | 13 | 9 | 1 | 57 | 17 | |
20202 | 136176 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | 13 | 9 | 1 | 57 | 17 | |||
32482 | 65937 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.445985572784 | (37.7958202522453, -122.445985572784) | 13 | 9 | 1 | 57 | 17 | ||
55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 | |||
106021 | 136178 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001367.93231 | 2119047.53981 | 37.798576891075 | -122.439360561339 | (37.798576891075, -122.439360561339) | 13 | 9 | 1 | 57 | 17 | |||
106256 | 65755 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3036 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 14 | Permit Number 28718 | 6004280.73363 | 2119630.96227 | 37.8003441497153 | -122.429322978897 | (37.8003441497153, -122.429322978897) | 13 | 9 | 1 | 57 | 17 | |
116025 | 30565 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | 13 | 9 | 1 | 57 | 17 | ||
146439 | 136181 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999405.90686 | 2119644.67772 | 37.8001046215781 | -122.446192737013 | (37.8001046215781, -122.446192737013) | 13 | 9 | 1 | 57 | 17 | |||
148213 | 136179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001333.81043 | 2119043.17386 | 37.7985629614603 | -122.439478320365 | (37.7985629614603, -122.439478320365) | 13 | 9 | 1 | 57 | 17 | |||
155023 | 80092 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.7988960100912 | -122.429310324527 | (37.7988960100912, -122.429310324527) | 13 | 9 | 1 | 57 | 17 | |
169587 | 83336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004282.92403 | 2119104.69719 | 37.7988992854406 | -122.429277851819 | (37.7988992854406, -122.429277851819) | 13 | 9 | 1 | 57 | 17 |
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) );